dbs

package
v0.0.0-...-0a6cffe Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Sep 22, 2023 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Company

type Company struct {
	ID        int64
	Alias     string
	Name      string
	CreatedBy int64
	CreatedAt time.Time
}

type CompanyNewAndGetIDParams

type CompanyNewAndGetIDParams struct {
	Alias     string
	Name      string
	CreatedBy int64
	CreatedAt time.Time
}

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 Queries

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

func New

func New(db DBTX) *Queries

func Prepare

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close

func (q *Queries) Close() error

func (*Queries) CompanyNewAndGetID

func (q *Queries) CompanyNewAndGetID(ctx context.Context, arg CompanyNewAndGetIDParams) (int64, error)

func (*Queries) ReviewNew

func (q *Queries) ReviewNew(ctx context.Context, arg ReviewNewParams) (int64, error)

func (*Queries) ReviewsNested

func (q *Queries) ReviewsNested(ctx context.Context, arg ReviewsNestedParams) ([]ReviewsNestedRow, error)

func (*Queries) ReviewsRootByCompany

func (q *Queries) ReviewsRootByCompany(ctx context.Context, companyID int64) ([]Review, error)

func (*Queries) UserGetByID

func (q *Queries) UserGetByID(ctx context.Context, id int64) (User, error)

func (*Queries) UserNew

func (q *Queries) UserNew(ctx context.Context, arg UserNewParams) error

func (*Queries) UserNewAndGet

func (q *Queries) UserNewAndGet(ctx context.Context, arg UserNewAndGetParams) (User, error)

func (*Queries) Users

func (q *Queries) Users(ctx context.Context, arg UsersParams) ([]User, error)

func (*Queries) UsersCount

func (q *Queries) UsersCount(ctx context.Context) (int64, error)

func (*Queries) VacancyByCompanies

func (q *Queries) VacancyByCompanies(ctx context.Context, companies []int64) ([]VacancyByCompaniesRow, error)

func (*Queries) VacancyNew

func (q *Queries) VacancyNew(ctx context.Context, arg VacancyNewParams) error

func (*Queries) WithTx

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

type Review

type Review struct {
	ID        int64
	ParentID  sql.NullInt64
	CompanyID int64
	Content   string
	CreatedBy int64
	CreatedAt time.Time
}

type ReviewNewParams

type ReviewNewParams struct {
	ParentID  sql.NullInt64
	CompanyID int64
	Content   string
	CreatedBy int64
	CreatedAt time.Time
}

type ReviewsNestedParams

type ReviewsNestedParams struct {
	CompanyID int64
	ID        int64
}

type ReviewsNestedRow

type ReviewsNestedRow struct {
	ID        int64
	ParentID  sql.NullInt64
	CompanyID int64
	Content   string
	CreatedBy int64
	CreatedAt time.Time
}

type User

type User struct {
	ID        int64
	Name      string
	CreatedAt time.Time
}

type UserNewAndGetParams

type UserNewAndGetParams struct {
	Name      string
	CreatedAt time.Time
}

type UserNewParams

type UserNewParams struct {
	Name      string
	CreatedAt time.Time
}

type UsersParams

type UsersParams struct {
	Offset int32
	Limit  int32
}

type Vacancy

type Vacancy struct {
	ID        int64
	CompanyID int64
	Title     string
	CreatedBy int64
	CreatedAt time.Time
}

type VacancyByCompaniesRow

type VacancyByCompaniesRow struct {
	VacancyID    int64
	VacancyTitle string
	CompanyID    int64
	CompanyAlias string
	CompanyName  string
}

type VacancyNewParams

type VacancyNewParams struct {
	CompanyID int64
	Title     string
	CreatedBy int64
	CreatedAt time.Time
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL