go gorm极简元数据处理

func Test003_GetDbMeta(t *testing.T) { var dbfacade = FindBeanDbmetaFacade() ret := dbfacade.GetDbMeta("plat_menu") golog.Info("dbmeta:", ret) }

2026-03-15 13:42:01.939 [INFO] dbmeta: { "code": 200, "msg": "成功", "exist": true, "data": { "tableExist": false, "tableType": "", "tableSchema": "", "tableName": "plat_menu", "indexName": "", "fieldsName": "", "columns": [ { "goType": "int64", "tableName": "plat_menu", "tableSchema": "", "columnName": "id", "dbTypeName": "int8", "primaryKey": true, "autoIncrement": true, "nullable": false, "unique": false, "columnType": "bigint", "length": 64, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 64, "Scale": 0 } }, { "goType": "string", "tableName": "plat_menu", "tableSchema": "", "columnName": "menu_code", "dbTypeName": "varchar", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "character varying", "length": -5, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "string", "tableName": "plat_menu", "tableSchema": "", "columnName": "menu_name", "dbTypeName": "varchar", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "character varying", "length": -5, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "string", "tableName": "plat_menu", "tableSchema": "", "columnName": "list_order", "dbTypeName": "varchar", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "character varying", "length": -5, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "int64", "tableName": "plat_menu", "tableSchema": "", "columnName": "created_by", "dbTypeName": "int8", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "bigint", "length": 64, "comment": "", "defaultValue": "1", "decimalSize": { "Precision": 64, "Scale": 0 } }, { "goType": "time.Time", "tableName": "plat_menu", "tableSchema": "", "columnName": "created_at", "dbTypeName": "timestamptz", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "timestamp with time zone", "length": 64, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 6, "Scale": 0 } }, { "goType": "bool", "tableName": "plat_menu", "tableSchema": "", "columnName": "active", "dbTypeName": "bool", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "boolean", "length": 8, "comment": "", "defaultValue": "true", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "bool", "tableName": "plat_menu", "tableSchema": "", "columnName": "visible", "dbTypeName": "bool", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "boolean", "length": 8, "comment": "", "defaultValue": "true", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "string", "tableName": "plat_menu", "tableSchema": "", "columnName": "subsys", "dbTypeName": "varchar", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "character varying", "length": -5, "comment": "", "defaultValue": "opc", "decimalSize": { "Precision": 0, "Scale": 0 } }, { "goType": "int64", "tableName": "plat_menu", "tableSchema": "", "columnName": "parent_id", "dbTypeName": "int8", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "bigint", "length": 64, "comment": "父节点", "defaultValue": "-1", "decimalSize": { "Precision": 64, "Scale": 0 } }, { "goType": "int32", "tableName": "plat_menu", "tableSchema": "", "columnName": "page_type", "dbTypeName": "int4", "primaryKey": false, "autoIncrement": false, "nullable": true, "unique": false, "columnType": "integer", "length": 32, "comment": "页面组件类型：10 菜单 20按扭", "defaultValue": "10", "decimalSize": { "Precision": 32, "Scale": 0 } } ], "pkInfo": [ { "goType": "int64", "tableName": "plat_menu", "tableSchema": "", "columnName": "id", "dbTypeName": "int8", "primaryKey": true, "autoIncrement": true, "nullable": false, "unique": false, "columnType": "bigint", "length": 64, "comment": "", "defaultValue": "", "decimalSize": { "Precision": 64, "Scale": 0 } } ] }, "total": 0, "pageSize": 0, "pageCurrent": 0 } 代码

package dbmeta import ( "gitee.com/leijmdas/goweb3/goconfig/base/basedto" "gitee.com/leijmdas/goweb3/goconfig/dbcontent" "gitee.com/leijmdas/goweb3/goconfig/ichublog/golog" "gitee.com/leijmdas/goweb3/goweb/pagemodel" _ "gorm.io/driver/mysql" _ "gorm.io/driver/postgres" "gorm.io/gorm" "gorm.io/gorm/schema" ) type DbmetaFacade struct { basedto.BaseEntitySingle Dbtables } func NewDbmetaFacade() *DbmetaFacade { return &DbmetaFacade{} } type Dbtables struct { basedto.BaseEntitySingle TableList []string `json:"tableList"` ColumnsMap map[string][]gorm.ColumnType `json:"columnsMap"` Columns []gorm.ColumnType `json:"columns"` TableName string `json:"tableName"` } func NewDbtables() *Dbtables { return &Dbtables{} } func (self *DbmetaFacade) Init() { if self.ColumnsMap == nil { self.ColumnsMap = make(map[string][]gorm.ColumnType) } if self.Columns == nil { self.Columns = make([]gorm.ColumnType, 0) } } func (self *DbmetaFacade) GetDbTable(table any) (err error) { self.TableList, err = self.GetTables() if err != nil { return err } self.Columns, err = self.ColumnTypes(table) return nil } func (self *DbmetaFacade) GetDbTables() (err error) { var dbs = dbcontent.GetDB().Migrator().CurrentDatabase() golog.Error(dbs) self.TableList, err = self.GetTables() if err != nil { return err } self.Init() for i := range self.TableList { var columns, err = self.ColumnTypes(self.TableList[i]) if err != nil { return err } self.ColumnsMap[self.TableList[i]] = columns } return err } func (self *DbmetaFacade) GetTables() ([]string, error) { tableList, err := dbcontent.GetDB().Migrator().GetTables() return tableList, err } func (self *DbmetaFacade) ColumnTypes(dst any) ([]gorm.ColumnType, error) { columnTypes, err := dbcontent.GetDB().Migrator().ColumnTypes(dst) return columnTypes, err } func (self *DbmetaFacade) GetDbMeta(paramTable any) *pagemodel.IchubResult[*DbmetaTable] { var table = FindBeanDbmetaTable() //if tab, err := self.GetTables(); err != nil { // golog.Error(err,tab) // return pagemodel.ResultErrData(tables, err) //} if tab, ok := paramTable.(string); ok { table.TableName = tab } else if tab, ok := paramTable.(schema.Tabler); ok { table.TableName = tab.TableName() } var columns, err = self.ColumnTypes(paramTable) if err != nil { golog.Error(err, columns) return pagemodel.ResultErrData(table, err) } for _, column := range columns { var dbcol = FindBeanDbmetaColumn() dbcol.TableName = table.TableName dbcol.FromColumnType(column) if dbcol.PrimaryKey { table.PkColumns = append(table.PkColumns, dbcol) } table.Columns = append(table.Columns, dbcol) } return pagemodel.ResultOk(table, true) }

package dbmeta import ( "gitee.com/leijmdas/goweb3/goconfig/base/baseiface" "gitee.com/leijmdas/goweb3/goconfig/basedi" "github.com/sirupsen/logrus" ) /* @Title 文件名称: dbmeta_column_init.go @Desp 描述: 依赖自动注入 @Company 公司: www.ichub.com @Author 作者: leijmdas@163.com 时间: 2026-03-15 12:51:06 @Update 作者: leijmdas@163.com 时间: 2026-03-15 12:51:06 */ var singleNameDbmetaColumn = "*dbmeta.DbmetaColumn-9d032f30-4763-45a5-9c04-1a27902a7995" // init register load func init() { registerBeanDbmetaColumn() } // register DbmetaColumn func registerBeanDbmetaColumn() { err := basedi.RegisterLoadBean(singleNameDbmetaColumn, LoadDbmetaColumn) if err != nil{ logrus.Error("register bean error!", err) } } // FindBeanDbmetaColumn func FindBeanDbmetaColumn() *DbmetaColumn { if bean, ok := basedi.FindBeanOk(singleNameDbmetaColumn); ok { return bean.(*DbmetaColumn) } logrus.Error("not find bean!") return nil } func LoadDbmetaColumn() baseiface.ISingleton { var inst = NewDbmetaColumn() InjectDbmetaColumn(inst) return inst } func InjectDbmetaColumn(s *DbmetaColumn) { }

package dbmeta import ( "strings" "gitee.com/leijmdas/goweb3/goconfig/base/basedto" "gitee.com/leijmdas/goweb3/goconfig/base/stringutils" "github.com/samber/lo" ) type DbmetaTable struct { basedto.BaseEntity TableExist bool `json:"tableExist"` TableType string `json:"tableType"` TableSchema string `json:"tableSchema" gorm:"column:table_schema"` TableName string `json:"tableName" gorm:"column:table_name"` IndexName string `json:"indexName"` FieldsName string `json:"fieldsName"` Columns []*DbmetaColumn `json:"columns"` PkColumns []*DbmetaColumn `json:"pkInfo"` } func NewDbmetaTable() *DbmetaTable { var metaTable = &DbmetaTable{ PkColumns: make([]*DbmetaColumn, 0), Columns: make([]*DbmetaColumn, 0), } metaTable.InitProxy(metaTable) return metaTable } func (self *DbmetaTable) IfPkColumnExists() bool { return self.PkColumns != nil && len(self.PkColumns) > 0 } func (self *DbmetaTable) IfView() bool { return self.TableType == "VIEW" } func (self *DbmetaTable) IfFieldNameExists() bool { return self.FieldsName != "" } func (self *DbmetaTable) IfFieldExists(field string) bool { var _, ok = self.FindColumn(field) return ok } func (self *DbmetaTable) FindColumn(field string) (*DbmetaColumn, bool) { return lo.Find(self.Columns, func(item *DbmetaColumn) bool { return item.ColumnName == field }) } func (self *DbmetaTable) ToFieldsName() string { var fields = lo.Map(self.Columns, func(item *DbmetaColumn, index int) string { return item.ColumnName }) self.FieldsName = strings.Join(fields, ",") return self.FieldsName } func (self *DbmetaTable) FindGoField(propName string) (*DbmetaColumn, bool) { return self.FindColumn(stringutils.Camel2Case(propName)) } func (self *DbmetaTable) FindGoType(propName string) string { var goField, ok = self.FindGoField(propName) return lo.Ternary(ok, goField.GoType, "string") }

package dbmeta import ( "gitee.com/leijmdas/goweb3/goconfig/base/basedto" "github.com/gogf/gf/v2/util/gconv" "gorm.io/gorm" ) type DecimalSize struct { Precision int64 Scale int64 } type DbmetaColumn struct { basedto.BaseEntity GoType string `json:"goType",gorm:"-"` TableName string `json:"tableName",gorm:"column:table_name"` TableSchema string `json:"tableSchema",gorm:"column:table_schema"` ColumnName string `json:"columnName",gorm:"column:column_name"` DbTypeName string `json:"dbTypeName,"gorm:"column:dbTypeName"` // varchar PrimaryKey bool `json:"primaryKey",gorm:"column:primary_key"` AutoIncrement bool `json:"autoIncrement",gorm:"column:auto_increment"` Nullable bool `json:"nullable",gorm:"column:nullable"` Unique bool `json:"unique",gorm:"column:unique"` ColumnType string `json:"columnType",gorm:"column:column_type"` // varchar(64) Length int64 `json:"length",gorm:"column:length"` Comment string `json:"comment" ,gorm:"column:comment"` DefaultValue string `json:"defaultValue" ,gorm:"column:default_value"` DecimalSize DecimalSize `json:"decimalSize",gorm:"column:decimal_size"` } func NewDbmetaColumn() *DbmetaColumn { var col = &DbmetaColumn{} col.InitProxy(col) return col } func (self *DbmetaColumn) FromColumnType(column gorm.ColumnType) *DbmetaColumn { self.ColumnName = column.Name() self.GoType = gconv.String(column.ScanType()) self.DbTypeName = column.DatabaseTypeName() // varchar self.ColumnType, _ = column.ColumnType() // varchar(64) self.Length, _ = column.Length() self.Comment, _ = column.Comment() self.DefaultValue, _ = column.DefaultValue() self.DecimalSize.Precision, self.DecimalSize.Scale, _ = column.DecimalSize() self.PrimaryKey, _ = column.PrimaryKey() self.Nullable, _ = column.Nullable() self.Unique, _ = column.Unique() self.AutoIncrement, _ = column.AutoIncrement() return self }