/** * {@inheritDoc} */ public Results execute(Query q, int batchSize, boolean optimise, boolean explain, boolean prefetch) { return osw.execute(q, batchSize, optimise, explain, prefetch); }
/** * {@inheritDoc} */ public List<ResultsRow<Object>> execute(Query q, int start, int limit, boolean optimise, boolean explain, Map<Object, Integer> sequence) throws ObjectStoreException { return osw.execute(q, start, limit, optimise, explain, sequence); }
/** * {@inheritDoc} */ public Results execute(Query q) { return osw.execute(q); }
/** * {@inheritDoc} */ public Results execute(Query q) { return osw.execute(q); }
/** * {@inheritDoc} */ public Results execute(Query q, int batchSize, boolean optimise, boolean explain, boolean prefetch) { return osw.execute(q, batchSize, optimise, explain, prefetch); }
/** * {@inheritDoc} */ public List<ResultsRow<Object>> execute(Query q, int start, int limit, boolean optimise, boolean explain, Map<Object, Integer> sequence) throws ObjectStoreException { return osw.execute(q, start, limit, optimise, explain, sequence); }
private TableRowIterator getResults(final PathQuery pq, final Page page) throws ObjectStoreException { Map<String, QuerySelectable> p2qn = new HashMap<String, QuerySelectable>(); Query q = MainHelper.makeQuery(pq, new HashMap<String, InterMineBag>(), p2qn, null, new HashMap<String, BagQueryResult>()); Results res = osw.execute(q, 1000, true, false, true); //puts("EXAMPLE ROW: " + res.get(0)); return new TableRowIterator(pq, q, res, p2qn, page, null); }
private void doNullCollectionTests(Query q) { Results res = osw.execute(q, 50000, true, false, true); for (Object o: res) { Department d = (Department) ((List) o).get(0); System.out.println(d.getName() + ":\n-------"); for (Employee e: d.getEmployees()) { System.out.println(e); } System.out.println(); } doTest(q, 2, 2); }
private void doNonNullCollectionTests(Query q) { Results res = osw.execute(q, 50000, true, false, true); for (Object o: res) { Department d = (Department) ((List) o).get(0); System.out.println(d.getName() + ":\n-------"); for (Employee e: d.getEmployees()) { System.out.println(e); } System.out.println(); } doTest(q, 2, 20); }
private int runQuery(ConstraintOp op, Collection<String> types) throws ObjectStoreException { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Employable.name"); pq.addConstraint(new PathConstraintMultitype("Employable", op, types)); Query q = MainHelper.makeQuery( pq, new HashMap(), new HashMap(), null, new HashMap()); Results res = osw.execute(q, 50000, true, false, true); return res.size(); }
protected Results runQuery(String path, ConstraintOp op, Collection<String> ranges) throws ObjectStoreException { PathQuery pq = new PathQuery(osw.getModel()); pq.addViews("Employee.name"); pq.addConstraint(Constraints.eq("Employee.name", "temp*")); pq.addConstraint(new PathConstraintRange(path, op, ranges)); Query q = MainHelper.makeQuery(pq, new HashMap(), new HashMap(), null, new HashMap()); Results res = osw.execute(q, 50000, true, false, true); return res; }
@Test public void isntOnRef() throws ObjectStoreException { Collection<String> types = Arrays.asList("CEO", "Contractor"); PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.employees.name"); pq.addConstraint(Constraints.eq("Department.name", tempDepartment.getName())); PathQuery all = pq.clone(); pq.addConstraint(new PathConstraintMultitype("Department.employees", ConstraintOp.ISNT, Arrays.asList("Manager", "CEO"))); Query q = MainHelper.makeQuery( pq, new HashMap(), new HashMap(), null, new HashMap()); Query qall = MainHelper.makeQuery( all, new HashMap(), new HashMap(), null, new HashMap()); Results res = osw.execute(q, 50000, true, false, true); Results resall = osw.execute(qall, 50000, true, false, true); assertEquals(res.size(), resall.size() - (types.size() * SET_SIZE)); } }
/** * Delete all bags having as a type one of the classes deleted */ public void deleteBags() { Query q = new Query(); QueryClass qc = new QueryClass(SavedBag.class); q.addToSelect(qc); q.addFrom(qc); QueryField typeField = new QueryField(qc, "type"); BagConstraint constraint = new BagConstraint(typeField, ConstraintOp.IN, deletedClasses); q.setConstraint(constraint); Results bagsToDelete = uosw.execute(q, 1000, false, false, true); for (Iterator<?> i = bagsToDelete.iterator(); i.hasNext();) { ResultsRow<?> row = (ResultsRow<?>) i.next(); SavedBag savedBag = (SavedBag) row.get(0); Profile profile = pm.getProfile(savedBag.getUserProfile().getUsername()); try { profile.deleteBag(savedBag.getName()); System .out.println("Deleted the list: " + savedBag.getName() + " having type " + savedBag.getType()); } catch (ObjectStoreException ose) { System .out.println("Problems deleting bag: " + savedBag.getName()); } } }
/** * Delete all bags having as a type one of the classes deleted */ public void deleteBags() { Query q = new Query(); QueryClass qc = new QueryClass(SavedBag.class); q.addToSelect(qc); q.addFrom(qc); QueryField typeField = new QueryField(qc, "type"); BagConstraint constraint = new BagConstraint(typeField, ConstraintOp.IN, deletedClasses); q.setConstraint(constraint); Results bagsToDelete = uosw.execute(q, 1000, false, false, true); for (Iterator<?> i = bagsToDelete.iterator(); i.hasNext();) { ResultsRow<?> row = (ResultsRow<?>) i.next(); SavedBag savedBag = (SavedBag) row.get(0); Profile profile = pm.getProfile(savedBag.getUserProfile().getUsername()); try { profile.deleteBag(savedBag.getName()); System .out.println("Deleted the list: " + savedBag.getName() + " having type " + savedBag.getType()); } catch (ObjectStoreException ose) { System .out.println("Problems deleting bag: " + savedBag.getName()); } } }
private void doTest(Query q, int rows, int expected) { Results res = osw.execute(q, 50000, true, false, true); assertEquals(rows, res.size()); int empsAndCompanies = 0; for (Object o: res) { Department d = (Department) ((List) o).get(0); if (d.getEmployees() != null) { empsAndCompanies += d.getEmployees().size(); } if (d.getCompany() != null) { empsAndCompanies++; } } assertEquals(expected, empsAndCompanies); }
@Test public void testSanity() throws ObjectStoreException { PathQuery pq = new PathQuery(osw.getModel()); pq.addViews("Employee.id", "Employee.employmentPeriod.id"); pq.addConstraint(Constraints.eq("Employee.name", "temp*")); Query q = MainHelper.makeQuery( pq, new HashMap(), new HashMap(), null, new HashMap()); Results res = osw.execute(q, 50000, true, false, true); assertEquals(res.size(), EMP_COUNT); for (Object row: res) { showRow(row); } }
@Test public void testFailFast() throws Exception { Query q1 = new Query(); QueryClass qc1 = new QueryClass(Employee.class); q1.addFrom(qc1); q1.addToSelect(qc1); Results r1 = writer.execute(q1); writer.store(data.get("EmployeeA1")); try { r1.iterator().hasNext(); fail("Expected: ConcurrentModificationException"); } catch (ConcurrentModificationException e) { } }
@Test public void getJSONRecords() throws ObjectStoreException, JSONException { PathQuery pq = getPQ(); pq.setOuterJoinStatus("Company.departments", OuterJoinStatus.OUTER); pq.setOuterJoinStatus("Company.departments.employees", OuterJoinStatus.OUTER); pq.setOuterJoinStatus("Company.departments.employees.address", OuterJoinStatus.OUTER); pq.setOuterJoinStatus("Company.secretarys", OuterJoinStatus.OUTER); Map<String, QuerySelectable> p2qn = new HashMap<String, QuerySelectable>(); Query q = MainHelper.makeQuery(pq, NO_BAGS, p2qn, null, getBQRAccumulator()); Results res = osw.execute(q, 1000, true, false, true); TableRowIterator iter = new TableRowIterator(pq, q, res, p2qn, new Page(2, 3), null); // EitherVisitor<ResultCell, SubTable, Void> printer = new IndentingPrinter(4); while(iter.hasNext()) { @SuppressWarnings("rawtypes") Collection data = CollectionUtils.collect(iter.next(), new Transformer() { @Override public Object transform(Object arg0) { @SuppressWarnings("unchecked") Either<ResultCell, SubTable> item = (Either<ResultCell, SubTable>) arg0; return item.accept(jsonTransformer); } }); JSONArray ja = new JSONArray(data); System.out.println(ja.toString(2)); } }
Query q = MainHelper.makeQuery(pq, NO_BAGS, p2qn, null, getBQRAccumulator()); Results res = osw.execute(q, 1000, true, false, true);
Query q = MainHelper.makeQuery(pq, NO_BAGS, p2qn, null, getBQRAccumulator()); Results res = osw.execute(q, 1000, true, false, true); TableRowIterator iter = new TableRowIterator(pq, q, res, p2qn, new Page(2, 10), null); int c = 0;