Examples of org.hsqldb_voltpatches.Table

org.hsqldb_voltpatches.Table
Holds the data structures and methods for creation of a database table. Extensively rewritten and extended in successive versions of HSQLDB. @author Thomas Mueller (Hypersonic SQL Group) @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since Hypersonic SQL

     *
     * @return Table
     */
    Table ADMINISTRABLE_ROLE_AUTHORIZATIONS() {


        Table t = sysTables[ADMINISTRABLE_ROLE_AUTHORIZATIONS];


        if (t == null) {
            t = createBlankTable(
                sysTableHsqlNames[ADMINISTRABLE_ROLE_AUTHORIZATIONS]);


            addColumn(t, "GRANTEE", SQL_IDENTIFIER);
            addColumn(t, "ROLE_NAME", SQL_IDENTIFIER);
            addColumn(t, "IS_GRANTABLE", SQL_IDENTIFIER);


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[ADMINISTRABLE_ROLE_AUTHORIZATIONS].name,
                false, SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2
            }, false);


            return t;
        }

View Full Code Here

     *    TO PUBLIC WITH GRANT OPTION;
     * </pre>
     */
    Table APPLICABLE_ROLES() {


        Table t = sysTables[APPLICABLE_ROLES];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[APPLICABLE_ROLES]);


            addColumn(t, "GRANTEE", SQL_IDENTIFIER);
            addColumn(t, "ROLE_NAME", SQL_IDENTIFIER);
            addColumn(t, "IS_GRANTABLE", SQL_IDENTIFIER);


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[APPLICABLE_ROLES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2
            }, false);


            return t;
        }

View Full Code Here

        }
    }


    Table ASSERTIONS() {


        Table t = sysTables[ASSERTIONS];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[ASSERTIONS]);


            addColumn(t, "CONSTRAINT_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_NAME", SQL_IDENTIFIER);    // not null
            addColumn(t, "IS_DEFERRABLE", YES_OR_NO);
            addColumn(t, "INITIALLY_DEFERRED", YES_OR_NO);


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[ASSERTIONS].name, false, SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2
            }, false);


            return t;
        }

View Full Code Here

     *
     * @return Table
     */
    Table AUTHORIZATIONS() {


        Table t = sysTables[AUTHORIZATIONS];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[AUTHORIZATIONS]);


            addColumn(t, "AUTHORIZATION_NAME", SQL_IDENTIFIER);    // not null
            addColumn(t, "AUTHORIZATION_TYPE", SQL_IDENTIFIER);    // not null


            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[AUTHORIZATIONS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[]{ 0 }, true);


            return t;
        }


        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // Intermediate holders
        Iterator grantees;
        Grantee  grantee;
        Object[] row;


        // initialization
        grantees = session.getGrantee().visibleGrantees().iterator();


        // Do it.
        while (grantees.hasNext()) {
            grantee = (Grantee) grantees.next();
            row     = t.getEmptyRowData();
            row[0]  = grantee.getNameString();
            row[1]  = grantee.isRole() ? "ROLE"
                                       : "USER";


            t.insertSys(store, row);
        }


        return t;
    }

View Full Code Here

        return t;
    }


    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;
    }

View Full Code Here

     *
     * @return Table
     */
    Table CHECK_CONSTRAINT_ROUTINE_USAGE() {


        Table t = sysTables[CHECK_CONSTRAINT_ROUTINE_USAGE];


        if (t == null) {
            t = createBlankTable(
                sysTableHsqlNames[CHECK_CONSTRAINT_ROUTINE_USAGE]);


            addColumn(t, "CONSTRAINT_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_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[CHECK_CONSTRAINT_ROUTINE_USAGE].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2, 3, 4, 5
            }, false);


            return t;
        }


        // column number mappings
        final int constraint_catalog = 0;
        final int constraint_schema  = 1;
        final int constraint_name    = 2;
        final int specific_catalog   = 3;
        final int specific_schema    = 4;
        final int specific_name      = 5;


        //
        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // calculated column values
        String constraintCatalog;
        String constraintSchema;
        String constraintName;
        String specificSchema;


        // Intermediate holders
        Iterator       tables;
        Table          table;
        Constraint[]   constraints;
        int            constraintCount;
        Constraint     constraint;
        OrderedHashSet collector;
        Iterator       iterator;
        OrderedHashSet methodSet;
        Method         method;
        Object[]       row;


        tables =
            database.schemaManager.databaseObjectIterator(SchemaObject.TABLE);
        collector = new OrderedHashSet();


        while (tables.hasNext()) {
            collector.clear();


            table = (Table) tables.next();


            if (table.isView()
                    || !session.getGrantee().isFullyAccessibleByRole(table)) {
                continue;
            }


            constraints       = table.getConstraints();
            constraintCount   = constraints.length;
            constraintCatalog = database.getCatalogName().name;
            constraintSchema  = table.getSchemaName().name;
            specificSchema =
                database.schemaManager.getDefaultSchemaHsqlName().name;


            for (int i = 0; i < constraintCount; i++) {
                constraint = constraints[i];

View Full Code Here

     *
     * @return Table
     */
    Table CHECK_CONSTRAINTS() {


        Table t = sysTables[CHECK_CONSTRAINTS];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[CHECK_CONSTRAINTS]);


            addColumn(t, "CONSTRAINT_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "CONSTRAINT_NAME", SQL_IDENTIFIER);    // not null
            addColumn(t, "CHECK_CLAUSE", CHARACTER_DATA);       // not null


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[CHECK_CONSTRAINTS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                2, 1, 0
            }, false);


            return t;
        }


        // column number mappings
        final int constraint_catalog = 0;
        final int constraint_schema  = 1;
        final int constraint_name    = 2;
        final int check_clause       = 3;


        //
        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // calculated column values
        // Intermediate holders
        Iterator     tables;
        Table        table;
        Constraint[] tableConstraints;
        int          constraintCount;
        Constraint   constraint;
        Object[]     row;


        //
        tables =
            database.schemaManager.databaseObjectIterator(SchemaObject.TABLE);


        while (tables.hasNext()) {
            table = (Table) tables.next();


            if (table.isView()
                    || !session.getGrantee().isFullyAccessibleByRole(table)) {
                continue;
            }


            tableConstraints = table.getConstraints();
            constraintCount  = tableConstraints.length;


            for (int i = 0; i < constraintCount; i++) {
                constraint = tableConstraints[i];


                if (constraint.getConstraintType() != Constraint.CHECK) {
                    continue;
                }


                row                     = t.getEmptyRowData();
                row[constraint_catalog] = database.getCatalogName().name;
                row[constraint_schema]  = table.getSchemaName().name;
                row[constraint_name]    = constraint.getName().name;


                try {
                    row[check_clause] = constraint.getCheckSQL();
                } catch (Exception e) {}

View Full Code Here

     *
     * @return Table
     */
    Table COLLATIONS() {


        Table t = sysTables[COLLATIONS];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[COLLATIONS]);


            addColumn(t, "COLLATION_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "COLLATION_SCHEMA", SQL_IDENTIFIER);    // not null
            addColumn(t, "COLLATION_NAME", SQL_IDENTIFIER);      // not null
            addColumn(t, "PAD_ATTRIBUTE", CHARACTER_DATA);


            // false PK, as rows may have NULL COLLATION_CATALOG
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[COLLATIONS].name, false, SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2
            }, false);


            return t;
        }


        // Column number mappings
        final int collation_catalog = 0;
        final int collation_schema  = 1;
        final int collation_name    = 2;
        final int pad_attribute     = 3;


        //
        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // Intermediate holders
        Iterator collations;
        String   collation;
        String   collationSchema = SqlInvariants.PUBLIC_SCHEMA;
        String   padAttribute    = "NO PAD";
        Object[] row;


        // Initialization
        collations = Collation.nameToJavaName.keySet().iterator();


        // Do it.
        while (collations.hasNext()) {
            row                    = t.getEmptyRowData();
            collation              = (String) collations.next();
            row[collation_catalog] = database.getCatalogName().name;
            row[collation_schema]  = collationSchema;
            row[collation_name]    = collation;
            row[pad_attribute]     = padAttribute;


            t.insertSys(store, row);
        }


        return t;
    }

View Full Code Here

     *
     * @return Table
     */
    Table COLUMN_COLUMN_USAGE() {


        Table t = sysTables[COLUMN_COLUMN_USAGE];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[COLUMN_COLUMN_USAGE]);


            addColumn(t, "TABLE_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "TABLE_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "TABLE_NAME", SQL_IDENTIFIER);
            addColumn(t, "COLUMN_NAME", SQL_IDENTIFIER);
            addColumn(t, "DEPENDENT_COLUMN", SQL_IDENTIFIER);


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[COLUMN_COLUMN_USAGE].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2, 3, 4
            }, false);


            return t;
        }

View Full Code Here

     *
     * @return Table
     */
    Table COLUMN_DOMAIN_USAGE() {


        Table t = sysTables[COLUMN_DOMAIN_USAGE];


        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[COLUMN_DOMAIN_USAGE]);


            addColumn(t, "DOMAIN_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "DOMAIN_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "DOMAIN_NAME", SQL_IDENTIFIER);
            addColumn(t, "TABLE_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "TABLE_SCHEMA", SQL_IDENTIFIER);
            addColumn(t, "TABLE_NAME", SQL_IDENTIFIER);     // not null
            addColumn(t, "COLUMN_NAME", SQL_IDENTIFIER);    // not null


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[COLUMN_DOMAIN_USAGE].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);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "SELECT DOMAIN_CATALOG, DOMAIN_SCHEMA, DOMAIN_NAME, TABLE_CATALOG, "
            + "TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS "
            + "WHERE DOMAIN_NAME IS NOT NULL;");


        t.insertSys(store, rs);
        sys.close();


        return t;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb_voltpatches.Table

org.hsqldb_voltpatches.dbinfo.DatabaseInformationFull

org.hsqldb_voltpatches.dbinfo.DatabaseInformationMain

org.hsqldb_voltpatches.HsqlNameManager.HsqlName

org.hsqldb_voltpatches.index.Index

org.hsqldb_voltpatches.index.IndexAVL

org.hsqldb_voltpatches.lib.HashMappedList

org.hsqldb_voltpatches.lib.HsqlArrayList

org.hsqldb_voltpatches.lib.OrderedHashSet

org.hsqldb_voltpatches.navigator.RowIterator

org.hsqldb_voltpatches.navigator.RowSetNavigator

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.