Versions in this module Expand all Collapse all v1 v1.0.1 Mar 4, 2024 Changes in this version + var TypeDM = &Type + var TypeGBase = &Type + var TypeKingBase = &Type + var TypeMysql = &Type + var TypeOdbc = &Type + var TypeOpenGauss = &Type + var TypeOracle = &Type + var TypePostgresql = &Type + var TypeShenTong = &Type + var TypeSqlite = &Type + var TypeYXu = &Type + func BytesIndex(array []byte, val byte) (index int) + func FormatCountSql(selectSql string) (countSql string, err error) + func FormatStatement(statement_ Statement, statementContext *StatementContext) (text string, err error) + func FormatStatements(statements []Statement, statementContext *StatementContext) (text string, err error) + func GetBaseTypeValue(data interface{}) (res interface{}, is bool) + func GetStatementValue(statement_ Statement, statementContext *StatementContext) (res interface{}, err error) + func GetStringValue(value interface{}) string + func ReplaceStringByRegex(str, rule, replace string) string + func StatementsFindValue(statements []Statement, statementContext *StatementContext) (findValue bool, err error) + func StringToInt(str string) (res int, err error) + func StringToInt64(str string) (res int64, err error) + func StringsIndex(array []string, val string) (index int) + func UUID() (res string) + type AbstractStatement struct + Children []Statement + Content string + Parent Statement + func (this_ *AbstractStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *AbstractStatement) GetChildren() (children *[]Statement) + func (this_ *AbstractStatement) GetContent() (content *string) + func (this_ *AbstractStatement) GetParent() (parent Statement) + func (this_ *AbstractStatement) GetTemplate() (template string) + type ColumnModel struct + ColumnAfterColumn string + ColumnCharacterSetName string + ColumnComment string + ColumnDataType string + ColumnDefault string + ColumnEnums []string + ColumnExtra string + ColumnLength int + ColumnName string + ColumnNotNull bool + ColumnPrecision int + ColumnScale int + Error string + OwnerName string + PrimaryKey bool + TableName string + type ColumnTypeInfo struct + ColumnDefaultPack func(param *ParamModel, column *ColumnModel) (columnDefaultPack string, err error) + ColumnTypePack func(column *ColumnModel) (columnTypePack string, err error) + Comment string + Format string + FullColumnByColumnType func(columnType string, column *ColumnModel) (err error) + IfNotFound bool + IsBoolean bool + IsBytes bool + IsDateTime bool + IsEnum bool + IsExtend bool + IsFloat bool + IsInteger bool + IsNumber bool + IsString bool + Matches []string + MaxLength *int + MaxPrecision *int + MaxScale *int + MinLength *int + MinPrecision *int + MinScale *int + Name string + SqlValuePack func(value string) (sqlValue string) + type Dialect interface + ColumnAddSql func(param *ParamModel, ownerName string, tableName string, column *ColumnModel) (sqlList []string, err error) + ColumnCommentSql func(param *ParamModel, ownerName string, tableName string, columnName string, ...) (sqlList []string, err error) + ColumnDefaultPack func(param *ParamModel, column *ColumnModel) (columnDefaultPack string, err error) + ColumnDeleteSql func(param *ParamModel, ownerName string, tableName string, columnName string) (sqlList []string, err error) + ColumnModel func(data map[string]interface{}) (table *ColumnModel, err error) + ColumnNamePack func(param *ParamModel, columnName string) string + ColumnNamesPack func(param *ParamModel, columnNames []string) string + ColumnSelectSql func(param *ParamModel, ownerName string, tableName string, columnName string) (sql string, err error) + ColumnTypePack func(column *ColumnModel) (columnTypePack string, err error) + ColumnUpdateSql func(param *ParamModel, ownerName string, tableName string, oldColumn *ColumnModel, ...) (sqlList []string, err error) + ColumnsSelectSql func(param *ParamModel, ownerName string, tableName string) (sql string, err error) + DialectType func() (dialectType *Type) + GetColumnTypeInfo func(column *ColumnModel) (columnTypeInfo *ColumnTypeInfo, err error) + GetColumnTypeInfos func() (columnTypeInfoList []*ColumnTypeInfo) + GetIndexTypeInfos func() (indexTypeInfoList []*IndexTypeInfo) + IndexAddSql func(param *ParamModel, ownerName string, tableName string, index *IndexModel) (sqlList []string, err error) + IndexDeleteSql func(param *ParamModel, ownerName string, tableName string, indexName string) (sqlList []string, err error) + IndexModel func(data map[string]interface{}) (index *IndexModel, err error) + IndexesSelectSql func(param *ParamModel, ownerName string, tableName string) (sql string, err error) + IsSqlEnd func(sqlInfo string) bool + OwnerCreateSql func(param *ParamModel, owner *OwnerModel) (sqlList []string, err error) + OwnerDeleteSql func(param *ParamModel, ownerName string) (sqlList []string, err error) + OwnerModel func(data map[string]interface{}) (owner *OwnerModel, err error) + OwnerNamePack func(param *ParamModel, ownerName string) string + OwnerSelectSql func(param *ParamModel, ownerName string) (sql string, err error) + OwnerTablePack func(param *ParamModel, ownerName string, tableName string) string + OwnersSelectSql func(param *ParamModel) (sql string, err error) + PackLimitOffsetSql func(selectSql string, limit int, offset int) (pageSql string) + PackPageSql func(selectSql string, pageSize int, pageNo int) (pageSql string) + PrimaryKeyAddSql func(param *ParamModel, ownerName string, tableName string, columnNames []string) (sqlList []string, err error) + PrimaryKeyDeleteSql func(param *ParamModel, ownerName string, tableName string) (sqlList []string, err error) + PrimaryKeyModel func(data map[string]interface{}) (primaryKey *PrimaryKeyModel, err error) + PrimaryKeysSelectSql func(param *ParamModel, ownerName string, tableName string) (sql string, err error) + ReplaceSqlVariable func(sqlInfo string, args []interface{}) (variableSql string) + SqlSplit func(sqlInfo string) []string + SqlValuePack func(param *ParamModel, column *ColumnModel, value interface{}) string + TableCommentSql func(param *ParamModel, ownerName string, tableName string, tableComment string) (sqlList []string, err error) + TableCreateSql func(param *ParamModel, ownerName string, table *TableModel) (sqlList []string, err error) + TableDeleteSql func(param *ParamModel, ownerName string, tableName string) (sqlList []string, err error) + TableModel func(data map[string]interface{}) (table *TableModel, err error) + TableNamePack func(param *ParamModel, tableName string) string + TableRenameSql func(param *ParamModel, ownerName string, oldTableName string, tableName string) (sqlList []string, err error) + TableSelectSql func(param *ParamModel, ownerName string, tableName string) (sql string, err error) + TablesSelectSql func(param *ParamModel, ownerName string) (sql string, err error) + WrapParamSQL func(paramIndex int) string + func NewDialect(dialectType string) (dia Dialect, err error) + func NewMappingDialect(mapping *SqlMapping) (dia Dialect, err error) + type ElseIfStatement struct + Condition string + ConditionExpression *ExpressionStatement + If *IfStatement + Index int + func (this_ *ElseIfStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ElseIfStatement) GetTemplate() (template string) + func (this_ *ElseIfStatement) IsEndElseIf() (isEnd bool) + type ElseStatement struct + If *IfStatement + func (this_ *ElseStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ElseStatement) GetTemplate() (template string) + type ExpressionBracketsStatement struct + func (this_ *ExpressionBracketsStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ExpressionFuncStatement struct + Args []Statement + Func string + func (this_ *ExpressionFuncStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ExpressionFuncStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ExpressionIdentifierStatement struct + Identifier string + func (this_ *ExpressionIdentifierStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ExpressionIdentifierStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ExpressionNumberStatement struct + Value float64 + func (this_ *ExpressionNumberStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ExpressionNumberStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ExpressionOperatorStatement struct + Operator string + type ExpressionStatement struct + func (this_ *ExpressionStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ExpressionStringStatement struct + Value string + func (this_ *ExpressionStringStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *ExpressionStringStatement) GetValue(statementContext *StatementContext) (res interface{}, err error) + type ForStatement struct + func (this_ *ForStatement) GetTemplate() (template string) + type IfStatement struct + Condition string + ConditionExpression *ExpressionStatement + Else *ElseStatement + ElseIfs []*ElseIfStatement + func (this_ *IfStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *IfStatement) GetTemplate() (template string) + type IgnorableStatement struct + func (this_ *IgnorableStatement) Format(statementContext *StatementContext) (text string, err error) + func (this_ *IgnorableStatement) GetTemplate() (template string) + type IndexModel struct + ColumnName string + ColumnNames []string + Error string + IndexComment string + IndexName string + IndexType string + OwnerName string + TableName string + type IndexTypeInfo struct + Format string + IndexNameFormat func(param *ParamModel, ownerName string, tableName string, index *IndexModel) (indexNameFormat string, err error) + IndexTypeFormat func(index *IndexModel) (indexTypeFormat string, err error) + IsExtend bool + Name string + NotSupportDataTypes []string + OnlySupportDataTypes []string + type MethodInfo struct + func (this_ *MethodInfo) Call(inValues []interface{}) (outValues []interface{}, err error) + type Order struct + AscDesc string + Name string + type OwnerModel struct + Error string + OwnerCharacterSetName string + OwnerCollationName string + OwnerComment string + OwnerName string + OwnerPassword string + type ParamModel struct + AppendSqlValue *bool + ColumnNamePack *bool + ColumnNamePackChar *string + CustomData map[string]interface{} + OwnerNamePack *bool + OwnerNamePackChar *string + SqlValueEscapeChar *string + SqlValuePackChar *string + TableNamePack *bool + TableNamePackChar *string + type PrimaryKeyModel struct + ColumnName string + Error string + OwnerName string + TableName string + type RootStatement struct + type SqlMapping struct + CanAppendOwnerName bool + ColumnAdd string + ColumnAfter string + ColumnComment string + ColumnDelete string + ColumnNamePackChar string + ColumnRename string + ColumnSelect string + ColumnUpdate string + ColumnUpdateHasAfter bool + ColumnUpdateHasComment bool + ColumnUpdateHasRename bool + ColumnsSelect string + IndexAdd string + IndexDelete string + IndexNameMaxLen int + IndexNamePack string + IndexesSelect string + MethodCache map[string]interface{} + OwnerCreate string + OwnerDelete string + OwnerNamePackChar string + OwnerSelect string + OwnerTablePack func(param *ParamModel, ownerName string, tableName string) string + OwnersSelect string + PackLimitOffsetSql func(selectSql string, limit int, offset int) (pageSql string) + PackPageSql func(selectSql string, pageSize int, pageNo int) (pageSql string) + PrimaryKeyAdd string + PrimaryKeyDelete string + PrimaryKeysSelect string + ReplaceSqlVariable func(sqlInfo string, args []interface{}) (variableSql string) + SqlValueEscapeChar string + SqlValuePackChar string + TableComment string + TableCreate string + TableCreateColumn string + TableCreateColumnHasComment bool + TableCreatePrimaryKey string + TableDelete string + TableNamePackChar string + TableRename string + TableSelect string + TablesSelect string + WrapParamSQL func(paramIndex int) string + func NewMappingDM() (mapping *SqlMapping) + func NewMappingGBase() (mapping *SqlMapping) + func NewMappingKingBase() (mapping *SqlMapping) + func NewMappingMysql() (mapping *SqlMapping) + func NewMappingOdbc() (mapping *SqlMapping) + func NewMappingOpenGauss() (mapping *SqlMapping) + func NewMappingOracle() (mapping *SqlMapping) + func NewMappingPostgresql() (mapping *SqlMapping) + func NewMappingShenTong() (mapping *SqlMapping) + func NewMappingSqlite() (mapping *SqlMapping) + func NewMappingYXRes() (mapping *SqlMapping) + func (this_ *SqlMapping) AddColumnTypeInfo(columnTypeInfo *ColumnTypeInfo) + func (this_ *SqlMapping) AddIndexTypeInfo(indexTypeInfo *IndexTypeInfo) + func (this_ *SqlMapping) ColumnTypePack(column *ColumnModel) (columnTypePack string, err error) + func (this_ *SqlMapping) DialectType() (dialectType *Type) + func (this_ *SqlMapping) GenDemoTable() (table *TableModel) + func (this_ *SqlMapping) GetColumnTypeInfo(column *ColumnModel) (columnTypeInfo *ColumnTypeInfo, err error) + func (this_ *SqlMapping) GetColumnTypeInfos() (columnTypeInfoList []*ColumnTypeInfo) + func (this_ *SqlMapping) GetIndexTypeInfo(typeName string) (indexTypeInfo *IndexTypeInfo, err error) + func (this_ *SqlMapping) GetIndexTypeInfos() (indexTypeInfoList []*IndexTypeInfo) + func (this_ *SqlMapping) IndexNameFormat(param *ParamModel, ownerName string, tableName string, index *IndexModel) (indexNameFormat string, err error) + func (this_ *SqlMapping) IndexTypeFormat(index *IndexModel) (indexTypeFormat string, err error) + type Statement interface + Format func(statementContext *StatementContext) (text string, err error) + GetChildren func() (children *[]Statement) + GetContent func() (content *string) + GetParent func() (parent Statement) + GetTemplate func() (template string) + type StatementContext struct + func NewStatementContext() (res *StatementContext) + func (this_ *StatementContext) AddMethod(name string, methodFunc interface{}) *StatementContext + func (this_ *StatementContext) GetData(name string) (value interface{}, find bool) + func (this_ *StatementContext) GetMethod(name string) (method *MethodInfo, find bool) + func (this_ *StatementContext) SetData(name string, value interface{}) *StatementContext + func (this_ *StatementContext) SetDataIfAbsent(name string, value interface{}) *StatementContext + func (this_ *StatementContext) SetJSONData(data interface{}) (err error) + func (this_ *StatementContext) SetMapData(data map[string]interface{}) *StatementContext + type StatementParser struct + type StatementScript struct + type TableModel struct + ColumnList []*ColumnModel + Error string + IndexList []*IndexModel + OwnerName string + PrimaryKeys []string + Sql string + TableCharacterSetName string + TableComment string + TableName string + func (this_ *TableModel) AddColumn(column *ColumnModel) *ColumnModel + func (this_ *TableModel) AddIndex(models ...*IndexModel) + func (this_ *TableModel) AddPrimaryKey(models ...*PrimaryKeyModel) + func (this_ *TableModel) FindColumnByName(name string) *ColumnModel + func (this_ *TableModel) FindIndexByName(name string) *IndexModel + type TextStatement struct + type Type struct + Name string + type Where struct + After string + AndOr string + Before string + CustomSql string + Name string + SqlConditionalOperation string + Value string