persistence

Documentation

Index

• type DB
  • func Open(dbPath string) (*DB, error)
  • func (db *DB) Migrate() error
  • func (db *DB) MigrateTenantColumn() error
  • func (db *DB) SeedDefaults() (string, error)

Types

type DB

type DB struct {
	*sql.DB
}

DB wraps *sql.DB with SQLite-specific setup and schema migration.

func Open

func Open(dbPath string) (*DB, error)

Open creates a SQLite connection at dbPath. Use ":memory:" for an in-memory database.

func (*DB) Migrate

func (db *DB) Migrate() error

Migrate creates all tables and indexes if they do not exist.

func (*DB) MigrateTenantColumn

func (db *DB) MigrateTenantColumn() error

MigrateTenantColumn adds tenant_id to session_entries if it does not already exist. This handles upgrades from schemas that predate multi-tenancy.

func (*DB) SeedDefaults

func (db *DB) SeedDefaults() (string, error)

SeedDefaults creates a default tenant, admin user, and API key if no tenants exist. Returns the plaintext API key for one-time display, or empty string if already seeded.