本文整理汇总了Java中org.hsqldb.Table.getEmptyRowData方法的典型用法代码示例。如果您正苦于以下问题:Java Table.getEmptyRowData方法的具体用法?Java Table.getEmptyRowData怎么用?Java Table.getEmptyRowData使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.hsqldb.Table
的用法示例。
在下文中一共展示了Table.getEmptyRowData方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: SYSTEM_CONNECTION_PROPERTIES
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* getClientInfoProperties
*
* @return Result
*
* <li><b>NAME</b> String=> The name of the client info property<br>
* <li><b>MAX_LEN</b> int=> The maximum length of the value for the property<br>
* <li><b>DEFAULT_VALUE</b> String=> The default value of the property<br>
* <li><b>DESCRIPTION</b> String=> A description of the property. This will typically
* contain information as to where this property is
* stored in the database.
*/
final Table SYSTEM_CONNECTION_PROPERTIES(Session session,
PersistentStore store) {
Table t = sysTables[SYSTEM_CONNECTION_PROPERTIES];
if (t == null) {
t = createBlankTable(
sysTableHsqlNames[SYSTEM_CONNECTION_PROPERTIES]);
addColumn(t, "NAME", SQL_IDENTIFIER);
addColumn(t, "MAX_LEN", Type.SQL_INTEGER);
addColumn(t, "DEFAULT_VALUE", SQL_IDENTIFIER); // not null
addColumn(t, "DESCRIPTION", SQL_IDENTIFIER); // not null
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[SYSTEM_CONNECTION_PROPERTIES].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row;
// column number mappings
final int iname = 0;
final int imax_len = 1;
final int idefault_value = 2;
final int idescription = 3;
Iterator it = HsqlDatabaseProperties.getPropertiesMetaIterator();
while (it.hasNext()) {
Object[] meta = (Object[]) it.next();
int propType =
((Integer) meta[HsqlProperties.indexType]).intValue();
if (propType == HsqlDatabaseProperties.FILE_PROPERTY) {
if (HsqlDatabaseProperties.hsqldb_readonly.equals(
meta[HsqlProperties.indexName]) || HsqlDatabaseProperties
.hsqldb_files_readonly.equals(
meta[HsqlProperties.indexName])) {}
else {
continue;
}
} else if (propType != HsqlDatabaseProperties.SQL_PROPERTY) {
continue;
}
row = t.getEmptyRowData();
Object def = meta[HsqlProperties.indexDefaultValue];
row[iname] = meta[HsqlProperties.indexName];
row[imax_len] = ValuePool.getInt(8);
row[idefault_value] = def == null ? null
: def.toString();
row[idescription] = "see HyperSQL guide";
t.insertSys(session, store, row);
}
return t;
}
示例2: addProcRows
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Inserts a set of procedure description rows into the <code>Table</code>
* object specified by the <code>t</code> argument. <p>
*
* @param t the table into which the specified rows will eventually
* be inserted
* @param l the list of procedure name aliases to which the specified column
* values apply
* @param cat the procedure catalog name
* @param schem the procedure schema name
* @param pName the base (non-alias) procedure name
* @param ip the procedure input parameter count
* @param op the procedure output parameter count
* @param rs the procedure result column count
* @param remark a human-readable remark regarding the procedure
* @param pType the procedure type code, indicating whether it is a
* function, procedure, or uncatagorized (i.e. returns
* a value, does not return a value, or it is unknown
* if it returns a value)
* @param specificName the specific name of the procedure
* (typically but not limited to a
* fully qualified Java Method name and signature)
* @param origin origin of the procedure, e.g.
* (["BUILTIN" | "USER DEFINED"] "ROUTINE" | "TRIGGER") | "ALIAS", etc.
*
*/
protected void addProcRows(Session session, Table t, HsqlArrayList l,
String cat, String schem, String pName,
Integer ip, Integer op, Integer rs,
String remark, Integer pType,
String specificName, String origin) {
PersistentStore store = t.getRowStore(session);
// column number mappings
final int icat = 0;
final int ischem = 1;
final int ipname = 2;
final int iinput_parms = 3;
final int ioutput_parms = 4;
final int iresult_sets = 5;
final int iremark = 6;
final int iptype = 7;
final int isn = 8;
final int iporigin = 9;
Object[] row = t.getEmptyRowData();
row[icat] = cat;
row[ischem] = schem;
row[ipname] = pName;
row[iinput_parms] = ip;
row[ioutput_parms] = op;
row[iresult_sets] = rs;
row[iremark] = remark;
row[iptype] = pType;
row[iporigin] = origin;
row[isn] = specificName;
t.insertSys(session, store, row);
if (l != null) {
int size = l.size();
for (int i = 0; i < size; i++) {
row = t.getEmptyRowData();
pName = (String) l.get(i);
row[icat] = cat;
row[ischem] = schem;
row[ipname] = pName;
row[iinput_parms] = ip;
row[ioutput_parms] = op;
row[iresult_sets] = rs;
row[iremark] = remark;
row[iptype] = pType;
row[iporigin] = "ALIAS";
row[isn] = specificName;
t.insertSys(session, store, row);
}
}
}
示例3: TRIGGER_SEQUENCE_USAGE
import org.hsqldb.Table; //导入方法依赖的package包/类
Table TRIGGER_SEQUENCE_USAGE() {
Table t = sysTables[TRIGGER_SEQUENCE_USAGE];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[TRIGGER_SEQUENCE_USAGE]);
addColumn(t, "TRIGGER_CATALOG", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_NAME", SQL_IDENTIFIER); // not null
addColumn(t, "SEQUENCE_CATALOG", SQL_IDENTIFIER);
addColumn(t, "SEQUENCE_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "SEQUENCE_NAME", SQL_IDENTIFIER); // not null
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[TRIGGER_SEQUENCE_USAGE].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2, 3, 4, 5
}, false);
return t;
}
PersistentStore store = database.persistentStoreCollection.getStore(t);
// column number mappings
final int trigger_catalog = 0;
final int trigger_schema = 1;
final int trigger_name = 2;
final int sequence_catalog = 3;
final int sequence_schema = 4;
final int sequence_name = 5;
Iterator it;
Object[] row;
it = database.schemaManager.databaseObjectIterator(
SchemaObject.TRIGGER);
while (it.hasNext()) {
TriggerDef trigger = (TriggerDef) it.next();
if (!session.getGrantee().isAccessible(trigger)) {
continue;
}
OrderedHashSet set = trigger.getReferences();
for (int i = 0; i < set.size(); i++) {
HsqlName refName = (HsqlName) set.get(i);
if (refName.type != SchemaObject.SEQUENCE) {
continue;
}
if (!session.getGrantee().isAccessible(refName)) {
continue;
}
row = t.getEmptyRowData();
row[trigger_catalog] = database.getCatalogName().name;
row[trigger_schema] = trigger.getSchemaName().name;
row[trigger_name] = trigger.getName().name;
row[sequence_catalog] = database.getCatalogName().name;
row[sequence_schema] = refName.schema.name;
row[sequence_name] = refName.name;
try {
t.insertSys(store, row);
} catch (HsqlException e) {}
}
}
// Initialization
return t;
}
示例4: DOMAIN_CONSTRAINTS
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
*
* @return Table
*/
Table DOMAIN_CONSTRAINTS() {
Table t = sysTables[DOMAIN_CONSTRAINTS];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[DOMAIN_CONSTRAINTS]);
addColumn(t, "CONSTRAINT_CATALOG", SQL_IDENTIFIER);
addColumn(t, "CONSTRAINT_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "CONSTRAINT_NAME", SQL_IDENTIFIER); // not null
addColumn(t, "DOMAIN_CATALOG", SQL_IDENTIFIER);
addColumn(t, "DOMAIN_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "DOMAIN_NAME", SQL_IDENTIFIER);
addColumn(t, "IS_DEFERRABLE", YES_OR_NO);
addColumn(t, "INITIALLY_DEFERRED", YES_OR_NO);
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[DOMAIN_CONSTRAINTS].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2, 4, 5, 6
}, false);
return t;
}
final int constraint_catalog = 0;
final int constraint_schema = 1;
final int constraint_name = 2;
final int domain_catalog = 3;
final int domain_schema = 4;
final int domain_name = 5;
final int is_deferrable = 6;
final int initially_deferred = 7;
//
PersistentStore store = database.persistentStoreCollection.getStore(t);
//
Iterator it =
database.schemaManager.databaseObjectIterator(SchemaObject.DOMAIN);
while (it.hasNext()) {
Type domain = (Type) it.next();
if (!domain.isDomainType()) {
continue;
}
if (!session.getGrantee().isFullyAccessibleByRole(domain)) {
continue;
}
Constraint[] constraints =
domain.userTypeModifier.getConstraints();
for (int i = 0; i < constraints.length; i++) {
Object[] data = t.getEmptyRowData();
data[constraint_catalog] = data[domain_catalog] =
database.getCatalogName().name;
data[constraint_schema] = data[domain_schema] =
domain.getSchemaName().name;
data[constraint_name] = constraints[i].getName().name;
data[domain_name] = domain.getName().name;
data[is_deferrable] = Tokens.T_NO;
data[initially_deferred] = Tokens.T_NO;
t.insertSys(store, data);
}
}
return t;
}
示例5: addProcRows
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Inserts a set of procedure description rows into the <code>Table</code>
* object specified by the <code>t</code> argument. <p>
*
* @param t the table into which the specified rows will eventually
* be inserted
* @param l the list of procedure name aliases to which the specified column
* values apply
* @param cat the procedure catalog name
* @param schem the procedure schema name
* @param pName the base (non-alias) procedure name
* @param ip the procedure input parameter count
* @param op the procedure output parameter count
* @param rs the procedure result column count
* @param remark a human-readable remark regarding the procedure
* @param pType the procedure type code, indicating whether it is a
* function, procedure, or uncatagorized (i.e. returns
* a value, does not return a value, or it is unknown
* if it returns a value)
* @param specificName the specific name of the procedure
* (typically but not limited to a
* fully qualified Java Method name and signature)
* @param origin origin of the procedure, e.g.
* (["BUILTIN" | "USER DEFINED"] "ROUTINE" | "TRIGGER") | "ALIAS", etc.
*
*/
protected void addProcRows(Table t, HsqlArrayList l, String cat,
String schem, String pName, Integer ip,
Integer op, Integer rs, String remark,
Integer pType, String specificName,
String origin) {
PersistentStore store = database.persistentStoreCollection.getStore(t);
// column number mappings
final int icat = 0;
final int ischem = 1;
final int ipname = 2;
final int iinput_parms = 3;
final int ioutput_parms = 4;
final int iresult_sets = 5;
final int iremark = 6;
final int iptype = 7;
final int isn = 8;
final int iporigin = 9;
Object[] row = t.getEmptyRowData();
row[icat] = cat;
row[ischem] = schem;
row[ipname] = pName;
row[iinput_parms] = ip;
row[ioutput_parms] = op;
row[iresult_sets] = rs;
row[iremark] = remark;
row[iptype] = pType;
row[iporigin] = origin;
row[isn] = specificName;
t.insertSys(store, row);
if (l != null) {
int size = l.size();
for (int i = 0; i < size; i++) {
row = t.getEmptyRowData();
pName = (String) l.get(i);
row[icat] = cat;
row[ischem] = schem;
row[ipname] = pName;
row[iinput_parms] = ip;
row[ioutput_parms] = op;
row[iresult_sets] = rs;
row[iremark] = remark;
row[iptype] = pType;
row[iporigin] = "ALIAS";
row[isn] = specificName;
t.insertSys(store, row);
}
}
}
示例6: ROUTINE_SEQUENCE_USAGE
import org.hsqldb.Table; //导入方法依赖的package包/类
Table ROUTINE_SEQUENCE_USAGE() {
Table t = sysTables[ROUTINE_SEQUENCE_USAGE];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[ROUTINE_SEQUENCE_USAGE]);
addColumn(t, "SPECIFIC_CATALOG", SQL_IDENTIFIER);
addColumn(t, "SPECIFIC_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "SPECIFIC_NAME", SQL_IDENTIFIER);
addColumn(t, "SEQUENCE_CATALOG", SQL_IDENTIFIER);
addColumn(t, "SEQUENCE_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "SEQUENCE_NAME", SQL_IDENTIFIER);
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[ROUTINE_SEQUENCE_USAGE].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2, 3, 4, 5
}, false);
return t;
}
// column number mappings
final int specific_catalog = 0;
final int specific_schema = 1;
final int specific_name = 2;
final int sequence_catalog = 3;
final int sequence_schema = 4;
final int sequence_name = 5;
//
PersistentStore store = database.persistentStoreCollection.getStore(t);
Iterator it;
Object[] row;
it = database.schemaManager.databaseObjectIterator(
SchemaObject.ROUTINE);
while (it.hasNext()) {
RoutineSchema routine = (RoutineSchema) it.next();
if (!session.getGrantee().isAccessible(routine)) {
continue;
}
Routine[] specifics = routine.getSpecificRoutines();
for (int m = 0; m < specifics.length; m++) {
OrderedHashSet set = specifics[m].getReferences();
for (int i = 0; i < set.size(); i++) {
HsqlName refName = (HsqlName) set.get(i);
if (refName.type != SchemaObject.SEQUENCE) {
continue;
}
if (!session.getGrantee().isAccessible(refName)) {
continue;
}
row = t.getEmptyRowData();
row[specific_catalog] = database.getCatalogName().name;
row[specific_schema] = specifics[m].getSchemaName().name;
row[specific_name] = specifics[m].getName().name;
row[sequence_catalog] = database.getCatalogName().name;
row[sequence_schema] = refName.schema.name;
row[sequence_name] = refName.name;
try {
t.insertSys(store, row);
} catch (HsqlException e) {}
}
}
}
return t;
}
示例7: SYSTEM_CONNECTION_PROPERTIES
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* getClientInfoProperties
*
* @return Result
*
* <li><b>NAME</b> String=> The name of the client info property<br>
* <li><b>MAX_LEN</b> int=> The maximum length of the value for the property<br>
* <li><b>DEFAULT_VALUE</b> String=> The default value of the property<br>
* <li><b>DESCRIPTION</b> String=> A description of the property. This will typically
* contain information as to where this property is
* stored in the database.
*/
final Table SYSTEM_CONNECTION_PROPERTIES(Session session,
PersistentStore store) {
Table t = sysTables[SYSTEM_CONNECTION_PROPERTIES];
if (t == null) {
t = createBlankTable(
sysTableHsqlNames[SYSTEM_CONNECTION_PROPERTIES]);
addColumn(t, "NAME", SQL_IDENTIFIER);
addColumn(t, "MAX_LEN", Type.SQL_INTEGER);
addColumn(t, "DEFAULT_VALUE", SQL_IDENTIFIER); // not null
addColumn(t, "DESCRIPTION", SQL_IDENTIFIER); // not null
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[SYSTEM_PRIMARYKEYS].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row;
// column number mappings
final int iname = 0;
final int imax_len = 1;
final int idefault_value = 2;
final int idescription = 3;
Iterator it = HsqlDatabaseProperties.getPropertiesMetaIterator();
while (it.hasNext()) {
Object[] meta = (Object[]) it.next();
int propType =
((Integer) meta[HsqlProperties.indexType]).intValue();
if (propType == HsqlDatabaseProperties.FILE_PROPERTY) {
if (HsqlDatabaseProperties.hsqldb_readonly.equals(
meta[HsqlProperties.indexName]) || HsqlDatabaseProperties
.hsqldb_files_readonly.equals(
meta[HsqlProperties.indexName])) {}
else {
continue;
}
} else if (propType != HsqlDatabaseProperties.SQL_PROPERTY) {
continue;
}
row = t.getEmptyRowData();
Object def = meta[HsqlProperties.indexDefaultValue];
row[iname] = meta[HsqlProperties.indexName];
row[imax_len] = ValuePool.getInt(8);
row[idefault_value] = def == null ? null
: def.toString();
row[idescription] = "see HyperSQL guide";
t.insertSys(session, store, row);
}
return t;
}
示例8: TRIGGERED_UPDATE_COLUMNS
import org.hsqldb.Table; //导入方法依赖的package包/类
Table TRIGGERED_UPDATE_COLUMNS() {
Table t = sysTables[TRIGGERED_UPDATE_COLUMNS];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[TRIGGERED_UPDATE_COLUMNS]);
addColumn(t, "TRIGGER_CATALOG", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_NAME", SQL_IDENTIFIER); // not null
addColumn(t, "EVENT_OBJECT_CATALOG", SQL_IDENTIFIER); // not null
addColumn(t, "EVENT_OBJECT_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "EVENT_OBJECT_TABLE", SQL_IDENTIFIER);
addColumn(t, "EVENT_OBJECT_COLUMN", SQL_IDENTIFIER); // not null
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[TRIGGERED_UPDATE_COLUMNS].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2, 3, 4, 5, 6
}, false);
return t;
}
PersistentStore store = database.persistentStoreCollection.getStore(t);
// column number mappings
final int trigger_catalog = 0;
final int trigger_schema = 1;
final int trigger_name = 2;
final int event_object_catalog = 3;
final int event_object_schema = 4;
final int event_object_table = 5;
final int event_object_column = 6;
Iterator it;
Object[] row;
it = database.schemaManager.databaseObjectIterator(
SchemaObject.TRIGGER);
while (it.hasNext()) {
TriggerDef trigger = (TriggerDef) it.next();
if (!session.getGrantee().isAccessible(trigger)) {
continue;
}
int[] colIndexes = trigger.getUpdateColumnIndexes();
if (colIndexes == null) {
continue;
}
for (int i = 0; i < colIndexes.length; i++) {
ColumnSchema column =
trigger.getTable().getColumn(colIndexes[i]);
row = t.getEmptyRowData();
row[trigger_catalog] = database.getCatalogName().name;
row[trigger_schema] = trigger.getSchemaName().name;
row[trigger_name] = trigger.getName().name;
row[event_object_catalog] = database.getCatalogName().name;
row[event_object_schema] =
trigger.getTable().getSchemaName().name;
row[event_object_table] = trigger.getTable().getName().name;
row[event_object_column] = column.getNameString();
t.insertSys(store, row);
}
}
// Initialization
return t;
}
示例9: TRIGGER_ROUTINE_USAGE
import org.hsqldb.Table; //导入方法依赖的package包/类
Table TRIGGER_ROUTINE_USAGE() {
Table t = sysTables[TRIGGER_ROUTINE_USAGE];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[TRIGGER_ROUTINE_USAGE]);
addColumn(t, "TRIGGER_CATALOG", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "TRIGGER_NAME", SQL_IDENTIFIER); // not null
addColumn(t, "SPECIFIC_CATALOG", SQL_IDENTIFIER);
addColumn(t, "SPECIFIC_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "SPECIFIC_NAME", SQL_IDENTIFIER); // not null
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[TRIGGER_ROUTINE_USAGE].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2, 3, 4, 5
}, false);
return t;
}
PersistentStore store = database.persistentStoreCollection.getStore(t);
// column number mappings
final int trigger_catalog = 0;
final int trigger_schema = 1;
final int trigger_name = 2;
final int specific_catalog = 3;
final int specific_schema = 4;
final int specific_name = 5;
Iterator it;
Object[] row;
it = database.schemaManager.databaseObjectIterator(
SchemaObject.TRIGGER);
while (it.hasNext()) {
TriggerDef trigger = (TriggerDef) it.next();
if (!session.getGrantee().isAccessible(trigger)) {
continue;
}
OrderedHashSet set = trigger.getReferences();
for (int i = 0; i < set.size(); i++) {
HsqlName refName = (HsqlName) set.get(i);
if (refName.type != SchemaObject.FUNCTION
&& refName.type != SchemaObject.PROCEDURE) {
continue;
}
if (!session.getGrantee().isAccessible(refName)) {
continue;
}
row = t.getEmptyRowData();
row[trigger_catalog] = database.getCatalogName().name;
row[trigger_schema] = trigger.getSchemaName().name;
row[trigger_name] = trigger.getName().name;
row[specific_catalog] = database.getCatalogName().name;
row[specific_schema] = refName.schema.name;
row[specific_name] = refName.name;
try {
t.insertSys(store, row);
} catch (HsqlException e) {}
}
}
return t;
}
示例10: CHARACTER_SETS
import org.hsqldb.Table; //导入方法依赖的package包/类
Table CHARACTER_SETS(Session session, PersistentStore store) {
Table t = sysTables[CHARACTER_SETS];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[CHARACTER_SETS]);
addColumn(t, "CHARACTER_SET_CATALOG", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_SET_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_SET_NAME", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_REPERTOIRE", SQL_IDENTIFIER);
addColumn(t, "FORM_OF_USE", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_CATALOG", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_NAME", SQL_IDENTIFIER);
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[CHARACTER_SETS].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[] {
0, 1, 2
}, false);
return t;
}
final int character_set_catalog = 0;
final int character_set_schema = 1;
final int character_set_name = 2;
final int character_repertoire = 3;
final int form_of_use = 4;
final int default_collate_catalog = 5;
final int default_collate_schema = 6;
final int default_collate_name = 7;
//
Iterator it = database.schemaManager.databaseObjectIterator(
SchemaObject.CHARSET);
while (it.hasNext()) {
Charset charset = (Charset) it.next();
if (!session.getGrantee().isAccessible(charset)) {
continue;
}
Object[] data = t.getEmptyRowData();
data[character_set_catalog] = database.getCatalogName().name;
data[character_set_schema] = charset.getSchemaName().name;
data[character_set_name] = charset.getName().name;
data[character_repertoire] = "UCS";
data[form_of_use] = "UTF16";
data[default_collate_catalog] = data[character_set_catalog];
if (charset.base == null) {
data[default_collate_schema] = data[character_set_schema];
data[default_collate_name] = data[character_set_name];
} else {
data[default_collate_schema] = charset.base.schema.name;
data[default_collate_name] = charset.base.name;
}
t.insertSys(session, store, data);
}
return t;
}
示例11: SYSTEM_SCHEMAS
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Retrieves a <code>Table</code> object describing the accessible schemas
* defined within this database. <p>
*
* Each row is a schema description with the following
* columns: <p>
*
* <pre class="SqlCodeExample">
* TABLE_SCHEM VARCHAR simple schema name
* TABLE_CATALOG VARCHAR catalog in which schema is defined
* IS_DEFAULT BOOLEAN is the schema the default for new sessions
* </pre> <p>
*
* @return table containing information about schemas defined
* within this database
*/
final Table SYSTEM_SCHEMAS(Session session, PersistentStore store) {
Table t = sysTables[SYSTEM_SCHEMAS];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[SYSTEM_SCHEMAS]);
addColumn(t, "TABLE_SCHEM", SQL_IDENTIFIER); // not null
addColumn(t, "TABLE_CATALOG", SQL_IDENTIFIER);
addColumn(t, "IS_DEFAULT", Type.SQL_BOOLEAN);
// order: TABLE_SCHEM
// true PK, as rows never have null TABLE_SCHEM
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[SYSTEM_SCHEMAS].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row;
// Initialization
String[] schemas = database.schemaManager.getSchemaNamesArray();
String defschema =
database.schemaManager.getDefaultSchemaHsqlName().name;
// Do it.
for (int i = 0; i < schemas.length; i++) {
row = t.getEmptyRowData();
String schema = schemas[i];
row[0] = schema;
row[1] = database.getCatalogName().name;
row[2] = schema.equals(defschema) ? Boolean.TRUE
: Boolean.FALSE;
t.insertSys(session, store, row);
}
return t;
}
示例12: CHARACTER_SETS
import org.hsqldb.Table; //导入方法依赖的package包/类
Table CHARACTER_SETS() {
Table t = sysTables[CHARACTER_SETS];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[CHARACTER_SETS]);
addColumn(t, "CHARACTER_SET_CATALOG", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_SET_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_SET_NAME", SQL_IDENTIFIER);
addColumn(t, "CHARACTER_REPERTOIRE", SQL_IDENTIFIER);
addColumn(t, "FORM_OF_USE", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_CATALOG", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_SCHEMA", SQL_IDENTIFIER);
addColumn(t, "DEFAULT_COLLATE_NAME", SQL_IDENTIFIER);
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[CHARACTER_SETS].name, false,
SchemaObject.INDEX);
t.createPrimaryKey(name, new int[] {
0, 1, 2
}, false);
return t;
}
final int character_set_catalog = 0;
final int character_set_schema = 1;
final int character_set_name = 2;
final int character_repertoire = 3;
final int form_of_use = 4;
final int default_collate_catalog = 5;
final int default_collate_schema = 6;
final int default_collate_name = 7;
//
PersistentStore store = database.persistentStoreCollection.getStore(t);
Iterator it = database.schemaManager.databaseObjectIterator(
SchemaObject.CHARSET);
while (it.hasNext()) {
Charset charset = (Charset) it.next();
if (!session.getGrantee().isAccessible(charset)) {
continue;
}
Object[] data = t.getEmptyRowData();
data[character_set_catalog] = database.getCatalogName().name;
data[character_set_schema] = charset.getSchemaName().name;
data[character_set_name] = charset.getName().name;
data[character_repertoire] = "UCS";
data[form_of_use] = "UTF16";
data[default_collate_catalog] = data[character_set_catalog];
if (charset.base == null) {
data[default_collate_schema] = data[character_set_schema];
data[default_collate_name] = data[character_set_name];
} else {
data[default_collate_schema] = charset.base.schema.name;
data[default_collate_name] = charset.base.name;
}
t.insertSys(store, data);
}
return t;
}
示例13: SYSTEM_TABLETYPES
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Retrieves a <code>Table</code> object describing the table types
* available in this database. <p>
*
* In general, the range of values that may be commonly encountered across
* most DBMS implementations is: <p>
*
* <UL>
* <LI><FONT color='#FF00FF'>"TABLE"</FONT>
* <LI><FONT color='#FF00FF'>"VIEW"</FONT>
* <LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
* <LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
* <LI><FONT color='#FF00FF'>"LOCAL TEMPORARY"</FONT>
* <LI><FONT color='#FF00FF'>"ALIAS"</FONT>
* <LI><FONT color='#FF00FF'>"SYNONYM"</FONT>
* </UL> <p>
*
* As of HSQLDB 1.7.2, the engine supports and thus this method reports
* only a subset of the range above: <p>
*
* <UL>
* <LI><FONT color='#FF00FF'>"TABLE"</FONT>
* (HSQLDB MEMORY, CACHED and TEXT tables)
* <LI><FONT color='#FF00FF'>"VIEW"</FONT> (Views)
* <LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
* (The tables generated by this object)
* <LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
* (HSQLDB TEMP and TEMP TEXT tables)
* </UL> <p>
*
* @return a <code>Table</code> object describing the table types
* available in this database
*/
Table SYSTEM_TABLETYPES(Session session, PersistentStore store) {
Table t = sysTables[SYSTEM_TABLETYPES];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[SYSTEM_TABLETYPES]);
addColumn(t, "TABLE_TYPE", SQL_IDENTIFIER); // not null
// order: TABLE_TYPE
// true PK
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[SYSTEM_TABLETYPES].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row;
for (int i = 0; i < tableTypes.length; i++) {
row = t.getEmptyRowData();
row[0] = tableTypes[i];
t.insertSys(session, store, row);
}
return t;
}
示例14: INFORMATION_SCHEMA_CATALOG_NAME
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Retrieves a <code>Table</code> object naming the accessible catalogs
* defined within this database. <p>
*
* Each row is a catalog name description with the following column: <p>
*
* <pre class="SqlCodeExample">
* TABLE_CAT VARCHAR catalog name
* </pre> <p>
*
* @return a <code>Table</code> object naming the accessible
* catalogs defined within this database
*/
final Table INFORMATION_SCHEMA_CATALOG_NAME(Session session,
PersistentStore store) {
Table t = sysTables[INFORMATION_SCHEMA_CATALOG_NAME];
if (t == null) {
t = createBlankTable(
sysTableHsqlNames[INFORMATION_SCHEMA_CATALOG_NAME]);
addColumn(t, "CATALOG_NAME", SQL_IDENTIFIER); // not null
// order: TABLE_CAT
// true PK
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[INFORMATION_SCHEMA_CATALOG_NAME].name,
false, SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row = t.getEmptyRowData();
row[0] = database.getCatalogName().name;
t.insertSys(session, store, row);
return t;
}
示例15: SYSTEM_TABLETYPES
import org.hsqldb.Table; //导入方法依赖的package包/类
/**
* Retrieves a <code>Table</code> object describing the table types
* available in this database. <p>
*
* In general, the range of values that may be commonly encounted across
* most DBMS implementations is: <p>
*
* <UL>
* <LI><FONT color='#FF00FF'>"TABLE"</FONT>
* <LI><FONT color='#FF00FF'>"VIEW"</FONT>
* <LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
* <LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
* <LI><FONT color='#FF00FF'>"LOCAL TEMPORARY"</FONT>
* <LI><FONT color='#FF00FF'>"ALIAS"</FONT>
* <LI><FONT color='#FF00FF'>"SYNONYM"</FONT>
* </UL> <p>
*
* As of HSQLDB 1.7.2, the engine supports and thus this method reports
* only a subset of the range above: <p>
*
* <UL>
* <LI><FONT color='#FF00FF'>"TABLE"</FONT>
* (HSQLDB MEMORY, CACHED and TEXT tables)
* <LI><FONT color='#FF00FF'>"VIEW"</FONT> (Views)
* <LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
* (The tables generated by this object)
* <LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
* (HSQLDB TEMP and TEMP TEXT tables)
* </UL> <p>
*
* @return a <code>Table</code> object describing the table types
* available in this database
*/
Table SYSTEM_TABLETYPES(Session session, PersistentStore store) {
Table t = sysTables[SYSTEM_TABLETYPES];
if (t == null) {
t = createBlankTable(sysTableHsqlNames[SYSTEM_TABLETYPES]);
addColumn(t, "TABLE_TYPE", SQL_IDENTIFIER); // not null
// order: TABLE_TYPE
// true PK
HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
sysTableHsqlNames[SYSTEM_TABLETYPES].name, false,
SchemaObject.INDEX);
t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);
return t;
}
Object[] row;
for (int i = 0; i < tableTypes.length; i++) {
row = t.getEmptyRowData();
row[0] = tableTypes[i];
t.insertSys(session, store, row);
}
return t;
}