Package org.apache.torque

Examples of org.apache.torque.ColumnImpl

527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
        c.setIgnoreCase(true);
        c.setSingleRecord(true);
        c.setDbName("myDB");
        c.setAll();
        c.setDistinct();
        c.addSelectColumn(new ColumnImpl("Author", "NAME"));
        c.addSelectColumn(new ColumnImpl("Author", "AUTHOR_ID"));
        c.addDescendingOrderByColumn(new ColumnImpl("Author", "NAME"));
        c.addAscendingOrderByColumn(new ColumnImpl("Author", "AUTHOR_ID"));
        c.addAlias("Writer", "Author");
        c.addAsColumn("AUTHOR_NAME", new ColumnImpl("Author", "NAME"));
        c.addJoin(new ColumnImpl("Author", "AUTHOR_ID"), new ColumnImpl("Book", "AUTHOR_ID"), Criteria.INNER_JOIN);
        c.add(new ColumnImpl("Author", "NAME"), "author%", Criteria.LIKE);

        // Some direct Criterion checks
        Criterion cn = c.getCriterion(new ColumnImpl("Author", "NAME"));
        cn.setIgnoreCase(true);
        assertEquals("author%", cn.getValue());
        assertEquals(Criteria.LIKE, cn.getComparison());
        Criterion cnDirectClone = (Criterion) SerializationUtils.clone(cn);
        assertEquals(cn, cnDirectClone);

        // Clone the object
        Criteria cClone = (Criteria) SerializationUtils.clone(c);

        // Check the clone
        assertEquals(c.size(), cClone.size());
        assertEquals(10, cClone.getOffset());
        assertEquals(c.getOffset(), cClone.getOffset());
        assertEquals(11, cClone.getLimit());
        assertEquals(c.getLimit(), cClone.getLimit());
        assertEquals(true, cClone.isIgnoreCase());
        assertEquals(c.isIgnoreCase(), cClone.isIgnoreCase());
        assertEquals(true, cClone.isSingleRecord());
        assertEquals(c.isSingleRecord(), cClone.isSingleRecord());
        assertEquals("myDB", cClone.getDbName());
        assertEquals(c.getDbName(), cClone.getDbName());
        List selectModifiersClone = cClone.getSelectModifiers();
        assertTrue(selectModifiersClone.contains(Criteria.ALL.toString()));
        assertTrue(selectModifiersClone.contains(Criteria.DISTINCT.toString()));
        assertEquals(c.getSelectModifiers(), cClone.getSelectModifiers());
        List selectColumnsClone = cClone.getSelectColumns();
        assertTrue(selectColumnsClone.contains(new ColumnImpl("Author", "NAME")));
        assertTrue(selectColumnsClone.contains(new ColumnImpl("Author", "AUTHOR_ID")));
        assertEquals(c.getSelectColumns(), cClone.getSelectColumns());
        List orderByColumnsClone = cClone.getOrderByColumns();
        assertTrue(orderByColumnsClone.contains(new OrderBy(new ColumnImpl("Author.NAME"), SqlEnum.DESC, false)));
        assertTrue(orderByColumnsClone.contains(new OrderBy(new ColumnImpl("Author.AUTHOR_ID"), SqlEnum.ASC, false)));
        assertEquals(c.getOrderByColumns(), cClone.getOrderByColumns());
        Map aliasesClone = cClone.getAliases();
        assertTrue(aliasesClone.containsKey("Writer"));
        assertEquals("Author", aliasesClone.get("Writer"));
        assertEquals(c.getAliases(), cClone.getAliases());
        Map asColumnsClone = cClone.getAsColumns();
        assertTrue(asColumnsClone.containsKey("AUTHOR_NAME"));
        assertEquals(new ColumnImpl("Author", "NAME"), asColumnsClone.get("AUTHOR_NAME"));
        assertEquals(c.getAsColumns(), cClone.getAsColumns());

        // Check Joins
        List joinsClone = cClone.getJoins();
        Join joinClone = (Join) joinsClone.get(0);
        assertEquals(
                new ColumnImpl("Author", "AUTHOR_ID"),
                joinClone.getJoinCondition().getLValue());
        assertEquals(new ColumnImpl("Book", "AUTHOR_ID"),
                joinClone.getJoinCondition().getRValue());
        assertEquals(Criteria.INNER_JOIN, joinClone.getJoinType());
        assertEquals(c.getJoins(), cClone.getJoins());

        // Some Criterion checks
        Criterion cnClone = cClone.getCriterion(new ColumnImpl("Author", "NAME"));
        assertEquals("author%", cnClone.getValue());
        assertEquals(Criteria.LIKE, cnClone.getComparison());
        assertEquals(cn.isIgnoreCase(), cnClone.isIgnoreCase());

        // Confirm that equals() checks all of the above.
View Full Code Here
611
612
613
614
615
616
617
618
619
620
621
     * Criteria object.
     * @throws TorqueException
     */
    public void testEquals() throws TorqueException
    {
        c.addSelectColumn(new ColumnImpl("Author", "NAME"));
        c.addSelectColumn(new ColumnImpl("Author", "AUTHOR_ID"));
        c.add(new ColumnImpl("Author", "NAME"), "foobar");
        Criteria cClone = (Criteria) SerializationUtils.clone(c);
        assertTrue(c.equals(cClone));
    }
View Full Code Here
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
        columnMap.setType(new Integer(0));
        tableMap.addColumn(columnMap);

        // check that alias'ed tables are referenced by their alias
        // name when added to the select clause.
        c.addSelectColumn(new ColumnImpl("AUTHOR", "NAME"));
        c.addAlias("a", "AUTHOR");
        c.addJoin(new ColumnImpl("AUTHOR", "AUTHOR_ID"),
                new ColumnImpl("a", "AUTHOR_ID"));
        c.addAscendingOrderByColumn(
                new ColumnImpl("a", "NAME"));

        Query result = SqlBuilder.buildQuery(c);
        assertEquals("SELECT AUTHOR.NAME, a.NAME "
                    + "FROM AUTHOR, AUTHOR a "
                    + "WHERE AUTHOR.AUTHOR_ID=a.AUTHOR_ID "
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
public class JoinTest extends BaseTestCase
{
    public void testHashCodeAndEquals()
    {
        Join join = new Join(
                new ColumnImpl("myTable1", "myColumn1"),
                new ColumnImpl("myTable2", "myColumn2"),
                Criteria.EQUAL,
                Criteria.LEFT_JOIN);
        Join compareToJoin = new Join(
                new ColumnImpl("myTable1", "myColumn1"),
                new ColumnImpl("myTable2", "myColumn2"),
                Criteria.EQUAL,
                Criteria.LEFT_JOIN);
        assertEquals(join.hashCode(), compareToJoin.hashCode());
        assertEquals(join, compareToJoin);
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58

    public void testToString()
    {
        Join join = new Join(
                new ColumnImpl("myTable1", "myColumn1"),
                new ColumnImpl("myTable2", "myColumn2"),
                Criteria.NOT_EQUAL,
                Criteria.LEFT_JOIN);
        assertEquals(" LEFT JOIN (null, null): "
                    + "myTable1.myColumn1<>myTable2.myColumn2",
                join.toString());
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
        {
            return;
        }

        Criteria subquery = new Criteria();
        subquery.addSelectColumn(new ColumnImpl("count(*)"));
        subquery.where(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        subquery.and(BookPeer.TITLE, book3.getTitle());
        subquery.addFrom(BookPeer.TABLE_NAME);
        Criteria criteria = new Criteria();
        criteria.where(subquery, 1);
View Full Code Here
316
317
318
319
320
321
322
323
     *
     * @return A modified Criteria object.
     */
    public Criteria addAsColumn(String name, String clause)
    {
        asColumns.put(name, new ColumnImpl(clause));
        return this;
    }
View Full Code Here
381
382
383
384
385
386
387
     *             manually with another key).
     */
    @Deprecated
    public boolean containsKey(String table, String column)
    {
        return containsTopLevelColumn(new ColumnImpl(table, column));
    }
View Full Code Here
434
435
436
437
438
439
440
     * @param column the column to get the criterion for.
     * @return A Criterion.
     */
    public Criterion getCriterion(String column)
    {
        return getCriterion(new ColumnImpl(column));
    }
View Full Code Here
446
447
448
449
450
451
452
     * @param column String name of column.
     * @return A Criterion.
     */
    public Criterion getCriterion(String table, String column)
    {
        return getCriterion(new ColumnImpl(table, column));
    }
View Full Code Here
TOP

Related Classes of org.apache.torque.ColumnImpl

  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.torque.criteria.CriteriaTest
  • org.apache.torque.criteria.CriterionTest
  • org.apache.torque.criteria.JoinTest
  • org.apache.torque.datatypes.BooleanIntCharTest
  • org.apache.torque.generated.peer.JoinTest
  • org.apache.torque.generated.peer.WhereClauseSubselectTest
  • org.apache.torque.sql.SqlBuilder
  • org.apache.torque.sql.SqlBuilderTest
    • 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.