dao

Documentation

Index

• Variables
• func CamelStr(name string) string
• type Column
  • func QueryColumn(ctx context.Context, DbName, TableName string) ([]Column, error)
• type Table
  • func QueryTable(ctx context.Context, DbName string) ([]Table, error)

Variables

var (
	// CmdNew represents the new command.
	CmdNew = &cobra.Command{
		Use:   "dao",
		Short: "Create a dao",
		Long:  "Create a dao using the repository template. Example: ratel dao",
		Run:   run,
	}
	AppConfig *config.Config
	Link      *query.Query
)

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.NullTime", "query.NullTime"},

	"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 获取数据中表的信息