IOT/SERVER/IotAdmin/template/api_migrate.template

package version

import (
	"gorm.io/gorm"
	"runtime"
    "time"

	"IotAdmin/core/sdk/pkg"

	"IotAdmin/migration"
	common "IotAdmin/common/models"
)

type Menu struct {
	MenuId     int    `json:"menuId" gorm:"primaryKey;autoIncrement"`
	MenuName   string `json:"menuName" gorm:"size:128;"`
	Title      string `json:"title" gorm:"size:128;"`
	Icon       string `json:"icon" gorm:"size:128;"`
	//Path       string `json:"path" gorm:"size:128;"`
	Paths      string `json:"paths" gorm:"size:128;"`
	MenuType   string `json:"menuType" gorm:"size:1;"`
	Action     string `json:"action" gorm:"size:16;"`
	Permission string `json:"permission" gorm:"size:255;"`
	ParentId   int    `json:"parentId" gorm:"size:11;"`
	//Breadcrumb string `json:"breadcrumb" gorm:"size:255;"`
	Component  string `json:"component" gorm:"size:255;"`
    BtnClass   string    `json:"btnClass" gorm:"size:128;"`
    BtnScript  string    `json:"btnScript" gorm:"size:128;"`
	Sort       int    `json:"sort" gorm:"size:4;"`
	NoCache    bool   `json:"noCache" gorm:"size:8;"`
	IsHide    bool `json:"isHide" gorm:"size:1;"`
	IsFrame    bool `json:"isFrame" gorm:"size:1;"`
	CreateBy   string `json:"createBy" gorm:"size:128;"`
	UpdateBy   string `json:"updateBy" gorm:"size:128;"`
	CreatedAt time.Time  `json:"createdAt"`
    UpdatedAt time.Time  `json:"updatedAt"`
    DeletedAt *time.Time `json:"deletedAt"`
}

func (Menu) TableName() string {
	return "sys_menu"
}

func init() {
	_, fileName, _, _ := runtime.Caller(0)
	migration.Migrate.SetVersion(migration.GetFilename(fileName), _{{.GenerateTime}}Test)
}

func _{{.GenerateTime}}Test(db *gorm.DB, version string) error {
	return db.Transaction(func(tx *gorm.DB) error {

        timeNow := pkg.GetCurrentTime()
        Mmenu := Menu{}
        Mmenu.MenuName = "{{.TBName}}Manage"
        Mmenu.Title = "{{.TableComment}}"
        Mmenu.Icon = "list-task"
        //Mmenu.Path = "/{{.TBName}}"
        Mmenu.MenuType = "M"
        Mmenu.Action = "无"
        Mmenu.ParentId = 0
        Mmenu.NoCache = false
        Mmenu.Component = "Layout"
        Mmenu.Sort = 0
        Mmenu.IsHide = false
        Mmenu.IsFrame = false
        Mmenu.CreateBy = "1"
        Mmenu.UpdateBy = "1"
        Mmenu.CreatedAt = timeNow
        Mmenu.UpdatedAt = timeNow
        // Mmenu.MenuId, err = Mmenu.Create(db)
        err := tx.Create(&Mmenu).Error
        if err != nil {
            return err
        }
        Cmenu := Menu{}
        Cmenu.MenuName = "{{.TBName}}"
        Cmenu.Title = "{{.TableComment}}"
        Cmenu.Icon = "pass"
        //Cmenu.Path = "{{.TBName}}"
        Cmenu.MenuType = "C"
        Cmenu.Action = "无"
        Cmenu.Permission = "{{.PackageName}}:{{.BusinessName}}"
        Cmenu.ParentId = Mmenu.MenuId
        Cmenu.NoCache = false
        Cmenu.Component = "{{.PackageName}}/{{.BusinessName}}/index"
        Cmenu.Sort = 0
        Cmenu.BtnClass= ""
        Cmenu.BtnScript= ""
        CMmenu.IsHide = false
        CMmenu.IsFrame = false
        Cmenu.CreateBy = "1"
        Cmenu.UpdateBy = "1"
        Cmenu.CreatedAt = timeNow
        Cmenu.UpdatedAt = timeNow
        // Cmenu.MenuId, err = Cmenu.Create(db)
        err = tx.Create(&Cmenu).Error
        if err != nil {
            return err
        }

        MList := Menu{}
        MList.MenuName = "{{.BusinessName}}Query"
        MList.Title = "分页获取{{.TableComment}}"
        MList.Icon = "eye"
        //MList.Path = "{{.TBName}}"
        MList.MenuType = "F"
        MList.Action = "无"
        MList.Permission = "{{.PackageName}}:{{.BusinessName}}:query"
        MList.ParentId = Cmenu.MenuId
        MList.NoCache = false
        MList.Sort = 0
        MList.BtnClass= ""
        MList.BtnScript= ""
        MList.IsHide = true
        MList.IsFrame = false
        MList.CreateBy = "1"
        MList.UpdateBy = "1"
        MList.CreatedAt = timeNow
        MList.UpdatedAt = timeNow
        // MList.MenuId, err = MList.Create(db)
        err = tx.Create(&MList).Error
        if err != nil {
            return err
        }

        MCreate := Menu{}
        MCreate.MenuName = "{{.BusinessName}}Add"
        MCreate.Title = "创建{{.TableComment}}"
        MCreate.Icon = "plus-square"
        //MCreate.Path = "{{.TBName}}"
        MCreate.MenuType = "F"
        MCreate.Action = "无"
        MCreate.Permission = "{{.PackageName}}:{{.BusinessName}}:add"
        MCreate.ParentId = Cmenu.MenuId
        MCreate.NoCache = false
        MCreate.Sort = 0
        MCreate.BtnClass= "btn btn-light-primary"
        MCreate.BtnScript= "handleCreate"
        MCreate.IsHide = false
        MCreate.IsFrame = false
        MCreate.CreateBy = "1"
        MCreate.UpdateBy = "1"
        MCreate.CreatedAt = timeNow
        MCreate.UpdatedAt = timeNow
        // MCreate.MenuId, err = MCreate.Create(db)
        err = tx.Create(&MCreate).Error
        if err != nil {
            return err
        }

        MUpdate := Menu{}
        MUpdate.MenuName = "{{.BusinessName}}Update"
        MUpdate.Title = "修改{{.TableComment}}"
        MUpdate.Icon = "pencil-square"
        //MUpdate.Path = "{{.TBName}}"
        MUpdate.MenuType = "F"
        MUpdate.Action = "无"
        MUpdate.Permission ="{{.PackageName}}:{{.BusinessName}}:edit"
        MUpdate.ParentId = Cmenu.MenuId
        MUpdate.NoCache = false
        MUpdate.Sort = 0
        MUpdate.BtnClass= "btn btn-light-success"
        MUpdate.BtnScript= "handleUpdate@1"
        MUpdate.IsHide = false
        MUpdate.IsFrame = false
        MUpdate.CreateBy = "1"
        MUpdate.UpdateBy = "1"
        MUpdate.CreatedAt = timeNow
        MUpdate.UpdatedAt = timeNow
        // MUpdate.MenuId, err = MUpdate.Create(db)
        err = tx.Create(&MUpdate).Error
        if err != nil {
            return err
        }

        MDelete := Menu{}
        MDelete.MenuName = "{{.BusinessName}}Remove"
        MDelete.Title = "删除{{.TableComment}}"
        MDelete.Icon = "dash-square"
        //MDelete.Path = "{{.TBName}}"
        MDelete.MenuType = "F"
        MDelete.Action = "无"
        MDelete.Permission = "{{.PackageName}}:{{.BusinessName}}:remove"
        MDelete.ParentId = Cmenu.MenuId
        MDelete.NoCache = false
        MDelete.Sort = 0
        MDelete.BtnClass= "btn btn-light-danger"
        MDelete.BtnScript= "handleDelete@0"
        MDelete.IsHide = false
        MDelete.IsFrame = false
        MDelete.CreateBy = "1"
        MDelete.UpdateBy = "1"
        MDelete.CreatedAt = timeNow
        MDelete.UpdatedAt = timeNow
        // MDelete.MenuId, err = MDelete.Create(db)
        err = tx.Create(&MDelete).Error
        if err != nil {
            return err
        }

        var InterfaceId = 63
        Amenu := Menu{}
        Amenu.MenuName = "{{.TBName}}"
        Amenu.Title = "{{.TableComment}}"
        Amenu.Icon = "bug"
        //Amenu.Path = "{{.TBName}}"
        Amenu.MenuType = "M"
        Amenu.Action = "无"
        Amenu.ParentId = InterfaceId
        Amenu.NoCache = false
        Amenu.Sort = 0
        Amenu.BtnClass= ""
        Amenu.BtnScript= ""
        Amenu.IsHide = true
        Amenu.IsFrame = false
        Amenu.CreateBy = "1"
        Amenu.UpdateBy = "1"
        Amenu.CreatedAt = timeNow
        Amenu.UpdatedAt = timeNow
        // Amenu.MenuId, err = Amenu.Create(db)
        err = tx.Create(&Amenu).Error
        if err != nil {
            return err
        }

        AList := Menu{}
        AList.MenuName = ""
        AList.Title = "分页获取{{.TableComment}}"
        AList.Icon = "bug"
        //AList.Path = "/api/{{.ModuleName}}"
        AList.MenuType = "A"
        AList.Action = "GET"
        AList.ParentId = Amenu.MenuId
        AList.NoCache = false
        AList.Sort = 0
        AList.BtnClass= ""
        AList.BtnScript= ""
        AList.IsHide = true
        AList.IsFrame = false
        AList.CreateBy = "1"
        AList.UpdateBy = "1"
        AList.CreatedAt = timeNow
        AList.UpdatedAt = timeNow
        // AList.MenuId, err = AList.Create(db)
        err = tx.Create(&AList).Error
        if err != nil {
            return err
        }

        AGet := Menu{}
        AGet.MenuName = ""
        AGet.Title = "根据id获取{{.TableComment}}"
        AGet.Icon = "bug"
        //AGet.Path = "/api/{{.ModuleName}}/:id"
        AGet.MenuType = "A"
        AGet.Action = "GET"
        AGet.ParentId = Amenu.MenuId
        AGet.NoCache = false
        AGet.Sort = 0
        AGet.BtnClass= ""
        AGet.BtnScript= ""
        AGet.IsHide = true
        AGet.IsFrame = false
        AGet.CreateBy = "1"
        AGet.UpdateBy = "1"
        AGet.CreatedAt = timeNow
        AGet.UpdatedAt = timeNow
        // AGet.MenuId, err = AGet.Create(db)
        err = tx.Create(&AGet).Error
        if err != nil {
            return err
        }

        ACreate := Menu{}
        ACreate.MenuName = ""
        ACreate.Title = "创建{{.TableComment}}"
        ACreate.Icon = "bug"
        //ACreate.Path = "/api/{{.ModuleName}}"
        ACreate.MenuType = "A"
        ACreate.Action = "POST"
        ACreate.ParentId = Amenu.MenuId
        ACreate.NoCache = false
        ACreate.Sort = 0
        ACreate.BtnClass= ""
        ACreate.BtnScript= ""
        ACreate.IsHide = true
        ACreate.IsFrame = false
        ACreate.CreateBy = "1"
        ACreate.UpdateBy = "1"
        ACreate.CreatedAt = timeNow
        ACreate.UpdatedAt = timeNow
        // ACreate.MenuId, err = ACreate.Create(db)
        err = tx.Create(&ACreate).Error
        if err != nil {
            return err
        }

        AUpdate := Menu{}
        AUpdate.MenuName = ""
        AUpdate.Title = "修改{{.TableComment}}"
        AUpdate.Icon = "bug"
        //AUpdate.Path = "/api/{{.ModuleName}}/:id"
        AUpdate.MenuType = "A"
        AUpdate.Action = "PUT"
        AUpdate.ParentId = Amenu.MenuId
        AUpdate.NoCache = false
        AUpdate.Sort = 0
        AUpdate.BtnClass= ""
        AUpdate.BtnScript= ""
        AUpdate.IsHide = true
        AUpdate.IsFrame = false
        AUpdate.CreateBy = "1"
        AUpdate.UpdateBy = "1"
        AUpdate.CreatedAt = timeNow
        AUpdate.UpdatedAt = timeNow
        // AUpdate.MenuId, err = AUpdate.Create(db)
        err = tx.Create(&AUpdate).Error
        if err != nil {
            return err
        }

        ADelete := Menu{}
        ADelete.MenuName = ""
        ADelete.Title = "删除{{.TableComment}}"
        ADelete.Icon = "bug"
        //ADelete.Path = "/api/{{.ModuleName}}"
        ADelete.MenuType = "A"
        ADelete.Action = "DELETE"
        ADelete.ParentId = Amenu.MenuId
        ADelete.NoCache = false
        ADelete.Sort = 0
        ADelete.BtnClass= ""
        ADelete.BtnScript= ""
        ADelete.IsHide = true
        ADelete.IsFrame = false
        ADelete.CreateBy = "1"
        ADelete.UpdateBy = "1"
        ADelete.CreatedAt = timeNow
        ADelete.UpdatedAt = timeNow
        //ADelete.MenuId, err = ADelete.Create(db)
        err = tx.Create(&ADelete).Error
        if err != nil {
            return err
        }

		return tx.Create(&common.Migration{
			Version: version,
		}).Error
	})
}