Files

136 lines
2.7 KiB
Go

package database
import (
"database/sql"
"embed"
"errors"
"fmt"
"regexp"
"strings"
_ "modernc.org/sqlite"
"github.com/pressly/goose/v3"
)
type DatabaseClient struct {
DB *sql.DB
WriteDB *sql.DB
Queries *Queries
WriteQueries *Queries
}
// content holds migrations files ( embeded into the go program )
//
//go:embed migrations/*
var embedMigrations embed.FS
type NewDatabaseParams struct {
DatabaseName *string
}
var databaseNamePattern = regexp.MustCompile(`^[a-zA-Z][a-zA-Z0-9_]*$`)
func NewDatabase(params NewDatabaseParams) (error, *DatabaseClient) {
databaseName := "database"
if params.DatabaseName != nil {
databaseName = *params.DatabaseName
}
normalizedDatabaseName, err := normalizeDatabaseName(databaseName)
if err != nil {
return err, nil
}
readDB, err := openSQLite(normalizedDatabaseName, 10)
if err != nil {
return err, nil
}
writeDB, err := openSQLite(normalizedDatabaseName, 1)
if err != nil {
_ = readDB.Close()
return err, nil
}
goose.SetBaseFS(embedMigrations)
if err := goose.SetDialect("sqlite3"); err != nil {
_ = readDB.Close()
_ = writeDB.Close()
return err, nil
}
if err := goose.Up(writeDB, "migrations"); err != nil {
_ = readDB.Close()
_ = writeDB.Close()
return err, nil
}
return nil, &DatabaseClient{
DB: readDB,
WriteDB: writeDB,
Queries: New(readDB),
WriteQueries: New(writeDB),
}
}
func (c *DatabaseClient) Close() error {
var errs []error
if c.WriteDB != nil {
errs = append(errs, c.WriteDB.Close())
}
if c.DB != nil {
errs = append(errs, c.DB.Close())
}
return errors.Join(errs...)
}
// openSQLite ouvre une connexion avec les PRAGMAs requis. Ils sont passés par
// le DSN car database/sql ouvre plusieurs connexions et qu'un PRAGMA exécuté
// dans une migration goose (transaction) est sans effet.
func openSQLite(databaseName string, maxOpenConns int) (*sql.DB, error) {
dsn := fmt.Sprintf(
"file:%s.db?_pragma=busy_timeout(5000)&_pragma=foreign_keys(1)&_pragma=journal_mode(WAL)&_pragma=synchronous(NORMAL)",
databaseName,
)
db, err := sql.Open("sqlite", dsn)
if err != nil {
return nil, err
}
db.SetMaxOpenConns(maxOpenConns)
db.SetMaxIdleConns(maxOpenConns)
if err := db.Ping(); err != nil {
_ = db.Close()
return nil, fmt.Errorf("ouverture de %s.db : %w", databaseName, err)
}
return db, nil
}
func normalizeDatabaseName(databaseName string) (string, error) {
trimmed := strings.TrimSpace(databaseName)
if !databaseNamePattern.MatchString(trimmed) {
return "", fmt.Errorf(
"nom de base invalide %q : attendu ^[a-zA-Z][a-zA-Z0-9_]*$",
databaseName,
)
}
return strings.ToLower(trimmed), nil
}