sqlstore

type Dialect interface {
	// Name identifies the dialect: "postgres" or "mariadb".
	Name() string
	// DriverName is the database/sql driver name to pass to sql.Open/sqlx.Open.
	DriverName() string
	// Rebind rewrites a query written with "?" placeholders into this
	// dialect's native placeholder style: a no-op for MariaDB, $1/$2/...
	// for Postgres.
	Rebind(query string) string
	// JSONColumnType is the column type used for JSON-valued columns:
	// "JSONB" for Postgres, "JSON" for MariaDB. The actual column types
	// live in the migration files; this is informational, for tests and
	// tooling that want to assert a dialect-appropriate schema.
	JSONColumnType() string
	// UpsertClause returns the dialect-native SQL fragment to append to an
	// "INSERT INTO table (...) VALUES (...)" statement to make it an
	// upsert-by-natural-key. conflictCols are the natural-key columns that
	// define the conflict target; updateCols are the columns to overwrite
	// when a conflict occurs. If updateCols is empty, the upsert becomes a
	// no-op-on-conflict insert (insert-if-absent).
	UpsertClause(conflictCols, updateCols []string) string
	// JSONContains returns a boolean SQL expression testing whether the JSON
	// value in column contains all the keys/values of the JSON document
	// bound to the next "?" placeholder (combine with Rebind as usual).
	JSONContains(column string) string
	// JSONTextExtract returns a SQL expression extracting the text value at
	// the given top-level key of a JSON column.
	JSONTextExtract(column, key string) string
	// CaseInsensitiveLike returns a boolean SQL expression doing a
	// case-insensitive substring match of column against the next "?"
	// placeholder. On MariaDB this relies on the column's collation being
	// case-insensitive (the default for this schema's text columns); it is
	// not otherwise enforced at the SQL level the way Postgres's ILIKE is.
	CaseInsensitiveLike(column string) string
}

type JSON[T any] struct {
	V T
}

type MariaDBConfig struct {
	// Host is the MariaDB server hostname. Required when Common.SQL.Backend
	// is "mariadb"; enforced by a SQL-level struct validation rather than a
	// plain "required_if" tag here, since "Backend" lives on the parent SQL
	// struct, not on MariaDBConfig, and required_if can only reference
	// sibling fields.
	Host string `yaml:"host" validate:"omitempty" doc_example:"\"mariadb\""`
	// Port is the MariaDB server port
	Port int `yaml:"port" default:"3306"`
	// User is the MariaDB connection user. Required when Common.SQL.Backend
	// is "mariadb" (see Host doc comment for why this isn't a required_if tag).
	User string `yaml:"user" validate:"omitempty"`
	// Password is the MariaDB connection password. May also be set via secrets.yaml
	// (Common.SQL.MariaDB.Password), following the same split as Mongo.URI.
	Password string `yaml:"password,omitempty"`
	// Database is the MariaDB database name
	Database string `yaml:"database" default:"vc" doc_example:"\"vc\""`
	// TLS enables TLS for the MariaDB connection.
	TLS bool `yaml:"tls" default:"false"`
	// CAFilePath is the path to a PEM-encoded CA certificate used to verify the server's certificate.
	CAFilePath string `yaml:"ca_file_path,omitempty"`
	// CertFilePath is the path to a PEM-encoded client certificate for mutual TLS (mTLS).
	CertFilePath string `yaml:"cert_file_path,omitempty" validate:"required_with=KeyFilePath"`
	// KeyFilePath is the path to a PEM-encoded client private key for mutual TLS (mTLS).
	KeyFilePath string `yaml:"key_file_path,omitempty" validate:"required_with=CertFilePath"`
	// MaxOpenConns is the maximum number of open connections to the database.
	MaxOpenConns int `yaml:"max_open_conns" default:"25"`
	// MaxIdleConns is the maximum number of idle connections in the pool.
	MaxIdleConns int `yaml:"max_idle_conns" default:"5"`
}

type PostgresConfig struct {
	// Host is the Postgres server hostname. Required when Common.SQL.Backend
	// is "postgres"; enforced by a SQL-level struct validation rather than a
	// plain "required_if" tag here, since "Backend" lives on the parent SQL
	// struct, not on PostgresConfig, and required_if can only reference
	// sibling fields.
	Host string `yaml:"host" validate:"omitempty" doc_example:"\"postgres\""`
	// Port is the Postgres server port
	Port int `yaml:"port" default:"5432"`
	// User is the Postgres connection user. Required when Common.SQL.Backend
	// is "postgres" (see Host doc comment for why this isn't a required_if tag).
	User string `yaml:"user" validate:"omitempty"`
	// Password is the Postgres connection password. May also be set via secrets.yaml
	// (Common.SQL.Postgres.Password), following the same split as Mongo.URI.
	Password string `yaml:"password,omitempty"`
	// Database is the Postgres database name
	Database string `yaml:"database" default:"vc" doc_example:"\"vc\""`
	// SSLMode is the Postgres SSL mode: disable, require, verify-ca, or verify-full
	SSLMode string `yaml:"ssl_mode" default:"disable" validate:"omitempty,oneof=disable require verify-ca verify-full"`
	// CAFilePath is the path to a PEM-encoded CA certificate used to verify the server's certificate.
	CAFilePath string `yaml:"ca_file_path,omitempty"`
	// CertFilePath is the path to a PEM-encoded client certificate for mutual TLS (mTLS).
	CertFilePath string `yaml:"cert_file_path,omitempty" validate:"required_with=KeyFilePath"`
	// KeyFilePath is the path to a PEM-encoded client private key for mutual TLS (mTLS).
	KeyFilePath string `yaml:"key_file_path,omitempty" validate:"required_with=CertFilePath"`
	// MaxOpenConns is the maximum number of open connections to the database.
	MaxOpenConns int `yaml:"max_open_conns" default:"25"`
	// MaxIdleConns is the maximum number of idle connections in the pool.
	MaxIdleConns int `yaml:"max_idle_conns" default:"5"`
}

type ProbeCache struct {
	// contains filtered or unexported fields
}

type SQL struct {
	// Backend selects the storage backend for services that support relational
	// storage. "mongo" (default, current behavior) keeps existing Mongo-backed
	// behavior unchanged; "postgres" and "mariadb" select the corresponding
	// relational backend.
	Backend string `yaml:"backend" default:"mongo" validate:"omitempty,oneof=mongo postgres mariadb"`
	// Postgres holds Postgres-specific connection settings, used when Backend is "postgres".
	Postgres *PostgresConfig `yaml:"postgres,omitempty" validate:"required_if=Backend postgres"`
	// MariaDB holds MariaDB/MySQL-specific connection settings, used when Backend is "mariadb".
	MariaDB *MariaDBConfig `yaml:"mariadb,omitempty" validate:"required_if=Backend mariadb"`
}