DatabaseScript.java

Index Score
		org.hsqldb
		HSQL Database Engine

View: Reasons, Metrics, Source Code

These are the metrics that contribute to the Enerjy Score for this file, ranked by impact. So the metrics listed at the top influence the score to a greater extent that the metrics listed at the bottom.

Metric	Description
LOOPS	Number of loops
OPERANDS	Number of operands
PROGRAM_LENGTH	Halstead program length
EXITS	Procedure exits
OPERATORS	Number of operators
LOGICAL_LINES	Number of statements
SIZE	Size of the file in bytes
EXEC_COMMENTS	Comments in executable code
JAVA0108	JAVA0108 Incorrect javadoc: no @param tag for 'parameter'
ELOC	Effective lines of code
CYCLOMATIC	Cyclomatic complexity
UNIQUE_OPERANDS	Number of unique operands
COMPARISONS	Number of comparison operators
LINES	Number of lines in the source file
WHITESPACE	Number of whitespace lines
LOC	Lines of code
PROGRAM_VOCAB	Halstead program vocabulary
LINE_COMMENT	Number of line comments
BLOCKS	Number of blocks
JAVA0076	JAVA0076 Use of magic number
JAVA0034	JAVA0034 Missing braces in if statement
INTERFACE_COMPLEXITY	Interface complexity
JAVA0110	JAVA0110 Incorrect javadoc: no @return tag
JAVA0177	JAVA0177 Variable declaration missing initializer
PARAMS	Number of formal parameter declarations
JAVA0123	JAVA0123 Use all three components of for loop
JAVA0171	JAVA0171 Unused local variable
RETURNS	Number of return points from functions
JAVA0117	JAVA0117 Missing javadoc: method 'method'
NEST_DEPTH	Maximum nesting depth
PROGRAM_VOLUME	Halstead program volume
JAVA0136	JAVA0136 N methods defined in class (maximum: M)
JAVA0032	JAVA0032 Switch statement missing default
JAVA0126	JAVA0126 Method declares unchecked exception in throws
BLOCK_COMMENT	Number of block comment lines
COMMENTS	Comment lines
UNIQUE_OPERATORS	Number of unique operators
JAVA0173	JAVA0173 Unused method parameter
JAVA0270	JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array
JAVA0145	JAVA0145 Tab character used in source file

/* Copyright (c) 1995-2000, The Hypersonic SQL Group. * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, this * list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of the Hypersonic SQL Group nor the names of its * contributors may be used to endorse or promote products derived from this * software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE HYPERSONIC SQL GROUP, * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * * This software consists of voluntary contributions made by many individuals * on behalf of the Hypersonic SQL Group. * * * For work added by the HSQL Development Group: * * Copyright (c) 2001-2007, The HSQL Development Group * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, this * list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of the HSQL Development Group nor the names of its * contributors may be used to endorse or promote products derived from this * software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG, * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ package org.hsqldb; import org.hsqldb.HsqlNameManager.HsqlName; import org.hsqldb.index.Index; import org.hsqldb.lib.HashMap; import org.hsqldb.lib.HashMappedList; import org.hsqldb.lib.HsqlArrayList; import org.hsqldb.lib.Iterator; import org.hsqldb.lib.StringConverter; import org.hsqldb.result.Result; import org.hsqldb.rights.Grantee; import org.hsqldb.rights.GranteeManager; import org.hsqldb.rights.User; import org.hsqldb.types.DistinctType; import org.hsqldb.types.DomainType; import org.hsqldb.types.Type; /** * Script generation. * * The core functionality of this class was inherited from Hypersonic and * extensively rewritten and extended in successive versions of HSQLDB.<p> * * @author Thomas Mueller (Hypersonic SQL Group) * @author fredt@users * @version 1.8.0 * @since 1.7.0 */ public class DatabaseScript { /** * Returns the DDL and all other statements for the database excluding * INSERT and SET <tablename> READONLY statements. * cachedData == true indicates that SET <tablename> INDEX statements should * also be included. * * This class should not have any dependencies on metadata reporting. */ public static Result getScript(Database database, boolean indexRoots) { Iterator it; Result r = Result.newSingleColumnResult("COMMAND", Type.SQL_VARCHAR); r.metaData.tableNames[0] = "SYSTEM_SCRIPT"; // collation for database if (database.collation.name != null) { String name = StringConverter.toQuotedString(database.collation.name, '"', true); addRow(r, "SET DATABASE COLLATION " + name); } // aliases HashMap map = database.aliasManager.getAliasMap(); HashMap builtin = Library.getAliasMap(); it = map.keySet().iterator(); while (it.hasNext()) { String alias = (String) it.next(); String java = (String) map.get(alias); String biJava = (String) builtin.get(alias); if (biJava != null && biJava.equals(java)) { continue; } StringBuffer buffer = new StringBuffer(64); buffer.append(Token.T_CREATE).append(' ').append( Token.T_ALIAS).append(' '); buffer.append(alias); buffer.append(" FOR \""); buffer.append(java); buffer.append('"'); addRow(r, buffer.toString()); } // Role definitions it = database.getGranteeManager().getRoleNames().iterator(); String role; while (it.hasNext()) { role = (String) it.next(); // ADMIN_ROLE_NAME is not persisted if (!GranteeManager.isReserved(role)) { addRow(r, "CREATE ROLE " + role); } } // Create Users Iterator users = database.getUserManager().getUsers().values().iterator(); for (; users.hasNext(); ) { User u = (User) users.next(); String name = u.getName(); addRow(r, u.getCreateUserDDL()); } // Create schemas and schema objects such as tables, sequences, etc. addSchemaStatements(database, r, indexRoots); addCrossSchemaStatements(database, r, indexRoots); // Set User Session Start Schemas users = database.getUserManager().getUsers().values().iterator(); HsqlName initialSchema; for (; users.hasNext(); ) { User u = (User) users.next(); String name = u.getName(); initialSchema = u.getInitialSchema(); if (initialSchema != null) { addRow(r, u.getInitialSchemaDDL()); } } // rights for classes, tables and views addRightsStatements(database, r); if (database.logger.hasLog()) { int delay = database.logger.getWriteDelay(); boolean millis = delay < 1000; if (millis) { if (delay != 0 && delay < 20) { delay = 20; } } else { delay /= 1000; } String statement = "SET WRITE_DELAY " + delay + (millis ? " MILLIS" : ""); addRow(r, statement); } return r; } static void addSchemaStatements(Database database, Result r, boolean indexRoots) { Iterator schemas = database.schemaManager.userSchemaNameIterator(); while (schemas.hasNext()) { String schemaKey = (String) schemas.next(); HsqlName schema = database.schemaManager.toSchemaHsqlName(schemaKey); HashMappedList tableList = database.schemaManager.getTables(schema.name); // schema creation { String ddl = getSchemaCreateDDL(database, schema); addRow(r, ddl); ddl = getSetSchemaDDL(database, schema); addRow(r, ddl); } // types and domains Iterator it = database.schemaManager.database.schemaManager .databaseObjectIterator(schema.name, SchemaObject.TYPE); while (it.hasNext()) { SchemaObject type = (SchemaObject) it.next(); if (type.getName().type == SchemaObject.TYPE) { addRow(r, getDistinctTypeDDL((DistinctType) type)); } } it = database.schemaManager.database.schemaManager .databaseObjectIterator(schema.name, SchemaObject.DOMAIN); while (it.hasNext()) { SchemaObject type = (SchemaObject) it.next(); if (type.getName().type == SchemaObject.DOMAIN) { addRow(r, getDomainDDL((DomainType) type)); } } // sequences /* CREATE SEQUENCE <name> ... */ it = database.schemaManager.database.schemaManager .databaseObjectIterator(schema.name, SchemaObject.SEQUENCE); while (it.hasNext()) { NumberSequence seq = (NumberSequence) it.next(); addRow(r, getSequenceDDL(seq)); } // tables for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); if (t.isView()) { continue; } StringBuffer a = new StringBuffer(128); getTableDDL(t, false, a); addRow(r, a.toString()); // indexes for table for (int j = 1; j < t.getIndexCount(); j++) { Index index = t.getIndex(j); if (index.isConstraint()) { // the following are autocreated with the table // indexes for primary keys // indexes for unique constraints // own table indexes for foreign keys continue; } a = new StringBuffer(64); a.append(Token.T_CREATE).append(' '); if (index.isUnique()) { a.append(Token.T_UNIQUE).append(' '); } a.append(Token.T_INDEX).append(' '); a.append(index.getName().statementName); a.append(' ').append(Token.T_ON).append(' '); a.append(t.getName().statementName); int[] col = index.getColumns(); int len = index.getVisibleColumns(); getColumnList(t, col, len, a); addRow(r, a.toString()); } // readonly for TEXT tables only if (t.isText() && t.isConnected() && t.isDataReadOnly()) { a = new StringBuffer(64); a.append(Token.T_SET).append(' ').append( Token.T_TABLE).append(' '); a.append(t.getName().statementName); a.append(' ').append(Token.T_READONLY).append(' ').append( Token.T_TRUE); addRow(r, a.toString()); } // data source String dataSource = getDataSourceDDL(t); if (dataSource != null) { addRow(r, dataSource); } // header String header = getDataSourceHeader(t); if (!indexRoots && header != null) { addRow(r, header); } } // RESTART WITH <value> statements for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); if (!t.isTemp()) { String ddl = getIdentityUpdateDDL(t); addRow(r, ddl); } } } } static void addCrossSchemaStatements(Database database, Result r, boolean indexRoots) { Iterator schemas = database.schemaManager.userSchemaNameIterator(); while (schemas.hasNext()) { String schemaKey = (String) schemas.next(); HsqlName schema = database.schemaManager.toSchemaHsqlName(schemaKey); HashMappedList tableList = database.schemaManager.getTables(schema.name); String setSchemaStatement = getSetSchemaDDL(database, schema); addRow(r, setSchemaStatement); // forward referencing foreign keys for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); Constraint[] constraintList = t.getConstraints(); for (int j = 0, vSize = constraintList.length; j < vSize; j++) { Constraint c = constraintList[j]; if (c.isForward) { StringBuffer a = new StringBuffer(128); a.append(Token.T_ALTER).append(' ').append( Token.T_TABLE).append(' '); a.append(c.getRef().getName().statementName); a.append(' ').append(Token.T_ADD).append(' '); getFKStatement(c, a); addRow(r, a.toString()); } } } // views for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); if (t.isView()) { View v = (View) tableList.get(i); StringBuffer a = new StringBuffer(128); a.append(Token.T_CREATE).append(' ').append( Token.T_VIEW).append(' '); a.append(v.getName().statementName).append(' ').append( '('); int count = v.getColumnCount(); for (int j = 0; j < count; j++) { a.append(v.getColumn(j).columnName.statementName); if (j < count - 1) { a.append(','); } } a.append(')').append(' ').append(Token.T_AS).append(' '); a.append(v.getStatement()); addRow(r, a.toString()); } } // triggers for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); for (int tv = 0; tv < t.triggerLists.length; tv++) { HsqlArrayList trigVec = t.triggerLists[tv]; if (trigVec == null) { continue; } int trCount = trigVec.size(); for (int k = 0; k < trCount; k++) { String a = ((TriggerDef) trigVec.get(k)).getDDL(); addRow(r, a); } } } // SET <tablename> INDEX statements Session sysSession = database.sessionManager.getSysSession(); for (int i = 0, tSize = tableList.size(); i < tSize; i++) { Table t = (Table) tableList.get(i); if (indexRoots && t.isIndexCached() && !t.isEmpty(sysSession)) { addRow(r, getIndexRootsDDL((Table) tableList.get(i))); } } } } // GENERATED {ALWAYS | BY DEFAULT} AS IDENTITY // (START WITH n INCREMENT BY m MINVALUE o MAXVALUE p) static String getIdentityDDL(NumberSequence seq) { StringBuffer a = new StringBuffer(128); a.append(Token.T_GENERATED).append(' '); if (seq.isAlways()) { a.append(Token.T_ALWAYS); } else { a.append(Token.T_BY).append(' ').append(Token.T_DEFAULT); } a.append(' ').append(Token.T_AS).append(' ').append( Token.T_IDENTITY).append(Token.T_OPENBRACKET).append( Token.T_START).append(' ').append(Token.T_WITH).append(' '); a.append(seq.getStartValue()); if (seq.getIncrement() != 1) { a.append(' ').append(Token.T_INCREMENT).append(' ').append( Token.T_BY).append(' '); a.append(seq.getIncrement()); } if (!seq.hasDefaultMinMax()) { a.append(' ').append(Token.T_MINVALUE).append(' '); a.append(seq.getMinValue()); a.append(' ').append(Token.T_MAXVALUE).append(' '); a.append(seq.getMaxValue()); } if (seq.isCycle()) { a.append(' ').append(Token.T_CYCLE); } a.append(Token.T_CLOSEBRACKET); return a.toString(); } static String getDistinctTypeDDL(DistinctType type) { StringBuffer sb = new StringBuffer(Token.T_CREATE).append(' '); sb.append(Token.T_TYPE).append(' ').append(type.getDefinition()); sb.append(' ').append(Token.T_AS).append(' '); sb.append(type.getBaseType().getDefinition()); return sb.toString(); } static String getDomainDDL(DomainType type) { StringBuffer sb = new StringBuffer(Token.T_CREATE).append(' '); sb.append(Token.T_DOMAIN).append(' ').append(type.getDefinition()); sb.append(' ').append(Token.T_AS).append(' '); sb.append(type.getBaseType().getDefinition()); Expression defaultClause = type.getDefaultClause(); if (defaultClause != null) { sb.append(' ').append(Token.T_DEFAULT).append(' '); sb.append(defaultClause.getDDL()); } Constraint[] constraints = type.getConstraints(); for (int i = 0; i < constraints.length; i++) { sb.append(' ').append(Token.T_CONSTRAINT).append(' '); sb.append(constraints[i].getName().statementName).append(' '); sb.append(Token.T_CHECK).append(Token.T_OPENBRACKET).append( constraints[i].getCheckDDL()).append(Token.T_CLOSEBRACKET); } return sb.toString(); } static String getSequenceDDL(NumberSequence seq) { StringBuffer a = new StringBuffer(128); a.append(Token.T_CREATE).append(' '); a.append(Token.T_SEQUENCE).append(' '); a.append(seq.getName().statementName).append(' '); a.append(Token.T_AS).append(' '); a.append(seq.getType().getNameString()).append(' '); a.append(Token.T_START).append(' '); a.append(Token.T_WITH).append(' '); a.append(seq.peek()).append(' '); if (seq.getIncrement() != 1) { a.append(' ').append(Token.T_INCREMENT).append(' '); a.append(Token.T_BY).append(' '); a.append(seq.getIncrement()); } if (!seq.hasDefaultMinMax()) { a.append(' ').append(Token.T_MINVALUE).append(' '); a.append(seq.getMinValue()); a.append(' ').append(Token.T_MAXVALUE).append(' '); a.append(seq.getMaxValue()); } if (seq.isCycle()) { a.append(' ').append(Token.T_CYCLE); } return a.toString(); } static String getIdentityUpdateDDL(Table t) { if (t.identityColumn == -1) { return ""; } else { String tablename = t.getName().statementName; String colname = t.getColumn(t.identityColumn).columnName.statementName; NumberSequence seq = t.identitySequence; StringBuffer a = new StringBuffer(128); a.append(Token.T_ALTER).append(' ').append(Token.T_TABLE).append( ' ').append(tablename).append(' ').append( Token.T_ALTER).append(' ').append(Token.T_COLUMN).append( ' ').append(colname).append(' ').append( Token.T_RESTART).append(' ').append(Token.T_WITH).append( ' ').append(seq.peek()); return a.toString(); } } static String getIndexRootsDDL(Table t) { StringBuffer a = new StringBuffer(128); a.append(Token.T_SET).append(' ').append(Token.T_TABLE).append(' '); a.append(t.getName().statementName); a.append(' ').append(Token.T_INDEX).append('\''); a.append(t.getIndexRoots()); a.append('\''); return a.toString(); } static String getSetSchemaDDL(Database database, HsqlName schemaName) { StringBuffer ab = new StringBuffer(128); ab.append(Token.T_SET).append(' '); ab.append(Token.T_SCHEMA).append(' '); ab.append(schemaName.statementName); return ab.toString(); } static String getSchemaCreateDDL(Database database, HsqlName schemaName) { StringBuffer ab = new StringBuffer(128); ab.append(Token.T_CREATE).append(' '); ab.append(Token.T_SCHEMA).append(' '); ab.append(schemaName.statementName).append(' '); ab.append(Token.T_AUTHORIZATION).append(' '); Grantee owner = database.schemaManager.toSchemaOwner(schemaName.name); ab.append(owner.getStatementName()); return ab.toString(); } static void getTableDDL(Table t, boolean useSchema, StringBuffer a) { a.append(Token.T_CREATE).append(' '); if (t.isTemp) { a.append(Token.T_GLOBAL).append(' '); a.append(Token.T_TEMPORARY).append(' '); } if (t.isText()) { a.append(Token.T_TEXT).append(' '); } else if (t.isCached()) { a.append(Token.T_CACHED).append(' '); } else { a.append(Token.T_MEMORY).append(' '); } a.append(Token.T_TABLE).append(' '); if (useSchema) { a.append(t.getName().schema.statementName).append('.'); } a.append(t.getName().statementName); a.append('('); int columns = t.getColumnCount(); int[] pk = t.getPrimaryKey(); Constraint pkConst = t.getPrimaryConstraint(); for (int j = 0; j < columns; j++) { Column column = t.getColumn(j); String colname = column.columnName.statementName; Type type = column.getType(); a.append(colname); a.append(' '); a.append(type.getDefinition()); String defaultString = column.getDefaultDDL(); if (defaultString != null) { a.append(' ').append(Token.T_DEFAULT).append(' '); a.append(defaultString); } if (column.isIdentity()) { a.append(' ').append( getIdentityDDL(column.getIdentitySequence())); } if (!column.isNullable()) { Constraint c = t.getNotNullConstraintForColumn(j); if (!c.getName().isReservedName()) { a.append(' ').append(Token.T_CONSTRAINT).append( ' ').append(c.getName().statementName); } a.append(' ').append(Token.T_NOT).append(' ').append( Token.T_NULL); } if (pk.length == 1 && j == pk[0] && pkConst.getName().isReservedName()) { a.append(' ').append(Token.T_PRIMARY).append(' ').append( Token.T_KEY); } if (j < columns - 1) { a.append(','); } } Constraint[] constraintList = t.getConstraints(); for (int j = 0, vSize = constraintList.length; j < vSize; j++) { Constraint c = constraintList[j]; switch (c.getType()) { case Constraint.PRIMARY_KEY : if (pk.length > 1 || (pk.length == 1 && !c.getName().isReservedName())) { a.append(','); if (!c.getName().isReservedName()) { a.append(Token.T_CONSTRAINT).append(' '); a.append(c.getName().statementName).append(' '); } a.append(Token.T_PRIMARY).append(' ').append( Token.T_KEY); getColumnList(t, pk, pk.length, a); } break; case Constraint.UNIQUE : a.append(','); if (!c.getName().isReservedName()) { a.append(Token.T_CONSTRAINT).append(' '); a.append(c.getName().statementName); a.append(' '); } a.append(Token.T_UNIQUE); int[] col = c.getMainColumns(); getColumnList(t, col, col.length, a); break; case Constraint.FOREIGN_KEY : // forward referencing FK if (!c.isForward) { a.append(','); getFKStatement(c, a); } break; case Constraint.CHECK : if (c.isNotNull()) { break; } a.append(','); if (!c.getName().isReservedName()) { a.append(Token.T_CONSTRAINT).append(' '); a.append(c.getName().statementName).append(' '); } a.append(Token.T_CHECK).append('('); a.append(c.check.getDDL()); a.append(')'); // should not throw as it is already tested OK break; } } a.append(')'); if (t.onCommitPreserve) { a.append(' ').append(Token.T_ON).append(' '); a.append(Token.T_COMMIT).append(' ').append(Token.T_PRESERVE); a.append(' ').append(Token.T_ROWS); } } /** * Generates the SET TABLE <tablename> SOURCE <string> statement for a * text table; */ static String getDataSourceDDL(Table t) { String dataSource = t.getDataSource(); if (dataSource == null) { return null; } boolean isDesc = t.isDescDataSource(); StringBuffer a = new StringBuffer(128); a.append(Token.T_SET).append(' ').append(Token.T_TABLE).append(' '); a.append(t.getName().statementName); a.append(' ').append(Token.T_SOURCE).append(' ').append('"'); a.append(dataSource); a.append('"'); if (isDesc) { a.append(' ').append(Token.T_DESC); } return a.toString(); } /** * Generates the SET TABLE <tablename> SOURCE HEADER <string> statement for a * text table; */ private static String getDataSourceHeader(Table t) { String header = t.getHeader(); if (header == null) { return null; } StringBuffer a = new StringBuffer(128); a.append(Token.T_SET).append(' ').append(Token.T_TABLE).append(' '); a.append(t.getName().statementName); a.append(' ').append(Token.T_SOURCE).append(' '); a.append(Token.T_HEADER).append(' '); a.append(header); return a.toString(); } /** * Generates the column definitions for a table. */ private static void getColumnList(Table t, int[] col, int len, StringBuffer a) { a.append('('); for (int i = 0; i < len; i++) { a.append(t.getColumn(col[i]).columnName.statementName); if (i < len - 1) { a.append(','); } } a.append(')'); } /** * Generates the foreign key declaration for a given Constraint object. */ private static void getFKStatement(Constraint c, StringBuffer a) { if (!c.getName().isReservedName()) { a.append(Token.T_CONSTRAINT).append(' '); a.append(c.getName().statementName); a.append(' '); } a.append(Token.T_FOREIGN).append(' ').append(Token.T_KEY); int[] col = c.getRefColumns(); getColumnList(c.getRef(), col, col.length, a); a.append(' ').append(Token.T_REFERENCES).append(' '); a.append(c.getMain().getSchemaName().statementName).append('.'); a.append(c.getMain().getName().statementName); col = c.getMainColumns(); getColumnList(c.getMain(), col, col.length, a); if (c.getDeleteAction() != Constraint.NO_ACTION) { a.append(' ').append(Token.T_ON).append(' ').append( Token.T_DELETE).append(' '); a.append(getFKAction(c.getDeleteAction())); } if (c.getUpdateAction() != Constraint.NO_ACTION) { a.append(' ').append(Token.T_ON).append(' ').append( Token.T_UPDATE).append(' '); a.append(getFKAction(c.getUpdateAction())); } } /** * Returns the foreign key action rule. */ private static String getFKAction(int action) { switch (action) { case Constraint.CASCADE : return Token.T_CASCADE; case Constraint.SET_DEFAULT : return Token.T_SET + ' ' + Token.T_DEFAULT; case Constraint.SET_NULL : return Token.T_SET + ' ' + Token.T_NULL; default : return Token.T_NO + ' ' + Token.T_ACTION; } } /** * Adds a script line to the result. */ private static void addRow(Result r, String sql) { if (sql == null || sql.length() == 0) { return; } String[] s = new String[1]; s[0] = sql; r.initialiseNavigator().add(s); } /** * Generates the GRANT statements for grantees. * * When views is true, generates rights for views only. Otherwise * generates rights for tables, sequences, and classes. * * Does not generate script for: * * grant on builtin classes to public * grant select on system tables * */ private static void addRightsStatements(Database dDatabase, Result r) { GranteeManager gm = dDatabase.getGranteeManager(); Iterator grantees = gm.getGrantees().iterator(); // grantees has ALL Users and Roles, incl. hidden and reserved ones. // Therefore, we filter out the non-persisting ones. while (grantees.hasNext()) { Grantee g = (Grantee) grantees.next(); String name = g.getName(); // _SYSTEM user, DBA Role grants/revokes not persisted if (name.equals("_SYSTEM") || name.equals("DBA")) { continue; } HsqlArrayList list = g.getRightsDDL(); for (int i = 0; i < list.size(); i++) { addRow(r, (String) list.get(i)); } } } static String getSavepointDDL(String name) { StringBuffer sb = new StringBuffer(Token.T_SAVEPOINT); sb.append(' ').append('"').append(name).append('"'); return sb.toString(); } static String getSavepointRollbackDDL(String name) { StringBuffer sb = new StringBuffer(); sb.append(Token.T_ROLLBACK).append(' ').append(Token.T_TO).append(' '); sb.append(Token.T_SAVEPOINT).append(' '); sb.append('"').append(name).append('"'); return sb.toString(); } }

The table below shows all metrics for DatabaseScript.java.

Metric	Value	Description
BLOCKS	108.00	Number of blocks
BLOCK_COMMENT	67.00	Number of block comment lines
COMMENTS	150.00	Comment lines
COMMENT_DENSITY	0.30	Comment density
COMPARISONS	87.00	Number of comparison operators
CYCLOMATIC	123.00	Cyclomatic complexity
DECL_COMMENTS	11.00	Comments in declarations
DOC_COMMENT	51.00	Number of javadoc comment lines
ELOC	499.00	Effective lines of code
EXEC_COMMENTS	27.00	Comments in executable code
EXITS	126.00	Procedure exits
FUNCTIONS	21.00	Number of function declarations
HALSTEAD_DIFFICULTY	114.89	Halstead difficulty
HALSTEAD_EFFORT	0.00	Halstead effort
INTERFACE_COMPLEXITY	82.00	Interface complexity
JAVA0001	0.00	JAVA0001 Package name does not contain only lower case letters
JAVA0002	0.00	JAVA0002 Package name does not begin with a top level domain name or country code
JAVA0003	0.00	JAVA0003 Minimize use of on-demand (.*) imports
JAVA0004	0.00	JAVA0004 Unnecessary import from java.lang
JAVA0005	0.00	JAVA0005 Imports not in specified order
JAVA0006	0.00	JAVA0006 Empty finally block
JAVA0007	0.00	JAVA0007 Should not declare public field
JAVA0008	0.00	JAVA0008 Empty catch block
JAVA0009	0.00	JAVA0009 Protected member in final class
JAVA0010	0.00	JAVA0010 Non-instantiable class does not contain a non-private static member
JAVA0011	0.00	JAVA0011 Abstract class does not contain an abstract method
JAVA0012	0.00	JAVA0012 Non-constructor method with same name as declaring class
JAVA0013	0.00	JAVA0013 Non-blank final field is not static
JAVA0014	1.00	JAVA0014 Class with only static members has non-private constructor
JAVA0015	0.00	JAVA0015 Package class contains public nested type
JAVA0016	0.00	JAVA0016 Abstract class contains public constructor
JAVA0017	0.00	JAVA0017 Class name does not have required form
JAVA0018	0.00	JAVA0018 Method name does not have required form
JAVA0019	0.00	JAVA0019 Interface name does not have required form
JAVA0020	0.00	JAVA0020 Field name does not have required form
JAVA0021	0.00	JAVA0021 Interface method name does not have required form
JAVA0022	0.00	JAVA0022 Static final field name does not have required form
JAVA0023	0.00	JAVA0023 Empty finalize method
JAVA0024	0.00	JAVA0024 Empty class
JAVA0025	0.00	JAVA0025 Method override is empty
JAVA0026	0.00	JAVA0026 Finalize method with parameters
JAVA0029	0.00	JAVA0029 Private method not used
JAVA0030	0.00	JAVA0030 Private field not used
JAVA0031	0.00	JAVA0031 Case statement not properly closed
JAVA0032	1.00	JAVA0032 Switch statement missing default
JAVA0033	0.00	JAVA0033 default: not last case in switch statement
JAVA0034	0.00	JAVA0034 Missing braces in if statement
JAVA0035	0.00	JAVA0035 Missing braces in for statement
JAVA0036	0.00	JAVA0036 Missing braces in while statement
JAVA0038	0.00	JAVA0038 Non-case label in switch statement
JAVA0039	0.00	JAVA0039 Break statement with label
JAVA0040	0.00	JAVA0040 Switch statement contains N cases (maximum: M)
JAVA0041	0.00	JAVA0041 Nested synchronized block
JAVA0042	0.00	JAVA0042 Empty synchronized statement
JAVA0043	0.00	JAVA0043 Inner class does not use outer class
JAVA0044	0.00	JAVA0044 Serializable class with no instance variables
JAVA0045	0.00	JAVA0045 Serializable class with only transient fields
JAVA0046	0.00	JAVA0046 Name of class not derived from Exception ends with 'Exception'
JAVA0047	0.00	JAVA0047 Serializable class derives from invalid base class
JAVA0048	0.00	JAVA0048 Name of class derived from Exception does not end with 'Exception'
JAVA0049	1.00	JAVA0049 Nested block at depth N (maximum: M)
JAVA0050	0.00	JAVA0050 Class derives from java.lang.Error
JAVA0051	0.00	JAVA0051 Class derives from java.lang.RuntimeException
JAVA0052	0.00	JAVA0052 Class derives from java.lang.Throwable
JAVA0053	0.00	JAVA0053 Unused label
JAVA0054	0.00	JAVA0054 Inheritance depth N exceeds maximum M
JAVA0055	0.00	JAVA0055 Class should be interface
JAVA0056	0.00	JAVA0056 Unnecessary abstract modifier for interface or annotation
JAVA0057	0.00	JAVA0057 Unnecessary default constructor
JAVA0058	0.00	JAVA0058 Constructor calls super()
JAVA0059	0.00	JAVA0059 Method override only calls super()
JAVA0061	0.00	JAVA0061 Inaccessible member in anonymous class
JAVA0062	0.00	JAVA0062 Public class missing public member or protected constructor
JAVA0063	0.00	JAVA0063 Identifier name should not contain '$'
JAVA0064	0.00	JAVA0064 N variations of identifier name (maximum: M)
JAVA0065	0.00	JAVA0065 Unnecessary final modifier for method in final class
JAVA0066	0.00	JAVA0066 Unnecessary modifier for interface nested type
JAVA0067	0.00	JAVA0067 Array descriptor on identifier name
JAVA0068	0.00	JAVA0068 Modifiers not declared in recommended order
JAVA0071	0.00	JAVA0071 Strings compared with ==
JAVA0073	0.00	JAVA0073 Integer division in floating-point context
JAVA0074	0.00	JAVA0074 Use of Object.notify()
JAVA0075	0.00	JAVA0075 Method parameter hides field
JAVA0076	18.00	JAVA0076 Use of magic number
JAVA0077	0.00	JAVA0077 Private field not used in declaring class
JAVA0078	0.00	JAVA0078 Floating point values compared with ==
JAVA0079	0.00	JAVA0079 Use of instance to reference static member
JAVA0080	0.00	JAVA0080 Import declaration not used
JAVA0081	0.00	JAVA0081 Boolean literal in comparison
JAVA0082	0.00	JAVA0082 Unnecessary widening cast
JAVA0083	0.00	JAVA0083 Unnecessary instanceof test
JAVA0084	0.00	JAVA0084 Should use compound assignment operator
JAVA0085	0.00	JAVA0085 Use of sun.* class
JAVA0087	0.00	JAVA0087 Use of Thread.sleep()
JAVA0089	0.00	JAVA0089 Use of restricted package
JAVA0092	0.00	JAVA0092 Use of restricted type
JAVA0093	0.00	JAVA0093 Redundant assignment
JAVA0094	0.00	JAVA0094 Field hides a superclass field
JAVA0095	0.00	JAVA0095 Uninitialized private field
JAVA0096	0.00	JAVA0096 Field in nested class hides outer field
JAVA0098	0.00	JAVA0098 Minimize use of implicit field initializers
JAVA0100	0.00	JAVA0100 Class contains N non-final fields (maximum: M)
JAVA0101	0.00	JAVA0101 Unnecessary modifier for field in interface
JAVA0102	0.00	JAVA0102 Last statement in finalize() not super.finalize()
JAVA0103	0.00	JAVA0103 Explicit call to finalize()
JAVA0104	0.00	JAVA0104 finalize() only calls super.finalize()
JAVA0105	0.00	JAVA0105 Duplicate import declaration
JAVA0106	0.00	JAVA0106 Unnecessary import from current package
JAVA0108	15.00	JAVA0108 Incorrect javadoc: no @param tag for 'parameter'
JAVA0109	0.00	JAVA0109 Incorrect javadoc: no parameter 'parameter'
JAVA0110	4.00	JAVA0110 Incorrect javadoc: no @return tag
JAVA0111	0.00	JAVA0111 Incorrect javadoc: @return tag for void method
JAVA0112	0.00	JAVA0112 Incorrect javadoc: no exception 'exception' in throws
JAVA0113	0.00	JAVA0113 Incorrect javadoc: no @author tag
JAVA0114	0.00	JAVA0114 Incorrect javadoc: no @version tag
JAVA0115	0.00	JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception'
JAVA0116	0.00	JAVA0116 Missing javadoc: field 'field'
JAVA0117	0.00	JAVA0117 Missing javadoc: method 'method'
JAVA0118	0.00	JAVA0118 Missing javadoc: type 'type'
JAVA0119	0.00	JAVA0119 Control variable changed within body of for loop
JAVA0123	2.00	JAVA0123 Use all three components of for loop
JAVA0125	0.00	JAVA0125 Continue statement with label
JAVA0126	0.00	JAVA0126 Method declares unchecked exception in throws
JAVA0128	0.00	JAVA0128 Public constructor in non-public class
JAVA0130	0.00	JAVA0130 Non-static method does not use instance fields
JAVA0131	0.00	JAVA0131 Compatible method does not override base
JAVA0132	0.00	JAVA0132 Method overload with compatible signature
JAVA0133	0.00	JAVA0133 Non-synchronized method overrides synchronized method
JAVA0135	0.00	JAVA0135 Only one of Object.equals and Object.hashCode defined: missing 'method'
JAVA0136	1.00	JAVA0136 N methods defined in class (maximum: M)
JAVA0137	0.00	JAVA0137 Non-abstract class missing constructor
JAVA0138	0.00	JAVA0138 N parameters defined for method (maximum: M)
JAVA0139	0.00	JAVA0139 Definition of main other than public static void main(java.lang.String[])
JAVA0141	0.00	JAVA0141 Unnecessary modifier for method in interface
JAVA0143	0.00	JAVA0143 Synchronized method
JAVA0144	0.00	JAVA0144 Line exceeds maximum M characters
JAVA0145	0.00	JAVA0145 Tab character used in source file
JAVA0150	0.00	JAVA0150 java.lang.Error (or subclass) thrown
JAVA0153	0.00	JAVA0153 Inefficient conversion of integer to string
JAVA0159	0.00	JAVA0159 Inefficient conversion of string to integer
JAVA0160	0.00	JAVA0160 Method does not throw specified exception
JAVA0161	0.00	JAVA0161 Conditional wait() not in loop
JAVA0163	0.00	JAVA0163 Empty statement
JAVA0165	0.00	JAVA0165 Conflicting return statement in finally block
JAVA0166	0.00	JAVA0166 Generic exception caught
JAVA0167	0.00	JAVA0167 ThreadDeath not rethrown
JAVA0169	0.00	JAVA0169 Unnecessary catch block: exception 'exception'
JAVA0170	0.00	JAVA0170 Caught exception not derived from java.lang.Exception
JAVA0171	2.00	JAVA0171 Unused local variable
JAVA0173	1.00	JAVA0173 Unused method parameter
JAVA0174	0.00	JAVA0174 Assigned local variable never used
JAVA0175	0.00	JAVA0175 Successive assignment to variable
JAVA0176	0.00	JAVA0176 Local variable name does not have required form
JAVA0177	3.00	JAVA0177 Variable declaration missing initializer
JAVA0179	0.00	JAVA0179 Local variable hides visible field
JAVA0233	0.00	JAVA0233 Definition of serialVersionUID other than 'private static final long serialVersionUID'
JAVA0234	0.00	JAVA0234 Class is Serializable but does not define serialVersionUID
JAVA0235	0.00	JAVA0235 Class defines serialVersionUID but does not implement Serializable
JAVA0236	0.00	JAVA0236 Attempt to clone an object which does not implement Cloneable
JAVA0237	0.00	JAVA0237 Class implements Cloneable but does not have public clone method
JAVA0238	0.00	JAVA0238 Clone method does not call super.clone()
JAVA0239	0.00	JAVA0239 Class declares 'readObject' or 'writeObject' but does not implement Serializable
JAVA0240	0.00	JAVA0240 Serializable class which declares readObject or writeObject but not both
JAVA0241	0.00	JAVA0241 'readObject' or 'writeObject' should be declared private in Serializable class
JAVA0242	0.00	JAVA0242 Transient field in non-Serializable class
JAVA0243	0.00	JAVA0243 'readResolve' or 'writeReplace' should be declared private or protected
JAVA0244	0.00	JAVA0244 Field or method name in subclass differs only by case from inherited field or method
JAVA0245	0.00	JAVA0245 JUnit TestCase with non-trivial constructor
JAVA0246	0.00	JAVA0246 JUnit assertXXX statement missing message parameter
JAVA0247	0.00	JAVA0247 JUnit 'setUp()' and 'tearDown()' should call super method
JAVA0248	0.00	JAVA0248 JUnit method 'setUp' or 'tearDown' with incorrect signature
JAVA0249	0.00	JAVA0249 JUnit TestCase 'suite()' should be declared static
JAVA0250	0.00	JAVA0250 JUnit TestCase declares testXXX method with incorrect signature
JAVA0251	0.00	JAVA0251 Use '%n' for line breaks in printf/format for platform independence
JAVA0252	0.00	JAVA0252 'enum' is a Java 1.5 reserved word
JAVA0253	0.00	JAVA0253 Not all enum constants consumed in switch statement
JAVA0254	0.00	JAVA0254 Use enhanced for loop construct instead of Iterator
JAVA0255	0.00	JAVA0255 Result of method invocation not used
JAVA0256	0.00	JAVA0256 Assignment of external collection/array to field
JAVA0257	0.00	JAVA0257 Use of 'Constant Interface' anti-pattern
JAVA0258	0.00	JAVA0258 Implement Iterable for foreach compatibility
JAVA0259	0.00	JAVA0259 Return of collection/array field
JAVA0260	0.00	JAVA0260 Use 'enum' instead of Enumerated Type pattern
JAVA0261	0.00	JAVA0261 Use specialized Enum collection types
JAVA0262	0.00	JAVA0262 Use of char in integer context
JAVA0263	0.00	JAVA0263 Long literal ends with 'l' instead of 'L'
JAVA0264	0.00	JAVA0264 Integer math in long context - check for overflow
JAVA0265	0.00	JAVA0265 Use of Throwable.printStackTrace()
JAVA0266	0.00	JAVA0266 Use of System.out
JAVA0267	0.00	JAVA0267 Use of System.err
JAVA0269	0.00	JAVA0269 Contents of StringBuffer never used
JAVA0270	1.00	JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array
JAVA0271	0.00	JAVA0271 Minimize use of on-demand (.*) static imports
JAVA0272	0.00	JAVA0272 Thread.run() called
JAVA0273	0.00	JAVA0273 Non-final derivative of Thread calls start() in constructor
JAVA0274	0.00	JAVA0274 Serializable class has a synchronized readObject()
JAVA0275	0.00	JAVA0275 Serializable class has a synchronized writeObject() and no other synchronized methods
JAVA0276	0.00	JAVA0276 Unnecessary use of String constructor
JAVA0277	0.00	JAVA0277 Iterator.next() implementation does not throw NoSuchElementException
JAVA0278	0.00	JAVA0278 Unnecessary use of Boolean constructor
JAVA0279	0.00	JAVA0279 Serialization method readObject or readObjectNoData calls an overridable method
JAVA0280	0.00	JAVA0280 IllegalMonitorStateException caught
JAVA0281	0.00	JAVA0281 Iterator.next() not called in loop
JAVA0282	0.00	JAVA0282 Call to Iterator.next() in loop which does not test Iterator.hasNext()
JAVA0283	0.00	JAVA0283 Control variable not updated in loop body
JAVA0284	0.00	JAVA0284 Explicit garbage collection
JAVA0285	0.00	JAVA0285 Dereference of potentially null variable
JAVA0286	0.00	JAVA0286 Dereference of null variable
JAVA0287	0.00	JAVA0287 Unnecessary null check
JAVA0288	0.00	JAVA0288 Inconsistent null check
LINES	989.00	Number of lines in the source file
LINE_COMMENT	32.00	Number of line comments
LOC	606.00	Lines of code
LOGICAL_LINES	374.00	Number of statements
LOOPS	26.00	Number of loops
NEST_DEPTH	6.00	Maximum nesting depth
OPERANDS	2153.00	Number of operands
OPERATORS	3503.00	Number of operators
PARAMS	36.00	Number of formal parameter declarations
PROGRAM_LENGTH	5656.00	Halstead program length
PROGRAM_VOCAB	477.00	Halstead program vocabulary
PROGRAM_VOLUME	0.00	Halstead program volume
RETURNS	46.00	Number of return points from functions
SIZE	32684.00	Size of the file in bytes
UNIQUE_OPERANDS	431.00	Number of unique operands
UNIQUE_OPERATORS	46.00	Number of unique operators
WHITESPACE	233.00	Number of whitespace lines

Enerjy

Explore.

DatabaseScript.java