public void testLastOrderWins() {
Query query = newQuery(Data.class);
query.descend("_id").orderDescending();
query.descend("_id").orderAscending();
query.descend("_id").constrain(new Integer(0)).greater();
assertOrdered(query.execute());
}
public void conc(ExtObjectContainer oc) {
Query q = oc.query();
q.constrain(QueryForUnknownFieldTestCase.class);
q.descend("_name").constrain("name");
Assert.areEqual(1, q.execute().size());
q = oc.query();
q.constrain(QueryForUnknownFieldTestCase.class);
q.descend("name").constrain("name");
Assert.areEqual(0, q.execute().size());
}
public void concUpdateDifferentObject(ExtObjectContainer oc, int seq) throws Exception {
Query query = oc.query();
query
.descend("_s")
.constrain(testString + seq)
.and(query.descend("_i").constrain(new Integer(seq)));
ObjectSet result = query.execute();
Assert.areEqual(1, result.size());
SimpleObject o = (SimpleObject) result.next();
o.setI(seq + COUNT);
oc.store(o);
}
private Item itemByName(String string) {
Query q = db().query();
q.constrain(Item.class);
q.descend("_name").constrain(string);
Object object = q.execute().next();
return (Item) object;
}
private Item storedItem(String id) {
Query query = newQuery(Item.class);
query.descend("_id").constrain(id);
ObjectSet<Item> result = query.execute();
Assert.isTrue(result.hasNext());
return result.next();
}
public void _test() throws Exception {
Query query = newQuery();
query.constrain(new TestEvaluation());
query.constrain(Item.class);
query.descend("name").orderDescending();
ObjectSet set = query.execute();
Assert.areEqual(3, set.size());
}
public void concRead(ExtObjectContainer oc) {
for (int i = 0; i < COUNT; i++) {
Query q = oc.query();
q.constrain(Atom.class);
q.descend("name").constrain("ibi" + i);
ObjectSet objectSet = q.execute();
Assert.areEqual(1, objectSet.size());
Atom child = (Atom) objectSet.next();
q = oc.query();
q.constrain(IndexedByIdentityTestCase.class);
q.descend("atom").constrain(child).identity();
objectSet = q.execute();
Assert.areEqual(1, objectSet.size());
IndexedByIdentityTestCase ibi = (IndexedByIdentityTestCase) objectSet.next();
Assert.areSame(child, ibi.atom);
}
}
private void assertQueryForTimestamp(Item expected, long timestamp) {
Query query = db().query();
query.constrain(Item.class);
query.descend(VirtualField.COMMIT_TIMESTAMP).constrain(timestamp);
ObjectSet<Object> objectSet = query.execute();
Assert.areEqual(1, objectSet.size());
Item actual = (Item) objectSet.next();
Assert.areSame(expected, actual);
}
public void checkUpdateSameObject(ExtObjectContainer oc) throws Exception {
Query query = oc.query();
query.descend("_s").constrain(testString + COUNT / 2);
ObjectSet result = query.execute();
Assert.areEqual(1, result.size());
SimpleObject o = (SimpleObject) result.next();
int i = o.getI();
Assert.isTrue(COUNT <= i && i < COUNT + threadCount());
}
public void concUpdateSameObject(ExtObjectContainer oc, int seq) throws Exception {
Query query = oc.query();
query.descend("_s").constrain(testString + COUNT / 2);
ObjectSet result = query.execute();
Assert.areEqual(1, result.size());
SimpleObject o = (SimpleObject) result.next();
o.setI(COUNT + seq);
oc.store(o);
}
public void testQuery() {
ExtObjectContainer oc = fixture().db();
initGenericObjects();
ReflectClass rc = getReflectClass(oc, PERSON_CLASSNAME);
Assert.isNotNull(rc);
// now query to make sure there are none left
Query q = oc.query();
q.constrain(rc);
q.descend("surname").constrain("John");
ObjectSet results = q.execute();
Assert.isTrue(results.size() == 1);
}
public void testQueryForVersionNumber() {
store(new Item(NEWER));
db().commit();
Item newer = itemByName(NEWER);
long version = version(newer);
Query query = db().query();
query.descend(VirtualField.COMMIT_TIMESTAMP).constrain(new Long(version)).smaller().not();
ObjectSet<Item> set = query.execute();
Assert.areEqual(1, set.size());
Assert.areSame(newer, set.next());
}
private void tQueryInts(ExtObjectContainer oc, int expectedZeroSize) {
Query q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(0));
int zeroSize = q.execute().size();
Assert.areEqual(expectedZeroSize, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(4)).greater().equal();
tExpectInts(q, new int[] {5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(4)).greater();
tExpectInts(q, new int[] {5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(3)).greater();
tExpectInts(q, new int[] {5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(3)).greater().equal();
tExpectInts(q, new int[] {3, 3, 5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(2)).greater().equal();
tExpectInts(q, new int[] {2, 3, 3, 5, 7});
q = oc.query();
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(2)).greater();
tExpectInts(q, new int[] {3, 3, 5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(1)).greater().equal();
tExpectInts(q, new int[] {1, 2, 3, 3, 5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(1)).greater();
tExpectInts(q, new int[] {2, 3, 3, 5, 7});
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(4)).smaller();
tExpectInts(q, new int[] {1, 2, 3, 3}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(4)).smaller().equal();
tExpectInts(q, new int[] {1, 2, 3, 3}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(3)).smaller();
tExpectInts(q, new int[] {1, 2}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(3)).smaller().equal();
tExpectInts(q, new int[] {1, 2, 3, 3}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(2)).smaller().equal();
tExpectInts(q, new int[] {1, 2}, zeroSize);
q = oc.query();
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(2)).smaller();
tExpectInts(q, new int[] {1}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(1)).smaller().equal();
tExpectInts(q, new int[] {1}, zeroSize);
q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_int").constrain(new Integer(1)).smaller();
tExpectInts(q, new int[] {}, zeroSize);
}
private Item queryRoot() {
Query q = newQuery(Item.class);
q.descend("name").constrain("1");
ObjectSet objectSet = q.execute();
return (Item) objectSet.next();
}
private void assertSingleElementQuery(Object element) {
Query q = db().query();
q.constrain(Item.class);
q.descend("list").constrain(element);
assertSingleElementQueryResult(q, element);
}
private void assertItemQuery(String constraint, int expected) {
Query query = db().query();
query.constrain(ListHolder.class);
query.descend("list").descend("name").constrain(constraint);
Assert.areEqual(expected, query.execute().size());
}
private void assertStringQuery(int expected, String valueToQuery) {
Query query = db().query();
query.constrain(ListHolder.class);
query.descend("list").constrain(valueToQuery);
Assert.areEqual(expected, query.execute().size());
}
private ObjectSet query(ExtObjectContainer oc, String n) {
Query q = oc.query();
q.constrain(CreateIndexFor.class);
q.descend("i_name").constrain(n);
return q.execute();
}