sdata

Documentation

Index

• type DBColumn
  • func DiscoverColumns(db *sql.DB, dbtype string, blockList []string) ([]DBColumn, error)
  • func (col DBColumn) String() string
• type DBFuncParam
• type DBFunction
  • func DiscoverFunctions(db *sql.DB, blockList []string) ([]DBFunction, error)
• type DBInfo
  • func GetDBInfo(db *sql.DB, dbType string, blockList []string) (*DBInfo, error)
  • func GetTestDBInfo() *DBInfo
  • func NewDBInfo(dbType string, dbVersion int, dbSchema string, dbName string, cols []DBColumn, ...) *DBInfo
  • func (di *DBInfo) AddTable(t DBTable)
  • func (di *DBInfo) GetColumn(schema, table, column string) (*DBColumn, error)
  • func (di *DBInfo) GetTable(schema, table string) (*DBTable, error)
• type DBRel
  • func PathToRel(p TPath) DBRel
  • func (re *DBRel) String() string
• type DBRelLeft
• type DBRelRight
• type DBSchema
  • func GetTestSchema() (*DBSchema, error)
  • func NewDBSchema(info *DBInfo, aliases map[string][]string) (*DBSchema, error)
  • func (s *DBSchema) DBName() string
  • func (s *DBSchema) DBSchema() string
  • func (s *DBSchema) DBType() string
  • func (s *DBSchema) DBVersion() int
  • func (s *DBSchema) Find(schema, name string) (DBTable, error)
  • func (s *DBSchema) FindPath(from, to string) ([]TPath, error)
  • func (s *DBSchema) GetAliases() map[string]DBTable
  • func (s *DBSchema) GetFunctions() map[string]DBFunction
  • func (s *DBSchema) GetTables() []DBTable
• type DBTable
  • func NewDBTable(schema, name, _type string, cols []DBColumn) DBTable
  • func (ti *DBTable) GetColumn(name string) (DBColumn, error)
  • func (ti *DBTable) String() string
• type RelType
  • func (i RelType) String() string
• type TEdge
• type TPath
• type VirtualTable

Types

type DBColumn

type DBColumn struct {
	ID         int32
	Name       string
	Type       string
	Array      bool
	NotNull    bool
	PrimaryKey bool
	UniqueKey  bool
	FullText   bool
	FKeySchema string
	FKeyTable  string
	FKeyCol    string
	Blocked    bool
	Table      string
	Schema     string
}

func DiscoverColumns

func DiscoverColumns(db *sql.DB, dbtype string, blockList []string) ([]DBColumn, error)

func (DBColumn) String

func (col DBColumn) String() string

type DBFuncParam

type DBFuncParam struct {
	ID   int
	Name sql.NullString
	Type string
}

type DBFunction

type DBFunction struct {
	Name   string
	Params []DBFuncParam
}

func DiscoverFunctions

func DiscoverFunctions(db *sql.DB, blockList []string) ([]DBFunction, error)

type DBInfo

type DBInfo struct {
	Type      string
	Version   int
	Schema    string
	Name      string
	Tables    []DBTable
	Functions []DBFunction
	VTables   []VirtualTable
	// contains filtered or unexported fields
}

func GetDBInfo

func GetDBInfo(
	db *sql.DB,
	dbType string,
	blockList []string) (*DBInfo, error)

func GetTestDBInfo

func GetTestDBInfo() *DBInfo

func NewDBInfo

func NewDBInfo(
	dbType string,
	dbVersion int,
	dbSchema string,
	dbName string,
	cols []DBColumn,
	funcs []DBFunction,
	blockList []string) *DBInfo

func (*DBInfo) AddTable

func (di *DBInfo) AddTable(t DBTable)

func (*DBInfo) GetColumn

func (di *DBInfo) GetColumn(schema, table, column string) (*DBColumn, error)

func (*DBInfo) GetTable

func (di *DBInfo) GetTable(schema, table string) (*DBTable, error)

type DBRel

type DBRel struct {
	Type  RelType
	Left  DBRelLeft
	Right DBRelRight
}

func PathToRel

func PathToRel(p TPath) DBRel

func (*DBRel) String

func (re *DBRel) String() string

type DBRelLeft

type DBRelLeft struct {
	Ti  DBTable
	Col DBColumn
}

type DBRelRight

type DBRelRight struct {
	VTable string
	Ti     DBTable
	Col    DBColumn
}

type DBSchema

type DBSchema struct {
	// contains filtered or unexported fields
}

func GetTestSchema

func GetTestSchema() (*DBSchema, error)

func NewDBSchema

func NewDBSchema(
	info *DBInfo,
	aliases map[string][]string) (*DBSchema, error)

func (*DBSchema) DBName

func (s *DBSchema) DBName() string

func (*DBSchema) DBSchema

func (s *DBSchema) DBSchema() string

func (*DBSchema) DBType

func (s *DBSchema) DBType() string

func (*DBSchema) DBVersion

func (s *DBSchema) DBVersion() int

func (*DBSchema) Find

func (s *DBSchema) Find(schema, name string) (DBTable, error)

func (*DBSchema) FindPath

func (s *DBSchema) FindPath(from, to string) ([]TPath, error)

func (*DBSchema) GetAliases

func (s *DBSchema) GetAliases() map[string]DBTable

func (*DBSchema) GetFunctions

func (s *DBSchema) GetFunctions() map[string]DBFunction

func (*DBSchema) GetTables

func (s *DBSchema) GetTables() []DBTable

type DBTable

type DBTable struct {
	Schema       string
	Name         string
	Type         string
	Columns      []DBColumn
	PrimaryCol   DBColumn
	SecondaryCol DBColumn
	FullText     []DBColumn
	Blocked      bool
	// contains filtered or unexported fields
}

func NewDBTable

func NewDBTable(schema, name, _type string, cols []DBColumn) DBTable

func (*DBTable) GetColumn

func (ti *DBTable) GetColumn(name string) (DBColumn, error)

func (*DBTable) String

func (ti *DBTable) String() string

type RelType

type RelType int

const (
	RelNone RelType = iota
	RelOneToOne
	RelOneToMany
	RelPolymorphic
	RelRecursive
	RelEmbedded
	RelRemote
	RelSkip
)

func (RelType) String

func (i RelType) String() string

type TEdge

type TEdge struct {
	Type RelType

	LT, RT DBTable
	L, R   DBColumn

	graph.WeightedLine
}

type TPath

type TPath struct {
	Rel RelType
	LT  DBTable
	LC  DBColumn
	RT  DBTable
	RC  DBColumn
}

type VirtualTable

type VirtualTable struct {
	Name       string
	IDColumn   string
	TypeColumn string
	FKeyColumn string
}