mysql

Documentation

Index

• type Customer
• type Customers
• type MySQL
  • func New(db *sqlx.DB) *MySQL
  • func (m *MySQL) Delete(ctx context.Context, isAdmin bool, customer *entity.Customer) (err error)
  • func (m *MySQL) GetByID(ctx context.Context, app int64, id int64, all bool, isAdmin bool, uid string) (customer *entity.Customer, err error)
  • func (m *MySQL) Insert(ctx context.Context, customer *entity.Customer) (err error)
  • func (m *MySQL) Select(ctx context.Context, app int64, all bool, isAdmin bool, uid string) (customers entity.Customers, err error)
  • func (m *MySQL) Update(ctx context.Context, isAdmin bool, customer *entity.Customer) (err error)

Types

type Customer

type Customer struct {
	ID           int64     `db:"id"`
	Name         string    `db:"name"`
	Email        *string   `db:"email"`
	Addreas      *string   `db:"address"`
	AppID        int64     `db:"app_id"`
	CreatedAt    null.Time `db:"created_at"`
	CreatedBy    string    `db:"created_by"`
	UpdatedAt    null.Time `db:"updated_at"`
	LastUpdateBy *string   `db:"last_update_by"`
	DeletedAt    null.Time `db:"deleted_at"`
	IsActive     int8      `db:"is_active"`
}

Customer struct

type Customers

type Customers []Customer

Customer list

type MySQL

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

MySQL struct

func New

func New(db *sqlx.DB) *MySQL

New init mysql

func (*MySQL) Delete

func (m *MySQL) Delete(ctx context.Context, isAdmin bool, customer *entity.Customer) (err error)

func (*MySQL) GetByID

func (m *MySQL) GetByID(ctx context.Context, app int64, id int64, all bool, isAdmin bool, uid string) (customer *entity.Customer, err error)

GetByID . . .

func (*MySQL) Insert

func (m *MySQL) Insert(ctx context.Context, customer *entity.Customer) (err error)

func (*MySQL) Select

func (m *MySQL) Select(ctx context.Context, app int64, all bool, isAdmin bool, uid string) (customers entity.Customers, err error)

Select . . .

func (*MySQL) Update

func (m *MySQL) Update(ctx context.Context, isAdmin bool, customer *entity.Customer) (err error)