Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.ProcedureQuery

335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
        // create an artist with painting in the database
        createArtist(1000.0);

        // test ProcedureQuery with Procedure as root
        Procedure proc = ctxt.getEntityResolver().getProcedure(SELECT_STORED_PROCEDURE);
        ProcedureQuery q = new ProcedureQuery(proc);
        q.setFetchingDataRows(true);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));

        // TESTING THIS ***
        // A.ARTIST_ID, A.DATE_OF_BIRTH, A.ARTIST_NAME
        ColumnDescriptor[] columns = new ColumnDescriptor[3];

        // read ID as Long, and everything else as default types
        columns[0] = new ColumnDescriptor("ARTIST_ID", Types.BIGINT);
        columns[1] = new ColumnDescriptor("ARTIST_NAME", Types.CHAR);
        columns[2] = new ColumnDescriptor("DATE_OF_BIRTH", Types.DATE);
        q.addResultDescriptor(columns);

        List rows = runProcedureSelect(q);

        // check the results
        assertNotNull("Null result from StoredProcedure.", rows);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
*/
public class ProcedureQueryValidator extends TreeNodeValidator {

    @Override
    public void validateObject(ProjectPath treeNodePath, Validator validator) {
        ProcedureQuery query = (ProcedureQuery) treeNodePath.getObject();

        validateName(query, treeNodePath, validator);
        validateRoot(query, treeNodePath, validator);
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    /**
     * Returns a ProcedureQuery.
     */
    @Override
    public Query getQuery() {
        ProcedureQuery query = new ProcedureQuery();
        Object root = getRoot();

        if (root != null) {
            query.setRoot(root);
        }

        query.setName(name);
        query.setResultEntityName(resultEntity);
        query.initWithProperties(properties);

        return query;
    }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
*/
public class ProcedureQueryValidator extends TreeNodeValidator {

    @Override
    public void validateObject(ProjectPath treeNodePath, Validator validator) {
        ProcedureQuery query = (ProcedureQuery) treeNodePath.getObject();

        validateName(query, treeNodePath, validator);
        validateRoot(query, treeNodePath, validator);
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    /**
     * Returns a ProcedureQuery.
     */
    @Override
    public Query getQuery() {
        ProcedureQuery query = new ProcedureQuery();
        Object root = getRoot();

        if (root != null) {
            query.setRoot(root);
        }

        query.setName(name);
        query.setResultEntityName(resultEntity);
        query.initWithProperties(properties);

        return query;
    }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
        }

        // create an artist with painting in the database
        createArtist(1000.0);

        ProcedureQuery q = new ProcedureQuery(UPDATE_STORED_PROCEDURE);
        q.addParameter("paintingPrice", new Integer(3000));

        // since stored procedure commits its stuff, we must use an explicit
        // non-committing transaction

        Transaction t = Transaction.externalTransaction(null);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
        }

        // create an artist with painting in the database
        createArtist(1000.0);

        ProcedureQuery q = new ProcedureQuery(UPDATE_STORED_PROCEDURE_NOPARAM);

        // since stored procedure commits its stuff, we must use an explicit
        // non-committing transaction

        Transaction t = Transaction.externalTransaction(null);
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
        }

        // create an artist with painting in the database
        createArtist(1000.0);

        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));
        List artists = runProcedureSelect(q);

        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);
        assertEquals(1, artists.size());
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
178
179
        }

        // create an artist with painting in the database
        createArtist(1000.0);

        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));

        List artists = runProcedureSelect(q);

        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
209
210
        // create an artist with painting in the database
        createArtist(1000.0);

        // test ProcedureQuery with Procedure as root
        Procedure proc = ctxt.getEntityResolver().getProcedure(SELECT_STORED_PROCEDURE);
        ProcedureQuery q = new ProcedureQuery(proc);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));

        List artists = runProcedureSelect(q);

        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);
View Full Code Here
TOP

Related Classes of org.apache.cayenne.query.ProcedureQuery

  • org.apache.cayenne.access.DataContextProcedureQueryTest
  • org.apache.cayenne.map.ProcedureQueryBuilder
  • org.apache.cayenne.modeler.dialog.query.QueryType
  • org.apache.cayenne.modeler.dialog.query.QueryTypeModel
  • org.apache.cayenne.modeler.editor.ProcedureQueryView
  • org.apache.cayenne.modeler.editor.ProcedureQueryView$ProcedureQueryPropertiesPanel
  • org.apache.cayenne.project.validator.ProcedureQueryValidator
  • java.util.ArrayList
    • 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.