queries

Documentation

Index

• type Address
• type CreateUserParams
• type CreateVlanParams
• type DBTX
• type Prefix
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) CreateVlan(ctx context.Context, arg CreateVlanParams) (Vlan, error)
  • func (q *Queries) GetUserById(ctx context.Context, id int64) (User, error)
  • func (q *Queries) GetUserByUsername(ctx context.Context, username string) (User, error)
  • func (q *Queries) ListVlans(ctx context.Context) ([]Vlan, error)
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateUserParams
• type User
• type Vlan

Types

type Address

type Address struct {
	ID          int64
	Address     int64
	Description sql.NullString
}

type CreateUserParams

type CreateUserParams struct {
	Username     string
	PasswordHash []byte
}

type CreateVlanParams

type CreateVlanParams struct {
	Tag  int64
	Name sql.NullString
}

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 Prefix

type Prefix struct {
	ID          int64
	Bitmask     int64
	Size        int64
	Description sql.NullString
	VlanID      sql.NullInt64
}

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, arg CreateUserParams) (User, error)

func (*Queries) CreateVlan

func (q *Queries) CreateVlan(ctx context.Context, arg CreateVlanParams) (Vlan, error)

func (*Queries) GetUserById

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

func (*Queries) GetUserByUsername

func (q *Queries) GetUserByUsername(ctx context.Context, username string) (User, error)

func (*Queries) ListVlans

func (q *Queries) ListVlans(ctx context.Context) ([]Vlan, error)

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

func (*Queries) WithTx

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

type UpdateUserParams

type UpdateUserParams struct {
	Username     sql.NullString
	PasswordHash []byte
	ID           int64
}

type User

type User struct {
	ID           int64
	Username     string
	PasswordHash []byte
}

type Vlan

type Vlan struct {
	ID   int64
	Tag  int64
	Name sql.NullString
}