sql

func (m *Mysql) AddCategory(ctx context.Context, r contract.AddCategoryBody) (int, error)

func (m *Mysql) AddLDAPUser(ctx context.Context, name, email string, isAdmin bool) (userID int, err error)

func (m *Mysql) AddLocalUser(ctx context.Context, name, email, password string, isAdmin bool) (userID int, err error)

func (m *Mysql) AddProduct(ctx context.Context, r contract.AddProductRequestBody) (int, error)

func (m *Mysql) AddTransaction(ctx context.Context, r *contract.ChangeBalanceRequestBody) error

func (m *Mysql) ChangeStock(ctx context.Context, r contract.ChangeStockRequestBody) error

func (m *Mysql) DeleteProduct(ctx context.Context, productID int) error

func (m *Mysql) DeleteUser(ctx context.Context, id int) (err error)

func (m *Mysql) EditProduct(ctx context.Context, productID int, r *contract.AddProductRequestBody) error

func (m *Mysql) EditUser(ctx context.Context, id int, name, email string, isBlocked, isAdmin types.BitBool) (err error)

func (m *Mysql) GetProductByID(ctx context.Context, productID int) (*contract.Product, error)

func (m *Mysql) GetProductsWithStock(ctx context.Context) ([]*contract.Product, error)

func (m *Mysql) GetPublicUserDataByUserID(ctx context.Context, userID int) (*contract.User, error)

func (m *Mysql) GetPublicUserDataByUserName(ctx context.Context, name string) (*contract.User, error)

func (m *Mysql) GetUserCount(ctx context.Context) (int64, error)

func (m *Mysql) GetUserWithBalance(ctx context.Context, userID int) (*contract.User, error)

func (m *Mysql) GetUsersWithBalance(ctx context.Context) ([]*contract.User, error)

func (m *Mysql) Login(ctx context.Context, name, pass string) error