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

org.apache.ws.jaxme.sqls.Index

Interface of an index declaration.
@author Jochen Wiedmann

    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

    
    /** <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 = getSQLGenerator();
        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

  public Table getTable() { return table; }
  public String getQName() { return getTable().getQName() + "." + getName(); }
  public boolean isVirtual() { return false; }


  public boolean isPrimaryKeyPart() {
    Index index = getTable().getPrimaryKey();
    if (index == null) {
      return false;
    }
    for (Iterator iter = index.getColumns();  iter.hasNext();  ) {
      Column column = (Column) iter.next();
      if (column.equals(this)) {
        return true;
      }
    }

View Full Code Here

      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

      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

    final String mName = "readPrimaryKey";
    logger.finest(mName, "Looking for primary keys of " + pTable + "=" + pTable.getTable().getQName());
    ResultSet rs = pData.getPrimaryKeys(pTable.getCatalogName(),
                                        pTable.getSchemaName(),
                                        pTable.getTableName());
    Index primaryKey = null;
    boolean isRsClosed = false;
    try {
      while (rs.next()) {
        if (primaryKey == null) {
          primaryKey = pTable.getTable().newPrimaryKey();
        } 


        String columnName = rs.getString(4);
        logger.finest(mName, "Found column " + columnName);
        primaryKey.addColumn(columnName);
      }


      isRsClosed = true;
      rs.close();
    } finally {

View Full Code Here

0 1 2 3 4 5 6

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

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.