Versions in this module Expand all Collapse all v1 v1.0.1 Nov 14, 2019 v1.0.0 Nov 14, 2019 v0 v0.11.5 Nov 14, 2019 v0.11.4 Nov 14, 2019 v0.11.3 Nov 14, 2019 v0.11.2 Nov 14, 2019 v0.11.1 Oct 23, 2019 Changes in this version + const TimeFormat + func Escape(source string, NoBackslashEscapes bool) string + func NullFloat(buf []byte) float64 + func NullInt(buf []byte) int64 + func NullString(buf []byte) string + func TimeString(t time.Time) string type Connector + Conn *sql.DB + func NewConnector(dsn *common.Dsn) (*Connector, error) + func (db *Connector) CurrentUser() (string, string, error) + func (db *Connector) HasAllPrivilege() bool + func (db *Connector) HasSelectPrivilege() bool + func (db *Connector) IsForeignKey(dbName, tbName, column string) bool type ExplainJSONOrderingOperation + OrderbySubqueries []ExplainJSONSubqueries type ReferenceValue + ReferencedTableName string + ReferencedTableSchema string + TableName string + TableSchema string type TableIndexInfo + Rows []TableIndexRow type TableIndexRow + Expression []byte + Visible string v0.8.1 Oct 23, 2018 v0.8.0 Oct 19, 2018 Changes in this version + const ExtendedExplainType + const IndexColumnName + const IndexIndexType + const IndexKeyName + const IndexNonUnique + const JSONFormatExplain + const PartitionsExplainType + const TraditionalExplainType + const TraditionalFormatExplain + var ExplainAccessType = map[string]string + var ExplainColumnIndent = map[string]string + var ExplainExtra = map[string]string + var ExplainFormatType = map[string]int + var ExplainKeyWords = []string + var ExplainScalability = map[string]string + var ExplainSelectType = map[string]string + var ExplainType = map[string]int + func ExplainInfoTranslator(exp *ExplainInfo) string + func FormatProfiling(res *QueryResult) string + func FormatTrace(res *QueryResult) string + func MySQLExplainQueryCost(exp *ExplainInfo) string + func MySQLExplainWarnings(exp *ExplainInfo) string + func PrintMarkdownExplainTable(exp *ExplainInfo) string + func RemoveSQLComments(sql []byte) []byte + type Connector struct + Addr string + Charset string + Database string + Pass string + User string + func (db *Connector) ColumnCardinality(tb, col string) float64 + func (db *Connector) Explain(sql string, explainType int, formatType int) (exp *ExplainInfo, err error) + func (db *Connector) FindColumn(name, dbName string, tables ...string) ([]*common.Column, error) + func (db *Connector) IsFKey(dbName, tbName, column string) bool + func (db *Connector) IsView(tbName string) bool + func (db *Connector) NewConnection() mysql.Conn + func (db *Connector) Profiling(sql string, params ...interface{}) (*QueryResult, error) + func (db *Connector) Query(sql string, params ...interface{}) (*QueryResult, error) + func (db *Connector) SamplingData(remote Connector, tables ...string) error + func (db *Connector) ShowColumns(tableName string) (*TableDesc, error) + func (db *Connector) ShowCreateDatabase(dbName string) (string, error) + func (db *Connector) ShowCreateTable(tableName string) (string, error) + func (db *Connector) ShowIndex(tableName string) (*TableIndexInfo, error) + func (db *Connector) ShowReference(dbName string, tbName ...string) ([]ReferenceValue, error) + func (db *Connector) ShowTableStatus(tableName string) (*TableStatInfo, error) + func (db *Connector) ShowTables() ([]string, error) + func (db *Connector) SingleIntValue(option string) (int, error) + func (db *Connector) Source(file string) ([]*QueryResult, error) + func (db *Connector) Trace(sql string, params ...interface{}) (*QueryResult, error) + func (db *Connector) Version() (int, error) + type ExplainInfo struct + ExplainFormat int + ExplainJSON *ExplainJSON + ExplainRows []*ExplainRow + QueryCost float64 + SQL string + Warnings []*ExplainWarning + func ParseExplainResult(res *QueryResult, formatType int) (exp *ExplainInfo, err error) + func ParseExplainText(content string) (exp *ExplainInfo, err error) + type ExplainJSON struct + QueryBlock ExplainJSONQueryBlock + type ExplainJSONBufferResult struct + NestedLoop []ExplainJSONNestedLoop + UsingTemporaryTable bool + type ExplainJSONCostInfo struct + DataReadPerJoin string + EvalCost string + PrefixCost string + QueryCost string + ReadCost string + SortCost string + type ExplainJSONDuplicatesRemoval struct + BufferResult ExplainJSONBufferResult + GroupingOperation ExplainJSONGroupingOperation + UsingFilesort bool + UsingTemporaryTable bool + type ExplainJSONGroupingOperation struct + CostInfo ExplainJSONCostInfo + GroupBySubqueries []ExplainJSONSubqueries + NestedLoop []ExplainJSONNestedLoop + Table ExplainJSONTable + UsingFilesort bool + UsingTemporaryTable bool + type ExplainJSONMaterializedFromSubquery struct + Cacheable bool + Dependent bool + QueryBlock *ExplainJSONQueryBlock + UsingTemporaryTable bool + type ExplainJSONNestedLoop struct + Table ExplainJSONTable + type ExplainJSONOrderingOperation struct + DuplicatesRemoval ExplainJSONDuplicatesRemoval + GroupingOperation ExplainJSONGroupingOperation + OderbySubqueries []ExplainJSONSubqueries + Table ExplainJSONTable + UsingFilesort bool + type ExplainJSONQueryBlock struct + CostInfo ExplainJSONCostInfo + GroupingOperation ExplainJSONGroupingOperation + HavingSubqueries []ExplainJSONSubqueries + Message string + NestedLoop []ExplainJSONNestedLoop + OptimizedAwaySubqueries []ExplainJSONSubqueries + OrderingOperation ExplainJSONOrderingOperation + QuerySpecifications []ExplainJSONSubqueries + SelectID int + SelectListSubqueries []ExplainJSONSubqueries + Table ExplainJSONTable + UnionResult ExplainJSONUnionResult + UpdateValueSubqueries []ExplainJSONSubqueries + type ExplainJSONSubqueries struct + Cacheable bool + Dependent bool + QueryBlock ExplainJSONQueryBlock + type ExplainJSONTable struct + AccessType string + AttachedCondition string + AttachedSubqueries []ExplainJSONSubqueries + CostInfo ExplainJSONCostInfo + Filtered string + Key string + KeyLength string + MaterializedFromSubquery ExplainJSONMaterializedFromSubquery + PossibleKeys []string + Ref []string + RowsExaminedPerScan int + RowsProducedPerJoin int + TableName string + UsedColumns []string + UsedKeyParts []string + UsingIndex bool + UsingIndexForGroupBy bool + type ExplainJSONUnionResult struct + AccessType string + QuerySpecifications []ExplainJSONSubqueries + TableName string + UsingTemporaryTable bool + type ExplainRow struct + AccessType string + Extra string + Filtered float64 + ID int + Key string + KeyLen string + Partitions string + PossibleKeys []string + Ref []string + Rows int + Scalability string + SelectType string + TableName string + func ConvertExplainJSON2Row(explainJSON *ExplainJSON) []*ExplainRow + func FormatJSONIntoTraditional(explainJSON string) []*ExplainRow + type ExplainWarning struct + Code int + Level string + Message string + type IndexSelectKey string + type Profiling struct + Rows []ProfilingRow + type ProfilingRow struct + Duration float64 + Status string + type QueryResult struct + Error error + QueryCost float64 + Result mysql.Result + Rows []mysql.Row + Warning []mysql.Row + type Reference map[string][]ReferenceValue + type ReferenceValue struct + ConstraintName string + DBName string + RefDBName string + RefTable string + Table string + type TableDesc struct + DescValues []TableDescValue + Name string + func NewTableDesc(tableName string) *TableDesc + func (td TableDesc) Columns() []string + type TableDescValue struct + Collation string + Comment string + Default string + Extra string + Field string + Key string + Null string + Privileges string + Type string + type TableIndexInfo struct + IdxRows []TableIndexRow + TableName string + func NewTableIndexInfo(tableName string) *TableIndexInfo + func (tbIndex *TableIndexInfo) FindIndex(arg IndexSelectKey, value string) []TableIndexRow + type TableIndexRow struct + Cardinality int + Collation string + ColumnName string + Comment string + IndexComment string + IndexType string + KeyName string + NonUnique int + Null string + Packed int + SeqInIndex int + SubPart int + Table string + type TableStatInfo struct + Name string + Rows []tableStatusRow + type Trace struct + Rows []TraceRow + type TraceRow struct + InsufficientPrivileges int + MissingBytesBeyondMaxMemSize int + Query string + Trace string
Go to main page