postgres

Documentation

Index

• func Connect(ctx context.Context, url string) (*pgxpool.Pool, error)
• func IsConstraintFailed(err error) bool
• func IsErrorCode(err error, code string) bool
• func Migrate(ctx context.Context, db *pgxpool.Pool) error
• func Versions() []string
• type DBTX
• type DeleteSubmissionParams
• type InitGuildParams
• type InsertPINParams
• type KnownGuild
• type Member
• type MemberInfoParams
• type Meta
• type PinCode
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CleanupSubmissions(ctx context.Context) error
  • func (q *Queries) DeleteGuild(ctx context.Context, guildID int64) (int64, error)
  • func (q *Queries) DeleteSubmission(ctx context.Context, arg DeleteSubmissionParams) error
  • func (q *Queries) GuildInfo(ctx context.Context, guildID int64) (KnownGuild, error)
  • func (q *Queries) InitGuild(ctx context.Context, arg InitGuildParams) error
  • func (q *Queries) InsertPIN(ctx context.Context, arg InsertPINParams) error
  • func (q *Queries) MemberInfo(ctx context.Context, arg MemberInfoParams) ([]byte, error)
  • func (q *Queries) RegisterMember(ctx context.Context, arg RegisterMemberParams) error
  • func (q *Queries) RestoreSubmission(ctx context.Context, arg RestoreSubmissionParams) ([]byte, error)
  • func (q *Queries) SaveSubmission(ctx context.Context, arg SaveSubmissionParams) error
  • func (q *Queries) SetGuildAdminRoleID(ctx context.Context, arg SetGuildAdminRoleIDParams) (int64, error)
  • func (q *Queries) UnregisterMember(ctx context.Context, arg UnregisterMemberParams) (int64, error)
  • func (q *Queries) ValidatePIN(ctx context.Context, arg ValidatePINParams) ([]byte, error)
  • func (q *Queries) Version(ctx context.Context) (int16, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type RegisterMemberParams
• type RegistrationSubmission
• type RestoreSubmissionParams
• type SaveSubmissionParams
• type SetGuildAdminRoleIDParams
• type UnregisterMemberParams
• type ValidatePINParams

Functions

func Connect

func Connect(ctx context.Context, url string) (*pgxpool.Pool, error)

Connect connects to a pgSQL database.

func IsConstraintFailed

func IsConstraintFailed(err error) bool

IsConstraintFailed returns true if err is returned because of a unique constraint violation.

func IsErrorCode

func IsErrorCode(err error, code string) bool

func Migrate

func Migrate(ctx context.Context, db *pgxpool.Pool) error

Migrate migrates the given database to the latest migrations. It uses the user_version pragma.

func Versions

func Versions() []string

Versions returns the versions of the schema.

Types

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteSubmissionParams

type DeleteSubmissionParams struct {
	GuildID int64
	UserID  int64
}

type InitGuildParams

type InitGuildParams struct {
	GuildID           int64
	ChannelID         int64
	InitUserID        int64
	RoleID            int64
	RegisteredMessage string
}

type InsertPINParams

type InsertPINParams struct {
	GuildID int64
	UserID  int64
	Pin     int16
}

type KnownGuild

type KnownGuild struct {
	GuildID           int64
	ChannelID         int64
	RoleID            int64
	InitUserID        int64
	RegisteredMessage string
	AdminRoleID       pgtype.Int8
}

type Member

type Member struct {
	GuildID  int64
	UserID   int64
	Email    string
	Metadata []byte
}

type MemberInfoParams

type MemberInfoParams struct {
	GuildID int64
	UserID  int64
}

type Meta

type Meta struct {
	V int16
}

type PinCode

type PinCode struct {
	GuildID int64
	UserID  int64
	Pin     int16
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) CleanupSubmissions

func (q *Queries) CleanupSubmissions(ctx context.Context) error

func (*Queries) DeleteGuild

func (q *Queries) DeleteGuild(ctx context.Context, guildID int64) (int64, error)

func (*Queries) DeleteSubmission

func (q *Queries) DeleteSubmission(ctx context.Context, arg DeleteSubmissionParams) error

func (*Queries) GuildInfo

func (q *Queries) GuildInfo(ctx context.Context, guildID int64) (KnownGuild, error)

func (*Queries) InitGuild

func (q *Queries) InitGuild(ctx context.Context, arg InitGuildParams) error

func (*Queries) InsertPIN

func (q *Queries) InsertPIN(ctx context.Context, arg InsertPINParams) error

func (*Queries) MemberInfo

func (q *Queries) MemberInfo(ctx context.Context, arg MemberInfoParams) ([]byte, error)

func (*Queries) RegisterMember

func (q *Queries) RegisterMember(ctx context.Context, arg RegisterMemberParams) error

func (*Queries) RestoreSubmission

func (q *Queries) RestoreSubmission(ctx context.Context, arg RestoreSubmissionParams) ([]byte, error)

func (*Queries) SaveSubmission

func (q *Queries) SaveSubmission(ctx context.Context, arg SaveSubmissionParams) error

func (*Queries) SetGuildAdminRoleID

func (q *Queries) SetGuildAdminRoleID(ctx context.Context, arg SetGuildAdminRoleIDParams) (int64, error)

func (*Queries) UnregisterMember

func (q *Queries) UnregisterMember(ctx context.Context, arg UnregisterMemberParams) (int64, error)

func (*Queries) ValidatePIN

func (q *Queries) ValidatePIN(ctx context.Context, arg ValidatePINParams) ([]byte, error)

func (*Queries) Version

func (q *Queries) Version(ctx context.Context) (int16, error)

Language: postgresql

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type RegisterMemberParams

type RegisterMemberParams struct {
	GuildID  int64
	UserID   int64
	Email    string
	Metadata []byte
}

type RegistrationSubmission

type RegistrationSubmission struct {
	GuildID  int64
	UserID   int64
	Metadata []byte
	ExpireAt pgtype.Timestamp
}

type RestoreSubmissionParams

type RestoreSubmissionParams struct {
	GuildID int64
	UserID  int64
}

type SaveSubmissionParams

type SaveSubmissionParams struct {
	GuildID  int64
	UserID   int64
	Metadata []byte
}

type SetGuildAdminRoleIDParams

type SetGuildAdminRoleIDParams struct {
	GuildID     int64
	AdminRoleID pgtype.Int8
}

type UnregisterMemberParams

type UnregisterMemberParams struct {
	GuildID int64
	UserID  int64
}

type ValidatePINParams

type ValidatePINParams struct {
	GuildID int64
	UserID  int64
	Pin     int16
}