statistics

Documentation

Index

• Variables
• type Row
  • func Query(db gnorm.DB, where gnorm.WhereClause) ([]*Row, error)

Variables

var (
	TableCatalogCol gnorm.StringField        = "TABLE_CATALOG"
	TableSchemaCol  gnorm.StringField        = "TABLE_SCHEMA"
	TableNameCol    gnorm.StringField        = "TABLE_NAME"
	NonUniqueCol    gnorm.Int64Field         = "NON_UNIQUE"
	IndexSchemaCol  gnorm.StringField        = "INDEX_SCHEMA"
	IndexNameCol    gnorm.StringField        = "INDEX_NAME"
	SeqInIndexCol   gnorm.Int64Field         = "SEQ_IN_INDEX"
	ColumnNameCol   gnorm.StringField        = "COLUMN_NAME"
	CollationCol    gnorm.SqlNullStringField = "COLLATION"
	CardinalityCol  gnorm.SqlNullInt64Field  = "CARDINALITY"
	SubPartCol      gnorm.SqlNullInt64Field  = "SUB_PART"
	PackedCol       gnorm.SqlNullStringField = "PACKED"
	NullableCol     gnorm.StringField        = "NULLABLE"
	IndexTypeCol    gnorm.StringField        = "INDEX_TYPE"
	CommentCol      gnorm.SqlNullStringField = "COMMENT"
	IndexCommentCol gnorm.StringField        = "INDEX_COMMENT"
)

Field values for every column in Statistics.

Types

type Row

type Row struct {
	TableCatalog string         // TABLE_CATALOG
	TableSchema  string         // TABLE_SCHEMA
	TableName    string         // TABLE_NAME
	NonUnique    int64          // NON_UNIQUE
	IndexSchema  string         // INDEX_SCHEMA
	IndexName    string         // INDEX_NAME
	SeqInIndex   int64          // SEQ_IN_INDEX
	ColumnName   string         // COLUMN_NAME
	Collation    sql.NullString // COLLATION
	Cardinality  sql.NullInt64  // CARDINALITY
	SubPart      sql.NullInt64  // SUB_PART
	Packed       sql.NullString // PACKED
	Nullable     string         // NULLABLE
	IndexType    string         // INDEX_TYPE
	Comment      sql.NullString // COMMENT
	IndexComment string         // INDEX_COMMENT
}

Row represents a row from 'STATISTICS'.

func Query

func Query(db gnorm.DB, where gnorm.WhereClause) ([]*Row, error)

Query retrieves rows from 'STATISTICS' as a slice of Row.