You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
synctv/internal/conf/db.go

41 lines
1.8 KiB
Go

package conf
type DatabaseType string
const (
DatabaseTypeSqlite3 DatabaseType = "sqlite3"
DatabaseTypeMysql DatabaseType = "mysql"
DatabaseTypePostgres DatabaseType = "postgres"
)
//nolint:tagliatelle
type DatabaseConfig struct {
Type DatabaseType `env:"DATABASE_TYPE" hc:"support sqlite3, mysql, postgres" lc:"default: sqlite3" yaml:"type"`
Host string `env:"DATABASE_HOST" hc:"when type is not sqlite3, and port is 0, it will use unix socket file" yaml:"host"`
Port uint16 `env:"DATABASE_PORT" yaml:"port"`
User string `env:"DATABASE_USER" yaml:"user"`
Password string `env:"DATABASE_PASSWORD" yaml:"password"`
Name string `env:"DATABASE_NAME" hc:"when type is sqlite3, it will use sqlite db file or memory" lc:"default: synctv" yaml:"name"`
SslMode string `env:"DATABASE_SSL_MODE" hc:"mysql: true, false, skip-verify, preferred, <name> postgres: disable, require, verify-ca, verify-full" yaml:"ssl_mode"`
CustomDSN string `env:"DATABASE_CUSTOM_DSN" hc:"when not empty, it will ignore other config" yaml:"custom_dsn"`
MaxIdleConns int `env:"DATABASE_MAX_IDLE_CONNS" hc:"sqlite3 does not support setting connection parameters" yaml:"max_idle_conns"`
MaxOpenConns int `env:"DATABASE_MAX_OPEN_CONNS" yaml:"max_open_conns"`
ConnMaxLifetime string `env:"DATABASE_CONN_MAX_LIFETIME" yaml:"conn_max_lifetime"`
ConnMaxIdleTime string `env:"DATABASE_CONN_MAX_IDLE_TIME" yaml:"conn_max_idle_time"`
}
func DefaultDatabaseConfig() DatabaseConfig {
return DatabaseConfig{
Type: DatabaseTypeSqlite3,
Host: "",
Name: "synctv",
MaxIdleConns: 4,
MaxOpenConns: 64,
ConnMaxLifetime: "2h",
ConnMaxIdleTime: "30m",
}
}