postgres

Documentation

Index

• type Begin
• type Pg
  • func New(db postgres.PgSQL) *Pg
  • func (pg *Pg) Close() error
  • func (pg *Pg) Commit() error
  • func (pg *Pg) CreateCategory(ctx context.Context, category *entities.Category) error
  • func (pg *Pg) CreateDialog(ctx context.Context, dialog *entities.Dialog) error
  • func (pg *Pg) CreateProduct(ctx context.Context, product *entities.Product) error
  • func (pg *Pg) CreateRepair(ctx context.Context, repair *entities.Repair) error
  • func (pg *Pg) CreateReservation(ctx context.Context, reservation *entities.Reservation) error
  • func (pg *Pg) CreateState(ctx context.Context, state *entities.State) error
  • func (pg *Pg) CreateUser(ctx context.Context, user *entities.User) error
  • func (pg *Pg) DeleteCategory(ctx context.Context, categoryID uuid.UUID) error
  • func (pg *Pg) DeleteProductByID(ctx context.Context, id uuid.UUID) error
  • func (pg *Pg) DeleteProductsByCategoryID(ctx context.Context, categoryID uuid.UUID) error
  • func (pg *Pg) DeleteRepairByID(ctx context.Context, id uuid.UUID) error
  • func (pg *Pg) DeleteReservationsByCategoryID(ctx context.Context, categoryID uuid.UUID) error
  • func (pg *Pg) DeleteReservationsByProductID(ctx context.Context, productID uuid.UUID) error
  • func (pg *Pg) DeleteState(ctx context.Context, id string, sType int) error
  • func (pg *Pg) EditCategory(ctx context.Context, category *entities.Category) error
  • func (pg *Pg) EditDialog(ctx context.Context, dialog *entities.Dialog) error
  • func (pg *Pg) EditProduct(ctx context.Context, product *entities.Product) error
  • func (pg *Pg) EditRepair(ctx context.Context, repair *entities.Repair) error
  • func (pg *Pg) EditReservation(ctx context.Context, reservation *entities.Reservation) error
  • func (pg *Pg) EditState(ctx context.Context, state *entities.State) error
  • func (pg *Pg) EditUser(ctx context.Context, user *entities.User) error
  • func (pg *Pg) ExistsReservationByProductID(ctx context.Context, productID uuid.UUID) (bool, error)
  • func (pg *Pg) FindCategory(ctx context.Context, name string, cType int) (*entities.Category, error)
  • func (pg *Pg) FindUser(ctx context.Context, q interface{}) (*entities.User, error)
  • func (pg *Pg) GetAllRepairs(ctx context.Context) ([]entities.Repair, error)
  • func (pg *Pg) GetCategories(ctx context.Context) ([]entities.Category, error)
  • func (pg *Pg) GetCategoriesByType(ctx context.Context, cType int) ([]entities.Category, error)
  • func (pg *Pg) GetCategoryByID(ctx context.Context, id uuid.UUID) (*entities.Category, error)
  • func (pg *Pg) GetDialogByTalkerID(ctx context.Context, talkerID int64) (*entities.Dialog, error)
  • func (pg *Pg) GetModelsByCategoryIDAndProducer(ctx context.Context, categoryID uuid.UUID, producer string) ([]string, error)
  • func (pg *Pg) GetModelsRepair(ctx context.Context, producerName string) ([]string, error)
  • func (pg *Pg) GetProducersByCategory(ctx context.Context, category string, cType int) ([]string, error)
  • func (pg *Pg) GetProducersByCategoryID(ctx context.Context, categoryID uuid.UUID) ([]string, error)
  • func (pg *Pg) GetProducersRepair(ctx context.Context) ([]string, error)
  • func (pg *Pg) GetProduct(ctx context.Context, model, additional string, cType int) (*entities.Product, error)
  • func (pg *Pg) GetProductByID(ctx context.Context, productID uuid.UUID) (*entities.Product, error)
  • func (pg *Pg) GetProductWithoutCategoryType(ctx context.Context, model, additional string) (*entities.Product, error)
  • func (pg *Pg) GetProducts(ctx context.Context) ([]entities.Product, error)
  • func (pg *Pg) GetProductsByProducer(ctx context.Context, producer string, cType int) ([]entities.Product, error)
  • func (pg *Pg) GetRepairByID(ctx context.Context, id uuid.UUID) (*entities.Repair, error)
  • func (pg *Pg) GetRepairByModelAndID(ctx context.Context, modelName string, id uuid.UUID) (*entities.Repair, error)
  • func (pg *Pg) GetRepairByModelAndName(ctx context.Context, modelName string, repairName string) (*entities.Repair, error)
  • func (pg *Pg) GetRepairs(ctx context.Context, modelName string) ([]entities.Repair, error)
  • func (pg *Pg) GetReservationByID(ctx context.Context, id uuid.UUID) (*entities.ReservationWithAdditionalData, error)
  • func (pg *Pg) GetReservations(ctx context.Context) ([]entities.ReservationWithAdditionalData, error)
  • func (pg *Pg) GetReservationsByUserID(ctx context.Context, userID int64) ([]entities.ReservationWithAdditionalData, error)
  • func (pg *Pg) GetSaleProducts(ctx context.Context) ([]entities.Product, error)
  • func (pg *Pg) GetState(ctx context.Context, id string, sType int) (*entities.State, error)
  • func (pg *Pg) GetUserByTgID(ctx context.Context, tgID int64) (*entities.User, error)
  • func (pg *Pg) GetUserIdsWhoManager(ctx context.Context) ([]int64, error)
  • func (pg *Pg) Rollback() error
  • func (pg *Pg) WithTx() (*Pg, error)

Types

type Begin

type Begin interface {
	Begin() (postgres.PgSQL, error)
}

type Pg

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

func New

func New(db postgres.PgSQL) *Pg

func (*Pg) Close

func (pg *Pg) Close() error

func (*Pg) Commit

func (pg *Pg) Commit() error

func (*Pg) CreateCategory

func (pg *Pg) CreateCategory(ctx context.Context, category *entities.Category) error

func (*Pg) CreateDialog

func (pg *Pg) CreateDialog(ctx context.Context, dialog *entities.Dialog) error

func (*Pg) CreateProduct

func (pg *Pg) CreateProduct(ctx context.Context, product *entities.Product) error

func (*Pg) CreateRepair

func (pg *Pg) CreateRepair(ctx context.Context, repair *entities.Repair) error

func (*Pg) CreateReservation

func (pg *Pg) CreateReservation(ctx context.Context, reservation *entities.Reservation) error

func (*Pg) CreateState

func (pg *Pg) CreateState(ctx context.Context, state *entities.State) error

func (*Pg) CreateUser

func (pg *Pg) CreateUser(ctx context.Context, user *entities.User) error

func (*Pg) DeleteCategory

func (pg *Pg) DeleteCategory(ctx context.Context, categoryID uuid.UUID) error

func (*Pg) DeleteProductByID

func (pg *Pg) DeleteProductByID(ctx context.Context, id uuid.UUID) error

func (*Pg) DeleteProductsByCategoryID

func (pg *Pg) DeleteProductsByCategoryID(ctx context.Context, categoryID uuid.UUID) error

func (*Pg) DeleteRepairByID

func (pg *Pg) DeleteRepairByID(ctx context.Context, id uuid.UUID) error

func (*Pg) DeleteReservationsByCategoryID

func (pg *Pg) DeleteReservationsByCategoryID(ctx context.Context, categoryID uuid.UUID) error

func (*Pg) DeleteReservationsByProductID

func (pg *Pg) DeleteReservationsByProductID(ctx context.Context, productID uuid.UUID) error

func (*Pg) DeleteState

func (pg *Pg) DeleteState(ctx context.Context, id string, sType int) error

func (*Pg) EditCategory

func (pg *Pg) EditCategory(ctx context.Context, category *entities.Category) error

func (*Pg) EditDialog

func (pg *Pg) EditDialog(ctx context.Context, dialog *entities.Dialog) error

func (*Pg) EditProduct

func (pg *Pg) EditProduct(ctx context.Context, product *entities.Product) error

func (*Pg) EditRepair

func (pg *Pg) EditRepair(ctx context.Context, repair *entities.Repair) error

func (*Pg) EditReservation

func (pg *Pg) EditReservation(ctx context.Context, reservation *entities.Reservation) error

func (*Pg) EditState

func (pg *Pg) EditState(ctx context.Context, state *entities.State) error

func (*Pg) EditUser

func (pg *Pg) EditUser(ctx context.Context, user *entities.User) error

func (*Pg) ExistsReservationByProductID

func (pg *Pg) ExistsReservationByProductID(ctx context.Context, productID uuid.UUID) (bool, error)

func (*Pg) FindCategory

func (pg *Pg) FindCategory(ctx context.Context, name string, cType int) (*entities.Category, error)

func (*Pg) FindUser

func (pg *Pg) FindUser(ctx context.Context, q interface{}) (*entities.User, error)

func (*Pg) GetAllRepairs

func (pg *Pg) GetAllRepairs(ctx context.Context) ([]entities.Repair, error)

func (*Pg) GetCategories

func (pg *Pg) GetCategories(ctx context.Context) ([]entities.Category, error)

func (*Pg) GetCategoriesByType

func (pg *Pg) GetCategoriesByType(ctx context.Context, cType int) ([]entities.Category, error)

func (*Pg) GetCategoryByID

func (pg *Pg) GetCategoryByID(ctx context.Context, id uuid.UUID) (*entities.Category, error)

func (*Pg) GetDialogByTalkerID

func (pg *Pg) GetDialogByTalkerID(ctx context.Context, talkerID int64) (*entities.Dialog, error)

func (*Pg) GetModelsByCategoryIDAndProducer

func (pg *Pg) GetModelsByCategoryIDAndProducer(ctx context.Context, categoryID uuid.UUID, producer string) ([]string, error)

func (*Pg) GetModelsRepair

func (pg *Pg) GetModelsRepair(ctx context.Context, producerName string) ([]string, error)

func (*Pg) GetProducersByCategory

func (pg *Pg) GetProducersByCategory(ctx context.Context, category string, cType int) ([]string, error)

func (*Pg) GetProducersByCategoryID

func (pg *Pg) GetProducersByCategoryID(ctx context.Context, categoryID uuid.UUID) ([]string, error)

func (*Pg) GetProducersRepair

func (pg *Pg) GetProducersRepair(ctx context.Context) ([]string, error)

func (*Pg) GetProduct

func (pg *Pg) GetProduct(ctx context.Context, model, additional string, cType int) (*entities.Product, error)

func (*Pg) GetProductByID

func (pg *Pg) GetProductByID(ctx context.Context, productID uuid.UUID) (*entities.Product, error)

func (*Pg) GetProductWithoutCategoryType

func (pg *Pg) GetProductWithoutCategoryType(ctx context.Context, model, additional string) (*entities.Product, error)

func (*Pg) GetProducts

func (pg *Pg) GetProducts(ctx context.Context) ([]entities.Product, error)

func (*Pg) GetProductsByProducer

func (pg *Pg) GetProductsByProducer(ctx context.Context, producer string, cType int) ([]entities.Product, error)

func (*Pg) GetRepairByID

func (pg *Pg) GetRepairByID(ctx context.Context, id uuid.UUID) (*entities.Repair, error)

func (*Pg) GetRepairByModelAndID

func (pg *Pg) GetRepairByModelAndID(ctx context.Context, modelName string, id uuid.UUID) (*entities.Repair, error)

func (*Pg) GetRepairByModelAndName

func (pg *Pg) GetRepairByModelAndName(ctx context.Context, modelName string, repairName string) (*entities.Repair, error)

func (*Pg) GetRepairs

func (pg *Pg) GetRepairs(ctx context.Context, modelName string) ([]entities.Repair, error)

func (*Pg) GetReservationByID

func (pg *Pg) GetReservationByID(ctx context.Context, id uuid.UUID) (*entities.ReservationWithAdditionalData, error)

func (*Pg) GetReservations

func (pg *Pg) GetReservations(ctx context.Context) ([]entities.ReservationWithAdditionalData, error)

func (*Pg) GetReservationsByUserID

func (pg *Pg) GetReservationsByUserID(ctx context.Context, userID int64) ([]entities.ReservationWithAdditionalData, error)

func (*Pg) GetSaleProducts

func (pg *Pg) GetSaleProducts(ctx context.Context) ([]entities.Product, error)

func (*Pg) GetState

func (pg *Pg) GetState(ctx context.Context, id string, sType int) (*entities.State, error)

func (*Pg) GetUserByTgID

func (pg *Pg) GetUserByTgID(ctx context.Context, tgID int64) (*entities.User, error)

func (*Pg) GetUserIdsWhoManager

func (pg *Pg) GetUserIdsWhoManager(ctx context.Context) ([]int64, error)

func (*Pg) Rollback

func (pg *Pg) Rollback() error

func (*Pg) WithTx

func (pg *Pg) WithTx() (*Pg, error)