Package org.apache.ws.jaxme.sqls

Examples of org.apache.ws.jaxme.sqls.Index

227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
   * a <code>FOREIGN KEY</code> clause.</p>
   */
  protected boolean isForeignKeyPartOfCreateTable() { return false; }

  protected String createPrimaryKeyAsPartOfCreateTable(Table pTable) {
    Index index = pTable.getPrimaryKey();
    if (index == null) {
      return null;
    }
    StringBuffer sb = new StringBuffer();
    sb.append("PRIMARY KEY").append(" (");
    boolean first = true;
    for (Iterator iter = index.getColumns();  iter.hasNext();  ) {
      if (first) {
        first = false;
      } else {
        sb.append(", ");
      }
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
      sb.append(s).append(getCreate((Column) iter.next()));
      s = "," + lf + indent;
    }

    for (Iterator iter = pTable.getIndexes();  iter.hasNext();  ) {
      Index index = (Index) iter.next();
      String st;
      if (index.isPrimaryKey()  &&  !isPrimaryKeyUniqueIndex()) {
        if (!isPrimaryKeyPartOfCreateTable()) {
          continue;
        }
        st = createPrimaryKeyAsPartOfCreateTable(pTable);
      } else if (index.isUnique()) {
        if (!isUniqueIndexPartOfCreateTable()) {
          continue;
        }
        st = createIndexAsPartOfCreateTable(index);
      } else {
View Full Code Here
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
  public Collection getCreate(Table pTable, boolean pAll) {
    if (!pAll) { return getCreate(pTable); }
    List result = new ArrayList();
    result.addAll(getCreate(pTable));
    for (Iterator iter = pTable.getIndexes();  iter.hasNext();  ) {
      Index index = (Index) iter.next();
      if (index.isPrimaryKey() && !isPrimaryKeyUniqueIndex()) {
        if (isPrimaryKeyPartOfCreateTable()) {
          continue;
        }
      } else if (index.isUnique()) {
        if (isUniqueIndexPartOfCreateTable()) {
          continue;
        }
      } else {
        if (isNonUniqueIndexPartOfCreateTable()) {
View Full Code Here
913
914
915
916
917
918
919
920
921
922
923
  public Collection getDrop(Table pTable, boolean pAll) {
    if (!pAll) { return getDrop(pTable); }
    List result = new ArrayList();
    for (Iterator iter = pTable.getIndexes();  iter.hasNext();  ) {
      Index index = (Index) iter.next();
      result.addAll(getDrop(index));
    }
    for (Iterator iter = pTable.getForeignKeys();  iter.hasNext();  ) {
      ForeignKey key = (ForeignKey) iter.next();
      result.addAll(getDrop(key));
View Full Code Here
367
368
369
370
371
372
373
374
375
376
377
378
379
          }
          isFirstTable = false;
          columnUpdater = new VerNumIncrementer(columnNum);
        } else {
          List pkColumns = new ArrayList();
          Index primaryKey = table.getPrimaryKey();
          if (primaryKey != null) {
            for (Iterator pkIter = primaryKey.getColumns();  pkIter.hasNext();  ) {
              Column pkColumn = (Column) pkIter.next();
              int columnNum = -1;
              int i = 0;
              for (Iterator colIter = table.getColumns();  colIter.hasNext();  i++) {
                Column colIterColumn = (Column) colIter.next();
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
        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
143
144
145
146
147
148
149
150
151
152
153
154
      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
89
90
91
92
93
94
95
96
97
98
99
100
      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
111
112
113
114
115
116
117
118
119
120
121
122
      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
95
96
97
98
99
100
101
102
103
   
    /** <p>Creates a table with primary key</p>
     */
    protected Table getPrimaryKeyTable() {
        Table table = getBasicTable();
        Index index = table.newPrimaryKey();
        index.addColumn("MyIndex");
        return table;
    }
View Full Code Here
TOP

Related Classes of org.apache.ws.jaxme.sqls.Index

  • org.apache.ws.jaxme.js.junit.VersionTest
  • org.apache.ws.jaxme.js.pattern.Ant$AntVersionGenerator
  • org.apache.ws.jaxme.sqls.impl.ColumnImpl
  • org.apache.ws.jaxme.sqls.impl.SQLFactoryImpl
  • org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl
  • org.apache.ws.jaxme.sqls.impl.TableImpl
  • org.apache.ws.jaxme.sqls.junit.CreateTest
    • Copyright © 2018 www.massapicom. 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.