database

type DB interface {
	Close() error
	Ping(context.Context) error
	PingWithRetry(context.Context, int, int) error // Only used by ping command
	Exec(context.Context, *sqlf.Query) error
	QueryRow(context.Context, *sqlf.Query) *sql.Row
	Query(context.Context, *sqlf.Query) (*sql.Rows, error)
	Driver() dbdriver.DatabaseDriver

	WithTransact(ctx context.Context, f func(Tx) error) error
}

type DBConfig struct {
	// Connection settings
	ConnectTimeout   time.Duration // Timeout for establishing connections
	StatementTimeout time.Duration // Timeout for individual SQL statements

	// Connection pool settings
	MaxOpenConns    int           // Maximum number of open connections
	MaxIdleConns    int           // Maximum number of idle connections
	ConnMaxLifetime time.Duration // Maximum connection lifetime

	// Default timeouts for operations
	DefaultTimeout time.Duration // Default timeout for operations without explicit context deadline
}

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

type Tx interface {
	DB

	Commit() error
	Rollback() error
}