postgres

type DesiredStateProvider interface {
	// GetConnectionDetails returns connection details for IR inspection
	// Returns: host, port, database, username, password
	GetConnectionDetails() (string, int, string, string, string)

	// GetSchemaName returns the actual schema name to inspect.
	// For embedded postgres: returns the temporary schema name (pgschema_tmp_*)
	// For external database: returns the temporary schema name (pgschema_tmp_*)
	GetSchemaName() string

	// ApplySchema applies the desired state SQL to a schema.
	// For embedded postgres: resets the schema (drop/recreate)
	// For external database: creates temporary schema with timestamp suffix
	ApplySchema(ctx context.Context, schema string, sql string) error

	// Stop performs cleanup.
	// For embedded postgres: stops instance and removes temp directory
	// For external database: drops temporary schema (best effort) and closes connection
	Stop() error
}

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

type EmbeddedPostgresConfig struct {
	Version  PostgresVersion
	Database string
	Username string
	Password string
	// Extensions maps extension name to its installation schema on the target
	// database. ApplySchema installs each one into the embedded database before
	// applying the desired state, so desired-state SQL can reference extension
	// types without a CREATE EXTENSION statement (issue #584). Optional.
	Extensions map[string]string
}

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

type ExternalDatabaseConfig struct {
	Host               string
	Port               int
	Database           string
	Username           string
	Password           string
	SSLMode            string
	TargetMajorVersion int // Expected major version to match
	// TargetExtensions maps extension name to its installation schema on the
	// target database. Optional: when populated (typically from querying the
	// target database), NewExternalDatabase validates that extensions installed
	// on both databases live in the same schema on each side; when empty or nil,
	// the validation is skipped. Without it, extension-owned types (e.g.
	// pgvector's vector) installed in different schemas resolve to different
	// schema-qualified names and the generated plan is silently wrong (issue #518).
	TargetExtensions map[string]string
}

type NoEffectKind string

type NoEffectStatement struct {
	Kind NoEffectKind
	SQL  string // statement text with whitespace collapsed, without the trailing ';'
	// Partial is set when only one action of the statement has no effect: an
	// OWNER TO sharing an ALTER TABLE with other actions. The rest still plans.
	Partial bool
}

type PostgresVersion = embeddedpostgres.PostgresVersion

type QualifiedName struct {
	Schema string
	Table  string
}