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

org.apache.ws.jaxme.sqls.Index

Interface of an index declaration.
@author Jochen Wiedmann

      return result;
  }


   public Index getPrimaryKey() {
      for (Iterator iter = getIndexes();  iter.hasNext();  ) {
         Index index = (Index) iter.next();
         if (index.isPrimaryKey()) {
            return index;
         }
      }
      return null;
   }

View Full Code Here

   public Iterator getIndexes() {
      return indexes.iterator();
   }


  public Index newPrimaryKey() {
      Index pk = getPrimaryKey();
      if (pk != null) {
         throw new IllegalStateException("A primary key is already defined on table " + getName());
      }
      Index result = new IndexImpl(this, true, true);
      indexes.add(result);
      return result;
  }

View Full Code Here


  /** <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

  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

   */
  public void testIndexNames() {
    SQLGenerator gen = sqlFactory.newSQLGenerator();
    Table table = getBasicTable();
    for (int i = 0;  i < 10;  i++) {
      Index index = table.newIndex();
      index.addColumn("MyName");
      String s = (String) gen.getCreate(index).iterator().next();
      assertEquals("CREATE INDEX MyTable_I" + i + " ON MySchema.MyTable (MyName)", s);
    }


    Collection coll = gen.getCreate(schema, true);

View Full Code Here

   * 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

      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

  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


  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

          }
          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

0 1 2 3 4 5 6 7 8 9

TOP

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

codec.asn1.ASN1ObjectIdentifier

codec.asn1.ASN1OpenType

codec.asn1.ASN1Sequence

codec.asn1.ASN1Set

codec.asn1.ASN1Type

codec.asn1.DEREncoder

codec.pkcs7.RecipientInfo

codec.pkcs7.SignerInfo

codec.util.CertificateStore$IdxKey

codec.x509.GeneralName

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.