public static TableDefinition buildCHASSISTable() {
    // CREATE TABLE JPA_OR_CHASSIS (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY
    // KEY (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_CHASSIS");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(10);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setShouldAllowNull(false);
    fieldID.setUnique(false);
    table.addField(fieldID);

    FieldDefinition serialNumber = new FieldDefinition();
    serialNumber.setName("SERIALNUMBER");
    serialNumber.setTypeName("NUMERIC");
    serialNumber.setSize(18);
    serialNumber.setSubSize(0);
    serialNumber.setIsPrimaryKey(false);
    serialNumber.setIsIdentity(false);
    serialNumber.setShouldAllowNull(true);
    serialNumber.setUnique(false);
    table.addField(serialNumber);

    return table;
  }
  public static TableDefinition buildCACHEABLE_PROTECTED_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_PROTECTED");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(true);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(true);
    table.addField(fieldID);

    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR");
    fieldNAME.setSize(75);
    fieldNAME.setShouldAllowNull(true);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setUnique(false);
    fieldNAME.setIsIdentity(false);
    table.addField(fieldNAME);

    return table;
  }
 public static TableDefinition tableDefinition() {
   TableDefinition definition = new TableDefinition();
   definition.setName("CALENDARTOTSTZ_BINDING");
   definition.addField("TEST_ID", Integer.class);
   definition.addField("TSTZ_DATA", TIMESTAMPTZ.class);
   return definition;
 }
  public TableDefinition buildCapoTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CAPO");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldUnderboss = new FieldDefinition();
    fieldUnderboss.setName("UNDERBOSS_ID");
    fieldUnderboss.setTypeName("NUMERIC");
    fieldUnderboss.setSize(15);
    fieldUnderboss.setShouldAllowNull(false);
    fieldUnderboss.setIsPrimaryKey(false);
    fieldUnderboss.setUnique(false);
    fieldUnderboss.setIsIdentity(false);
    // fieldUnderboss.setForeignKeyFieldName("JPA_UNDERBOSS.ID");
    table.addField(fieldUnderboss);

    return table;
  }
  public TableDefinition buildSoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_SOLDIER");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldCapo = new FieldDefinition();
    fieldCapo.setName("CAPO_ID");
    fieldCapo.setTypeName("NUMERIC");
    fieldCapo.setSize(15);
    fieldCapo.setShouldAllowNull(false);
    fieldCapo.setIsPrimaryKey(false);
    fieldCapo.setUnique(false);
    fieldCapo.setIsIdentity(false);
    // fieldCapo.setForeignKeyFieldName("JPA_CAPO.ID");
    table.addField(fieldCapo);

    return table;
  }
  public TableDefinition buildMafiaFamily_RevenueTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_FAMILY_REVENUE");

    FieldDefinition fieldFamilyId = new FieldDefinition();
    fieldFamilyId.setName("ID");
    fieldFamilyId.setTypeName("NUMERIC");
    fieldFamilyId.setSize(15);
    fieldFamilyId.setIsPrimaryKey(false);
    fieldFamilyId.setIsIdentity(false);
    fieldFamilyId.setUnique(false);
    fieldFamilyId.setShouldAllowNull(false);
    // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID");
    table.addField(fieldFamilyId);

    FieldDefinition fieldRevenue = new FieldDefinition();
    fieldRevenue.setName("REVENUE");
    fieldRevenue.setTypeName("NUMBER");
    fieldRevenue.setSize(15);
    fieldRevenue.setSubSize(0);
    fieldRevenue.setIsPrimaryKey(false);
    fieldRevenue.setIsIdentity(false);
    fieldRevenue.setUnique(false);
    fieldRevenue.setShouldAllowNull(true);
    table.addField(fieldRevenue);

    return table;
  }
  public TableDefinition buildMafiaFamily_TagsTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_FAMILY_TAGS");

    FieldDefinition fieldFamilyId = new FieldDefinition();
    fieldFamilyId.setName("FAMILY_ID");
    fieldFamilyId.setTypeName("NUMERIC");
    fieldFamilyId.setSize(15);
    fieldFamilyId.setIsPrimaryKey(false);
    fieldFamilyId.setIsIdentity(false);
    fieldFamilyId.setUnique(false);
    fieldFamilyId.setShouldAllowNull(false);
    // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID");
    table.addField(fieldFamilyId);

    FieldDefinition fieldTag = new FieldDefinition();
    fieldTag.setName("TAG");
    fieldTag.setTypeName("VARCHAR2");
    fieldTag.setSize(60);
    fieldTag.setSubSize(0);
    fieldTag.setIsPrimaryKey(false);
    fieldTag.setIsIdentity(false);
    fieldTag.setUnique(false);
    fieldTag.setShouldAllowNull(true);
    table.addField(fieldTag);

    return table;
  }
  public TableDefinition buildAboutToInsertSingleTable() {
    TableDefinition table = new TableDefinition();
    table.setName("AboutToInsertSingle");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(28);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(false);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);

    FieldDefinition fieldNUMBER = new FieldDefinition();
    fieldNUMBER.setName("EXTRA_NUMBER");
    fieldNUMBER.setTypeName("NUMERIC");
    fieldNUMBER.setSize(28);
    fieldNUMBER.setSubSize(0);
    fieldNUMBER.setIsPrimaryKey(false);
    fieldNUMBER.setIsIdentity(false);
    fieldNUMBER.setUnique(false);
    fieldNUMBER.setShouldAllowNull(true);
    table.addField(fieldNUMBER);

    return table;
  }
  public TableDefinition buildContract_SoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CONTRACT_SOLDIER");

    FieldDefinition fieldContractId = new FieldDefinition();
    fieldContractId.setName("CONTRACT_ID");
    fieldContractId.setTypeName("NUMERIC");
    fieldContractId.setSize(15);
    fieldContractId.setShouldAllowNull(false);
    fieldContractId.setIsPrimaryKey(true);
    fieldContractId.setUnique(false);
    fieldContractId.setIsIdentity(false);
    fieldContractId.setForeignKeyFieldName("JPA_CONTRACT.ID");
    table.addField(fieldContractId);

    FieldDefinition fieldSoldierId = new FieldDefinition();
    fieldSoldierId.setName("SOLDIER_ID");
    fieldSoldierId.setTypeName("NUMERIC");
    fieldSoldierId.setSize(15);
    fieldSoldierId.setShouldAllowNull(false);
    fieldSoldierId.setIsPrimaryKey(true);
    fieldSoldierId.setUnique(false);
    fieldSoldierId.setIsIdentity(false);
    fieldSoldierId.setForeignKeyFieldName("JPA_SOLDIER.ID");
    table.addField(fieldSoldierId);

    return table;
  }
 /** INTERNAL: Return a TableDefinition specifying sequence table. */
 public TableDefinition buildTableDefinition() {
   TableDefinition definition = new TableDefinition();
   definition.setName(getSequenceTableName());
   definition.addPrimaryKeyField(getSequenceNameFieldName(), String.class, 50);
   definition.addField(getSequenceCounterFieldName(), BigDecimal.class);
   return definition;
 }
  public static TableDefinition buildPARTNERLINKTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_MW");

    FieldDefinition fieldMID = new FieldDefinition();
    fieldMID.setName("M");
    fieldMID.setTypeName("NUMERIC");
    fieldMID.setSize(15);
    fieldMID.setSubSize(0);
    fieldMID.setIsPrimaryKey(false);
    fieldMID.setIsIdentity(false);
    fieldMID.setUnique(false);
    fieldMID.setShouldAllowNull(true);
    fieldMID.setForeignKeyFieldName("XML_MAN.ID");
    table.addField(fieldMID);

    FieldDefinition fieldWID = new FieldDefinition();
    fieldWID.setName("W");
    fieldWID.setTypeName("NUMERIC");
    fieldWID.setSize(15);
    fieldWID.setSubSize(0);
    fieldWID.setIsPrimaryKey(false);
    fieldWID.setIsIdentity(false);
    fieldWID.setUnique(false);
    fieldWID.setShouldAllowNull(true);
    fieldWID.setForeignKeyFieldName("XML_WOMAN.ID");
    table.addField(fieldWID);

    return table;
  }
  public static TableDefinition buildEMPLOYEE_SEQTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_EMPLOYEE_SEQ");

    FieldDefinition fieldSEQ_COUNT = new FieldDefinition();
    fieldSEQ_COUNT.setName("SEQ_COUNT");
    fieldSEQ_COUNT.setTypeName("NUMBER");
    fieldSEQ_COUNT.setSize(15);
    fieldSEQ_COUNT.setSubSize(0);
    fieldSEQ_COUNT.setIsPrimaryKey(false);
    fieldSEQ_COUNT.setIsIdentity(false);
    fieldSEQ_COUNT.setUnique(false);
    fieldSEQ_COUNT.setShouldAllowNull(false);
    table.addField(fieldSEQ_COUNT);

    FieldDefinition fieldSEQ_NAME = new FieldDefinition();
    fieldSEQ_NAME.setName("SEQ_NAME");
    fieldSEQ_NAME.setTypeName("VARCHAR2");
    fieldSEQ_NAME.setSize(80);
    fieldSEQ_NAME.setSubSize(0);
    fieldSEQ_NAME.setIsPrimaryKey(true);
    fieldSEQ_NAME.setIsIdentity(false);
    fieldSEQ_NAME.setUnique(false);
    fieldSEQ_NAME.setShouldAllowNull(false);
    table.addField(fieldSEQ_NAME);

    return table;
  }
  public TableDefinition buildCHILDNAMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CHILDNAM");

    FieldDefinition fieldHOLDER_ID = new FieldDefinition();
    fieldHOLDER_ID.setName("HOLDER_ID");
    fieldHOLDER_ID.setTypeName("NUMBER");
    fieldHOLDER_ID.setSize(18);
    fieldHOLDER_ID.setSubSize(0);
    fieldHOLDER_ID.setIsPrimaryKey(true);
    fieldHOLDER_ID.setIsIdentity(false);
    fieldHOLDER_ID.setUnique(false);
    fieldHOLDER_ID.setShouldAllowNull(false);
    table.addField(fieldHOLDER_ID);

    FieldDefinition fieldCHILD_NAME = new FieldDefinition();
    fieldCHILD_NAME.setName("CHILD_NAME");
    fieldCHILD_NAME.setTypeName("VARCHAR2");
    fieldCHILD_NAME.setSize(30);
    fieldCHILD_NAME.setSubSize(0);
    fieldCHILD_NAME.setIsPrimaryKey(true);
    fieldCHILD_NAME.setIsIdentity(false);
    fieldCHILD_NAME.setUnique(false);
    fieldCHILD_NAME.setShouldAllowNull(false);
    table.addField(fieldCHILD_NAME);

    ForeignKeyConstraint foreignKeyFK_CHILDNAM_HOLDER_ID = new ForeignKeyConstraint();
    foreignKeyFK_CHILDNAM_HOLDER_ID.setName("CHILD_HOLDER");
    foreignKeyFK_CHILDNAM_HOLDER_ID.setTargetTable("HOLDER");
    foreignKeyFK_CHILDNAM_HOLDER_ID.addSourceField("HOLDER_ID");
    foreignKeyFK_CHILDNAM_HOLDER_ID.addTargetField("SSN");
    table.addForeignKeyConstraint(foreignKeyFK_CHILDNAM_HOLDER_ID);

    return table;
  }
  public static TableDefinition buildSALARYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_SALARY");

    FieldDefinition fieldEMP_ID = new FieldDefinition();
    fieldEMP_ID.setName("E_ID");
    fieldEMP_ID.setTypeName("NUMERIC");
    fieldEMP_ID.setSize(15);
    fieldEMP_ID.setSubSize(0);
    fieldEMP_ID.setIsPrimaryKey(true);
    fieldEMP_ID.setIsIdentity(false);
    fieldEMP_ID.setUnique(false);
    fieldEMP_ID.setShouldAllowNull(false);
    fieldEMP_ID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(fieldEMP_ID);

    FieldDefinition fieldSALARY = new FieldDefinition();
    fieldSALARY.setName("SALARY");
    fieldSALARY.setTypeName("NUMBER");
    fieldSALARY.setSize(15);
    fieldSALARY.setSubSize(0);
    fieldSALARY.setIsPrimaryKey(false);
    fieldSALARY.setIsIdentity(false);
    fieldSALARY.setUnique(false);
    fieldSALARY.setShouldAllowNull(true);
    table.addField(fieldSALARY);

    return table;
  }
  public static TableDefinition buildRESPONSTable() {
    TableDefinition table = new TableDefinition();
    // SECTION: TABLE
    table.setName("CMP3_XML_RESPONS");

    // SECTION: FIELD
    FieldDefinition field = new FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(false);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    FieldDefinition field1 = new FieldDefinition();
    field1.setName("DESCRIPTION");
    field1.setTypeName("VARCHAR");
    field1.setSize(200);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    return table;
  }
Esempio n. 16
0
  @SuppressWarnings({"unchecked", "deprecation"})
  private final <T extends TableDefinition> List<T> filterMasterDataTables(
      List<TableDefinition> list, boolean include) {
    List<T> result = new ArrayList<T>();

    definitionLoop:
    for (TableDefinition definition : list) {
      for (MasterDataTable table : configuredMasterDataTables) {
        if (definition.getName().equals(table.getName())) {

          // If we have a match, then add the table only if master
          // data tables are included in the result
          if (include) {
            log.info(
                "DEPRECATION",
                "Master data tables have been deprecated in jOOQ 2.5.0 and will be removed in jOOQ 3.0. Do not reuse this feature");
            result.add((T) new DefaultMasterDataTableDefinition(definition));
          }

          continue definitionLoop;
        }
      }

      // If we don't have any match, then add the table only if
      // master data tables are excluded in the result
      if (!include) {
        result.add((T) definition);
      }
    }

    return result;
  }
  public static TableDefinition buildTIREDETAILTable() {
    // 474752 :CREATE TABLE TIREDETAIL (ID NUMBER(10) NOT NULL, DETAIL VARCHAR2(255), PRIMARY KEY
    // (ID))
    TableDefinition table = new TableDefinition();
    table.setName("OR_TIREDETAIL");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("TIRE_ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(10);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setShouldAllowNull(false);
    fieldID.setUnique(false);
    table.addField(fieldID);

    FieldDefinition fieldDetail = new FieldDefinition();
    fieldDetail.setName("DETAIL");
    fieldDetail.setTypeName("VARCHAR");
    fieldDetail.setSize(255);
    fieldDetail.setSubSize(0);
    fieldDetail.setIsPrimaryKey(false);
    fieldDetail.setIsIdentity(false);
    fieldDetail.setShouldAllowNull(true);
    fieldDetail.setUnique(false);
    table.addField(fieldDetail);

    return table;
  }
  public TableDefinition buildVHCL_POLTable() {
    TableDefinition table = new TableDefinition();
    table.setName("VHCL_POL");

    FieldDefinition fieldPOL_ID = new FieldDefinition();
    fieldPOL_ID.setName("POL_ID");
    fieldPOL_ID.setTypeName("NUMBER");
    fieldPOL_ID.setSize(18);
    fieldPOL_ID.setSubSize(0);
    fieldPOL_ID.setIsPrimaryKey(true);
    fieldPOL_ID.setIsIdentity(false);
    fieldPOL_ID.setUnique(false);
    fieldPOL_ID.setShouldAllowNull(false);
    table.addField(fieldPOL_ID);

    FieldDefinition fieldMODEL = new FieldDefinition();
    fieldMODEL.setName("MODEL");
    fieldMODEL.setTypeName("VARCHAR2");
    fieldMODEL.setSize(30);
    fieldMODEL.setSubSize(0);
    fieldMODEL.setIsPrimaryKey(false);
    fieldMODEL.setIsIdentity(false);
    fieldMODEL.setUnique(false);
    fieldMODEL.setShouldAllowNull(true);
    table.addField(fieldMODEL);

    ForeignKeyConstraint foreignKeyFK_VHCL_POL_POL_ID = new ForeignKeyConstraint();
    foreignKeyFK_VHCL_POL_POL_ID.setName("VHCL_POL_POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.setTargetTable("POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.addSourceField("POL_ID");
    foreignKeyFK_VHCL_POL_POL_ID.addTargetField("POL_ID");
    table.addForeignKeyConstraint(foreignKeyFK_VHCL_POL_POL_ID);

    return table;
  }
  public static TableDefinition buildENGINETable() {
    // CREATE TABLE JPA_OR_ENGINE (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY KEY
    // (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_ENGINE");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(10);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setShouldAllowNull(false);
    fieldID.setUnique(false);
    table.addField(fieldID);

    FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
    fieldSERIALNUMBER.setName("SERIALNUMBER");
    fieldSERIALNUMBER.setTypeName("NUMERIC");
    fieldSERIALNUMBER.setSize(18);
    fieldSERIALNUMBER.setSubSize(0);
    fieldSERIALNUMBER.setIsPrimaryKey(false);
    fieldSERIALNUMBER.setIsIdentity(false);
    fieldSERIALNUMBER.setShouldAllowNull(true);
    fieldSERIALNUMBER.setUnique(false);
    table.addField(fieldSERIALNUMBER);

    return table;
  }
  public static TableDefinition buildCACHEABLE_FALSE_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_FALSE");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(true);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(true);
    table.addField(fieldID);

    FieldDefinition protectedFK = new FieldDefinition();
    protectedFK.setName("PROTECTED_FK");
    protectedFK.setTypeName("NUMERIC");
    protectedFK.setSize(15);
    protectedFK.setShouldAllowNull(true);
    protectedFK.setIsPrimaryKey(false);
    protectedFK.setUnique(false);
    protectedFK.setIsIdentity(false);
    table.addField(protectedFK);

    return table;
  }
  public static TableDefinition buildPROJECT_EMPTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_PROJ_EMP");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("PROJ_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_PROJECT.PROJ_ID");
    table.addField(field1);

    return table;
  }
Esempio n. 22
0
  public static TableDefinition tableDefinition() {
    TableDefinition table = new TableDefinition();

    table.setName("INT_COMP");
    table.addField("SERNUM", java.math.BigDecimal.class, 15);
    table.addField("DESCRIP", String.class, 50);

    return table;
  }
Esempio n. 23
0
  /** Return a platform independant definition of the LPROJECT database table. */
  public static TableDefinition tableDefinition() {
    TableDefinition definition = new TableDefinition();

    definition.setName("BUDGET");
    definition.addIdentityField("ID", BigInteger.class, 15);
    definition.addField("CUR", String.class, 3);
    definition.addField("AMNT", Double.class, 15, 2);

    return definition;
  }
Esempio n. 24
0
  public static TableDefinition tableDefinition() {
    TableDefinition definition = new TableDefinition();

    definition.setName("STUDENT2");

    definition.addPrimaryKeyField("COURSE_ID", java.math.BigDecimal.class, 15);
    definition.addField("PROF", String.class, 40);
    definition.addField("COURSENAME", String.class, 40);

    return definition;
  }
Esempio n. 25
0
  /**
   * Constructor.
   *
   * @param table table definition
   * @param data table data
   * @throws MPXJException
   */
  public FileRow(TableDefinition table, List<String> data) throws MPXJException {
    super(new HashMap<String, Object>());

    ColumnDefinition[] columns = table.getColumns();
    for (int index = 0; index < columns.length; index++) {
      ColumnDefinition column = columns[index];
      if (index < data.size()) {
        m_map.put(
            column.getName(),
            getColumnValue(table.getName(), column.getName(), data.get(index), column.getType()));
      }
    }
  }
  /** Return a platform independant definition of the database table. */
  public static TableDefinition tableDefinition(Session session) {
    TableDefinition definition = TypeTester.tableDefinition();
    FieldDefinition fieldDef;

    definition.setName("BOOLEANS");
    fieldDef = new FieldDefinition("BOOLEANV", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    fieldDef = new FieldDefinition("BOOLEANC", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    return definition;
  }
  public static TableDefinition buildSUB_CACHEABLE_NONE_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_SUB_CACHEABLE_NONE");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(true);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(true);
    table.addField(fieldID);

    return table;
  }
  public static TableDefinition buildREADONLYCLASSTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_READONLY");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("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);

    return table;
  }
  public static TableDefinition buildWHEELRIMTable() {
    // CREATE TABLE JPA_OR_WHEEL_RIM (ID NUMBER(10) NOT NULL, PRIMARY KEY (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_WHEEL_RIM");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(10);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setShouldAllowNull(false);
    fieldID.setUnique(false);
    table.addField(fieldID);

    return table;
  }
Esempio n. 30
0
 public PartitionManager(TableDefinition tableDefinition) {
   this.tableDefinition = tableDefinition;
   this.partitioningSpec = tableDefinition.getPartitioningSpec();
   if (partitioningSpec.type == _type.NONE
       || partitioningSpec.type == _type.VALUE) { // pcache never changes in this case
     pcache = new Interval(TimeEncoding.MIN_INSTANT, TimeEncoding.MAX_INSTANT);
     intervals.put(TimeEncoding.MIN_INSTANT, pcache);
   }
 }