dao

package
v3.2.15 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 20, 2022 License: Apache-2.0 Imports: 15 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var (
	// CmdNew represents the new command.
	CmdNew = &cobra.Command{
		Use:   "dao",
		Short: "数据访问对象",
		Long:  "创建数据访问对象: toolkit dao",
		Run:   run,
	}
	AppConfig *config.Config
	Link      *query.Query
)
View Source
var DataTypeMap = map[string][]string{

	"TINYINT":   {"int64", "query.NullInt64"},
	"SMALLINT":  {"int64", "query.NullInt64"},
	"MEDIUMINT": {"int64", "query.NullInt64"},
	"INT":       {"int64", "query.NullInt64"},
	"INTEGER":   {"int64", "query.NullInt64"},
	"BIGINT":    {"int64", "query.NullInt64"},

	"FLOAT":   {"float64", "query.NullFloat64"},
	"DOUBLE":  {"float64", "query.NullFloat64"},
	"DECIMAL": {"float64", "query.NullFloat64"},

	"DATE":      {"query.NullDate", "query.NullDate"},
	"TIME":      {"query.NullTime", "query.NullTime"},
	"YEAR":      {"query.NullYear", "query.NullYear"},
	"DATETIME":  {"query.NullDateTime", "query.NullDateTime"},
	"TIMESTAMP": {"query.NullTimeStamp", "query.NullTimeStamp"},

	"CHAR":       {"string", "query.NullString"},
	"VARCHAR":    {"string", "query.NullString"},
	"TINYBLOB":   {"string", "query.NullString"},
	"TINYTEXT":   {"string", "query.NullString"},
	"BLOB":       {"string", "query.NullString"},
	"TEXT":       {"string", "query.NullString"},
	"MEDIUMBLOB": {"string", "query.NullString"},
	"MEDIUMTEXT": {"string", "query.NullString"},
	"LONGBLOB":   {"string", "query.NullString"},
	"LONGTEXT":   {"string", "query.NullString"},
	"JSON":       {"string", "query.NullString"},
}

DataTypeMap ...

Functions

func CamelStr

func CamelStr(name string) string

CamelStr 下划线转驼峰

Types

type Column

type Column struct {
	ColumnName    string `db:"COLUMN_NAME"`
	IsNullable    string `db:"IS_NULLABLE"`
	DataType      string `db:"DATA_TYPE"`
	ColumnKey     string `db:"COLUMN_KEY"`
	ColumnComment string `db:"COLUMN_COMMENT"`
}

Column ...

func QueryColumn

func QueryColumn(ctx context.Context, DbName, TableName string) ([]Column, error)

QueryColumn 获取数据中表中字段的信息

type Table

type Table struct {
	TableName    string `db:"TABLE_NAME"`
	TableComment string `db:"TABLE_COMMENT"`
}

func QueryTable

func QueryTable(ctx context.Context, DbName string) ([]Table, error)

QueryTable 获取数据中表的信息

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL