db

package
v0.0.0-...-c8a7627 Latest Latest
Warning

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

Go to latest
Published: Sep 16, 2022 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Connect

func Connect(ctx context.Context, dbConf *config.DB) (*sqlx.DB, error)

func CreateCompany

func CreateCompany(ctx context.Context, dbConn NamedExerContext, dbCompany *Company) error

func DeleteCompanyByID

func DeleteCompanyByID(ctx context.Context, dbConn sqlx.ExecerContext, companyID uuid.UUID) error

func Disconnect

func Disconnect(dbConn *sqlx.DB) error

Types

type Company

type Company struct {
	Name      string    `db:"name"`
	Code      string    `db:"code"`
	Country   string    `db:"country"`
	WebSite   string    `db:"website"`
	CreatedAt time.Time `db:"created_at"`
	Phone     string    `db:"phone"`
	ID        uuid.UUID `db:"id"`
}

func GetCompaniesListByID

func GetCompaniesListByID(ctx context.Context, dbConn *sqlx.DB, companyIDs []uuid.UUID) ([]Company, error)

func GetCompanyByID

func GetCompanyByID(ctx context.Context, dbConn RowxQueryerContext, companyID uuid.UUID) (*Company, error)

type NamedExerContext

type NamedExerContext interface {
	NamedExecContext(ctx context.Context, query string, arg any) (sql.Result, error)
}

type RowxQueryerContext

type RowxQueryerContext interface {
	QueryRowxContext(ctx context.Context, query string, args ...any) *sqlx.Row
}

Jump to

Keyboard shortcuts

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