persistence

type DB struct {
	*sql.DB
}

type Options struct {
	// UseInMemory forces our persistence layer to use an in-memory sqlite database
	UseInMemory bool

	// DSN contains the DSN, such as the file name of our sqlite database
	DSN string
}

type Scanner interface {
	Scan(args ...any) error
}

type StorageObject interface {
	InitTables(db *DB) (err error)
	PrepareReplace(db *DB) (stmt *sql.Stmt, err error)
	PrepareList(db *DB) (stmt *sql.Stmt, err error)
	PrepareGet(db *DB) (stmt *sql.Stmt, err error)
	PrepareUpdate(db *DB, columns []string) (stmt *sql.Stmt, err error)
	PrepareDelete(db *DB) (stmt *sql.Stmt, err error)
	ReplaceIntoArgs() []any
	UpdateArgs([]string) []any
	Scan(sc Scanner) (StorageObject, error)
}

type StorageOperations[T StorageObject] interface {
	Replace(o StorageObject) (err error)
	List(args ...any) (list []T, err error)
	Get(key any) (obj T, err error)
	Update(key any, in T, columns []string) (out T, err error)
	Delete(key any) (err error)
}