Blob imageFor(String name, HttpServletResponse res) { // find desired image PersistenceManager pm = PMF.get().getPersistenceManager(); Query query = pm.newQuery("select from MyImage " + "where name = nameParam " + "parameters String nameParam"); List<MyImage> results = (List<MyImage>)query.execute(name); Blob image = results.iterator().next().getImage(); // serve the first image res.setContentType("image/jpeg"); res.getOutputStream().write(image.getBytes()); }
public StockClient[] getStocks() throws NotLoggedInException { checkLoggedIn(); PersistenceManager pm = getPersistenceManager(); List<StockClient> stockclients = new ArrayList<StockClient>(); try { Query q = pm.newQuery(Stock.class, "user == u"); q.declareParameters("com.google.appengine.api.users.User u"); q.setOrdering("createDate"); List<Stock> stocks = (List<Stock>) q.execute(getUser()); for (Stock stock : stocks) { stockclients.add(new StockClient(stock.getId(), stock.getSymbol(), stock.getCreateDate())); } } finally { pm.close(); } return (StockClient[]) stockclients.toArray(new StockClient[0]); }
import javax.jcr.query.Query; import javax.jcr.query.QueryManager; import javax.jcr.query.QueryResult; import javax.jcr.query.NodeIterator; import org.apache.jackrabbit.commons.iterator.NodeIteratorAdapter; import java.util.ArrayList; import java.util.Collections; import java.util.Comparator; . . . Query query = queryManager.createQuery( /* query without any ordering specs */ ); QueryResult queryResult = query.execute(); NodeIterator nodeIterator = queryResult.getNodes();
private static String getPlan(Session session, String xpath) throws RepositoryException { QueryManager qm = session.getWorkspace().getQueryManager(); QueryResult qr = qm.createQuery("explain " + xpath, "xpath").execute(); Row r = qr.getRows().nextRow(); String plan = r.getValue("plan").getString(); return plan; }
public Object call(Query query) throws RepositoryException { RowIterator rows = query.execute().getRows(); assertTrue("empty result", rows.hasNext()); Row r = rows.nextRow(); assertEquals("unexpected value", TEST_VALUE, r.getValue(columnName1).getString()); assertEquals("unexpected value", TEST_VALUE, r.getValue(columnName2).getString()); return null; } });
private static String getPaths(Query q) throws RepositoryException { QueryResult r = q.execute(); RowIterator it = r.getRows(); StringBuilder buff = new StringBuilder(); if (it.hasNext()) { Row row = it.nextRow(); if (buff.length() > 0) { buff.append(", "); } buff.append(row.getPath()); } return buff.toString(); }
protected QueryResult executeSQL2Query(String statement) throws RepositoryException { return qm.createQuery(statement, JCR_SQL2).execute(); }
@Override protected Query createQuery(QueryManager manager, int i) throws RepositoryException { return manager.createQuery( "SELECT * FROM [nt:base] AS n WHERE ISDESCENDANTNODE(n, '/" + testNodeName +"') AND testcount=" + i, "JCR-SQL2"); }
Query q = pm.newQuery (...); q.setWhere(...); q.setRange (...); q.setOrdering (...); q.setLimit(...); q.newParameter(...); // declare a query parameter q.execute(34.5); // execute the SQL query with a parameter
/** * @inheritDoc */ public String[] getColumnNames() throws RepositoryException { return result.getColumnNames(); }
private StaticOperand checkFullTextSearchExpression(StaticOperand fullTextSearchExpression) throws RepositoryException { if (fullTextSearchExpression == null) { throw new InvalidQueryException( "fullTextSearchExpression must not be null"); } return fullTextSearchExpression; } }
@Override public Node storeAsNode(String s) throws ItemExistsException, PathNotFoundException, VersionException, ConstraintViolationException, LockException, UnsupportedRepositoryOperationException, RepositoryException { return this.query.storeAsNode(s); } }
protected Query createQuery(QueryManager manager, int i) throws RepositoryException { @SuppressWarnings("deprecation") String xpath = Query.XPATH; return manager.createQuery("//*[@testcount=" + i + "]", xpath); }
/** * @inheritDoc */ public Node storeAsNode(String absPath) throws ItemExistsException, PathNotFoundException, VersionException, ConstraintViolationException, LockException, UnsupportedRepositoryOperationException, RepositoryException { Node node = query.storeAsNode(absPath); return node; }