db

Documentation

Index

• type AddOtpOfUserParam
• type CreateSessionParams
• type CreateUserParams
• type DBTX
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) AddOtpOfUser(ctx context.Context, param AddOtpOfUserParam) (i models.EmailOTP, err error)
  • func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (i models.Sessions, err error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (i models.User, err error)
  • func (q *Queries) GetOtpOfUser(ctx context.Context, email string) (i models.EmailOTP, err error)
  • func (q *Queries) GetSession(ctx context.Context, id uuid.UUID) (i models.Sessions, err error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (i models.User, err error)
  • func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (i models.User, err error)
  • func (q *Queries) GetUserByUserName(ctx context.Context, userName string) (i models.User, err error)
  • func (q *Queries) MakeUserVerify(ctx context.Context, email string) (i models.User, err error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SQLStore
  • func NewStore(db *sql.DB) *SQLStore
• type Store

Types

type AddOtpOfUserParam

type AddOtpOfUserParam struct {
	UID        uuid.UUID `json:"UID" `
	OTP        int64     `json:"OTP"`
	CountOfDay int16     `json:"CountOfDay"`
	ExpiredAt  time.Time `json:"ExpiredAt" `
}

type CreateSessionParams

type CreateSessionParams struct {
	ID           uuid.UUID `json:"ID" `
	UID          uuid.UUID `json:"UID" `
	RefreshToken string    `json:"RefreshToken"`
	UserAgent    string    `json:"UserAgent" `
	ClientIP     string    `json:"ClientIP" `
	IsBlocked    bool      `json:"IsBlocked" `
	DeviceID     string    `json:"DeviceID"`
	ExpiresAt    time.Time `json:"ExpiresAt" `
}

type CreateUserParams

type CreateUserParams struct {
	FirstName string `json:"FirstName" `
	LastName  string `json:"LastName" `
	Email     string `json:"Email" `
	UserName  string `json:"UserName" `
	Password  string `json:"password" `
}

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 Querier

type Querier interface {
	GetUserByID(ctx context.Context, id uuid.UUID) (i models.User, err error)
	CreateUser(ctx context.Context, arg CreateUserParams) (i models.User, err error)
	GetUserByUserName(ctx context.Context, username string) (i models.User, err error)
	GetUserByEmail(ctx context.Context, email string) (i models.User, err error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (i models.Sessions, err error)
	GetSession(ctx context.Context, id uuid.UUID) (i models.Sessions, err error)
	GetOtpOfUser(ctx context.Context, email string) (i models.EmailOTP, err error)
	AddOtpOfUser(ctx context.Context, param AddOtpOfUserParam) (i models.EmailOTP, err error)
	MakeUserVerify(ctx context.Context, email string) (i models.User, err error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddOtpOfUser

func (q *Queries) AddOtpOfUser(ctx context.Context, param AddOtpOfUserParam) (i models.EmailOTP, err error)

func (*Queries) CreateSession

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (i models.Sessions, err error)

func (*Queries) CreateUser

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

func (*Queries) GetOtpOfUser

func (q *Queries) GetOtpOfUser(ctx context.Context, email string) (i models.EmailOTP, err error)

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, id uuid.UUID) (i models.Sessions, err error)

func (*Queries) GetUserByEmail

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

func (*Queries) GetUserByID

func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (i models.User, err error)

func (*Queries) GetUserByUserName

func (q *Queries) GetUserByUserName(ctx context.Context, userName string) (i models.User, err error)

func (*Queries) MakeUserVerify

func (q *Queries) MakeUserVerify(ctx context.Context, email string) (i models.User, err error)

func (*Queries) WithTx

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

type SQLStore

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

func NewStore

func NewStore(db *sql.DB) *SQLStore

type Store

type Store interface {
	Querier
}