postgresDB

Documentation

Index

• type Auth
• type CreateAuthTokenParams
• type CreateUserParams
• type DBTX
• type DeleteUserParams
• type GetAuthTokenParams
• type GetUserParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAuthToken(ctx context.Context, arg CreateAuthTokenParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteAuthToken(ctx context.Context, id pgtype.UUID) error
  • func (q *Queries) DeleteUser(ctx context.Context, arg DeleteUserParams) error
  • func (q *Queries) GetAuthToken(ctx context.Context, arg GetAuthTokenParams) (Auth, error)
  • func (q *Queries) GetUser(ctx context.Context, arg GetUserParams) (User, error)
  • func (q *Queries) GetUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpdateUserParams
• type User

Types

type Auth

type Auth struct {
	ID        pgtype.UUID
	Userid    pgtype.UUID
	Token     string
	Ipaddress pgtype.Text
	Useragent pgtype.Text
	Expiresat pgtype.Timestamptz
}

type CreateAuthTokenParams

type CreateAuthTokenParams struct {
	ID        pgtype.UUID
	Userid    pgtype.UUID
	Token     string
	Expiresat pgtype.Timestamptz
	Ipaddress pgtype.Text
	Useragent pgtype.Text
}

type CreateUserParams

type CreateUserParams struct {
	ID       pgtype.UUID
	Username string
	Password string
}

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 DeleteUserParams

type DeleteUserParams struct {
	ID       pgtype.UUID
	Username string
}

type GetAuthTokenParams

type GetAuthTokenParams struct {
	ID       pgtype.UUID
	Username string
}

type GetUserParams

type GetUserParams struct {
	ID       pgtype.UUID
	Username string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAuthToken

func (q *Queries) CreateAuthToken(ctx context.Context, arg CreateAuthTokenParams) error

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteAuthToken

func (q *Queries) DeleteAuthToken(ctx context.Context, id pgtype.UUID) error

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, arg DeleteUserParams) error

func (*Queries) GetAuthToken

func (q *Queries) GetAuthToken(ctx context.Context, arg GetAuthTokenParams) (Auth, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, arg GetUserParams) (User, error)

func (*Queries) GetUsers

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

func (*Queries) UpdateUser

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

func (*Queries) WithTx

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

type UpdateUserParams

type UpdateUserParams struct {
	Username   string
	Password   string
	ID         pgtype.UUID
	Username_2 string
}

type User

type User struct {
	ID        pgtype.UUID
	Username  string
	Password  string
	Createdat pgtype.Timestamptz
	Updatedat pgtype.Timestamptz
}