Package org.apache.torque.sql

Examples of org.apache.torque.sql.OrderBy

568
569
570
571
572
573
574
575
576
577
578
579
        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());
View Full Code Here
1737
1738
1739
1740
1741
1742
1743
1744
     * @param column The column to order by.
     * @return A modified Criteria object.
     */
    public Criteria addAscendingOrderByColumn(Column column)
    {
        orderByColumns.add(new OrderBy(column, SqlEnum.ASC, false));
        return this;
    }
View Full Code Here
1752
1753
1754
1755
1756
1757
1758
1759
     *
     * @return A modified Criteria object.
     */
    public Criteria addAscendingOrderByColumn(Column column, boolean ignoreCase)
    {
        orderByColumns.add(new OrderBy(column, SqlEnum.ASC, ignoreCase));
        return this;
    }
View Full Code Here
1764
1765
1766
1767
1768
1769
1770
1771
     * @return A modified Criteria object.
     */
    public Criteria addAscendingOrderByColumn(String column)
    {
        orderByColumns.add(
                new OrderBy(new ColumnImpl(column), SqlEnum.ASC, false));
        return this;
    }
View Full Code Here
1776
1777
1778
1779
1780
1781
1782
1783
     * @param column The column to order by.
     * @return A modified Criteria object.
     */
    public Criteria addDescendingOrderByColumn(Column column)
    {
        orderByColumns.add(new OrderBy(column, SqlEnum.DESC, false));
        return this;
    }
View Full Code Here
1792
1793
1794
1795
1796
1797
1798
1799
     */
    public Criteria addDescendingOrderByColumn(
            Column column,
            boolean ignoreCase)
    {
        orderByColumns.add(new OrderBy(column, SqlEnum.DESC, ignoreCase));
        return this;
    }
View Full Code Here
1805
1806
1807
1808
1809
1810
1811
1812
     * @return A modified Criteria object.
     */
    public Criteria addDescendingOrderByColumn(String column)
    {
        orderByColumns.add(
                new OrderBy(new ColumnImpl(column), SqlEnum.DESC, false));
        return this;
    }
View Full Code Here
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
                new ColumnImpl("Author", "NAME")));
        assertTrue(selectColumnsClone.contains(
                new ColumnImpl("Author", "AUTHOR_ID")));
        assertEquals(c.getSelectColumns(), cClone.getSelectColumns());
        List<OrderBy> 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<String, Object> aliasesClone = cClone.getAliases();
View Full Code Here
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
                new ColumnImpl("Author", "NAME")));
        assertTrue(selectColumnsClone.contains(
                new ColumnImpl("Author", "AUTHOR_ID")));
        assertEquals(c.getSelectColumns(), cClone.getSelectColumns());
        List<OrderBy> 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<String, Object> aliasesClone = cClone.getAliases();
View Full Code Here
835
836
837
838
839
840
841
842
     *
     * @return A modified Criteria object.
     */
    public Criteria addAscendingOrderByColumn(Column column)
    {
        orderByColumns.add(new OrderBy(column, SqlEnum.ASC, false));
        return this;
    }
View Full Code Here
TOP

Related Classes of org.apache.torque.sql.OrderBy

  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.torque.criteria.Criteria
  • org.apache.torque.criteria.CriteriaTest
  • org.apache.torque.util.Criteria
  • org.apache.torque.util.CriteriaTest
    • 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.