columns

Documentation

Index

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

Variables

var (
	TableCatalogCol           gnorm.SqlNullStringField = "table_catalog"
	TableSchemaCol            gnorm.SqlNullStringField = "table_schema"
	TableNameCol              gnorm.SqlNullStringField = "table_name"
	ColumnNameCol             gnorm.SqlNullStringField = "column_name"
	OrdinalPositionCol        gnorm.SqlNullInt64Field  = "ordinal_position"
	ColumnDefaultCol          gnorm.SqlNullStringField = "column_default"
	IsNullableCol             gnorm.SqlNullStringField = "is_nullable"
	DataTypeCol               gnorm.SqlNullStringField = "data_type"
	CharacterMaximumLengthCol gnorm.SqlNullInt64Field  = "character_maximum_length"
	CharacterOctetLengthCol   gnorm.SqlNullInt64Field  = "character_octet_length"
	NumericPrecisionCol       gnorm.SqlNullInt64Field  = "numeric_precision"
	NumericPrecisionRadixCol  gnorm.SqlNullInt64Field  = "numeric_precision_radix"
	NumericScaleCol           gnorm.SqlNullInt64Field  = "numeric_scale"
	DatetimePrecisionCol      gnorm.SqlNullInt64Field  = "datetime_precision"
	IntervalTypeCol           gnorm.SqlNullStringField = "interval_type"
	IntervalPrecisionCol      gnorm.SqlNullInt64Field  = "interval_precision"
	CharacterSetCatalogCol    gnorm.SqlNullStringField = "character_set_catalog"
	CharacterSetSchemaCol     gnorm.SqlNullStringField = "character_set_schema"
	CharacterSetNameCol       gnorm.SqlNullStringField = "character_set_name"
	CollationCatalogCol       gnorm.SqlNullStringField = "collation_catalog"
	CollationSchemaCol        gnorm.SqlNullStringField = "collation_schema"
	CollationNameCol          gnorm.SqlNullStringField = "collation_name"
	DomainCatalogCol          gnorm.SqlNullStringField = "domain_catalog"
	DomainSchemaCol           gnorm.SqlNullStringField = "domain_schema"
	DomainNameCol             gnorm.SqlNullStringField = "domain_name"
	UdtCatalogCol             gnorm.SqlNullStringField = "udt_catalog"
	UdtSchemaCol              gnorm.SqlNullStringField = "udt_schema"
	UdtNameCol                gnorm.SqlNullStringField = "udt_name"
	ScopeCatalogCol           gnorm.SqlNullStringField = "scope_catalog"
	ScopeSchemaCol            gnorm.SqlNullStringField = "scope_schema"
	ScopeNameCol              gnorm.SqlNullStringField = "scope_name"
	MaximumCardinalityCol     gnorm.SqlNullInt64Field  = "maximum_cardinality"
	DtdIdentifierCol          gnorm.SqlNullStringField = "dtd_identifier"
	IsSelfReferencingCol      gnorm.SqlNullStringField = "is_self_referencing"
	IsIdentityCol             gnorm.SqlNullStringField = "is_identity"
	IdentityGenerationCol     gnorm.SqlNullStringField = "identity_generation"
	IdentityStartCol          gnorm.SqlNullStringField = "identity_start"
	IdentityIncrementCol      gnorm.SqlNullStringField = "identity_increment"
	IdentityMaximumCol        gnorm.SqlNullStringField = "identity_maximum"
	IdentityMinimumCol        gnorm.SqlNullStringField = "identity_minimum"
	IdentityCycleCol          gnorm.SqlNullStringField = "identity_cycle"
	IsGeneratedCol            gnorm.SqlNullStringField = "is_generated"
	GenerationExpressionCol   gnorm.SqlNullStringField = "generation_expression"
	IsUpdatableCol            gnorm.SqlNullStringField = "is_updatable"
)

Field values for every column in Columns.

Types

type Row

type Row struct {
	TableCatalog           sql.NullString // table_catalog
	TableSchema            sql.NullString // table_schema
	TableName              sql.NullString // table_name
	ColumnName             sql.NullString // column_name
	OrdinalPosition        sql.NullInt64  // ordinal_position
	ColumnDefault          sql.NullString // column_default
	IsNullable             sql.NullString // is_nullable
	DataType               sql.NullString // data_type
	CharacterMaximumLength sql.NullInt64  // character_maximum_length
	CharacterOctetLength   sql.NullInt64  // character_octet_length
	NumericPrecision       sql.NullInt64  // numeric_precision
	NumericPrecisionRadix  sql.NullInt64  // numeric_precision_radix
	NumericScale           sql.NullInt64  // numeric_scale
	DatetimePrecision      sql.NullInt64  // datetime_precision
	IntervalType           sql.NullString // interval_type
	IntervalPrecision      sql.NullInt64  // interval_precision
	CharacterSetCatalog    sql.NullString // character_set_catalog
	CharacterSetSchema     sql.NullString // character_set_schema
	CharacterSetName       sql.NullString // character_set_name
	CollationCatalog       sql.NullString // collation_catalog
	CollationSchema        sql.NullString // collation_schema
	CollationName          sql.NullString // collation_name
	DomainCatalog          sql.NullString // domain_catalog
	DomainSchema           sql.NullString // domain_schema
	DomainName             sql.NullString // domain_name
	UdtCatalog             sql.NullString // udt_catalog
	UdtSchema              sql.NullString // udt_schema
	UdtName                sql.NullString // udt_name
	ScopeCatalog           sql.NullString // scope_catalog
	ScopeSchema            sql.NullString // scope_schema
	ScopeName              sql.NullString // scope_name
	MaximumCardinality     sql.NullInt64  // maximum_cardinality
	DtdIdentifier          sql.NullString // dtd_identifier
	IsSelfReferencing      sql.NullString // is_self_referencing
	IsIdentity             sql.NullString // is_identity
	IdentityGeneration     sql.NullString // identity_generation
	IdentityStart          sql.NullString // identity_start
	IdentityIncrement      sql.NullString // identity_increment
	IdentityMaximum        sql.NullString // identity_maximum
	IdentityMinimum        sql.NullString // identity_minimum
	IdentityCycle          sql.NullString // identity_cycle
	IsGenerated            sql.NullString // is_generated
	GenerationExpression   sql.NullString // generation_expression
	IsUpdatable            sql.NullString // is_updatable
}

Row represents a row from 'columns'.

func Query

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

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