Examples of org.apache.cayenne.query.ProcedureQuery

org.apache.cayenne.query.ProcedureQuery
A query based on Procedure. Can be used as a select query, or as a query of an arbitrary complexity, performing data modification, selecting data (possibly with multiple result sets per call), returning values via OUT parameters.
Execution with DataContext

Reading OUT parameters

If a ProcedureQuery has OUT parameters, they are wrapped in a separate List in the query result. Such list will contain a single Map with OUT parameter values.

Using ProcedureQuery as a GenericSelectQuery

Executing ProcedureQuery via {@link org.apache.cayenne.access.DataContext#performQuery(Query)} makes sense only ifthe stored procedure returns a single result set (or alternatively returns a result via OUT parameters and no other result sets). It is still OK if data modification occurs as a side effect. However if the query returns more then one result set, a more generic form should be used: {@link org.apache.cayenne.access.DataContext#performGenericQuery(Query)}.
@author Andrus Adamchik

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


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


        assertEquals(2, artists.size());
    }

View Full Code Here

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


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


        assertEquals(1, artists.size());
    }

View Full Code Here

            return;
        }
        
        // create an artist with painting in the database
        createArtist(1000.0);
        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        
        q.setColumnNamesCapitalization(CapsStrategy.LOWER);
        q.addParameter("aName", "An Artist");
        List<DataRow> artists = runProcedureSelect(q);
        
        ProcedureQuery q1 = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        
        q1.setColumnNamesCapitalization(CapsStrategy.UPPER);
        q1.addParameter("aName", "An Artist");
        List<DataRow> artists1 = runProcedureSelect(q1);
        
        assertTrue(artists.get(0).containsKey("date_of_birth"));
        assertFalse(artists.get(0).containsKey("DATE_OF_BIRTH"));

View Full Code Here

    public void testOutParams() throws Exception {
        if (!getAccessStackAdapter().supportsStoredProcedures()) {
            return;
        }


        ProcedureQuery q = new ProcedureQuery(OUT_STORED_PROCEDURE);
        q.addParameter("in_param", new Integer(20));


        List rows = runProcedureSelect(q);


        assertEquals(1, rows.size());
        Object row = rows.get(0);

View Full Code Here

        }


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


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE, Artist.class);
        q.addParameter("aName", "An Artist");


        List artists = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);

View Full Code Here

        // 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, Long.class
                .getName());
        columns[1] = new ColumnDescriptor("ARTIST_NAME", Types.CHAR, String.class
                .getName());
        columns[2] = new ColumnDescriptor("DATE_OF_BIRTH", Types.DATE, Date.class
                .getName());
        q.addResultDescriptor(columns);


        List rows = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", rows);

View Full Code Here


    /**
     * Returns a ProcedureQuery.
     */
    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


    /**
     * Returns a ProcedureQuery.
     */
    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

 * @since 1.1
 */
public class ProcedureQueryValidator extends TreeNodeValidator {


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


        validateName(query, treeNodePath, validator);
        validateRoot(query, treeNodePath, validator);
    }

View Full Code Here

 * @since 1.1
 */
public class ProcedureQueryValidator extends TreeNodeValidator {


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


        validateName(query, treeNodePath, validator);
        validateRoot(query, treeNodePath, validator);
    }

View Full Code Here

0 1 2 3 4 5 6

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

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.

Examples of org.apache.cayenne.query.ProcedureQuery

Execution with DataContext

Reading OUT parameters

Using ProcedureQuery as a GenericSelectQuery

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