Examples of newPrimaryKey()

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

116
117
118
119
120
121
122
123
124
125
126
  /** <p>Creates a table with primary key</p>
   */
  protected Table getPrimaryKeyTable() {
    Table table = getBasicTable();
    Index index = table.newPrimaryKey();
    index.addColumn("MyIndex");
    return table;
  }

  protected Table getForeignKeyTable(Table pTable) {
View Full Code Here

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

127
128
129
130
131
132
133
134
135
136
137
     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"));
     return otherTable;
  }
View Full Code Here

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

296
297
298
299
300
301
302
303
304
305
306
    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();
    deleteStatement.setTable(table);
View Full Code Here

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

121
122
123
124
125
126
127
128
129
130
131
        mtName.setLength(60);
        BinaryColumn mtSig = (BinaryColumn) mt.newColumn("SIG", Column.Type.BINARY);
        mtSig.setLength(16);
        mt.newColumn("DATE", Column.Type.DATE);

        Index primaryKey = mt.newPrimaryKey();
        primaryKey.addColumn(mtId);
        primaryKey.addColumn(mtVer);
        mainTable = mt;
     }
     return mainTable;
View Full Code Here

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

143
144
145
146
147
148
149
150
151
152
153
      stAddress.setLength(60);
      StringColumn stEmail = (StringColumn) st.newColumn("EMAIL", Column.Type.VARCHAR);
      stEmail.setLength(60);
      stEmail.setNullable(true);

      Index primaryKey = st.newPrimaryKey();
      primaryKey.addColumn(stId);

      ForeignKey foreignKey = st.newForeignKey(getMainTable());
      foreignKey.addColumnLink(stMtId, getMainTable().getColumn("ID"));
      foreignKey.addColumnLink(stMtVer, getMainTable().getColumn("VER"));
View Full Code Here

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

89
90
91
92
93
94
95
96
97
98
99
      mtName.setLength(60);
      BinaryColumn mtSig = (BinaryColumn) mt.newColumn("SIG", Column.Type.BINARY);
      mtSig.setLength(16);
      mt.newColumn("DATE", Column.Type.DATE);
     
      Index primaryKey = mt.newPrimaryKey();
      primaryKey.addColumn(mtId);
      primaryKey.addColumn(mtVer);
      mainTable = mt;
    }
    return mainTable;
View Full Code Here

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

111
112
113
114
115
116
117
118
119
120
121
      stAddress.setLength(60);
      StringColumn stEmail = (StringColumn) st.newColumn("EMAIL", Column.Type.VARCHAR);
      stEmail.setLength(60);
      stEmail.setNullable(true);
     
      Index primaryKey = st.newPrimaryKey();
      primaryKey.addColumn(stId);
     
      ForeignKey foreignKey = st.newForeignKey(getMainTable());
      foreignKey.addColumnLink(stMtId, getMainTable().getColumn("ID"));
      foreignKey.addColumnLink(stMtVer, getMainTable().getColumn("VER"));
View Full Code Here

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

95
96
97
98
99
100
101
102
103
104
105
   
    /** <p>Creates a table with primary key</p>
     */
    protected Table getPrimaryKeyTable() {
        Table table = getBasicTable();
        Index index = table.newPrimaryKey();
        index.addColumn("MyIndex");
        return table;
    }
   
    protected Table getForeignKeyTable(Table pTable) {
View Full Code Here

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

106
107
108
109
110
111
112
113
114
115
116
        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"));
        return otherTable;
    }
View Full Code Here

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

336
337
338
339
340
341
342
343
344
345
346
        SQLGenerator gen = getSQLGenerator();
        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();
        deleteStatement.setTable(table);
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.