DBSchema

Documentation

Index

• Variables
• func FieldName(s string) string
• func FmtFieldName(s string) string
• func Generate(columnTypes []generatorModels.ColumnData, tableName string, structName string, ...) ([]byte, error)
• func GenerateGrapql(columnTypes []generatorModels.ColumnData, tableName string, structName string, ...) ([]byte, error)
• func GenerateGrapqlOrder(columnTypes []generatorModels.ColumnData, tableName string, structName string, ...) ([]byte, error)
• func GenerateOnlyStruct(columnTypes []generatorModels.ColumnData, tableName string, structName string, ...) ([]byte, error)
• func GenerateProtobuf(columnTypes []generatorModels.ColumnData, tableName string, structName string, ...) ([]byte, error)
• func GenerateSchemaForCloud() models.DBSCHEMA
• func GenerateWithImports(otherPackage string, columnTypes []generatorModels.ColumnData, ...) ([]byte, error)
• func GenerateWithImportsNoTime(otherPackage string, columnTypes []generatorModels.ColumnData, ...) ([]byte, error)
• func GetColumns(db *sql.DB, dbTable string, hiddenColumns []string) (string, error)
• func GetColumnsFromSQLlTable(db *sql.DB, dbTable string, hiddenColumns []string) ([]generatorModels.ColumnData, error)
• func GetColumnsWithMeta(db *sql.DB, dbTable string, hiddenColumns []string) ([]map[string]string, error)
• func GetDBSchema() models.DBSCHEMA
• func GetDBSchemaWithTargets(tables map[string][]string) models.DBSCHEMA
• func GetOnlyOneField(db *sql.DB, dbTable string, oneField string) (*map[string]map[string]string, error)
• func GetTableSchema(columnTypes []generatorModels.ColumnData) string
• func IsSecureField(table, column, dataType string) string
• func LcFirst(s string) string
• func StringifyFirstChar(str string) string
• func TableColumns(table string, hiddenColumns []string) string
• func TableColumnsWithMeta(table string, hiddenColumns []string) []map[string]string
• func TableMetas(tableName string) []models.TableMeta
• func TableToGraphql(table string, hiddenColumns []string, Subs []string, isInpute bool) string
• func TableToGraphqlOrderBy(table string, hiddenColumns []string) string
• func TableToStruct(table string, hiddenColumns []string, pkgName string, Subs []string) string
• func TableToStructNoTime(table string, hiddenColumns []string, pkgName string) string
• func Tables() map[string][]string
• func TablesForCloud() map[string][]string
• func ToGo(name string) string
• func TypeContains(v string, a []string) bool
• func UcFirst(s string) string

Variables

var Debug = false

var Enums []models.PostgresEnum

var TypeBigIntegers = []string{
	"bigint",
	"int8",
	"LONG",
}

var TypeBinaries = []string{
	"binary",
	"blob",
	"longblob",
	"mediumblob",
	"varbinary",
	"BFILE",
	"BLOB",
}

var TypeBool = []string{
	"bool",
}

var TypeDates = []string{}

var TypeFloat32 = []string{
	"float",
	"float8",
	"float4",
	"real",
	"FLOAT",
	"NUMBER",
}

var TypeFloat64 = []string{
	"decimal",
	"double",
	"numeric",
	"BINARY_FLOAT",
	"BINARY_DOUBLE",
	"DECIMAL",
}

var TypeGeo = []string{}

var TypeIntegers = []string{
	"tinyint",
	"int",
	"smallint",
	"mediumint",
	"int4",
	"int2",
	"year",
	"SMALLINT",
	"INT",
	"INTEGER",
}

var TypeSecure = []string{
	"secure",
}

var TypeStrings = []string{
	"char",
	"enum",
	"varchar",
	"nvarchar",
	"longtext",
	"mediumtext",
	"text",
	"ntext",
	"tinytext",
	"uuid",
	"bpchar",
	"CHARACTER",
	"VARCHAR",
	"VARCHAR2",
	"NVARCHAR2",
	"CLOB",
	"CHAR",
	"NCHAR",
	"NCLOB",
	"JSON",
	"JSONB",
	"json",
	"ROWID",
	"UROWID",
	"jsonb",
	"time",
	"geometry",
	"INTERVAL",
	"interval",
}

var TypeTimes = []string{
	"datetimeoffset",
	"timestamptz",
	"TIMESTAMP(6) WITH TIME ZONE",
	"TIMESTAMP(6) WITH LOCAL TIME ZONE",
	"TIMESTAMP",
	"TIMESTAMP(6)",
	"datetime",
	"date",
	"DATE",
	"timestamp",
	"TIMESTAMP",
}

Functions

func FieldName

func FieldName(s string) string

func FmtFieldName

func FmtFieldName(s string) string

func Generate

func Generate(columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string) ([]byte, error)

func GenerateGrapql

func GenerateGrapql(columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string, Subs []string, isInpute bool) ([]byte, error)

func GenerateGrapqlOrder

func GenerateGrapqlOrder(columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string) ([]byte, error)

func GenerateOnlyStruct

func GenerateOnlyStruct(columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string) ([]byte, error)

func GenerateProtobuf

func GenerateProtobuf(columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string, Subs []string, isInpute bool) ([]byte, error)

func GenerateSchemaForCloud

func GenerateSchemaForCloud() models.DBSCHEMA

func GenerateWithImports

func GenerateWithImports(otherPackage string, columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string, virtualColums string) ([]byte, error)

func GenerateWithImportsNoTime

func GenerateWithImportsNoTime(otherPackage string, columnTypes []generatorModels.ColumnData, tableName string, structName string, pkgName string, jsonAnnotation bool, gormAnnotation bool, gureguTypes bool, extraColumns string, extraStucts string) ([]byte, error)

func GetColumns

func GetColumns(db *sql.DB, dbTable string, hiddenColumns []string) (string, error)

func GetColumnsFromSQLlTable

func GetColumnsFromSQLlTable(db *sql.DB, dbTable string, hiddenColumns []string) ([]generatorModels.ColumnData, error)

func GetColumnsWithMeta

func GetColumnsWithMeta(db *sql.DB, dbTable string, hiddenColumns []string) ([]map[string]string, error)

func GetDBSchema

func GetDBSchema() models.DBSCHEMA

func GetDBSchemaWithTargets

func GetDBSchemaWithTargets(tables map[string][]string) models.DBSCHEMA

func GetOnlyOneField

func GetOnlyOneField(db *sql.DB, dbTable string, oneField string) (*map[string]map[string]string, error)

func GetTableSchema

func GetTableSchema(columnTypes []generatorModels.ColumnData) string

func IsSecureField

func IsSecureField(table, column, dataType string) string

func LcFirst

func LcFirst(s string) string

func StringifyFirstChar

func StringifyFirstChar(str string) string

func TableColumns

func TableColumns(table string, hiddenColumns []string) string

func TableColumnsWithMeta

func TableColumnsWithMeta(table string, hiddenColumns []string) []map[string]string

func TableMetas

func TableMetas(tableName string) []models.TableMeta

func TableToGraphql

func TableToGraphql(table string, hiddenColumns []string, Subs []string, isInpute bool) string

func TableToGraphqlOrderBy

func TableToGraphqlOrderBy(table string, hiddenColumns []string) string

func TableToStruct

func TableToStruct(table string, hiddenColumns []string, pkgName string, Subs []string) string

func TableToStructNoTime

func TableToStructNoTime(table string, hiddenColumns []string, pkgName string) string

func Tables

func Tables() map[string][]string

func TablesForCloud

func TablesForCloud() map[string][]string

func ToGo

func ToGo(name string) string

func TypeContains

func TypeContains(v string, a []string) bool

func UcFirst

func UcFirst(s string) string