db

Documentation

Index

• type AddCountryParams
• type AddStateParams
• type CreateSessionParams
• type CreateUserParams
• type DBTX
• type GetCountriesListParams
• type GetStateListByCountryParams
• type GetStateListParams
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) AddCountry(ctx context.Context, arg AddCountryParams) (models.Country, error)
  • func (q *Queries) AddState(ctx context.Context, arg AddStateParams) (models.State, error)
  • func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (models.Sessions, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (models.User, error)
  • func (q *Queries) GetCountriesList(ctx context.Context, arg GetCountriesListParams) ([]models.Country, error)
  • func (q *Queries) GetSession(ctx context.Context, id uuid.UUID) (models.Sessions, error)
  • func (q *Queries) GetStateList(ctx context.Context, arg GetStateListParams) ([]models.State, error)
  • func (q *Queries) GetStateListByCountry(ctx context.Context, arg GetStateListByCountryParams) ([]models.State, error)
  • func (q *Queries) GetTotalCountryCount(ctx context.Context) (models.CountryCount, error)
  • func (q *Queries) GetTotalStateCount(ctx context.Context) (models.StateCount, error)
  • func (q *Queries) GetUser(ctx context.Context, username string) (models.User, error)
  • func (q *Queries) GetUserById(ctx context.Context, userId int32) (models.User, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SQLStore
  • func NewStore(db *sql.DB) *SQLStore
• type Store

Types

type AddCountryParams

type AddCountryParams struct {
	ID               int    `json:"id"`
	Name             string `json:"name" `
	CountryShortName string `json:"country_short_name"`
}

type AddStateParams

type AddStateParams struct {
	ID        int    `json:"id"`
	StateName string `json:"state_name" `
	CountryId int    `json:"country_id"`
}

type CreateSessionParams

type CreateSessionParams struct {
	ID           uuid.UUID `json:"id"`
	UserId       int32     `json:"userId"`
	RefreshToken string    `json:"refreshToken"`
	UserAgent    string    `json:"userAgent"`
	ClientIp     string    `json:"clientIp"`
	IsBlocked    bool      `json:"isBlocked"`
	ExpiresAt    time.Time `json:"expiresAt"`
}

type CreateUserParams

type CreateUserParams struct {
	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 GetCountriesListParams

type GetCountriesListParams struct {
	FromId int `json:"fromId"`
	Limit  int `json:"limit"`
}

type GetStateListByCountryParams

type GetStateListByCountryParams struct {
	Name string `json:"name" `
}

type GetStateListParams

type GetStateListParams struct {
	FromId int `json:"fromId"`
	Limit  int `json:"limit"`
}

type Querier

type Querier interface {
	CreateUser(ctx context.Context, arg CreateUserParams) (models.User, error)
	GetUser(ctx context.Context, username string) (models.User, error)
	GetUserById(ctx context.Context, userid int32) (models.User, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (models.Sessions, error)
	GetSession(ctx context.Context, id uuid.UUID) (models.Sessions, error)
	AddCountry(ctx context.Context, arg AddCountryParams) (models.Country, error)
	GetTotalCountryCount(ctx context.Context) (models.CountryCount, error)
	GetCountriesList(ctx context.Context, arg GetCountriesListParams) ([]models.Country, error)
	AddState(ctx context.Context, arg AddStateParams) (models.State, error)
	GetTotalStateCount(ctx context.Context) (models.StateCount, error)
	GetStateList(ctx context.Context, arg GetStateListParams) ([]models.State, error)
	GetStateListByCountry(ctx context.Context, arg GetStateListByCountryParams) ([]models.State, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddCountry

func (q *Queries) AddCountry(ctx context.Context, arg AddCountryParams) (models.Country, error)

func (*Queries) AddState

func (q *Queries) AddState(ctx context.Context, arg AddStateParams) (models.State, error)

func (*Queries) CreateSession

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

func (*Queries) CreateUser

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

func (*Queries) GetCountriesList

func (q *Queries) GetCountriesList(ctx context.Context, arg GetCountriesListParams) ([]models.Country, error)

func (*Queries) GetSession

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

func (*Queries) GetStateList

func (q *Queries) GetStateList(ctx context.Context, arg GetStateListParams) ([]models.State, error)

func (*Queries) GetStateListByCountry

func (q *Queries) GetStateListByCountry(ctx context.Context, arg GetStateListByCountryParams) ([]models.State, error)

func (*Queries) GetTotalCountryCount

func (q *Queries) GetTotalCountryCount(ctx context.Context) (models.CountryCount, error)

func (*Queries) GetTotalStateCount

func (q *Queries) GetTotalStateCount(ctx context.Context) (models.StateCount, error)

func (*Queries) GetUser

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

func (*Queries) GetUserById

func (q *Queries) GetUserById(ctx context.Context, userId int32) (models.User, 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
}