sqlserver

Apr 27, 2026

Changes in this version

type Database

+ UseExisting bool

type Login

+ UseExisting bool

Mar 30, 2026

Changes in this version

+ func OpenDatabase(connUrl string, databaseName string) (*sql.DB, error)

+ func QuoteIdentifier(name string) string

+ func QuoteLiteral(s string) string

type Database

+ func (d Database) Key() string

+ type DatabaseAccess struct

+ Database string

+ Login string

+ func (a DatabaseAccess) Key() DatabaseAccessKey

+ type DatabaseAccessKey struct

+ Database string

+ Login string

+ type DatabaseAccesses struct

+ DbOpener DbOpener

+ func (r *DatabaseAccesses) Create(obj DatabaseAccess) (*DatabaseAccess, error)

+ func (r *DatabaseAccesses) Drop(key DatabaseAccessKey) (bool, error)

+ func (r *DatabaseAccesses) Read(key DatabaseAccessKey) (*DatabaseAccess, error)

+ func (r *DatabaseAccesses) Update(key DatabaseAccessKey, obj DatabaseAccess) (*DatabaseAccess, error)

+ type Databases struct

+ DbOpener DbOpener

+ func (d *Databases) Create(obj Database) (*Database, error)

+ func (d *Databases) Drop(key string) (bool, error)

+ func (d *Databases) Read(key string) (*Database, error)

+ func (d *Databases) Update(key string, obj Database) (*Database, error)

+ type DbOpener interface

+ OpenDatabase func(dbName string) (*sql.DB, error)

+ type Login struct

+ Name string

+ Password string

+ func (l Login) Key() string

+ type Logins struct

+ DbOpener DbOpener

+ func (r *Logins) Create(obj Login) (*Login, error)

+ func (r *Logins) Drop(key string) (bool, error)

+ func (r *Logins) Read(key string) (*Login, error)

+ func (r *Logins) Update(key string, obj Login) (*Login, error)

+ type Store struct

+ DatabaseAccess *DatabaseAccesses

+ Databases *Databases

+ Logins *Logins

+ func NewStore(connUrl string) *Store

+ func (s *Store) Close()

+ func (s *Store) ConnectionUrl() string

+ func (s *Store) OpenDatabase(dbName string) (*sql.DB, error)

Jul 26, 2022

Changes in this version

+ type Database struct

+ Collation string

+ ConnectionLimit int

+ DisableConnections bool

+ Encoding string

+ IsTemplate bool

+ LcCtype string

+ Name string

+ Owner string

+ TablespaceName string

+ Template string

+ func (d *Database) Read(db *sql.DB) error

+ func (d Database) Create(db *sql.DB, info DbInfo) error

+ func (d Database) Drop(db *sql.DB) error

+ func (d Database) Ensure(db *sql.DB, info DbInfo) error

+ func (d Database) Exists(db *sql.DB) (bool, error)

+ func (d Database) Update(db *sql.DB) error

+ type DbInfo struct

+ CurrentUser string

+ DbVersion semver.Version

+ IsSuperuser bool

+ SupportedFeatures Features

+ func CalcDbConnectionInfo(db *sql.DB) (*DbInfo, error)

+ type FeatureName uint

+ const FeatureCreateRoleWith

+ const FeatureDBAllowConnections

+ const FeatureDBIsTemplate

+ const FeatureExtension

+ const FeatureFallbackApplicationName

+ const FeatureForceDropDatabase

+ const FeaturePid

+ const FeaturePrivileges

+ const FeatureRLS

+ const FeatureReplication

+ const FeatureSchemaCreateIfNotExist

+ type Features map[FeatureName]bool

+ func CalcSupportedFeatures(dbVersion semver.Version) Features

+ func (f Features) IsSupported(name FeatureName) bool

+ type NoopRevoker struct

+ func (t NoopRevoker) Revoke(db *sql.DB) error

+ type Revoker interface

+ Revoke func(db *sql.DB) error

+ type Role struct

+ Name string

+ Password string

+ func (r Role) Create(db *sql.DB) error

+ func (r Role) Ensure(db *sql.DB) error

+ func (r Role) Exists(db *sql.DB) (bool, error)

+ func (r Role) Read(db *sql.DB) error

+ type RoleGrant struct

+ Member string

+ Target string

+ WithAdminOption bool

+ func (g RoleGrant) Create(db *sql.DB) error

+ func (g RoleGrant) Ensure(db *sql.DB) error

+ func (g RoleGrant) Exists(db *sql.DB) (bool, error)

+ func (g RoleGrant) Read(db *sql.DB) error

+ type TempGrant struct

+ CurrentUser string

+ Role string

+ Tx *sql.Tx

+ func GrantRoleMembership(db *sql.DB, role string, currentUser string) (*TempGrant, error)

+ func (t TempGrant) Revoke(db *sql.DB) error