go-xorm-create/sqlload/SqlEntity.go

package sqlload

import "fmt"

type CTable struct {
	Name               string       //名字
	Comment            string       //注释
	KeyName            string       //主键名称
	Key                CTableColumn // 主键字段数据
	KeyIsAutoIncrement bool
	CTableColumns      []CTableColumn //字段数据
}

func (C CTable) String() string {
	return fmt.Sprintf("CTable{Name:%s,Comment:%s,KeyName:%s,Key:%s,KeyIsAutoIncrement:%t,CTableColumns:%s}", C.Name, C.Comment, C.KeyName, C.Key, C.KeyIsAutoIncrement, C.CTableColumns)
}

type CTableColumn struct {
	IsPrimaryKey    bool     //是否为主键
	IsAutoIncrement bool     //是否自增
	Name            string   //名称
	Comment         string   //注释
	SQLType         CSQLType //数据库类型
	Nullable        bool     //可否为null
}

func (C CTableColumn) String() string {
	return fmt.Sprintf("CTableColumn{IsPrimaryKey:%t,IsAutoIncrement:%t,Name:%s,Comment:%s,SQLType:%s,Nullable:%t}", C.IsPrimaryKey, C.IsAutoIncrement, C.Name, C.Comment, C.SQLType, C.Nullable)
}

type CSQLType struct {
	Name           string //类型
	DefaultLength  int64  //默认长度
	DefaultLength2 int64  //小数点位数
}

func (C CSQLType) String() string {
	return fmt.Sprintf("CSQLType{Name:%s,DefaultLength:%d,DefaultLength2:%d}", C.Name, C.DefaultLength, C.DefaultLength2)
}

type Gen struct {
	Table        GenTable         `json:"table"`
	TableColumns []GenTableColumn `json:"tableColumns"`
}

func (receiver Gen) String() string {
	return fmt.Sprintf("Gen{Table:%s,TableColumns:%s}", receiver.Table, receiver.TableColumns)
}

type GenTable struct {
	Id           int64  `xorm:"id" json:"id"`                       // 11 0 注释：id
	TableName    string `xorm:"table_name"  json:"tableName"`       // 255 0 注释：数据库名
	TableComment string `xorm:"table_comment"  json:"tableComment"` // 255 0 注释：数据库注释
	Name         string `xorm:"name"  json:"name"`                  // 255 0 注释：名字
	RouterName   string `xorm:"router_name"  json:"routerName"`     // 255 0 注释：路由名
	Remark       string `xorm:"remark"  json:"remark"`              // 255 0 注释：备注
}

func (receiver GenTable) String() string {
	return fmt.Sprint("GenTable{Id:", receiver.Id, ",TableName:", receiver.TableName, ",TableComment:", receiver.TableComment, ",Name:", receiver.Name, ",RouterName:", receiver.RouterName, ",Remark:", receiver.Remark, "}")
}

type GenTableColumn struct {
	Id            int64  `xorm:"id" json:"id"`                         // 11 0 注释：id
	TableId       int64  `xorm:"table_id"  json:"tableId"`             // 11 0 注释：表格id
	Sort          int64  `xorm:"sort"  json:"sort"`                    // 255 0 注释：排序
	ColumnName    string `xorm:"column_name"  json:"columnName"`       // 255 0 注释：字段名
	ColumnComment string `xorm:"column_comment"  json:"columnComment"` // 255 0 注释：字段注释
	ColumnType    string `xorm:"column_type"  json:"columnType"`       // 255 0 注释：字段类型
	GoType        string `xorm:"go_type"  json:"goType"`               // 255 0 注释：go类型
	GoField       string `xorm:"go_field"  json:"goField"`             // 255 0 注释：go字段名
	IsKey         string `xorm:"is_key"  json:"isKey"`                 // 1 0 注释：是否主键
	IsIncrement   string `xorm:"is_increment"  json:"isIncrement"`     // 1 0 注释：是否自增
	IsRequired    string `xorm:"is_required"  json:"isRequired"`       // 1 0 注释：是否未必填
	QueryType     string `xorm:"query_type"  json:"queryType"`         // 1 0 注释：查询方式
	VueShowType   string `xorm:"vue_show_type"  json:"vueShowType"`    // 255 0 注释：前端显示类型
	DictType      string `xorm:"dict_type"  json:"dictType"`           // 255 0 注释：字典类型
}

func (receiver GenTableColumn) String() string {
	return fmt.Sprint("GenTableColumn{Id:", receiver.Id, ",TableId:", receiver.TableId, ",Sort:", receiver.Sort, ",ColumnName:", receiver.ColumnName, ",ColumnComment:", receiver.ColumnComment, ",ColumnType:", receiver.ColumnType, ",GoType:", receiver.GoType, ",GoField:", receiver.GoField, ",IsKey:", receiver.IsKey, ",IsIncrement:", receiver.IsIncrement, ",IsRequired:", receiver.IsRequired, ",QueryType:", receiver.QueryType, ",VueShowType:", receiver.VueShowType, ",DictType:", receiver.DictType, "}")
}