devdb

type Config struct {
	// DSN, when set, is used as-is instead of starting a container.
	// The referenced database MUST be disposable: whenever SchemaSQL
	// is non-empty, sqletch resets the public schema (DROP SCHEMA
	// public CASCADE) before applying it, so repeated runs are
	// idempotent. Never point this at a database you care about.
	//
	// Because the DSN comes from sqletch.yaml — repo-controlled, so a
	// cloned project could aim it at a database the developer cares
	// about — a user-supplied DSN does NOT reset by default: Acquire
	// returns *DestructiveResetError unless AllowDestructive is set. A
	// database sqletch provisioned itself (empty DSN → a fresh
	// container or temp file) is disposable by construction and always
	// resets.
	DSN string
	// AllowDestructive clears the user-supplied-DSN reset guard above:
	// the caller (a person passing --allow-destructive on the command
	// line) has confirmed the database at DSN is disposable, so sqletch
	// may drop and recreate its schema. It is ignored when DSN is empty.
	AllowDestructive bool
	// ServerVersion is the pinned version prefix (e.g. "16" or
	// "16.4"); it selects the container image and is validated as a
	// dotted prefix of whatever we connect to (see versionPrefixMatch).
	ServerVersion string
	// SchemaSQL is executed in order after connecting (plain SQL —
	// schema files are read by the caller).
	SchemaSQL []string
	// Detected, when non-nil, receives what Acquire learned by
	// connecting — facts no caller can compute offline. It is filled
	// in before the schema is applied; on an error return its contents
	// are undefined. Callers that do not care leave it nil, and then
	// the extra round trip is skipped unless the version pin needs it.
	Detected *Detected
}

type DestructiveResetError struct {
	Server string // display name, e.g. "PostgreSQL", "MySQL", "SQLite"
}

type Detected struct {
	// ServerVersion is the raw string the engine reported, e.g.
	// "16.4 (Debian 16.4-1.pgdg120+1)", "8.0.36-log", "3.50.4".
	ServerVersion string
}

type VersionMismatchError struct {
	Pinned, Actual string
	Server         string // display name, e.g. "PostgreSQL", "MySQL", "SQLite"
}