Package org.apache.ws.jaxme.sqls

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

298
299
300
301
302
303
304
305
306
307
308
309
310
    Table otherTable = getForeignKeyTable(table);
    SelectStatement statement = table.getSelectStatement();
    SelectTableReference tableReference = statement.getSelectTableReference();
    SelectStatement existsStatement = otherTable.getSelectStatement();
    SelectTableReference existsTableReference = existsStatement.getSelectTableReference();
    BooleanConstraint bc = existsStatement.getWhere().createEQ();
    bc.addPart(existsTableReference.newColumnReference("RefIndex"));
    bc.addPart(tableReference.newColumnReference("MyIndex"));
    statement.getWhere().createEXISTS(existsStatement);
  
    SQLGenerator generator = getSQLGenerator();
    generator.setLineTerminator("\n");
    String got = generator.getQuery(statement);
View Full Code Here
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
      if (column.isPrimaryKeyPart()) {
        selectStatement.addResultColumn(selectStatement.getTableReference().newColumnReference(refColumn));
        columns.add(deleteStatement.getTableReference().newColumnReference(column));
      }
    }
    BooleanConstraint eq = selectStatement.getWhere().createEQ();
    eq.addPart(selectStatement.getTableReference().newColumnReference("RefMyName"));
    eq.addPlaceholder();

    BooleanConstraint bc = deleteStatement.getWhere().createIN();
    bc.addPart((ColumnReference[]) columns.toArray(new ColumnReference[columns.size()]));
    bc.addPart(selectStatement);
    String expect = "DELETE FROM MySchema.MyTable WHERE (MyIndex, VerNum) IN ((SELECT RefMyIndex, RefVerNum FROM MySchema.OtherTable WHERE RefMyName=?))";
    String got = gen.getQuery(deleteStatement);
    assertEquals(expect, got);
  }
View Full Code Here
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
        return getCombinedConstraint(selectStatementMetaData, cc);
      } else {
        return getCombinedConstraint(null, cc);
      }
    } else if (pConstraint instanceof BooleanConstraint) {
      BooleanConstraint bc = (BooleanConstraint) pConstraint;
      Statement st = bc.getConstrainedStatement();
      if (st instanceof SelectStatement) {
        SelectStatementMetaData selectStatementMetaData = new SelectStatementMetaData((SelectStatement) st);
        return getBooleanConstraint(selectStatementMetaData, bc);
      } else {
        return getBooleanConstraint(null, bc);
View Full Code Here
TOP

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

  • org.apache.ws.jaxme.sqls.impl.CombinedConstraintImpl
  • org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl
  • org.apache.ws.jaxme.sqls.junit.CreateTest
  • org.apache.ws.jaxme.sqls.junit.JoinTest
  • org.apache.ws.jaxme.sqls.junit.Oracle8Test
    • 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.