Package org.apache.torque.util

Examples of org.apache.torque.util.Criteria.addAlias()

270
271
272
273
274
275
276
277
278
279
280
    }

    public void testAliasWithDefaultSchema() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
View Full Code Here
291
292
293
294
295
296
297
298
299
300
301
    }

    public void testAliasWithIgnoreCaseUnknownColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        criteria.add("alias.column1", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
    }

    public void testAliasWithIgnoreCaseStringColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN1");
        criteria.add("alias.COLUMN1", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
    }

    public void testAliasWithIgnoreCaseIntegerColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN4");
        criteria.add("alias.COLUMN4", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
View Full Code Here
334
335
336
337
338
339
340
341
342
343
344
    public void testAliasWithIgnoreCaseStringColumnTypeAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN1");
        criteria.add("alias.COLUMN1", "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
    public void testAliasWithIgnoreCaseIntegerColumnTypeAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN4");
        criteria.add("alias.COLUMN4", "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try
View Full Code Here
621
622
623
624
625
626
627
628
629
630
631
    public void testInnerJoinImplicitWithAlias()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table1 alias, table2"
                    + " WHERE alias.column=table2.column",
View Full Code Here
635
636
637
638
639
640
641
642
643
644
645
    public void testInnerJoinImplicitWithAliasAndAsColumn()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("x", "alias.column");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("x", "table2.column");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column AS x FROM table2, table1 alias"
                    + " WHERE x=table2.column",
View Full Code Here
674
675
676
677
678
679
680
681
682
683
684
    public void testInnerJoinImplicitWithAliasAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.