Examples of org.tmatesoft.sqljet.core.internal.table.ISqlJetBtreeSchemaTable

Package org.tmatesoft.sqljet.core.internal.table

Examples of org.tmatesoft.sqljet.core.internal.table.ISqlJetBtreeSchemaTable

org.tmatesoft.sqljet.core.internal.table.ISqlJetBtreeSchemaTable
@author TMate Software Ltd. @author Sergey Scherbina (sergey.scherbina@gmail.com)

            throw new SqlJetException(SqlJetErrorCode.MISUSE, "View name must be not empty");


        if (!viewDefs.containsKey(viewName))
            throw new SqlJetException(SqlJetErrorCode.MISUSE, "View not found: " + viewName);
        final SqlJetViewDef viewDef = (SqlJetViewDef) viewDefs.get(viewName);
        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {


            schemaTable.lock();


            try {


                db.getOptions().changeSchemaVersion();


                if (!schemaTable.goToRow(viewDef.getRowId()) || !VIEW_TYPE.equals(schemaTable.getTypeField()))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                final String n = schemaTable.getNameField();
                if (null == n || !viewName.equals(n))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                schemaTable.delete();


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }
        viewDefs.remove(viewName);


    }

View Full Code Here

            throw new SqlJetException(SqlJetErrorCode.MISUSE, "Trigger name must be not empty");


        if (!triggerDefs.containsKey(triggerName))
            throw new SqlJetException(SqlJetErrorCode.MISUSE, "Trigger not found: " + triggerName);
        final SqlJetTriggerDef triggerDef = (SqlJetTriggerDef) triggerDefs.get(triggerName);
        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {


            schemaTable.lock();


            try {


                db.getOptions().changeSchemaVersion();


                if (!schemaTable.goToRow(triggerDef.getRowId()) || !TRIGGER_TYPE.equals(schemaTable.getTypeField()))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                final String n = schemaTable.getNameField();
                if (null == n || !triggerName.equals(n))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                schemaTable.delete();


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }
        triggerDefs.remove(triggerName);


    }

View Full Code Here

                return triggerDefs.get(triggerName);
            }
            throw new SqlJetException(SqlJetErrorCode.ERROR, "Trigger \"" + triggerName + "\" already exists");
        }
        checkNameConflict(SqlJetSchemaObjectType.TRIGGER, triggerName);
        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {
            schemaTable.lock();
            try {
                db.getOptions().changeSchemaVersion();


                long rowId = schemaTable.insertRecord(TRIGGER_TYPE, triggerName, tableName, 0, sql);
                triggerDef.setRowId(rowId);
                triggerDefs.put(triggerName, triggerDef);
                return triggerDef;


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }
    }

View Full Code Here

    }


    private void init() throws SqlJetException {
        if (db.getOptions().getSchemaVersion() == 0)
            return;
        final ISqlJetBtreeSchemaTable table = openSchemaTable(false);
        try {
            table.lock();
            try {
                readShema(table);
            } finally {
                table.unlock();
            }
        } finally {
            table.close();
        }
    }

View Full Code Here

        if (null == columns || 0 == columns.size())
            throw new SqlJetException(SqlJetErrorCode.ERROR);


        final String createTableSql = getCreateTableSql(parseTable);


        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {


            schemaTable.lock();


            try {


                db.getOptions().changeSchemaVersion();


                final int page = btree.createTable(BTREE_CREATE_TABLE_FLAGS);
                final long rowId = schemaTable.insertRecord(TABLE_TYPE, tableName, tableName, page, createTableSql);


                addConstraints(schemaTable, tableDef);


                tableDef.setPage(page);
                tableDef.setRowId(rowId);
                tableDefs.put(tableName, tableDef);
                return tableDef;


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }


    }

View Full Code Here

            if (null == tableDef.getColumn(columnName))
                throw new SqlJetException(SqlJetErrorCode.ERROR, "Column \"" + columnName + "\" not found in table \""
                        + tableName + "\"");
        }


        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);
        final String createIndexSQL = indexDef.isUnique() ? getCreateIndexUniqueSql(parseIndex)
                : getCreateIndexSql(parseIndex);


        try {


            schemaTable.lock();


            try {


                db.getOptions().changeSchemaVersion();


                final int page = btree.createTable(BTREE_CREATE_INDEX_FLAGS);


                final long rowId = schemaTable.insertRecord(INDEX_TYPE, indexName, tableName, page, createIndexSQL);


                indexDef.setPage(page);
                indexDef.setRowId(rowId);
                indexDef.bindColumns(tableDef);
                indexDefs.put(indexName, indexDef);


                final SqlJetBtreeIndexTable indexTable = new SqlJetBtreeIndexTable(btree, indexDef.getName(), true);
                try {
                    indexTable.reindex(this);
                } finally {
                    indexTable.close();
                }
                return indexDef;


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }
    }

View Full Code Here

            throw new SqlJetException(SqlJetErrorCode.MISUSE, "Table not found: " + tableName);
        final SqlJetTableDef tableDef = (SqlJetTableDef) tableDefs.get(tableName);


        dropTableIndexes(tableDef);


        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {


            schemaTable.lock();


            try {


                db.getOptions().changeSchemaVersion();


                if (!schemaTable.goToRow(tableDef.getRowId()) || !TABLE_TYPE.equals(schemaTable.getTypeField()))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                final String n = schemaTable.getNameField();
                if (null == n || !tableName.equals(n))
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                schemaTable.delete();


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }


        final int page = tableDef.getPage();
        final int moved = btree.dropTable(page);
        if (moved != 0) {

View Full Code Here

            if (throwIfFial)
                throw new SqlJetException(SqlJetErrorCode.MISUSE, String.format(CANT_DELETE_IMPLICIT_INDEX, indexName));
            return false;
        }


        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);


        try {


            schemaTable.lock();


            try {


                if (!schemaTable.goToRow(indexDef.getRowId()) || !INDEX_TYPE.equals(schemaTable.getTypeField())) {
                    if (throwIfFial)
                        throw new SqlJetException(SqlJetErrorCode.INTERNAL);
                    return false;
                }
                final String n = schemaTable.getNameField();
                if (null == n || !indexName.equals(n)) {
                    if (throwIfFial)
                        throw new SqlJetException(SqlJetErrorCode.INTERNAL);
                    return false;
                }


                if (!allowAutoIndex && schemaTable.isNull(ISqlJetBtreeSchemaTable.SQL_FIELD)) {
                    if (throwIfFial)
                        throw new SqlJetException(SqlJetErrorCode.MISUSE, String.format(CANT_DELETE_IMPLICIT_INDEX,
                                indexName));
                    return false;
                }


                schemaTable.delete();


            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }


        final int page = indexDef.getPage();
        final int moved = btree.dropTable(page);
        if (moved != 0) {

View Full Code Here

     * @param page
     * @param moved
     * @throws SqlJetException
     */
    private void movePage(final int page, final int moved) throws SqlJetException {
        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);
        try {
            schemaTable.lock();
            try {
                for (schemaTable.first(); !schemaTable.eof(); schemaTable.next()) {
                    final long pageField = schemaTable.getPageField();
                    if (pageField == moved) {
                        final String nameField = schemaTable.getNameField();
                        schemaTable.updateRecord(schemaTable.getRowId(), schemaTable.getTypeField(), nameField,
                                schemaTable.getTableField(), page, schemaTable.getSqlField());
                        final ISqlJetIndexDef index = getIndex(nameField);
                        if (index != null) {
                            if (index instanceof SqlJetBaseIndexDef) {
                                ((SqlJetBaseIndexDef) index).setPage(page);
                            }
                        } else {
                            final ISqlJetTableDef table = getTable(nameField);
                            if (table != null) {
                                if (table instanceof SqlJetTableDef) {
                                    ((SqlJetTableDef) table).setPage(page);
                                }
                            }
                        }
                        return;
                    }
                }
            } finally {
                schemaTable.unlock();
            }


        } finally {
            schemaTable.close();
        }
    }

View Full Code Here

        final long rowId = tableDef.getRowId();


        final SqlJetTableDef alterDef = new SqlJetTableDef(newTableName, null, tableDef.isTemporary(), false, columns,
                tableDef.getConstraints(), page, rowId);


        final ISqlJetBtreeSchemaTable schemaTable = openSchemaTable(true);
        try {
            schemaTable.lock();
            try {


                if (!schemaTable.goToRow(rowId)) {
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                }


                final String typeField = schemaTable.getTypeField();
                final String nameField = schemaTable.getNameField();
                final String tableField = schemaTable.getTableField();
                final int pageField = schemaTable.getPageField();


                if (null == typeField || !TABLE_TYPE.equals(typeField)) {
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                }
                if (null == nameField || !tableName.equals(nameField)) {
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                }
                if (null == tableField || !tableName.equals(tableField)) {
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                }
                if (0 == pageField || pageField != page) {
                    throw new SqlJetException(SqlJetErrorCode.CORRUPT);
                }


                final String alteredSql = getTableAlteredSql(schemaTable.getSqlField(), alterTableDef);


                db.getOptions().changeSchemaVersion();


                schemaTable.insertRecord(TABLE_TYPE, newTableName, newTableName, page, alteredSql);


                if (renameTable && !tableName.equals(newTableName)) {
                    renameTablesIndices(schemaTable, tableName, newTableName, getAlterTableName(alterTableDef));
                }


                tableDefs.remove(tableName);
                tableDefs.put(newTableName, alterDef);


                return alterDef;


            } finally {
                schemaTable.unlock();
            }
        } finally {
            schemaTable.close();
        }


    }

View Full Code Here

0 1

TOP

Related Classes of org.tmatesoft.sqljet.core.internal.table.ISqlJetBtreeSchemaTable

org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema

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.