pgsqlc

Documentation

Index

• type CreateSessionParams
• type CreateUserParams
• type CreateUserRow
• type DBTX
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
  • func (q *Queries) GetSession(ctx context.Context, uid uuid.UUID) (Session, error)
  • func (q *Queries) GetUser(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserByUID(ctx context.Context, uid uuid.UUID) (User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Session
• type User

Types

type CreateSessionParams

type CreateSessionParams struct {
	UID          uuid.UUID
	UserEmail    string
	RefreshToken string
	UserAgent    string
	ClientIP     string
	IsBlocked    bool
	ExpiresAt    time.Time
}

type CreateUserParams

type CreateUserParams struct {
	Email     string
	Password  string
	FullName  string
	IsStaff   bool
	IsActive  bool
	LastLogin time.Time
}

type CreateUserRow

type CreateUserRow struct {
	UID        uuid.UUID
	Email      string
	FullName   string
	CreatedAt  time.Time
	ModifiedAt time.Time
}

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 Querier

type Querier interface {
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
	GetSession(ctx context.Context, uid uuid.UUID) (Session, error)
	GetUser(ctx context.Context, email string) (User, error)
	GetUserByUID(ctx context.Context, uid uuid.UUID) (User, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateSession

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

func (*Queries) CreateUser

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

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, uid uuid.UUID) (Session, error)

func (*Queries) GetUser

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

func (*Queries) GetUserByUID

func (q *Queries) GetUserByUID(ctx context.Context, uid uuid.UUID) (User, error)

func (*Queries) WithTx

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

type Session

type Session struct {
	ID           int64
	UID          uuid.UUID
	UserEmail    string
	RefreshToken string
	UserAgent    string
	ClientIP     string
	IsBlocked    bool
	ExpiresAt    time.Time
	CreatedAt    time.Time
}

type User

type User struct {
	ID         int64
	UID        uuid.UUID
	Email      string
	Password   string
	FullName   string
	IsStaff    bool
	IsActive   bool
	LastLogin  time.Time
	CreatedAt  time.Time
	ModifiedAt time.Time
}