information_schema

package
v0.18.1 Latest Latest
Warning

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

 Go to latest Published: Apr 9, 2024 License: Apache-2.0 Imports: 19 Imported by: 18

Documentation

Index

Constants

View Source 
const (
	// AdministrableRoleAuthorizationsTableName is the name of the ADMINISTRABLE_ROLE_AUTHORIZATIONS table.
	AdministrableRoleAuthorizationsTableName = "administrable_role_authorizations"
	// ApplicableRolesTableName is the name of the APPLICABLE_ROLES table.
	ApplicableRolesTableName = "applicable_roles"
	// CharacterSetsTableName is the name of the CHARACTER_SETS table
	CharacterSetsTableName = "character_sets"
	// CheckConstraintsTableName is the name of CHECK_CONSTRAINTS table
	CheckConstraintsTableName = "check_constraints"
	// CollationCharSetApplicabilityTableName is the name of COLLATION_CHARACTER_SET_APPLICABILITY table.
	CollationCharSetApplicabilityTableName = "collation_character_set_applicability"
	// CollationsTableName is the name of the COLLATIONS table.
	CollationsTableName = "collations"
	// ColumnPrivilegesTableName is the name of the COLUMN_PRIVILEGES table.
	ColumnPrivilegesTableName = "column_privileges"
	// ColumnStatisticsTableName is the name of the COLUMN_STATISTICS table.
	ColumnStatisticsTableName = "column_statistics"
	// ColumnsTableName is the name of the COLUMNS table.
	ColumnsTableName = "columns"
	// ColumnsExtensionsTableName is the name of the COLUMN_EXTENSIONS table.
	ColumnsExtensionsTableName = "columns_extensions"
	// EnabledRolesTablesName is the name of the ENABLED_ROLES table.
	EnabledRolesTablesName = "enabled_roles"
	// EnginesTableName is the name of the ENGINES table
	EnginesTableName = "engines"
	// EventsTableName is the name of the EVENTS table.
	EventsTableName = "events"
	// FilesTableName is the name of the FILES table.
	FilesTableName = "files"
	// KeyColumnUsageTableName is the name of the KEY_COLUMN_USAGE table.
	KeyColumnUsageTableName = "key_column_usage"
	// KeywordsTableName is the name of the KEYWORDS table.
	KeywordsTableName = "keywords"
	// OptimizerTraceTableName is the name of the OPTIMIZER_TRACE table.
	OptimizerTraceTableName = "optimizer_trace"
	// ParametersTableName is the name of the PARAMETERS table.
	ParametersTableName = "parameters"
	// PartitionsTableName is the name of the PARTITIONS table
	PartitionsTableName = "partitions"
	// PluginsTableName is the name of the PLUGINS table.
	PluginsTableName = "plugins"
	// ProcessListTableName is the name of the PROCESSLIST table
	ProcessListTableName = "processlist"
	// ProfilingTableName is the name of the PROFILING table.
	ProfilingTableName = "profiling"
	// ReferentialConstraintsTableName is the name of the TABLE_CONSTRAINTS table.
	ReferentialConstraintsTableName = "referential_constraints"
	// ResourceGroupsTableName is the name of the RESOURCE_GROUPS table.
	ResourceGroupsTableName = "resource_groups"
	// RoleColumnGrantsTableName is the name of the ROLE_COLUMNS_GRANTS table.
	RoleColumnGrantsTableName = "role_column_grants"
	// RoleRoutineGrantsTableName is the name of the ROLE_ROUTINE_GRANTS table.
	RoleRoutineGrantsTableName = "role_routine_grants"
	// RoleTableGrantsTableName is the name of the ROLE_TABLE_GRANTS table.
	RoleTableGrantsTableName = "role_table_grants"
	// RoutinesTableName is the name of the ROUTINES table.
	RoutinesTableName = "routines"
	// SchemaPrivilegesTableName is the name of the SCHEMA_PRIVILEGES table.
	SchemaPrivilegesTableName = "schema_privileges"
	// SchemataTableName is the name of the SCHEMATA table.
	SchemataTableName = "schemata"
	// SchemataExtensionsTableName is the name of the SCHEMATA_EXTENSIONS table.
	SchemataExtensionsTableName = "schemata_extensions"
	// StGeometryColumnsTableName is the name of the ST_GEOMETRY_COLUMNS table.
	StGeometryColumnsTableName = "st_geometry_columns"
	// StSpatialReferenceSystemsTableName is the name of the ST_SPATIAL_REFERENCE_SYSTEMS table.
	StSpatialReferenceSystemsTableName = "st_spatial_reference_systems"
	// StUnitsOfMeasureTableName is the name of the ST_UNITS_OF_MEASURE
	StUnitsOfMeasureTableName = "st_units_of_measure"
	// StatisticsTableName is the name of the STATISTICS table.
	StatisticsTableName = "statistics"
	// TableConstraintsTableName is the name of the TABLE_CONSTRAINTS table.
	TableConstraintsTableName = "table_constraints"
	// TableConstraintsExtensionsTableName is the name of the TABLE_CONSTRAINTS_EXTENSIONS table.
	TableConstraintsExtensionsTableName = "table_constraints_extensions"
	// TablePrivilegesTableName is the name of the TABLE_PRIVILEGES table.
	TablePrivilegesTableName = "table_privileges"
	// TablesTableName is the name of the TABLES table.
	TablesTableName = "tables"
	// TablesExtensionsTableName is the name of TABLE_EXTENSIONS table.
	TablesExtensionsTableName = "tables_extensions"
	// TablespacesTableName is the names of the TABLESPACES table.
	TablespacesTableName = "tablespaces"
	// TablespacesExtensionsTableName is the name of the TABLESPACES_EXTENSIONS table.
	TablespacesExtensionsTableName = "tablespaces_extensions"
	// TriggersTableName is the name of the TRIGGERS table.
	TriggersTableName = "triggers"
	// UserAttributesTableName is the name of the USER_ATTRIBUTES table.
	UserAttributesTableName = "user_attributes"
	// UserPrivilegesTableName is the name of the USER_PRIVILEGES table
	UserPrivilegesTableName = "user_privileges"
	// ViewRoutineUsageTableName is the name of VIEW_ROUTINE_USAGE table.
	ViewRoutineUsageTableName = "view_routine_usage"
	// ViewTableUsageTableName is the name of the VIEW_TABLE_USAGE table.
	ViewTableUsageTableName = "view_table_usage"
	// ViewsTableName is the name of the VIEWS table.
	ViewsTableName = "views"
)
View Source 
const (
	// InnoDBBufferPageName is the name of the INNODB_BUFFER_PAGE Table
	InnoDBBufferPageName = "innodb_buffer_page"
	// InnoDBBufferPageLRUName is the name of the INNODB_BUFFER_PAGE_LRU Table
	InnoDBBufferPageLRUName = "innodb_buffer_page_lru"
	// InnoDBBufferPoolStatsName is the name of the INNODB_BUFFER_POOL_STATS Table
	InnoDBBufferPoolStatsName = "innodb_buffer_pool_stats"
	// InnoDBCachedIndexesName is the name of the INNODB_CACHED_INDEXES Table
	InnoDBCachedIndexesName = "innodb_cached_indexes"
	// InnoDBCmpName is the name of the INNODB_CMP and INNODB_CMP_RESET Tables
	InnoDBCmpName      = "innodb_cmp"
	InnoDBCmpResetName = "innodb_cmp_reset"
	// InnoDBCmpmemName is the name of the INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
	InnoDBCmpmemName      = "innodb_cmpmem"
	InnoDBCmpmemResetName = "innodb_cmpmem_reset"
	// InnoDBCmpPerIndexName is the name of the INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Table
	InnoDBCmpPerIndexName      = "innodb_cmp_per_index"
	InnoDBCmpPerIndexResetName = "innodb_cmp_per_index_reset"
	// InnoDBColumnsName is the name of the INNODB_COLUMNS Table
	InnoDBColumnsName = "innodb_columns"
	// InnoDBDatafilesName is the name of the INNODB_DATAFILES Table
	InnoDBDatafilesName = "innodb_datafiles"
	// InnoDBFieldsName is the name of the INNODB_FIELDS Table
	InnoDBFieldsName = "innodb_fields"
	// InnoDBForeignName is the name of the INNODB_FOREIGN Table
	InnoDBForeignName = "innodb_foreign"
	// InnoDBForeignColsName is the name of the INNODB_FOREIGN_COLS Table
	InnoDBForeignColsName = "innodb_foreign_cols"
	// InnoDBFtBeingDeletedName is the name of the INNODB_FT_BEING_DELETED Table
	InnoDBFtBeingDeletedName = "innodb_ft_being_deleted"
	// InnoDBFtConfigName is the name of the INNODB_FT_CONFIG Table
	InnoDBFtConfigName = "innodb_ft_config"
	// InnoDBFtDefaultStopwordName is the name of the INNODB_FT_DEFAULT_STOPWORD Table
	InnoDBFtDefaultStopwordName = "innodb_ft_default_stopword"
	// InnoDBFtDeletedName is the name of the INNODB_FT_DELETED Table
	InnoDBFtDeletedName = "innodb_ft_deleted"
	// InnoDBFtIndexCacheName is the name of the INNODB_FT_INDEX_CACHE Table
	InnoDBFtIndexCacheName = "innodb_ft_index_cache"
	// InnoDBFtIndexTableName is the name of the INNODB_FT_INDEX_TABLE Table
	InnoDBFtIndexTableName = "innodb_ft_index_table"
	// InnoDBIndexesName is the name of the INNODB_INDEXES Table
	InnoDBIndexesName = "innodb_indexes"
	// InnoDBMetricsName is the name of the INNODB_METRICS Table
	InnoDBMetricsName = "innodb_metrics"
	// InnoDBSessionTempTablespacesName is the name of the INNODB_SESSION_TEMP_TABLESPACES Table
	InnoDBSessionTempTablespacesName = "innodb_session_temp_tablespaces"
	// InnoDBTablesName is the name of the INNODB_TABLES Table
	InnoDBTablesName = "innodb_tables"
	// InnoDBTablespacesName is the name of the INNODB_TABLESPACES Table
	InnoDBTablespacesName = "innodb_tablespaces"
	// InnoDBTablespacesBriefName is the name of the INNODB_TABLESPACES_BRIEF Table
	InnoDBTablespacesBriefName = "innodb_tablespaces_brief"
	// InnoDBTablestatsName is the name of the INNODB_TABLESTATS View
	InnoDBTablestatsName = "innodb_tablestats"
	// InnoDBTempTableInfoName is the name of the INNODB_TEMP_TABLE_INFO table
	InnoDBTempTableInfoName = "innodb_temp_table_info"
	// InnoDBTrxName is the name of the INNODB_TRX Table
	InnoDBTrxName = "innodb_trx"
	// InnoDBVirtualName is the name of the INNODB_VIRTUAL Table
	InnoDBVirtualName = "innodb_virtual"
)

Variables

This section is empty.

Functions

func NewDefaultStats added in v0.15.0 

func NewDefaultStats() *defaultStatsTable

func NewInformationSchemaDatabase 

func NewInformationSchemaDatabase() Database

NewInformationSchemaDatabase creates a new INFORMATION_SCHEMA Database.

Types

type ColumnsTable added in v0.12.0 

type ColumnsTable struct {
	// contains filtered or unexported fields
}

ColumnsTable describes the information_schema.columns table. It implements both sql.Node and sql.Table as way to handle resolving column defaults.

func (*ColumnsTable) AllColumns added in v0.14.0 

func (c *ColumnsTable) AllColumns(ctx *sql.Context) (sql.Schema, error)

AllColumns returns all columns in the catalog, renamed to reflect their database and table names

func (*ColumnsTable) AssignCatalog added in v0.14.0 

func (c *ColumnsTable) AssignCatalog(cat sql.Catalog) sql.Table

func (*ColumnsTable) Collation added in v0.14.0 

func (c *ColumnsTable) Collation() sql.CollationID

Collation implements the sql.Table interface.

func (*ColumnsTable) DataLength added in v0.18.0 

func (c *ColumnsTable) DataLength(_ *sql.Context) (uint64, error)

func (*ColumnsTable) Database added in v0.18.0 

func (c *ColumnsTable) Database() string

Database implements the sql.Databaseable interface.

func (*ColumnsTable) HasDynamicColumns added in v0.17.0 

func (c *ColumnsTable) HasDynamicColumns() bool

func (*ColumnsTable) Name added in v0.12.0 

func (c *ColumnsTable) Name() string

Name implements the sql.Table interface.

func (*ColumnsTable) PartitionRows added in v0.12.0 

func (c *ColumnsTable) PartitionRows(context *sql.Context, partition sql.Partition) (sql.RowIter, error)

PartitionRows implements the sql.Table interface.

func (*ColumnsTable) Partitions added in v0.12.0 

func (c *ColumnsTable) Partitions(context *sql.Context) (sql.PartitionIter, error)

Partitions implements the sql.Table interface.

func (*ColumnsTable) RowCount added in v0.18.0 

func (c *ColumnsTable) RowCount(ctx *sql.Context) (uint64, bool, error)

func (*ColumnsTable) Schema added in v0.12.0 

func (c *ColumnsTable) Schema() sql.Schema

Schema implements the sql.Table interface.

func (*ColumnsTable) String added in v0.12.0 

func (c *ColumnsTable) String() string

String implements the sql.Table interface.

func (ColumnsTable) WithColumnDefaults added in v0.14.0 

func (c ColumnsTable) WithColumnDefaults(columnDefaults []sql.Expression) (sql.Table, error)

func (ColumnsTable) WithDefaultsSchema added in v0.17.0 

func (c ColumnsTable) WithDefaultsSchema(sch sql.Schema) (sql.Table, error)

type Keyword added in v0.15.0 

type Keyword struct {
	Word     string
	Reserved int32
}

type UnitOfMeasure added in v0.15.0 

type UnitOfMeasure struct {
	Name             string
	Type             string
	ConversionFactor float64
	Description      string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.