mirror of
https://github.com/renorris/openfsd
synced 2026-03-22 06:25:35 +08:00
1. Database Enhancements (db/repositories.go): - Added ConfigRepository interface and implementations for PostgreSQL and SQLite - Updated Repositories struct to include ConfigRepository - Modified NewRepositories to initialize both UserRepo and ConfigRepo 2. FSD Server Improvements: - Removed hardcoded jwtSecret, now retrieved from ConfigRepository (fsd/conn.go, web/auth.go) - Added dynamic welcome message retrieval from ConfigRepository (fsd/conn.go) - Optimized METAR buffer size from 4096 to 512 bytes (fsd/metar.go) - Reduced minimum fields for DeleteATC and DeletePilot packets (fsd/packet.go) - Improved Haversine distance calculation with constants (fsd/postoffice.go) - Added thread-safety documentation for sendError (fsd/client.go) 3. Server Configuration (fsd/server.go): - Added NewDefaultServer to initialize server with environment-based config - Implemented automatic database migration and default admin user creation - Added configurable METAR worker count - Improved logging with slog and environment-based debug level 4. Web Interface Enhancements: - Added user and config editor frontend routes (web/frontend.go, web/routes.go) - Improved JWT handling by retrieving secret from ConfigRepository (web/auth.go) - Enhanced user management API endpoints (web/user.go) - Updated dashboard to display CID and conditional admin links (web/templates/dashboard.html) - Embedded templates using go:embed (web/templates.go) 5. Frontend JavaScript Improvements: - Added networkRatingFromInt helper for readable ratings (web/static/js/openfsd/dashboard.js) - Improved API request handling with auth/no-auth variants (web/static/js/openfsd/api.js) 6. Miscellaneous: - Added sethvargo/go-envconfig dependency for environment variable parsing - Fixed parseVisRange to use 64-bit float parsing (fsd/util.go) - Added strPtr utility function (fsd/util.go, web/main.go) - Improved SVG logo rendering in layout (web/templates/layout.html)
51 lines
1.3 KiB
Go
51 lines
1.3 KiB
Go
package db
|
|
|
|
import (
|
|
"database/sql"
|
|
"fmt"
|
|
"github.com/lib/pq"
|
|
"modernc.org/sqlite"
|
|
)
|
|
|
|
// Repositories bundles all repository interfaces
|
|
type Repositories struct {
|
|
UserRepo UserRepository
|
|
ConfigRepo ConfigRepository
|
|
}
|
|
|
|
// NewUserRepository creates a UserRepository based on the database driver
|
|
func NewUserRepository(db *sql.DB) (UserRepository, error) {
|
|
switch db.Driver().(type) {
|
|
case *pq.Driver:
|
|
return &PostgresUserRepository{db: db}, nil
|
|
case *sqlite.Driver:
|
|
return &SQLiteUserRepository{db: db}, nil
|
|
default:
|
|
return nil, fmt.Errorf("unsupported database")
|
|
}
|
|
}
|
|
|
|
// NewConfigRepository creates a ConfigRepository based on the database driver
|
|
func NewConfigRepository(db *sql.DB) (ConfigRepository, error) {
|
|
switch db.Driver().(type) {
|
|
case *pq.Driver:
|
|
return &PostgresConfigRepository{db: db}, nil
|
|
case *sqlite.Driver:
|
|
return &SQLiteConfigRepository{db: db}, nil
|
|
default:
|
|
return nil, fmt.Errorf("unsupported database")
|
|
}
|
|
}
|
|
|
|
// NewRepositories creates a Repositories bundle with implementations for the given database
|
|
func NewRepositories(db *sql.DB) (repositories *Repositories, err error) {
|
|
repositories = &Repositories{}
|
|
if repositories.UserRepo, err = NewUserRepository(db); err != nil {
|
|
return
|
|
}
|
|
if repositories.ConfigRepo, err = NewConfigRepository(db); err != nil {
|
|
return
|
|
}
|
|
return
|
|
}
|