You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
92 lines
3.4 KiB
92 lines
3.4 KiB
/* Copyright (c) 2001-2015, 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 com.fr.third.org.hsqldb; |
|
|
|
import com.fr.third.org.hsqldb.HsqlNameManager.HsqlName; |
|
import com.fr.third.org.hsqldb.types.Type; |
|
|
|
/* |
|
* Utility functions to set up special tables. |
|
* |
|
* @author Fred Toussi (fredt@users dot sourceforge.net) |
|
* @version 2.3.3 |
|
* @since 1.9.0 |
|
*/ |
|
public class TableUtil { |
|
|
|
static Table newSingleColumnTable(Database database, HsqlName tableName, |
|
int tableType, HsqlName colName, |
|
Type colType) { |
|
|
|
TableDerived table; |
|
|
|
table = new TableDerived(database, tableName, tableType); |
|
|
|
ColumnSchema column = new ColumnSchema(colName, colType, false, true, |
|
null); |
|
|
|
table.addColumn(column); |
|
table.createPrimaryKeyConstraint(table.getName(), new int[]{ 0 }, |
|
true); |
|
|
|
return table; |
|
} |
|
|
|
public static void addAutoColumns(Table table, Type[] colTypes) { |
|
|
|
for (int i = 0; i < colTypes.length; i++) { |
|
ColumnSchema column = |
|
new ColumnSchema(HsqlNameManager.getAutoColumnName(i), |
|
colTypes[i], true, false, null); |
|
|
|
table.addColumnNoCheck(column); |
|
} |
|
} |
|
|
|
public static void setColumnsInSchemaTable(Table table, |
|
HsqlName[] columnNames, Type[] columnTypes) { |
|
|
|
for (int i = 0; i < columnNames.length; i++) { |
|
HsqlName columnName = columnNames[i]; |
|
|
|
columnName = table.database.nameManager.newColumnSchemaHsqlName( |
|
table.getName(), columnName); |
|
|
|
ColumnSchema column = new ColumnSchema(columnName, columnTypes[i], |
|
true, false, null); |
|
|
|
table.addColumn(column); |
|
} |
|
|
|
table.setColumnStructures(); |
|
} |
|
}
|
|
|