tablescanner

package
v0.0.0-...-be1cf1d Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Aug 13, 2021 License: Apache-2.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
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)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL