Files
openfsd/db/repositories.go
Reese Norris 335409c4b4 Add ConfigRepository and enhance server configuration management
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)
2025-05-16 22:27:26 -07:00

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
}