tables

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"
	TableTypeCol      gnorm.StringField        = "TABLE_TYPE"
	EngineCol         gnorm.SqlNullStringField = "ENGINE"
	VersionCol        gnorm.SqlNullInt64Field  = "VERSION"
	RowFormatCol      gnorm.SqlNullStringField = "ROW_FORMAT"
	TableRowsCol      gnorm.SqlNullInt64Field  = "TABLE_ROWS"
	AvgRowLengthCol   gnorm.SqlNullInt64Field  = "AVG_ROW_LENGTH"
	DataLengthCol     gnorm.SqlNullInt64Field  = "DATA_LENGTH"
	MaxDataLengthCol  gnorm.SqlNullInt64Field  = "MAX_DATA_LENGTH"
	IndexLengthCol    gnorm.SqlNullInt64Field  = "INDEX_LENGTH"
	DataFreeCol       gnorm.SqlNullInt64Field  = "DATA_FREE"
	AutoIncrementCol  gnorm.SqlNullInt64Field  = "AUTO_INCREMENT"
	CreateTimeCol     gnorm.MysqlNullTimeField = "CREATE_TIME"
	UpdateTimeCol     gnorm.MysqlNullTimeField = "UPDATE_TIME"
	CheckTimeCol      gnorm.MysqlNullTimeField = "CHECK_TIME"
	TableCollationCol gnorm.SqlNullStringField = "TABLE_COLLATION"
	ChecksumCol       gnorm.SqlNullInt64Field  = "CHECKSUM"
	CreateOptionsCol  gnorm.SqlNullStringField = "CREATE_OPTIONS"
	TableCommentCol   gnorm.StringField        = "TABLE_COMMENT"
)

Field values for every column in Tables.

Types

type Row

type Row struct {
	TableCatalog   string         // TABLE_CATALOG
	TableSchema    string         // TABLE_SCHEMA
	TableName      string         // TABLE_NAME
	TableType      string         // TABLE_TYPE
	Engine         sql.NullString // ENGINE
	Version        sql.NullInt64  // VERSION
	RowFormat      sql.NullString // ROW_FORMAT
	TableRows      sql.NullInt64  // TABLE_ROWS
	AvgRowLength   sql.NullInt64  // AVG_ROW_LENGTH
	DataLength     sql.NullInt64  // DATA_LENGTH
	MaxDataLength  sql.NullInt64  // MAX_DATA_LENGTH
	IndexLength    sql.NullInt64  // INDEX_LENGTH
	DataFree       sql.NullInt64  // DATA_FREE
	AutoIncrement  sql.NullInt64  // AUTO_INCREMENT
	CreateTime     mysql.NullTime // CREATE_TIME
	UpdateTime     mysql.NullTime // UPDATE_TIME
	CheckTime      mysql.NullTime // CHECK_TIME
	TableCollation sql.NullString // TABLE_COLLATION
	Checksum       sql.NullInt64  // CHECKSUM
	CreateOptions  sql.NullString // CREATE_OPTIONS
	TableComment   string         // TABLE_COMMENT
}

Row represents a row from 'TABLES'.

func Query

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

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