database

Documentation

Index

• type DBTX
• type Event
• type Position
• type Post
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUser(ctx context.Context, username string) (int32, error)
  • func (q *Queries) FindUserUsername(ctx context.Context, username string) (int32, error)
  • func (q *Queries) GetEvent(ctx context.Context, id int32) (Event, error)
  • func (q *Queries) GetPosition(ctx context.Context, id int32) (Position, error)
  • func (q *Queries) GetPositionUsers(ctx context.Context, committeeID int32) ([]UsersCommittee, error)
  • func (q *Queries) GetUser(ctx context.Context, id int32) (User, error)
  • func (q *Queries) GetUserPositions(ctx context.Context, userID int32) ([]UsersCommittee, error)
  • func (q *Queries) GetUsersPass(ctx context.Context, id int32) (UsersPass, error)
  • func (q *Queries) ListEvents(ctx context.Context) ([]Event, error)
  • func (q *Queries) ListPositions(ctx context.Context) ([]Position, error)
  • func (q *Queries) ListUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) SetUsersPass(ctx context.Context, arg SetUsersPassParams) error
  • func (q *Queries) UpdateUserName(ctx context.Context, arg UpdateUserNameParams) error
  • func (q *Queries) UpdateUserUsername(ctx context.Context, arg UpdateUserUsernameParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SetUsersPassParams
• type UpdateUserNameParams
• type UpdateUserUsernameParams
• type User
• type UsersCommittee
• type UsersPass

Types

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 Event

type Event struct {
	ID          int32
	Name        string
	StartTime   time.Time
	EndTime     sql.NullTime
	Location    sql.NullString
	Description sql.NullString
}

type Position

type Position struct {
	ID          int32
	Name        sql.NullString
	Alias       string
	Ordering    int16
	Description sql.NullString
	Executive   sql.NullBool
}

type Post

type Post struct {
	ID      int32
	Date    time.Time
	Title   string
	Body    sql.NullString
	EventID int32
	Link    sql.NullString
}

type Querier

type Querier interface {
	CreateUser(ctx context.Context, username string) (int32, error)
	FindUserUsername(ctx context.Context, username string) (int32, error)
	GetEvent(ctx context.Context, id int32) (Event, error)
	GetPosition(ctx context.Context, id int32) (Position, error)
	GetPositionUsers(ctx context.Context, committeeID int32) ([]UsersCommittee, error)
	GetUser(ctx context.Context, id int32) (User, error)
	GetUserPositions(ctx context.Context, userID int32) ([]UsersCommittee, error)
	GetUsersPass(ctx context.Context, id int32) (UsersPass, error)
	ListEvents(ctx context.Context) ([]Event, error)
	ListPositions(ctx context.Context) ([]Position, error)
	ListUsers(ctx context.Context) ([]User, error)
	SetUsersPass(ctx context.Context, arg SetUsersPassParams) error
	UpdateUserName(ctx context.Context, arg UpdateUserNameParams) error
	UpdateUserUsername(ctx context.Context, arg UpdateUserUsernameParams) error
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, username string) (int32, error)

func (*Queries) FindUserUsername

func (q *Queries) FindUserUsername(ctx context.Context, username string) (int32, error)

func (*Queries) GetEvent

func (q *Queries) GetEvent(ctx context.Context, id int32) (Event, error)

func (*Queries) GetPosition

func (q *Queries) GetPosition(ctx context.Context, id int32) (Position, error)

func (*Queries) GetPositionUsers

func (q *Queries) GetPositionUsers(ctx context.Context, committeeID int32) ([]UsersCommittee, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id int32) (User, error)

func (*Queries) GetUserPositions

func (q *Queries) GetUserPositions(ctx context.Context, userID int32) ([]UsersCommittee, error)

func (*Queries) GetUsersPass

func (q *Queries) GetUsersPass(ctx context.Context, id int32) (UsersPass, error)

func (*Queries) ListEvents

func (q *Queries) ListEvents(ctx context.Context) ([]Event, error)

func (*Queries) ListPositions

func (q *Queries) ListPositions(ctx context.Context) ([]Position, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context) ([]User, error)

func (*Queries) SetUsersPass

func (q *Queries) SetUsersPass(ctx context.Context, arg SetUsersPassParams) error

func (*Queries) UpdateUserName

func (q *Queries) UpdateUserName(ctx context.Context, arg UpdateUserNameParams) error

func (*Queries) UpdateUserUsername

func (q *Queries) UpdateUserUsername(ctx context.Context, arg UpdateUserUsernameParams) error

func (*Queries) WithTx

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

type SetUsersPassParams

type SetUsersPassParams struct {
	ID       int32
	Password string
}

type UpdateUserNameParams

type UpdateUserNameParams struct {
	ID   int32
	Name string
}

type UpdateUserUsernameParams

type UpdateUserUsernameParams struct {
	ID       int32
	Username string
}

type User

type User struct {
	ID       int32
	Username string
	Name     string
	Bio      sql.NullString
}

type UsersCommittee

type UsersCommittee struct {
	ID          int32
	UserID      int32
	CommitteeID int32
	FromDate    time.Time
	TillDate    sql.NullTime
	Outgoing    bool
}

type UsersPass

type UsersPass struct {
	ID       int32
	Password string
}