gomini元数据之二: DB发现表信息,转化go结构信息；是实现代码工厂的基础

代码开源：

ichub/gomini

安装工具： 

go install gitee.com/ichub/gomini/cmd/gomini

聚合根

工具\go-ichub\go\gomini

2024-05-08 13:18:55.693 [INFO] D:\go-ichub\go\gomini
This is a gomini application using Cobra

Usage:
  gomini [flags]
  gomini [command]

Available Commands:
  db          db table
  file        file get all rootDir
  goast       goast flag stru
  help        Help about any command
  version     Print the version number of gomini

Flags:
  -h, --help   help for gomini

Use "gomini [command] --help" for more information about a command.
 

执行gomini db sys_app

 

结果

{
     "table_schema": "goplatform",
     "table_name": "sys_app",
     "table_comment": "",
     "pk_info": {
          "pk_name": "app_id",
          "col_name": "app_id",
          "type_name": "int"
     },
     "columns": [
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "app_id",
               "data_type": "int",
               "column_type": "int(11)",
               "column_key": "PRI",
               "char_max_len": "",
               "column_comment": "子系统标识号",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "app_no",
               "data_type": "varchar",
               "column_type": "varchar(64)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "app_name",
               "data_type": "varchar",
               "column_type": "varchar(64)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "子系统名称",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "remark",
               "data_type": "varchar",
               "column_type": "varchar(64)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "子系统",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "ip",
               "data_type": "varchar",
               "column_type": "varchar(64)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "port",
               "data_type": "int",
               "column_type": "int(2)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "",
               "column_default": ""
          },
          {
               "table_name": "sys_app",
               "table_schema": "goplatform",
               "column_name": "type",
               "data_type": "varchar",
               "column_type": "varchar(32)",
               "column_key": "",
               "char_max_len": "",
               "column_comment": "",
               "column_default": ""
          }
     ],
     "go_fields": [
          {
               "column_name": "app_id",
               "data_type": "int",
               "column_type": "",
               "go_type": "int32"
          },
          {
               "column_name": "app_no",
               "data_type": "varchar",
               "column_type": "",
               "go_type": "string"
          },
          {
               "column_name": "app_name",
               "data_type": "varchar",
               "column_type": "",
               "go_type": "string"
          },
          {
               "column_name": "remark",
               "data_type": "varchar",
               "column_type": "",
               "go_type": "string"
          },
          {
               "column_name": "ip",
               "data_type": "varchar",
               "column_type": "",
               "go_type": "string"
          },
          {
               "column_name": "port",
               "data_type": "int",
               "column_type": "",
               "go_type": "int32"
          },
          {
               "column_name": "type",
               "data_type": "varchar",
               "column_type": "",
               "go_type": "string"
          }
     ],
     "table_exist": true,
     "fields_name": "",
     "index_name": "sys_app"
}