12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- package dbModel
- import (
- "github.com/jinzhu/gorm"
- "github.com/pkg/errors"
- "main/controller/servers"
- "main/init/qmsql"
- "main/model/modelInterface"
- )
- type Api struct {
- gorm.Model
- Path string `json:"path"`
- Description string `json:"description"`
- Group string `json:"group"`
- }
- func (a *Api) CreateApi() (err error) {
- findOne := qmsql.DEFAULTDB.Where("path = ?", a.Path).Find(&Menu{}).Error
- if findOne == nil {
- return errors.New("存在相同api")
- } else {
- err = qmsql.DEFAULTDB.Create(a).Error
- }
- return err
- }
- func (a *Api) DeleteApi() (err error) {
- err = qmsql.DEFAULTDB.Delete(a).Error
- err = qmsql.DEFAULTDB.Where("api_id = ?", a.ID).Unscoped().Delete(&ApiAuthority{}).Error
- return err
- }
- func (a *Api) UpdataApi() (err error) {
- err = qmsql.DEFAULTDB.Save(a).Error
- return err
- }
- func (a *Api) GetApiById(id float64) (err error, api Api) {
- err = qmsql.DEFAULTDB.Where("id = ?", id).First(&api).Error
- return
- }
- // 获取所有api信息
- func (a *Api) GetAllApis() (err error, apis []Api) {
- err = qmsql.DEFAULTDB.Find(&apis).Error
- return
- }
- // 分页获取数据 需要分页实现这个接口即可
- func (a *Api) GetInfoList(info modelInterface.PageInfo) (err error, list interface{}, total int) {
- // 封装分页方法 调用即可 传入 当前的结构体和分页信息
- err, db, total := servers.PagingServer(a, info)
- if err != nil {
- return
- } else {
- var apiList []Api
- err = db.Order("group", true).Where("path LIKE ?", "%"+a.Path+"%").Find(&apiList).Error
- return err, apiList, total
- }
- }
|