storage

type Backend string

type FactoryConfig struct {
	// Backend selects the storage engine. Defaults to BackendPostgres when
	// the zero value is passed.
	Backend Backend
	// PostgresDSN is the libpq-style connection string for the Postgres
	// backend. Required when Backend == BackendPostgres.
	PostgresDSN string
	// SQLitePath is the file path the SQLite backend opens (e.g.
	// "./wayneblacktea.db" or ":memory:" for tests). Required when
	// Backend == BackendSQLite.
	SQLitePath string
	// PGSSLRootCert is the file path to a PEM-encoded CA certificate bundle
	// used to verify the Postgres server's TLS certificate. When empty and
	// AppEnv is "production", NewServerStores returns ErrMissingPGSSLROOTCERT.
	// When empty and AppEnv is not "production", the system CA pool is used.
	PGSSLRootCert string
	// AppEnv is the deployment environment (e.g. "production", "staging").
	// Used by BuildTLSConfig to enforce PGSSLROOTCERT in production.
	AppEnv string
}

type ServerStores interface {
	io.Closer

	GTD() gtd.StoreIface
	Workspace() workspace.StoreIface
	Decision() decision.StoreIface
	Session() session.StoreIface
	Knowledge() knowledge.StoreIface
	Learning() learning.StoreIface
	Proposal() proposal.StoreIface
	Arch() arch.StoreIface
	WorkSession() worksession.StoreIface
	Vision() vision.StoreIface
	Playbook() playbook.StoreIface
	Procedural() procedural.StoreIface
	Atom() atom.StoreIface
	Outcome() outcome.StoreIface
	Skill() skill.StoreIface
	Discipline() discipline.Store
	Reflection() reflection.StoreIface
	BehaviorRule() behaviorrule.StoreIface
	DisciplineEventStore() watchdog.DisciplineEventStoreIface

	// KnowledgePruner / LearningPruner return decay.PrunerStore for the
	// active backend's knowledge / concepts stores. Both the Postgres and
	// SQLite backends implement decay.PrunerStore via SoftPruneDecayed; the
	// type assertion lives here (backend-internal detail) so callers such as
	// cmd/server's buildPruner never need to type-assert a backend-specific
	// type themselves. Returns nil when the concrete store does not
	// implement the interface (unexpected backend) — the daily prune job for
	// that table is then skipped gracefully, matching prior behavior.
	KnowledgePruner() decay.PrunerStore
	LearningPruner() decay.PrunerStore

	// WorkspaceID returns the workspace UUID configured at startup, or nil
	// when operating in legacy single-workspace mode. Used by MCP tools that
	// need to scope writes (e.g. snapshot) without a raw pgxpool reference.
	WorkspaceID() *uuid.UUID

	// PgxPool returns the underlying pgx pool when this bundle is the
	// Postgres backend, or nil for any other backend. Used only by code
	// paths that legitimately need a pgx-typed transaction.
	PgxPool() *pgxpool.Pool

	// PgGTD / PgProposal / PgLearning / PgDecision / PgKnowledge / PgPlaybook
	// return concrete *Store handles only when the bundle is Postgres-backed
	// (so callers can WithTx(tx) on a pgx.Tx). They return nil on the SQLite
	// bundle. See the type doc for the future migration path. PgKnowledge /
	// PgPlaybook back internal/proposal's pgAcceptAdapter (the ADR 0003
	// accept-seam contract).
	PgGTD() *gtd.Store
	PgProposal() *proposal.Store
	PgLearning() *learning.Store
	PgDecision() *decision.Store
	PgKnowledge() *knowledge.Store
	PgPlaybook() *playbook.Store

	// SqliteGTD / SqliteProposal / SqliteLearning / SqliteDecision /
	// SqliteKnowledge / SqlitePlaybook return concrete *Store handles only
	// when the bundle is SQLite-backed, so callers can use the *Tx
	// transactional helpers for atomic cross-store writes (e.g. the
	// confirm_proposal accept path for type='decision'). They return nil on
	// the Postgres bundle. SqliteKnowledge / SqlitePlaybook back
	// internal/storage/sqlite's sqliteAcceptAdapter (the ADR 0003 accept-seam
	// contract).
	SqliteGTD() *wbtsqlite.GTDStore
	SqliteProposal() *wbtsqlite.ProposalStore
	SqliteLearning() *wbtsqlite.LearningStore
	SqliteDecision() *wbtsqlite.DecisionStore
	SqliteKnowledge() *wbtsqlite.KnowledgeStore
	SqlitePlaybook() *wbtsqlite.PlaybookStore

	// SqliteDB returns the underlying *wbtsqlite.DB when the bundle is
	// SQLite-backed, or nil for the Postgres bundle. Used by domain stores
	// (e.g. completioncandidate) that need sql.Rows-based list queries
	// through the same connection pool as all other stores.
	SqliteDB() *wbtsqlite.DB
}