db

type Configure struct {
	Database  string `env:"MYSQL_DATABASE" envDefault:"database"`
	Username  string `env:"MYSQL_USERNAME" envDefault:"user"`
	Password  string `env:"MYSQL_PASSWORD" envDefault:"password"`
	Host      string `env:"MYSQL_HOST" envDefault:"localhost"`
	SlaveHost string `env:"MYSQL_SLAVE_HOST" envDefault:""`
	Port      string `env:"MYSQL_PORT" envDefault:"3306"`
}

type Model struct {
	ID        uint64     `form:"id" json:"id" gorm:"primary_key"`
	CreatedBy uint64     `json:"-"`
	UpdatedBy uint64     `json:"-"`
	DeletedBy uint64     `json:"-"`
	CreatedAt time.Time  `json:"createdAt"`
	UpdatedAt time.Time  `json:"updatedAt"`
	DeletedAt *time.Time `json:"-" sql:"index"`
}

type Pagination struct {
	Data interface{} `json:"data"`
	Meta struct {
		Total     int `json:"total"`
		TotalPage int `json:"totalPage"`
		Offset    int `json:"offset"`
		Limit     int `json:"limit"`
		Page      int `json:"page"`
		PrevPage  int `json:"prevPage"`
		NextPage  int `json:"nextPage"`
	} `json:"meta"`
}

type PaginationParam struct {
	DB          *gorm.DB
	Page        int    `form:"page" json:"page"`
	Limit       int    `form:"limit" json:"limit"`
	OrderBy     string `form:"orderBy" json:"orderBy"`
	OrderBySort string `form:"orderBySort" json:"orderBySort"`
}