postgresql

Oct 18, 2023

Changes in this version

type Database

+ func (d Database) Key() string

type Role

+ func (r Role) Key() string

type RoleMember

+ func (r RoleMember) Key() RoleMemberKey

May 12, 2023

Changes in this version

type Role

+ Attributes RoleAttributes

+ MemberOf []string

+ SkipPasswordUpdate bool

+ type RoleAttributes struct

+ CreateDb bool

+ CreateRole bool

type Store

+ func (s *Store) ConnectionUrl() string

Feb 7, 2023

Changes in this version

type Databases

+ DbOpener DbOpener

+ type DbOpener interface

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

type DefaultGrants

+ DbOpener DbOpener

type RoleMembers

+ DbOpener DbOpener

type Roles

+ DbOpener DbOpener

type SchemaPrivileges

+ DbOpener DbOpener

type Store

+ func (s *Store) Close()

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

Aug 29, 2022

Changes in this version

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

type Database

+ UseExisting bool

+ type Databases struct

+ BaseConnectionUrl string

+ 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 DefaultGrant struct

+ Database string

+ Id string

+ Role string

+ Target string

+ func (g *DefaultGrant) SetId()

+ func (g DefaultGrant) Key() DefaultGrantKey

+ type DefaultGrantKey struct

+ Database string

+ Role string

+ Target string

+ type DefaultGrants struct

+ BaseConnectionUrl string

+ func (g *DefaultGrants) Create(grant DefaultGrant) (*DefaultGrant, error)

+ func (g *DefaultGrants) Drop(key DefaultGrantKey) (bool, error)

+ func (g *DefaultGrants) Read(key DefaultGrantKey) (*DefaultGrant, error)

+ func (g *DefaultGrants) Update(key DefaultGrantKey, grant DefaultGrant) (*DefaultGrant, error)

type Role

+ UseExisting bool

+ type RoleMember struct

+ Member string

+ Target string

+ UseExisting bool

+ WithAdminOption bool

+ type RoleMemberKey struct

+ Member string

+ Target string

+ type RoleMembers struct

+ BaseConnectionUrl string

+ func (r *RoleMembers) Create(membership RoleMember) (*RoleMember, error)

+ func (r *RoleMembers) Drop(key RoleMemberKey) (bool, error)

+ func (r *RoleMembers) Read(key RoleMemberKey) (*RoleMember, error)

+ func (r *RoleMembers) Update(key RoleMemberKey, membership RoleMember) (*RoleMember, error)

+ type Roles struct

+ BaseConnectionUrl string

+ func (r *Roles) Create(role Role) (*Role, error)

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

+ func (r *Roles) Read(key string) (*Role, error)

+ func (r *Roles) Update(key string, role Role) (*Role, error)

+ type SchemaPrivilege struct

+ Database string

+ Role string

+ func (p SchemaPrivilege) Key() SchemaPrivilegeKey

+ type SchemaPrivilegeKey struct

+ Database string

+ Role string

+ type SchemaPrivileges struct

+ BaseConnectionUrl string

+ func (r *SchemaPrivileges) Create(obj SchemaPrivilege) (*SchemaPrivilege, error)

+ func (r *SchemaPrivileges) Drop(key SchemaPrivilegeKey) (bool, error)

+ func (r *SchemaPrivileges) Read(key SchemaPrivilegeKey) (*SchemaPrivilege, error)

+ func (r *SchemaPrivileges) Update(key SchemaPrivilegeKey, obj SchemaPrivilege) (*SchemaPrivilege, error)

+ type Store struct

+ Databases *Databases

+ DefaultGrants *DefaultGrants

+ RoleMembers *RoleMembers

+ Roles *Roles

+ SchemaPrivileges *SchemaPrivileges

+ func NewStore(connUrl string) Store

Jul 5, 2022

Changes in this version

+ func GrantDbAndSchemaPrivileges(db *sql.DB, user Role, database Database) error

+ func GrantDefaultPrivileges(info *DbInfo, db *sql.DB, user Role, database Database) error

Aug 9, 2021

Changes in this version

type Database

+ DisableConnections bool

Aug 4, 2021

Changes in this version

type Database

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

type Role

+ func (r Role) Ensure(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

Aug 2, 2021

Changes in this version

+ type NoopRevoker struct

+ Tx *sql.Tx

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

+ type Revoker interface

+ Revoke func(db *sql.DB) error

type TempGrant

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

Jul 31, 2021

Changes in this version

type Database

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

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

type Role

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

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

Jul 29, 2021

Changes in this version

type TempGrant

+ CurrentUser string

type TempRoleMembership

+ CurrentUser string

Jul 29, 2021

Changes in this version

+ type Database struct

+ AllowConnections bool

+ Collation string

+ ConnectionLimit int

+ Encoding string

+ IsTemplate bool

+ LcCtype string

+ Name string

+ Owner string

+ TablespaceName string

+ Template string

+ func DefaultDatabase() Database

+ func (d Database) Create(conn *pgx.Conn, info DbInfo) (err error)

+ func (d Database) Drop() error

+ func (d Database) Update() error

+ type DbInfo struct

+ CurrentUser string

+ DbVersion semver.Version

+ IsSuperuser bool

+ SupportedFeatures Features

+ func CalcDbConnectionInfo(conn *pgx.Conn) (*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 Role struct

+ Name string

+ Password string

+ func (r Role) Create(conn *pgx.Conn) error

+ type TempGrant struct

+ Member string

+ Role string

+ Tx pgx.Tx

+ func (t TempGrant) Revoke(conn *pgx.Conn) error

+ type TempRoleMembership struct

+ Member string

+ Role string

+ func (t TempRoleMembership) Grant(conn *pgx.Conn, currentUser string) (*TempGrant, error)