sqlc

Documentation

Index

• type CreateGuildParams
• type CreateSystemUserGuildParams
• type CreateTokenParams
• type DBTX
• type DeleteSystemUserGuildParams
• type FindByIDSystemUserGuildParams
• type Guild
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateGuild(ctx context.Context, arg CreateGuildParams) (sql.Result, error)
  • func (q *Queries) CreateSystemUser(ctx context.Context, discordID string) (sql.Result, error)
  • func (q *Queries) CreateSystemUserGuild(ctx context.Context, arg CreateSystemUserGuildParams) (sql.Result, error)
  • func (q *Queries) CreateToken(ctx context.Context, arg CreateTokenParams) (sql.Result, error)
  • func (q *Queries) DeleteGuild(ctx context.Context, id int64) error
  • func (q *Queries) DeleteSystemUser(ctx context.Context, id int64) error
  • func (q *Queries) DeleteSystemUserGuild(ctx context.Context, arg DeleteSystemUserGuildParams) error
  • func (q *Queries) DeleteToken(ctx context.Context, id int64) error
  • func (q *Queries) FindByDiscordIDGuild(ctx context.Context, discordID string) (Guild, error)
  • func (q *Queries) FindByDiscordIDSystemUser(ctx context.Context, discordID string) (SystemUser, error)
  • func (q *Queries) FindByGuildIDSystemUserGuild(ctx context.Context, guildID int64) ([]SystemUserGuild, error)
  • func (q *Queries) FindByIDGuild(ctx context.Context, id int64) (Guild, error)
  • func (q *Queries) FindByIDSystemUser(ctx context.Context, id int64) (SystemUser, error)
  • func (q *Queries) FindByIDSystemUserGuild(ctx context.Context, arg FindByIDSystemUserGuildParams) (SystemUserGuild, error)
  • func (q *Queries) FindByIDToken(ctx context.Context, id int64) (Token, error)
  • func (q *Queries) FindBySystemUserIDSystemUserGuild(ctx context.Context, systemUserID int64) ([]SystemUserGuild, error)
  • func (q *Queries) FindByUserIDToken(ctx context.Context, systemUserID sql.NullInt64) (Token, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SystemUser
• type SystemUserGuild
• type Token

Types

type CreateGuildParams

type CreateGuildParams struct {
	Name      string
	DiscordID string
	SheetID   sql.NullString
}

type CreateSystemUserGuildParams

type CreateSystemUserGuildParams struct {
	SystemUserID int64
	GuildID      int64
}

type CreateTokenParams

type CreateTokenParams struct {
	SystemUserID sql.NullInt64
	GuildID      sql.NullInt64
	AccessToken  string
	TokenType    string
	RefreshToken string
	Expiry       time.Time
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteSystemUserGuildParams

type DeleteSystemUserGuildParams struct {
	SystemUserID int64
	GuildID      int64
}

type FindByIDSystemUserGuildParams

type FindByIDSystemUserGuildParams struct {
	GuildID      int64
	SystemUserID int64
}

type Guild

type Guild struct {
	ID        int64
	Name      string
	DiscordID string
	SheetID   sql.NullString
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateGuild

func (q *Queries) CreateGuild(ctx context.Context, arg CreateGuildParams) (sql.Result, error)

func (*Queries) CreateSystemUser

func (q *Queries) CreateSystemUser(ctx context.Context, discordID string) (sql.Result, error)

func (*Queries) CreateSystemUserGuild

func (q *Queries) CreateSystemUserGuild(ctx context.Context, arg CreateSystemUserGuildParams) (sql.Result, error)

func (*Queries) CreateToken

func (q *Queries) CreateToken(ctx context.Context, arg CreateTokenParams) (sql.Result, error)

func (*Queries) DeleteGuild

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

func (*Queries) DeleteSystemUser

func (q *Queries) DeleteSystemUser(ctx context.Context, id int64) error

func (*Queries) DeleteSystemUserGuild

func (q *Queries) DeleteSystemUserGuild(ctx context.Context, arg DeleteSystemUserGuildParams) error

func (*Queries) DeleteToken

func (q *Queries) DeleteToken(ctx context.Context, id int64) error

func (*Queries) FindByDiscordIDGuild

func (q *Queries) FindByDiscordIDGuild(ctx context.Context, discordID string) (Guild, error)

func (*Queries) FindByDiscordIDSystemUser

func (q *Queries) FindByDiscordIDSystemUser(ctx context.Context, discordID string) (SystemUser, error)

func (*Queries) FindByGuildIDSystemUserGuild

func (q *Queries) FindByGuildIDSystemUserGuild(ctx context.Context, guildID int64) ([]SystemUserGuild, error)

func (*Queries) FindByIDGuild

func (q *Queries) FindByIDGuild(ctx context.Context, id int64) (Guild, error)

func (*Queries) FindByIDSystemUser

func (q *Queries) FindByIDSystemUser(ctx context.Context, id int64) (SystemUser, error)

func (*Queries) FindByIDSystemUserGuild

func (q *Queries) FindByIDSystemUserGuild(ctx context.Context, arg FindByIDSystemUserGuildParams) (SystemUserGuild, error)

func (*Queries) FindByIDToken

func (q *Queries) FindByIDToken(ctx context.Context, id int64) (Token, error)

func (*Queries) FindBySystemUserIDSystemUserGuild

func (q *Queries) FindBySystemUserIDSystemUserGuild(ctx context.Context, systemUserID int64) ([]SystemUserGuild, error)

func (*Queries) FindByUserIDToken

func (q *Queries) FindByUserIDToken(ctx context.Context, systemUserID sql.NullInt64) (Token, error)

func (*Queries) WithTx

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

type SystemUser

type SystemUser struct {
	ID        int64
	DiscordID string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type SystemUserGuild

type SystemUserGuild struct {
	SystemUserID int64
	GuildID      int64
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

type Token

type Token struct {
	ID           int64
	SystemUserID sql.NullInt64
	GuildID      sql.NullInt64
	AccessToken  string
	TokenType    string
	RefreshToken string
	Expiry       time.Time
	CreatedAt    time.Time
	UpdatedAt    time.Time
}