Class InformationSchemaTableLegacy

java.lang.Object

org.h2.engine.DbObject

org.h2.schema.SchemaObject

org.h2.table.Table

org.h2.table.MetaTable

org.h2.table.InformationSchemaTableLegacy

All Implemented Interfaces:

HasSQL

public final class InformationSchemaTableLegacy
extends MetaTable

This class is responsible to build the legacy variant of INFORMATION_SCHEMA tables.

Field Summary

Fields

Modifier and Type	Field	Description
private static final int	CATALOGS
private static final String	CHARACTER_SET_NAME
private static final int	CHECK_CONSTRAINTS
private static final int	COLLATIONS
private static final int	COLUMN_PRIVILEGES
private static final int	COLUMNS
private static final int	CONSTANTS
private static final int	CONSTRAINT_COLUMN_USAGE
private static final int	CONSTRAINTS
private static final int	CROSS_REFERENCES
private static final int	DOMAIN_CONSTRAINTS
private static final int	DOMAINS
private static final int	FUNCTION_ALIASES
private static final int	FUNCTION_COLUMNS
private static final int	HELP
private static final int	IN_DOUBT
private static final int	INDEXES
private static final int	KEY_COLUMN_USAGE
private static final int	LOCKS
static final int	META_TABLE_TYPE_COUNT	The number of meta table types.
private static final int	QUERY_STATISTICS
private static final int	REFERENTIAL_CONSTRAINTS
private static final int	RIGHTS
private static final int	ROLES
private static final int	SCHEMATA
private static final int	SEQUENCES
private static final int	SESSION_STATE
private static final int	SESSIONS
private static final int	SETTINGS
private static final int	SYNONYMS
private static final int	TABLE_CONSTRAINTS
private static final int	TABLE_PRIVILEGES
private static final int	TABLE_TYPES
private static final int	TABLES
private static final int	TRIGGERS
private static final int	TYPE_INFO
private static final int	USERS
private static final int	VIEWS

Fields inherited from class MetaTable

indexColumn, metaIndex, ROW_COUNT_APPROXIMATION, type

Fields inherited from class Table

columns, compareMode, EXCLUSIVE_LOCK, isHidden, READ_LOCK, TYPE_CACHED, TYPE_MEMORY, WRITE_LOCK

Fields inherited from class DbObject

AGGREGATE, comment, COMMENT, CONSTANT, CONSTRAINT, database, DOMAIN, FUNCTION_ALIAS, INDEX, RIGHT, ROLE, SCHEMA, SEQUENCE, SETTING, SYNONYM, TABLE_OR_VIEW, trace, TRIGGER, USER

Fields inherited from interface HasSQL

ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS

Constructor Summary

Constructors

Constructor	Description
InformationSchemaTableLegacy(Schema schema, int id, int type)	Create a new metadata table.

Method Summary

Modifier and Type	Method	Description
private void	addConstraintColumnUsage(SessionLocal session, ArrayList<Row> rows, String catalog, Constraint constraint, Column column)
private void	addPrivilege(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, String right)
private void	addPrivileges(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, int rightMask)
ArrayList<Row>	generateRows(SessionLocal session, SearchRow first, SearchRow last)	Generate the data for the given metadata table using the given first and last row filters.
private ArrayList<SchemaObject>	getAllSchemaObjects(int type)
private ArrayList<Table>	getAllTables(SessionLocal session)	Get all tables of this database, including local temporary tables for the session.
long	getMaxDataModificationId()	Get the last data modification id.
private static short	getRefAction(ConstraintActionType action)
private ArrayList<Table>	getTablesByName(SessionLocal session, String tableName)
private static String	replaceNullWithEmpty(String s)

Methods inherited from class MetaTable

add, addIndex, addRow, canDrop, canGetRowCount, canReference, checkIndex, checkRename, checkSupportAlter, close, column, column, getCreateSQL, getIndexes, getRowCount, getRowCountApproximation, getScanIndex, getTableType, hideTable, identifier, isDeterministic, isInsertable, removeChildrenAndResources, removeRow, setMetaTableName, truncate

Methods inherited from class Table

addConstraint, addDependencies, addDependentView, addSequence, addSynonym, addTrigger, canTruncate, checkDeadlock, checkWritingAllowed, compareValues, convertInsertRow, convertUpdateRow, createRow, doesColumnExist, dropMultipleColumnsConstraintsAndIndexes, findColumn, findPrimaryKey, fire, fireAfterRow, fireBeforeRow, fireRow, getBestPlanItem, getCheckForeignKeyConstraints, getChildren, getColumn, getColumn, getColumn, getColumns, getCompareMode, getConstraints, getCreateSQLForCopy, getDependentViews, getDiskSpaceUsed, getIdentityColumn, getIndex, getIndexForColumn, getMainIndexColumn, getNullRow, getOnCommitDrop, getOnCommitTruncate, getPrimaryKey, getRow, getRowFactory, getRowIdColumn, getScanIndex, getSQLTableType, getTemplateRow, getTemplateSimpleRow, getTriggers, getType, hasSelectTrigger, isGlobalTemporary, isHidden, isLockedExclusively, isLockedExclusivelyBy, isPersistData, isPersistIndexes, isQueryComparable, isRowLockable, isTableExpression, isView, lock, lockRow, removeColumnExpressionsDependencies, removeConstraint, removeDependentView, removeIndex, removeIndexOrTransferOwnership, removeSequence, removeSynonym, removeTrigger, rename, renameColumn, setCheckForeignKeyConstraints, setColumns, setHidden, setOnCommitDrop, setOnCommitTruncate, setTableExpression, unlock, updateRow, updateRows

Methods inherited from class SchemaObject

getSchema, getSQL, getSQL

Methods inherited from class DbObject

getComment, getCreateSQLForMeta, getDatabase, getDropSQL, getId, getModificationId, getName, invalidate, isTemporary, isValid, setComment, setModified, setObjectName, setTemporary, toString

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface HasSQL

getTraceSQL

Field Details

CHARACTER_SET_NAME

private static final String CHARACTER_SET_NAME

See Also:

• Constant Field Values

TABLES

private static final int TABLES

See Also:

• Constant Field Values

COLUMNS

private static final int COLUMNS

See Also:

• Constant Field Values

INDEXES

private static final int INDEXES

See Also:

• Constant Field Values

TABLE_TYPES

private static final int TABLE_TYPES

See Also:

• Constant Field Values

TYPE_INFO

private static final int TYPE_INFO

See Also:

• Constant Field Values

CATALOGS

private static final int CATALOGS

See Also:

• Constant Field Values

SETTINGS

private static final int SETTINGS

See Also:

• Constant Field Values

HELP

private static final int HELP

See Also:

• Constant Field Values

SEQUENCES

private static final int SEQUENCES

See Also:

• Constant Field Values

USERS

private static final int USERS

See Also:

• Constant Field Values

ROLES

private static final int ROLES

See Also:

• Constant Field Values

RIGHTS

private static final int RIGHTS

See Also:

• Constant Field Values

FUNCTION_ALIASES

private static final int FUNCTION_ALIASES

See Also:

• Constant Field Values

SCHEMATA

private static final int SCHEMATA

See Also:

• Constant Field Values

TABLE_PRIVILEGES

private static final int TABLE_PRIVILEGES

See Also:

• Constant Field Values

COLUMN_PRIVILEGES

private static final int COLUMN_PRIVILEGES

See Also:

• Constant Field Values

COLLATIONS

private static final int COLLATIONS

See Also:

• Constant Field Values

VIEWS

private static final int VIEWS

See Also:

• Constant Field Values

IN_DOUBT

private static final int IN_DOUBT

See Also:

• Constant Field Values

CROSS_REFERENCES

private static final int CROSS_REFERENCES

See Also:

• Constant Field Values

FUNCTION_COLUMNS

private static final int FUNCTION_COLUMNS

See Also:

• Constant Field Values

CONSTRAINTS

private static final int CONSTRAINTS

See Also:

• Constant Field Values

CONSTANTS

private static final int CONSTANTS

See Also:

• Constant Field Values

DOMAINS

private static final int DOMAINS

See Also:

• Constant Field Values

TRIGGERS

private static final int TRIGGERS

See Also:

• Constant Field Values

SESSIONS

private static final int SESSIONS

See Also:

• Constant Field Values

LOCKS

private static final int LOCKS

See Also:

• Constant Field Values

SESSION_STATE

private static final int SESSION_STATE

See Also:

• Constant Field Values

QUERY_STATISTICS

private static final int QUERY_STATISTICS

See Also:

• Constant Field Values

SYNONYMS

private static final int SYNONYMS

See Also:

• Constant Field Values

TABLE_CONSTRAINTS

private static final int TABLE_CONSTRAINTS

See Also:

• Constant Field Values

DOMAIN_CONSTRAINTS

private static final int DOMAIN_CONSTRAINTS

See Also:

• Constant Field Values

KEY_COLUMN_USAGE

private static final int KEY_COLUMN_USAGE

See Also:

• Constant Field Values

REFERENTIAL_CONSTRAINTS

private static final int REFERENTIAL_CONSTRAINTS

See Also:

• Constant Field Values

CHECK_CONSTRAINTS

private static final int CHECK_CONSTRAINTS

See Also:

• Constant Field Values

CONSTRAINT_COLUMN_USAGE

private static final int CONSTRAINT_COLUMN_USAGE

See Also:

• Constant Field Values

META_TABLE_TYPE_COUNT

public static final int META_TABLE_TYPE_COUNT

The number of meta table types. Supported meta table types are 0..META_TABLE_TYPE_COUNT - 1.

See Also:

• Constant Field Values

Constructor Details

InformationSchemaTableLegacy

public InformationSchemaTableLegacy(Schema schema,
 int id,
 int type)

Create a new metadata table.

Parameters:

schema - the schema

id - the object id

type - the meta table type

Method Details

replaceNullWithEmpty

private static String replaceNullWithEmpty(String s)

generateRows

public ArrayList<Row> generateRows(SessionLocal session,
 SearchRow first,
 SearchRow last)

Description copied from class: MetaTable

Generate the data for the given metadata table using the given first and last row filters.

Specified by:

generateRows in class MetaTable

Parameters:

session - the session

first - the first row to return

last - the last row to return

Returns:

the generated rows

getRefAction

private static short getRefAction(ConstraintActionType action)

addConstraintColumnUsage

private void addConstraintColumnUsage(SessionLocal session,
 ArrayList<Row> rows,
 String catalog,
 Constraint constraint,
 Column column)

addPrivileges

private void addPrivileges(SessionLocal session,
 ArrayList<Row> rows,
 DbObject grantee,
 String catalog,
 Table table,
 String column,
 int rightMask)

addPrivilege

private void addPrivilege(SessionLocal session,
 ArrayList<Row> rows,
 DbObject grantee,
 String catalog,
 Table table,
 String column,
 String right)

getAllSchemaObjects

private ArrayList<SchemaObject> getAllSchemaObjects(int type)

getAllTables

private ArrayList<Table> getAllTables(SessionLocal session)

Get all tables of this database, including local temporary tables for the session.

Parameters:

session - the session

Returns:

the array of tables

getTablesByName

private ArrayList<Table> getTablesByName(SessionLocal session,
 String tableName)

getMaxDataModificationId

public long getMaxDataModificationId()

Description copied from class: Table

Get the last data modification id.

Specified by:

getMaxDataModificationId in class Table

Returns:

the modification id