tablescanner

Documentation

Index

• Variables
• func TransValue(value interface{}) string
• type Column
  • func GetColumns(dbName, tableName string) ([]Column, error)
• type DBInfoTool
  • func (DBInfoTool) GetDBConnt() (*sql.DB, error)
• type Database
  • func GetDatabases(defaultDatabase []string) ([]Database, error)
• type Table
  • func GetTables(dbName string) ([]Table, error)

Variables

var MysqlDefaultDatabase []string = []string{
	"information_schema",
	"mysql",
	"performance_schema",
	"sys",
}

MysqlDefaultDatabase mysql中的默认表

Functions

func TransValue

func TransValue(value interface{}) string

TransValue 将接口值的类型转换为string

Types

type Column

type Column struct {
	TableCatalog           string
	TableSchema            string
	TableName              string
	ColumnName             string
	OrdinalPosition        string
	ColumnDefault          string
	IsNullAble             string
	DataType               string
	CharacterMaximumLength string
	CharacterOrtetLength   string
	NumericPrecision       string
	NumericScale           string
	DataTimePrecision      string
	CharacterSetName       string
	CollationName          string
	ColumnType             string
	ColumnKey              string
	Extra                  string
	Privileges             string
	ColumnComment          string
	GenerationExpression   string
}

func GetColumns

func GetColumns(dbName, tableName string) ([]Column, error)

type DBInfoTool

type DBInfoTool struct {
}

var DBTool DBInfoTool

func (DBInfoTool) GetDBConnt

func (DBInfoTool) GetDBConnt() (*sql.DB, error)

GetDBConnt 建立数据库连接

type Database

type Database struct {
	Database string `bdb:"Database"`
}

database

func GetDatabases

func GetDatabases(defaultDatabase []string) ([]Database, error)

GetDatabases 得到数据库的列表

type Table

type Table struct {
	TableCatalog   string
	TableSchema    string
	TableName      string
	TableType      string
	Engine         string
	Version        string
	RowFormat      string
	TableRows      string
	AvgRowLength   string
	DataLength     string
	MaxDataLength  string
	IndexLength    string
	DataFree       string
	AutoIncrement  string
	CreateTime     string
	UpdateTime     string
	CheckTime      string
	TableCollation string
	CheckSum       string
	CreateOptions  string
	TableComment   string
}

func GetTables

func GetTables(dbName string) ([]Table, error)