Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

pgperms

package module

Go to main page

Versions in this module

v0

v0.1.1

Jun 22, 2023

v0.1.0

Jan 25, 2023

v0.0.5

Jan 25, 2023

Changes in this version

type Config

+ LanguagePrivileges []GenericPrivilege

+ TypePrivileges []GenericPrivilege

v0.0.4

Jan 24, 2023

Changes in this version

+ func MD5Password(username, password string) string

+ func ScramSha256Password(password string) (string, error)

+ type PasswordHasher func(username, password string) (string, error)

+ func SelectPasswordHasher(ctx context.Context, conn *pgx.Conn) (PasswordHasher, error)

v0.0.3

Jan 23, 2023

Changes in this version

+ type QueryForDatabase struct

+ Database string

+ Query string

+ func (q QueryForDatabase) String() string

type Recorder

+ func (r *Recorder) Apply(ctx context.Context, conns *Connections) error

v0.0.2

Jan 23, 2023

v0.0.1

Jan 23, 2023

Changes in this version

+ func Dump(ctx context.Context, conns *Connections) (string, error)

+ func Escape(s string) string

+ func FetchRoles(ctx context.Context, conn *pgx.Conn) (map[string]RoleAttributes, error)

+ func Sync(ctx context.Context, conns *Connections, desired []byte, ss SyncSink) error

+ func SyncDatabases(ss SyncSink, wanted, tombstoned, actual []string)

+ func SyncPrivileges(ss SyncSink, databases []string, actual, desired []GenericPrivilege)

+ func SyncRoles(ss SyncSink, oldRoles, newRoles map[string]RoleAttributes, tombstoned []string)

+ func SyncSchemas(ss SyncSink, wanted, tombstoned, actual []string)

+ func ValidateConfig(c *Config) error

+ type Config struct

+ DatabasePrivileges []GenericPrivilege

+ Databases []string

+ IgnoreSuperuserGrants *bool

+ Roles map[string]RoleAttributes

+ SchemaPrivileges []GenericPrivilege

+ Schemas []string

+ SequencePrivileges []GenericPrivilege

+ TablePrivileges []GenericPrivilege

+ TombstonedDatabases []string

+ TombstonedRoles []string

+ TombstonedSchemas []string

+ func Gather(ctx context.Context, conns *Connections, ...) (*Config, error)

+ func (c Config) GetIgnoreSuperuserGrants() bool

+ type Connections struct

+ func NewConnections(ctx context.Context, primary *pgx.Conn) *Connections

+ func (c *Connections) Close()

+ func (c *Connections) DropCachedConnection(database string)

+ func (c *Connections) Get(database string) (*pgx.Conn, func(), error)

+ type GenericPrivilege struct

+ Columns []string

+ Databases []string

+ Domains []string

+ ForeignDataWrappers []string

+ ForeignServers []string

+ Grantable bool

+ Languages []string

+ LargeObjects []string

+ Privileges []string

+ Roles []string

+ Routines []string

+ Schemas []string

+ Sequences []string

+ Tables []string

+ Tablespaces []string

+ Types []string

+ type Recorder struct

+ func NewRecorder() *Recorder

+ func (r *Recorder) AddBarrier()

+ func (r *Recorder) Get() []string

+ func (r *Recorder) Query(database, query string)

+ type RoleAttributes struct

+ BypassRLS bool

+ ConnectionLimit *int

+ CreateDB bool

+ CreateRole bool

+ Inherit *bool

+ Login *bool

+ MemberOf []string

+ Password *string

+ Replication bool

+ Superuser bool

+ ValidUntil *time.Time

+ func (r RoleAttributes) CreateSQL(username string) string

+ func (r RoleAttributes) GetConnectionLimit() int

+ func (r RoleAttributes) GetInherit() bool

+ func (r RoleAttributes) GetLogin() bool

+ func (r RoleAttributes) GetValidUntil() time.Time

+ type SyncSink interface

+ AddBarrier func()

+ Query func(database, query string)