Examples of org.apache.torque.criteria.Criteria.addJoin()

Class org.apache.torque.criteria.Criteria

Examples of org.apache.torque.criteria.Criteria.addJoin()

org.apache.torque.criteria.Criteria.addJoin()
Adds a join to the criteria, E.g. to create the condition
AND PROJECT.PROJECT_ID=FOO.PROJECT_ID
use
criteria.addJoin(ProjectPeer.PROJECT_ID, FooPeer.PROJECT_ID) @param left A String with the left side of the join. @param right A String with the right side of the join. @return A modified Criteria object.

                new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
        criteria.addJoin(
                new ColumnImpl("table1.column1"),
                new ColumnImpl("table2.column2"),
                Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // right join must be converted to left join to satisfy

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(
                new ColumnImpl("alias.column"),
                new ColumnImpl("table2.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table1 alias, table2"

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("x", new ColumnImpl("alias.column"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(new ColumnImpl("x"), new ColumnImpl("table2.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column AS x FROM table2, table1 alias"
                    + " WHERE x=table2.column",
                query.toString());

View Full Code Here

    public void testInnerJoinImplicitWithDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("*"));
        criteria.addJoin(
                new ColumnImpl("table1.column"),
                new ColumnImpl("table2.column"));
        String oldSchema = database.getSchema();
        try
        {

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(
                new ColumnImpl("alias.column"),
                new ColumnImpl("table2.column"));
        String oldSchema = database.getSchema();
        try
        {

View Full Code Here

    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(
                new ColumnImpl("schema1.alias.column1"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(
                new ColumnImpl("schema1.alias.column"),
                new ColumnImpl("schema2.table2.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM schema1.table1 alias, schema2.table2"

View Full Code Here

            .where(new ColumnImpl("table2.column2b"), "x");


        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        criteria.addAlias("alias", subquery);
        criteria.addJoin(
                new ColumnImpl("alias.column1"),
                new ColumnImpl("table2.column2"));


        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

        Criterion join = new Criterion(join1).and(join2).and(join3);


        Criteria criteria = new Criteria();
        criteria.setDbName(databasePostgresql.getName());
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin("table1", "table2", join, null);
        criteria.where(new ColumnImpl("table1.column3"), null, Criteria.ISNULL);


        Query query = SqlBuilder.buildQuery(criteria);


        assertEquals(

View Full Code Here

0 1 2 3 4

TOP

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.