database

Documentation

Index

• func ConvertFromPGTimestamptzToTime(t pgtype.Timestamptz) time.Time
• func ConvertToPGTimestamptz(t time.Time) pgtype.Timestamptz
• func SetupDatabasePool(ctx context.Context, databaseURL string) *pgxpool.Pool
• type ConfirmUserEmailParams
• type DBTX
• type InsertUserParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) ConfirmUserEmail(ctx context.Context, arg ConfirmUserEmailParams) (User, error)
  • func (q *Queries) DeleteToken(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) DoesMailExists(ctx context.Context, mail string) (bool, error)
  • func (q *Queries) InsertUser(ctx context.Context, arg InsertUserParams) (User, error)
  • func (q *Queries) QueryTokenByHash(ctx context.Context, hash string) (Token, error)
  • func (q *Queries) QueryUser(ctx context.Context, id uuid.UUID) (User, error)
  • func (q *Queries) QueryUserByMail(ctx context.Context, mail string) (User, error)
  • func (q *Queries) QueryUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) RemoveUnverifiedUsers(ctx context.Context, twoWeeksAgo pgtype.Timestamptz) error
  • func (q *Queries) StoreToken(ctx context.Context, arg StoreTokenParams) error
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type StoreTokenParams
• type Token
• type UpdateUserParams
• type User

Functions

func ConvertFromPGTimestamptzToTime

func ConvertFromPGTimestamptzToTime(t pgtype.Timestamptz) time.Time

func ConvertToPGTimestamptz

func ConvertToPGTimestamptz(t time.Time) pgtype.Timestamptz

func SetupDatabasePool

func SetupDatabasePool(ctx context.Context, databaseURL string) *pgxpool.Pool

Types

type ConfirmUserEmailParams

type ConfirmUserEmailParams struct {
	ID             uuid.UUID
	UpdatedAt      pgtype.Timestamptz
	MailVerifiedAt pgtype.Timestamptz
}

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 InsertUserParams

type InsertUserParams struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
	Name      string
	Mail      string
	Password  string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ConfirmUserEmail

func (q *Queries) ConfirmUserEmail(ctx context.Context, arg ConfirmUserEmailParams) (User, error)

func (*Queries) DeleteToken

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

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error

func (*Queries) DoesMailExists

func (q *Queries) DoesMailExists(ctx context.Context, mail string) (bool, error)

func (*Queries) InsertUser

func (q *Queries) InsertUser(ctx context.Context, arg InsertUserParams) (User, error)

func (*Queries) QueryTokenByHash

func (q *Queries) QueryTokenByHash(ctx context.Context, hash string) (Token, error)

func (*Queries) QueryUser

func (q *Queries) QueryUser(ctx context.Context, id uuid.UUID) (User, error)

func (*Queries) QueryUserByMail

func (q *Queries) QueryUserByMail(ctx context.Context, mail string) (User, error)

func (*Queries) QueryUsers

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

func (*Queries) RemoveUnverifiedUsers

func (q *Queries) RemoveUnverifiedUsers(ctx context.Context, twoWeeksAgo pgtype.Timestamptz) error

func (*Queries) StoreToken

func (q *Queries) StoreToken(ctx context.Context, arg StoreTokenParams) error

func (*Queries) UpdateUser

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

func (*Queries) WithTx

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

type StoreTokenParams

type StoreTokenParams struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	Hash      string
	ExpiresAt pgtype.Timestamptz
	Scope     string
	UserID    uuid.UUID
}

type Token

type Token struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	Hash      string
	ExpiresAt pgtype.Timestamptz
	Scope     string
	UserID    uuid.UUID
}

type UpdateUserParams

type UpdateUserParams struct {
	ID        uuid.UUID
	UpdatedAt pgtype.Timestamptz
	Name      string
	Mail      string
	Password  string
}

type User

type User struct {
	ID             uuid.UUID
	CreatedAt      pgtype.Timestamptz
	UpdatedAt      pgtype.Timestamptz
	Name           string
	Mail           string
	MailVerifiedAt pgtype.Timestamptz
	Password       string
}