model

Documentation

Index

• Variables
• type TableColumn
  • func GetColumnsByTableName(dbEngine *sql.DB, databaseName string, tableName string) ([]*TableColumn, error)
• type TableNameColumn
  • func GetColumnsByDatabaseName(dbEngine *sql.DB, databaseName string, tableName string) ([]*TableNameColumn, error)

Variables

var DBSkipColName = map[string]string{
	"is_deleted":  "is_deleted",
	"update_time": "update_time",
	"update_user": "update_user",
	"create_time": "create_time",
	"create_user": "create_user",
}

var DBTypeToStructType = map[string]string{
	"int":       "int32",
	"tinyint":   "int",
	"smallint":  "int",
	"mediumint": "int64",
	"bigint":    "int64",
	"bit":       "int",
	"bool":      "bool",
	"enum":      "string",
	"set":       "string",
	"varchar":   "string",
	"text":      "string",
	"datetime":  "string",
}

DBTypeToStructType 数据库字段类型 转 go 数据字段类型

Types

type TableColumn

type TableColumn struct {
	TableName     string
	ColumnName    string
	DataType      string
	IsNullable    string
	ColumnKey     string
	ColumnType    string
	ColumnComment string
}

func GetColumnsByTableName

func GetColumnsByTableName(dbEngine *sql.DB, databaseName string, tableName string) ([]*TableColumn, error)

type TableNameColumn

type TableNameColumn struct {
	TableName string
}

func GetColumnsByDatabaseName

func GetColumnsByDatabaseName(dbEngine *sql.DB, databaseName string, tableName string) ([]*TableNameColumn, error)