Examples of SelectQuery


Examples of org.apache.cayenne.query.SelectQuery

        ivSub1Sub1Table.insert(3, "xSUB1_SUB1");

        ivRootTable.insert(4, "xROOT_SUB2", "IvSub2");
        ivSub2Table.insert(4, "xSUB2");

        SelectQuery query = new SelectQuery(IvRoot.class);

        List<IvRoot> results = context.performQuery(query);

        assertEquals(4, results.size());
        Map<String, IvRoot> resultTypes = new HashMap<String, IvRoot>();
View Full Code Here

Examples of org.apache.cayenne.query.SelectQuery

        // insert
        iv1RootTable.insert(1, "xROOT", null);
        iv1RootTable.insert(2, "xSUB1_ROOT", "Iv1Sub1");
        iv1Sub1Table.insert(2, "xSUB1");

        SelectQuery query = new SelectQuery(Iv1Root.class);
        List<Iv1Root> results = context.performQuery(query);

        assertEquals(2, results.size());

        // since we don't have ordering, need to analyze results in an order agnostic
View Full Code Here

Examples of org.apache.cayenne.query.SelectQuery

        super.setUp();

        deleteTestData();
        createTestData("testArtists");

        SelectQuery q = new SelectQuery("Artist");
        q.setPageSize(6);
        q.setFetchingDataRows(true);
        q.addOrdering("db:ARTIST_ID", SortOrder.ASCENDING);

        query = q;
        list = new SimpleIdIncrementalFaultList(super.createDataContext(), query);
    }
View Full Code Here

Examples of org.apache.cayenne.query.SelectQuery

    public void testIndexOf1() throws Exception {
        DataContext parallelContext = createDataContext();

        Expression qual = ExpressionFactory.matchExp("artistName", "artist20");
        SelectQuery query = new SelectQuery(Artist.class, qual);
        query.setFetchingDataRows(true);
        List artists = parallelContext.performQuery(query);

        assertEquals(1, artists.size());

        Map row = (Map) artists.get(0);
View Full Code Here

Examples of org.apache.cayenne.query.SelectQuery

       
        // resolve first page
        list.get(0);

        Expression qual = ExpressionFactory.matchExp("artistName", "artist2");
        SelectQuery query = new SelectQuery(Artist.class, qual);
        query.setFetchingDataRows(true);
        List artists = parallelContext.performQuery(query);

        assertEquals(1, artists.size());

        Map row = (Map) artists.get(0);
View Full Code Here

Examples of org.apache.cayenne.query.SelectQuery

      
        // resolve first page
        list.get(0);

        Expression qual = ExpressionFactory.matchExp("artistName", "artist3");
        SelectQuery query = new SelectQuery(Artist.class, qual);
        query.setFetchingDataRows(true);
        List artists = parallelContext.performQuery(query);

        assertEquals(1, artists.size());

        Map row = (Map) artists.get(0);
View Full Code Here

Examples of org.apache.clerezza.rdf.core.sparql.query.SelectQuery

        .append("> WHERE { <").append(subject).append("> <")
        .append(predicate).append("> ?").append(variable).append(" . }");

    Query q = QueryParser.getInstance().parse(queryStrBuf.toString());
    Assert.assertTrue(SelectQuery.class.isAssignableFrom(q.getClass()));
    SelectQuery selectQuery = (SelectQuery) q;
    Assert.assertTrue(selectQuery.getSelection().get(0)
        .equals(new Variable(variable)));
    Assert.assertTrue(selectQuery.getDataSet().getDefaultGraphs().toArray()[0]
        .equals(new UriRef(defaultGraph)));

    GraphPattern gp = (GraphPattern) selectQuery.getQueryPattern()
        .getGraphPatterns().toArray()[0];
    Assert.assertTrue(BasicGraphPattern.class.isAssignableFrom(gp.getClass()));
    BasicGraphPattern bgp = (BasicGraphPattern) gp;

    Set<TriplePattern> triplePatterns = bgp.getTriplePatterns();
View Full Code Here

Examples of org.atomojo.sparql.SelectQuery

      this.db = db;
      this.query = query;
      if (!(query instanceof SelectQuery)) {
         throw new QueryException("Only select queries are supported.");
      }
      SelectQuery select = (SelectQuery)query;
      Set<String> returnVars = select.getReturnVariables();
      if (returnVars.size()!=1) {
         throw new QueryException("Only one entry/feed return variable is currently supported.");
      }
      var = returnVars.iterator().next();
      List<Triple> triples = select.getWhereClause().getClauses();
      pivot = null;
      entryPivot = false;
      feedPivot = false;
      unsatisfiable = false;
      Triple lastBind = null;
View Full Code Here

Examples of org.jooq.SelectQuery

    }

    @Test
    public void testFetch() throws Exception {
        SelectQuery q = create().selectQuery();
        q.addFrom(TAuthor());
        q.addSelect(TAuthor().getFields());
        q.addOrderBy(TAuthor_LAST_NAME());

        Result<?> result = q.fetch();

        assertEquals(2, result.size());
        assertEquals("Coelho", result.get(0).getValue(TAuthor_LAST_NAME()));
        assertEquals("Orwell", result.get(1).getValue(TAuthor_LAST_NAME()));

        try {
            q.fetchOne();
            fail();
        }
        catch (InvalidResultException expected) {}

        Record record = q.fetchAny();
        assertEquals("Coelho", record.getValue(TAuthor_LAST_NAME()));
    }
View Full Code Here

Examples of org.modeshape.jcr.api.query.qom.SelectQuery

        Ordering[] orderings = null;
        Limit limit = qomFactory.limit(2, 0);
        boolean isDistinct = false;

        // Build and execute the query ...
        SelectQuery selectQuery = qomFactory.select(selector, constraint, orderings, columns, limit, isDistinct);
        Query query1 = qomFactory.createQuery(selectQuery);
        QueryResult result1 = query1.execute();
        String[] columnNames = {"maker", "car:model", "car:year", "car:userRating"};
        validateQuery().rowCount(2).hasColumns(columnNames).validate(query1, result1);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.