mysql

Documentation

Index

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

Types

type Employee

type Employee struct {
	ID           int64     `db:"id"`
	PositionID   int64     `db:"position_id"`
	Name         string    `db:"name"`
	DateOfBirth  null.Time `db:"date_of_birth"`
	Address      *string   `db:"address"`
	Gender       *string   `db:"gender"`
	Email        *string   `db:"email"`
	Salary       float64   `db:"salary"`
	Bonus        *float64  `db:"bonus"`
	FromDate     null.Time `db:"from_date"`
	FinishDate   null.Time `db:"finish_date"`
	ShowEmployee int8      `db:"show_employee"`
	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"`
	ImageUrl     *string   `db:"image_url"`
	ImageID      *string   `db:"image_id"`
	IsActive     int8      `db:"is_active"`
}

Employee struct

type Employees

type Employees []Employee

Employee 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, employee *entity.Employee) (err error)

func (*MySQL) GetByID

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

GetByID . . .

func (*MySQL) Insert

func (m *MySQL) Insert(ctx context.Context, employee *entity.Employee) (err error)

func (*MySQL) Select

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

Select . . .

func (*MySQL) Update

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