Package org.apache.torque.criteria

Examples of org.apache.torque.criteria.Criteria

62
63
64
65
66
67
68
69
            {
                firstAuthorId = author.getAuthorId();
            }
        }
        // Set up the standard criteria for the test.
        criteria = new Criteria();
        criteria.where(AuthorPeer.NAME, LARGE_SELECT_AUTHOR);
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    public void setUp() throws Exception
    {
        super.setUp();

        // Clean up any previous failures
        Summarize1Peer.doDelete(new Criteria());

        // Create some test data
        for (int i = 0; i < TEST_GROUPBY1.length; i++)
        {
            for ( int j = 0; j < TEST_GROUPBY2.length; j++ ) {
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
     * Test a simple single table with group bys
     */
    public void testSummarize()
                        throws Exception
    {
        Criteria c = new Criteria();

        c.addAscendingOrderByColumn(Summarize1Peer.GROUP_BY1);

        SummaryHelper summary = new SummaryHelper();

        summary.setExcludeExprColumns(true);
        List<Class<?>> returnTypes = new ArrayList<Class<?>>();
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    }
    /*
     * Test a total table aggregate summaries (no group bys)
     */
    public void testSummarizeEntireTable() throws Exception {
        Criteria c = new Criteria();

        SummaryHelper summary = new SummaryHelper();

        summary.setExcludeExprColumns(true);
        List<Class<?>> returnTypes = new ArrayList<Class<?>>();
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
     */
    public void testLeftJoins() throws Exception
    {
        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                BookPeer.AUTHOR_ID,
                Criteria.LEFT_JOIN);

        List<Author> authorList = AuthorPeer.doSelect(criteria);
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
     */
    public void testInnerJoins() throws Exception
    {
        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                BookPeer.AUTHOR_ID,
                Criteria.INNER_JOIN);

        List<Author> authorList = AuthorPeer.doSelect(criteria);
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
     */
    public void testImplicitInnerJoins() throws Exception
    {
        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                BookPeer.AUTHOR_ID);

        List<Author> authorList = AuthorPeer.doSelect(criteria);

View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
159
            return;
        }

        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addJoin(
                BookPeer.AUTHOR_ID,
                AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);

        List<Author> authorList = AuthorPeer.doSelect(criteria);
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
188
     */
    public void testInnerJoinsOtherComparator() throws Exception
    {
        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addJoin(
                BookPeer.TABLE_NAME,
                AuthorPeer.TABLE_NAME,
                    new Criterion(
                    BookPeer.AUTHOR_ID,
                    AuthorPeer.AUTHOR_ID,
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
            return;
        }

        cleanBookstore();
        insertTestData();
        Criteria criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(
                BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                new ColumnImpl("b." + BookPeer.AUTHOR_ID.getColumnName()),
                Criteria.LEFT_JOIN);
        List<Author> authorList = AuthorPeer.doSelect(criteria);
        // Here we get 11 authors:
View Full Code Here
TOP

Related Classes of org.apache.torque.criteria.Criteria

  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.torque.BaseDatabaseTestCase
  • org.apache.torque.BeanTestConditional
  • org.apache.torque.DataTest
  • org.apache.torque.datatypes.BitTest
  • org.apache.torque.datatypes.BooleanIntCharTest
  • org.apache.torque.datatypes.ByteTypeTest
  • org.apache.torque.datatypes.ClobTest
  • org.apache.torque.DocsTest
    • 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.