db

Documentation

Index

• Variables
• func AddJSONFormGormTag(in string) string
• func AddressCrdb() string
• func ConnectCrdb() map[string]*gorm.DB
• func ConnectSql() map[string]*gorm.DB
• func FindUpperElement(s string) []string
• func GenerateFile(filePath string, content string) error
• func GenerateModel(source string, tableName string) interface{}
• func HumpToUnderLine(s string) string
• func InfoSql() string
• func Split(s string, sub string) []string
• func Split2(s string, sub string, tmp *string, rs *[]string)
• func TableToStruct(dataSource string, tableName string) string
• func UnderLineToHump(s string) string
• type Column
  • func FindColumns(dataSource string, tableName string) []Column
• type Index
• type Table
  • func FindTables(dataSource string) []Table

Variables

var CRDBInstance map[string]*gorm.DB

var DBInstance map[string]*gorm.DB

var FindColumnsSql = `
	SELECT COLUMN_NAME,DATA_TYPE,IS_NULLABLE,COLUMN_DEFAULT
	FROM information_schema.COLUMNS 
	WHERE TABLE_NAME = ?
`

Functions

func AddJSONFormGormTag

func AddJSONFormGormTag(in string) string

AddJSONFormGormTag adds json format

func AddressCrdb

func AddressCrdb() string

func ConnectCrdb

func ConnectCrdb() map[string]*gorm.DB

func ConnectSql

func ConnectSql() map[string]*gorm.DB

func FindUpperElement

func FindUpperElement(s string) []string

FindUpperElement finds a list of uppercase letters in the string, attached to HumpToUnderLine

func GenerateFile

func GenerateFile(filePath string, content string) error

create file model

func GenerateModel

func GenerateModel(source string, tableName string) interface{}

func HumpToUnderLine

func HumpToUnderLine(s string) string

HumpToUnderLine hump underline

func InfoSql

func InfoSql() string

func Split

func Split(s string, sub string) []string

Split Enhanced Split, for a,,,,,,,b,,c cut to "a,b,c] with ","

func Split2

func Split2(s string, sub string, tmp *string, rs *[]string)

Split2 is attached to Split and can be used independently

func TableToStruct

func TableToStruct(dataSource string, tableName string) string

generate go model y specific the dataSource and table name

func UnderLineToHump

func UnderLineToHump(s string) string

UnderLineToHump underline to hump

Types

type Column

type Column struct {
	ColumnNumber  int    `gorm:"column_number "` // column index
	ColumnName    string `gorm:"column_name"`    // column_name
	DataType      string `gorm:"data_type"`      // column_type
	ColumnDefault string `gorm:"column_default"` // column_default
	IsNullAble    bool   `gorm:"is_nullable"`    // column_default
	Constraint    Index  `gorm:"indices"`        // column_default
}

func FindColumns

func FindColumns(dataSource string, tableName string) []Column

find columns' property by specific dataSource and table name

type Index

type Index struct {
	TableName string `gorm:"column:table_name"` //table name
	IndexName string `gorm:"index_name"`
	Direction string `gorm:"direction"`
}

type Table

type Table struct {
	TableName string `gorm:"column:table_name"` //table name
}

func FindTables

func FindTables(dataSource string) []Table

dataSource = fmt.Sprintf("host=%s port=%s user=%s dbname=%s sslmode=%s password=%s","localhost", "5432", "postgres", "test", "disable", "123")