database

Documentation

Index

• Constants
• func Open(dialect Dialect, dsn string) (*sql.DB, error)
• func RunMigrations(dialect Dialect, dsn string, db *sql.DB) error
• type Dialect
  • func DetectDialect() (Dialect, string)

Constants

const SQLiteInitFile = "db/sqlite_init.sql"

SQLiteInitFile is the path to the SQLite schema initialization SQL file.

Functions

func Open

func Open(dialect Dialect, dsn string) (*sql.DB, error)

Open opens a database connection for the given dialect and DSN.

func RunMigrations

func RunMigrations(dialect Dialect, dsn string, db *sql.DB) error

RunMigrations applies database migrations based on the dialect.

Types

type Dialect

type Dialect string

Dialect represents the database engine type.

const (
	DialectPostgres Dialect = "postgres"
	DialectSQLite   Dialect = "sqlite"
)

func DetectDialect

func DetectDialect() (Dialect, string)

DetectDialect determines the database dialect and DSN from environment variables. If DATABASE_URL is set, PostgreSQL is used. Otherwise, SQLite is used as the default.