/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* Oracle - initial API and implementation from Oracle TopLink
******************************************************************************/
package org.eclipse.persistence.testing.models.jpa.datatypes;
import org.eclipse.persistence.tools.schemaframework.TableDefinition;
import org.eclipse.persistence.tools.schemaframework.FieldDefinition;
public class DataTypesTableCreator extends org.eclipse.persistence.tools.schemaframework.TableCreator {
public DataTypesTableCreator() {
setName("EJB3DataTypesProject");
addTableDefinition(DataTypesTableCreator.buildPrimitiveTypesTable());
addTableDefinition(DataTypesTableCreator.buildWrapperTypesTable());
addTableDefinition(DataTypesTableCreator.buildByteArrayTable());
addTableDefinition(DataTypesTableCreator.buildPrimitiveByteArrayTable());
addTableDefinition(DataTypesTableCreator.buildCharacterArrayTable());
addTableDefinition(DataTypesTableCreator.buildCharArrayTable());
}
public static TableDefinition buildPrimitiveTypesTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_PRIMITIVE_TYPES");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("PT_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldBOOLEANDATA = new FieldDefinition();
fieldBOOLEANDATA.setName("BOOLEAN_DATA");
fieldBOOLEANDATA.setTypeName("BIT");
fieldBOOLEANDATA.setIsPrimaryKey(false);
fieldBOOLEANDATA.setIsIdentity(false);
fieldBOOLEANDATA.setUnique(false);
fieldBOOLEANDATA.setShouldAllowNull(false);
table.addField(fieldBOOLEANDATA);
FieldDefinition fieldBYTEDATA = new FieldDefinition();
fieldBYTEDATA.setName("BYTE_DATA");
fieldBYTEDATA.setTypeName("TINYINT");
fieldBYTEDATA.setIsPrimaryKey(false);
fieldBYTEDATA.setIsIdentity(false);
fieldBYTEDATA.setUnique(false);
fieldBYTEDATA.setShouldAllowNull(false);
table.addField(fieldBYTEDATA);
FieldDefinition fieldCHARDATA = new FieldDefinition();
fieldCHARDATA.setName("CHAR_DATA");
fieldCHARDATA.setTypeName("CHAR");
fieldCHARDATA.setIsPrimaryKey(false);
fieldCHARDATA.setIsIdentity(false);
fieldCHARDATA.setUnique(false);
fieldCHARDATA.setShouldAllowNull(false);
table.addField(fieldCHARDATA);
FieldDefinition fieldSHORTDATA = new FieldDefinition();
fieldSHORTDATA.setName("SHORT_DATA");
fieldSHORTDATA.setTypeName("SMALLINT");
fieldSHORTDATA.setIsPrimaryKey(false);
fieldSHORTDATA.setIsIdentity(false);
fieldSHORTDATA.setUnique(false);
fieldSHORTDATA.setShouldAllowNull(false);
table.addField(fieldSHORTDATA);
FieldDefinition fieldINTDATA = new FieldDefinition();
fieldINTDATA.setName("INT_DATA");
fieldINTDATA.setTypeName("NUMERIC");
fieldINTDATA.setSize(15);
fieldINTDATA.setIsPrimaryKey(false);
fieldINTDATA.setIsIdentity(false);
fieldINTDATA.setUnique(false);
fieldINTDATA.setShouldAllowNull(false);
table.addField(fieldINTDATA);
FieldDefinition fieldLONGDATA = new FieldDefinition();
fieldLONGDATA.setName("LONG_DATA");
fieldLONGDATA.setTypeName("NUMERIC");
fieldLONGDATA.setSize(18);
fieldLONGDATA.setIsPrimaryKey(false);
fieldLONGDATA.setIsIdentity(false);
fieldLONGDATA.setUnique(false);
fieldLONGDATA.setShouldAllowNull(false);
table.addField(fieldLONGDATA);
FieldDefinition fieldFLOATDATA = new FieldDefinition();
fieldFLOATDATA.setName("FLOAT_DATA");
fieldFLOATDATA.setTypeName("FLOAT");
fieldFLOATDATA.setIsPrimaryKey(false);
fieldFLOATDATA.setIsIdentity(false);
fieldFLOATDATA.setUnique(false);
fieldFLOATDATA.setShouldAllowNull(false);
table.addField(fieldFLOATDATA);
FieldDefinition fieldDOUBLEDATA = new FieldDefinition();
fieldDOUBLEDATA.setName("DOUBLE_DATA");
fieldDOUBLEDATA.setTypeName("DOUBLE");
fieldDOUBLEDATA.setIsPrimaryKey(false);
fieldDOUBLEDATA.setIsIdentity(false);
fieldDOUBLEDATA.setUnique(false);
fieldDOUBLEDATA.setShouldAllowNull(false);
table.addField(fieldDOUBLEDATA);
FieldDefinition fieldSTRINGDATA = new FieldDefinition();
fieldSTRINGDATA.setName("STRING_DATA");
fieldSTRINGDATA.setTypeName("VARCHAR");
fieldSTRINGDATA.setSize(30);
fieldSTRINGDATA.setIsPrimaryKey(false);
fieldSTRINGDATA.setIsIdentity(false);
fieldSTRINGDATA.setUnique(false);
fieldSTRINGDATA.setShouldAllowNull(true);
table.addField(fieldSTRINGDATA);
return table;
}
public static TableDefinition buildWrapperTypesTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_WRAPPER_TYPES");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("WT_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldBIGDECIMALDATA = new FieldDefinition();
fieldBIGDECIMALDATA.setName("BIGDECIMAL_DATA");
fieldBIGDECIMALDATA.setTypeName("NUMERIC");
fieldBIGDECIMALDATA.setSize(18);
fieldBIGDECIMALDATA.setSubSize(0);
fieldBIGDECIMALDATA.setIsPrimaryKey(false);
fieldBIGDECIMALDATA.setIsIdentity(false);
fieldBIGDECIMALDATA.setUnique(false);
fieldBIGDECIMALDATA.setShouldAllowNull(true);
table.addField(fieldBIGDECIMALDATA);
FieldDefinition fieldBIGINTEGERDATA = new FieldDefinition();
fieldBIGINTEGERDATA.setName("BIGINTEGER_DATA");
fieldBIGINTEGERDATA.setTypeName("NUMERIC");
fieldBIGINTEGERDATA.setSize(18);
fieldBIGINTEGERDATA.setSubSize(0);
fieldBIGINTEGERDATA.setIsPrimaryKey(false);
fieldBIGINTEGERDATA.setIsIdentity(false);
fieldBIGINTEGERDATA.setUnique(false);
fieldBIGINTEGERDATA.setShouldAllowNull(true);
table.addField(fieldBIGINTEGERDATA);
FieldDefinition fieldBOOLEANDATA = new FieldDefinition();
fieldBOOLEANDATA.setName("BOOLEAN_DATA");
fieldBOOLEANDATA.setTypeName("BIT");
fieldBOOLEANDATA.setIsPrimaryKey(false);
fieldBOOLEANDATA.setIsIdentity(false);
fieldBOOLEANDATA.setUnique(false);
fieldBOOLEANDATA.setShouldAllowNull(true);
table.addField(fieldBOOLEANDATA);
FieldDefinition fieldBYTEDATA = new FieldDefinition();
fieldBYTEDATA.setName("BYTE_DATA");
fieldBYTEDATA.setTypeName("TINYINT");
fieldBYTEDATA.setIsPrimaryKey(false);
fieldBYTEDATA.setIsIdentity(false);
fieldBYTEDATA.setUnique(false);
fieldBYTEDATA.setShouldAllowNull(true);
table.addField(fieldBYTEDATA);
FieldDefinition fieldCHARDATA = new FieldDefinition();
fieldCHARDATA.setName("CHARACTER_DATA");
fieldCHARDATA.setTypeName("CHAR");
fieldCHARDATA.setIsPrimaryKey(false);
fieldCHARDATA.setIsIdentity(false);
fieldCHARDATA.setUnique(false);
fieldCHARDATA.setShouldAllowNull(true);
table.addField(fieldCHARDATA);
FieldDefinition fieldSHORTDATA = new FieldDefinition();
fieldSHORTDATA.setName("SHORT_DATA");
fieldSHORTDATA.setTypeName("SMALLINT");
fieldSHORTDATA.setIsPrimaryKey(false);
fieldSHORTDATA.setIsIdentity(false);
fieldSHORTDATA.setUnique(false);
fieldSHORTDATA.setShouldAllowNull(true);
table.addField(fieldSHORTDATA);
FieldDefinition fieldINTDATA = new FieldDefinition();
fieldINTDATA.setName("INTEGER_DATA");
fieldINTDATA.setTypeName("NUMERIC");
fieldINTDATA.setSize(15);
fieldINTDATA.setIsPrimaryKey(false);
fieldINTDATA.setIsIdentity(false);
fieldINTDATA.setUnique(false);
fieldINTDATA.setShouldAllowNull(true);
table.addField(fieldINTDATA);
FieldDefinition fieldLONGDATA = new FieldDefinition();
fieldLONGDATA.setName("LONG_DATA");
fieldLONGDATA.setTypeName("NUMERIC");
fieldLONGDATA.setSize(18);
fieldLONGDATA.setIsPrimaryKey(false);
fieldLONGDATA.setIsIdentity(false);
fieldLONGDATA.setUnique(false);
fieldLONGDATA.setShouldAllowNull(true);
table.addField(fieldLONGDATA);
FieldDefinition fieldFLOATDATA = new FieldDefinition();
fieldFLOATDATA.setName("FLOAT_DATA");
fieldFLOATDATA.setTypeName("FLOAT");
fieldFLOATDATA.setIsPrimaryKey(false);
fieldFLOATDATA.setIsIdentity(false);
fieldFLOATDATA.setUnique(false);
fieldFLOATDATA.setShouldAllowNull(true);
table.addField(fieldFLOATDATA);
FieldDefinition fieldDOUBLEDATA = new FieldDefinition();
fieldDOUBLEDATA.setName("DOUBLE_DATA");
fieldDOUBLEDATA.setTypeName("DOUBLE");
fieldDOUBLEDATA.setIsPrimaryKey(false);
fieldDOUBLEDATA.setIsIdentity(false);
fieldDOUBLEDATA.setUnique(false);
fieldDOUBLEDATA.setShouldAllowNull(true);
table.addField(fieldDOUBLEDATA);
FieldDefinition fieldSTRINGDATA = new FieldDefinition();
fieldSTRINGDATA.setName("STRING_DATA");
fieldSTRINGDATA.setTypeName("VARCHAR");
fieldSTRINGDATA.setSize(30);
fieldSTRINGDATA.setIsPrimaryKey(false);
fieldSTRINGDATA.setIsIdentity(false);
fieldSTRINGDATA.setUnique(false);
fieldSTRINGDATA.setShouldAllowNull(true);
table.addField(fieldSTRINGDATA);
return table;
}
public static TableDefinition buildByteArrayTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_BYTEARRAY_TYPE");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("BA_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldBYTEARRAYDATA = new FieldDefinition();
fieldBYTEARRAYDATA.setName("BYTEARRAY_DATA");
fieldBYTEARRAYDATA.setTypeName("LONGVARBINARY");
fieldBYTEARRAYDATA.setIsPrimaryKey(false);
fieldBYTEARRAYDATA.setIsIdentity(false);
fieldBYTEARRAYDATA.setUnique(false);
fieldBYTEARRAYDATA.setShouldAllowNull(true);
table.addField(fieldBYTEARRAYDATA);
return table;
}
public static TableDefinition buildPrimitiveByteArrayTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_PBYTEARRAY_TYPE");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("PBA_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldPRIMITIVEBYTEARRAYDATA = new FieldDefinition();
fieldPRIMITIVEBYTEARRAYDATA.setName("PBYTEARRAY_DATA");
fieldPRIMITIVEBYTEARRAYDATA.setTypeName("LONGVARBINARY");
fieldPRIMITIVEBYTEARRAYDATA.setIsPrimaryKey(false);
fieldPRIMITIVEBYTEARRAYDATA.setIsIdentity(false);
fieldPRIMITIVEBYTEARRAYDATA.setUnique(false);
fieldPRIMITIVEBYTEARRAYDATA.setShouldAllowNull(true);
table.addField(fieldPRIMITIVEBYTEARRAYDATA);
return table;
}
public static TableDefinition buildCharacterArrayTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_CHARACTERARRAY_TYPE");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("CA_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldCHARACTERARRAYDATA = new FieldDefinition();
fieldCHARACTERARRAYDATA.setName("CHARACTERARRAY_DATA");
fieldCHARACTERARRAYDATA.setTypeName("LONGVARCHAR");
fieldCHARACTERARRAYDATA.setIsPrimaryKey(false);
fieldCHARACTERARRAYDATA.setIsIdentity(false);
fieldCHARACTERARRAYDATA.setUnique(false);
fieldCHARACTERARRAYDATA.setShouldAllowNull(true);
table.addField(fieldCHARACTERARRAYDATA);
return table;
}
public static TableDefinition buildCharArrayTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_PCHARARRAY_TYPE");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("PCA_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldCHARARRAYDATA = new FieldDefinition();
fieldCHARARRAYDATA.setName("PCHARARRAY_DATA");
fieldCHARARRAYDATA.setTypeName("LONGVARCHAR");
fieldCHARARRAYDATA.setIsPrimaryKey(false);
fieldCHARARRAYDATA.setIsIdentity(false);
fieldCHARARRAYDATA.setUnique(false);
fieldCHARARRAYDATA.setShouldAllowNull(true);
table.addField(fieldCHARARRAYDATA);
return table;
}
}