db

Documentation

Index

• func CreateConnection(ctx context.Context, dbUrl string) *pgx.Conn
• type DBTX
• type Queries
  • func GetQueries() *Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserById(ctx context.Context, id pgtype.UUID) (User, error)
  • func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (pgtype.UUID, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpsertUserParams
• type User

Functions

func CreateConnection

func CreateConnection(ctx context.Context, dbUrl string) *pgx.Conn

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 Queries

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

func GetQueries

func GetQueries() *Queries

func New

func New(db DBTX) *Queries

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserById

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

func (*Queries) UpsertUser

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (pgtype.UUID, error)

func (*Queries) WithTx

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

type UpsertUserParams

type UpsertUserParams struct {
	FullName          string `json:"full_name"`
	Email             string `json:"email"`
	PhoneNumber       string `json:"phone_number"`
	ProfilePictureUrl string `json:"profile_picture_url"`
	Username          string `json:"username"`
	HashedPassword    string `json:"hashed_password"`
}

type User

type User struct {
	ID                pgtype.UUID        `json:"id"`
	FullName          string             `json:"full_name"`
	Email             string             `json:"email"`
	PhoneNumber       string             `json:"phone_number"`
	ProfilePictureUrl string             `json:"profile_picture_url"`
	Username          string             `json:"username"`
	HashedPassword    string             `json:"hashed_password"`
	CreatedAt         pgtype.Timestamptz `json:"created_at"`
}