Package org.apache.torque.util

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

335
336
337
338
339
340
341
342
343
344
345
    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
360
361
362
363
364
365
366
367
368
369
370
    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
434
435
436
437
438
439
440
441
442
443
444
    public void testAsColumnWithIgnoreCaseStringColumnAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", stringColumnMap);
        criteria.addSelectColumn("columnAlias");
        criteria.add("columnAlias", "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try
        {
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
    public void testAsColumnWithIgnoreCaseIntegerColumnAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", integerColumnMap);
        criteria.addSelectColumn("columnAlias");
        criteria.add("columnAlias", "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try
        {
View Full Code Here
483
484
485
486
487
488
489
490
491
492
493
    public void testInnerJoinImplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column");
        criteria.addJoin("table1.column1", "table2.column2");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column FROM table1, table2"
                    + " WHERE table1.column1=table2.column2",
View Full Code Here
497
498
499
500
501
502
503
504
505
506
507
    public void testInnerJoinExplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin(
                "table1.column1",
                "table2.column2",
                Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
513
514
515
516
517
518
519
520
521
522
523
    public void testInnerJoinWithExcplicitExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // second join condition must be changed in order to satisfy
        // first join condition
View Full Code Here
532
533
534
535
536
537
538
539
540
541
542
    public void testInnerJoinExcplicitWithExistingRightAndLeftTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table4.column4", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.INNER_JOIN);
        try
        {
View Full Code Here
554
555
556
557
558
559
560
561
562
563
564
    public void testLeftJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table1.column", "table2.column", Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column1"
                    + " FROM table1 LEFT JOIN table2"
View Full Code Here
568
569
570
571
572
573
574
575
576
577
578
    public void testLeftJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // left join must be converted to right join to satisfy
        // first join condition
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.