Examples of newColumn()

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

98
99
100
101
102
103
104
105
106
107
108
  /** <p>Creates a basic table</p>
   */
  protected Table getBasicTable() {
    Table table = schema.newTable("MyTable");
    Column myIndex = table.newColumn("MyIndex", Column.Type.INTEGER);
    assertTrue(!myIndex.isStringColumn());
    assertTrue(!myIndex.isBinaryColumn());
    Column myName = table.newColumn("MyName", Column.Type.VARCHAR);
    assertTrue(myName.isStringColumn()); // myName may be casted to a StringColumn
    assertTrue(!myName.isBinaryColumn());
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

101
102
103
104
105
106
107
108
109
110
111
  protected Table getBasicTable() {
    Table table = schema.newTable("MyTable");
    Column myIndex = table.newColumn("MyIndex", Column.Type.INTEGER);
    assertTrue(!myIndex.isStringColumn());
    assertTrue(!myIndex.isBinaryColumn());
    Column myName = table.newColumn("MyName", Column.Type.VARCHAR);
    assertTrue(myName.isStringColumn()); // myName may be casted to a StringColumn
    assertTrue(!myName.isBinaryColumn());
    ((StringColumn) myName).setLength(60);
    Column myDate = table.newColumn("MyDate", Column.Type.DATE);
    assertTrue(!myDate.isStringColumn());
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

105
106
107
108
109
110
111
112
113
114
115
    assertTrue(!myIndex.isBinaryColumn());
    Column myName = table.newColumn("MyName", Column.Type.VARCHAR);
    assertTrue(myName.isStringColumn()); // myName may be casted to a StringColumn
    assertTrue(!myName.isBinaryColumn());
    ((StringColumn) myName).setLength(60);
    Column myDate = table.newColumn("MyDate", Column.Type.DATE);
    assertTrue(!myDate.isStringColumn());
    assertTrue(!myDate.isBinaryColumn());
    myDate.setNullable(true);
    return table;
  }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

123
124
125
126
127
128
129
130
131
132
133
    return table;
  }

  protected Table getForeignKeyTable(Table pTable) {
     Table otherTable = pTable.getSchema().newTable("OtherTable");
     Column otherIndex = otherTable.newColumn("MyIndex", Column.Type.INTEGER);
     Column referenceColumn = otherTable.newColumn("RefIndex", Column.Type.INTEGER);
     Column companyColumn = otherTable.newColumn("Company", Column.Type.VARCHAR);
     ((StringColumn) companyColumn).setLength(60);
     otherTable.newPrimaryKey().addColumn(otherIndex);
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

124
125
126
127
128
129
130
131
132
133
134
  }

  protected Table getForeignKeyTable(Table pTable) {
     Table otherTable = pTable.getSchema().newTable("OtherTable");
     Column otherIndex = otherTable.newColumn("MyIndex", Column.Type.INTEGER);
     Column referenceColumn = otherTable.newColumn("RefIndex", Column.Type.INTEGER);
     Column companyColumn = otherTable.newColumn("Company", Column.Type.VARCHAR);
     ((StringColumn) companyColumn).setLength(60);
     otherTable.newPrimaryKey().addColumn(otherIndex);

     ForeignKey reference = otherTable.newForeignKey(pTable);
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

125
126
127
128
129
130
131
132
133
134
135
  protected Table getForeignKeyTable(Table pTable) {
     Table otherTable = pTable.getSchema().newTable("OtherTable");
     Column otherIndex = otherTable.newColumn("MyIndex", Column.Type.INTEGER);
     Column referenceColumn = otherTable.newColumn("RefIndex", Column.Type.INTEGER);
     Column companyColumn = otherTable.newColumn("Company", Column.Type.VARCHAR);
     ((StringColumn) companyColumn).setLength(60);
     otherTable.newPrimaryKey().addColumn(otherIndex);

     ForeignKey reference = otherTable.newForeignKey(pTable);
     reference.addColumnLink(referenceColumn, pTable.getColumn("MyIndex"));
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

245
246
247
248
249
250
251
252
253
254
255
  /** <p>Creates a table with a composed primary key.</p>
   */
  protected Table getComposedKeyTable() {
    Table table = getPrimaryKeyTable();
    Column verNumColumn = table.newColumn("VerNum", Column.Type.INTEGER);
    assertTrue(!verNumColumn.isStringColumn());
    assertTrue(!verNumColumn.isBinaryColumn());
    Index index = table.getPrimaryKey();
    index.addColumn("VerNum");
    return table;
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

295
296
297
298
299
300
301
302
303
304
305
  public void testSubSelect() {
    SQLGenerator gen = sqlFactory.newSQLGenerator();
    Table table = getComposedKeyTable();

    Table otherTable = table.getSchema().newTable("OtherTable");
    Column otherIndex = otherTable.newColumn("MyIndex", Column.Type.INTEGER);
    otherTable.newPrimaryKey().addColumn(otherIndex);
    ForeignKey foreignKey = otherTable.newForeignKey(table);
    SelectStatement selectStatement = sqlFactory.newSelectStatement();
    selectStatement.setTable(otherTable);
    DeleteStatement deleteStatement = sqlFactory.newDeleteStatement();
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

305
306
307
308
309
310
311
312
313
314
315
    DeleteStatement deleteStatement = sqlFactory.newDeleteStatement();
    deleteStatement.setTable(table);
    List columns = new ArrayList();
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
      Column column = (Column) iter.next();
      Column refColumn = otherTable.newColumn("Ref" + column.getName(), column.getType());
      foreignKey.addColumnLink(refColumn, column);
      if (column.isPrimaryKeyPart()) {
        selectStatement.addResultColumn(selectStatement.getTableReference().newColumnReference(refColumn));
        columns.add(deleteStatement.getTableReference().newColumnReference(column));
      }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.Table.newColumn()

113
114
115
116
117
118
119
120
121
122
123
  }

  protected Table getMainTable() {
     if (mainTable == null) {
        Table mt = getSchema().newTable("MAIN");
        Column mtId = mt.newColumn("ID", Column.Type.BIGINT);
        Column mtVer = mt.newColumn("VER", Column.Type.INTEGER);
        StringColumn mtName = (StringColumn) mt.newColumn("NAME", Column.Type.VARCHAR);
        mtName.setLength(60);
        BinaryColumn mtSig = (BinaryColumn) mt.newColumn("SIG", Column.Type.BINARY);
        mtSig.setLength(16);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.