@Override public void run() { query.executeDeleteWithoutDetachingEntities(); } });
@Override public void run() { query.forCurrentThread().executeDeleteWithoutDetachingEntities(); } };
public void testThrowOutsideOwnerThread() throws InterruptedException { createQueryFromOtherThread(); try { queryFromOtherThread.executeDeleteWithoutDetachingEntities(); fail("Did not throw"); } catch (DaoException expected) { } try { queryFromOtherThread.setParameter(0, 42); fail("Did not throw"); } catch (DaoException expected) { } }
public void testDeleteQueryOr() { ArrayList<TestEntity> inserted = insert(3); QueryBuilder<TestEntity> queryBuilder = dao.queryBuilder(); Integer value1 = inserted.get(0).getSimpleInteger(); Integer value2 = inserted.get(2).getSimpleInteger(); queryBuilder.whereOr(Properties.SimpleInteger.eq(value1), Properties.SimpleInteger.eq(value2)); DeleteQuery<TestEntity> deleteQuery = queryBuilder.buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); List<TestEntity> allAfterDelete = dao.loadAll(); assertEquals(1, allAfterDelete.size()); assertEquals(inserted.get(1).getSimpleInteger(), allAfterDelete.get(0).getSimpleInteger()); }
public void testDeleteQuerySimple() { ArrayList<TestEntity> inserted = insert(3); int value = getSimpleInteger(1); inserted.get(2).setSimpleInteger(value); dao.update(inserted.get(2)); DeleteQuery<TestEntity> deleteQuery = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)) .buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); List<TestEntity> allAfterDelete = dao.loadAll(); assertEquals(1, allAfterDelete.size()); assertEquals(getSimpleInteger(0), (int) allAfterDelete.get(0).getSimpleInteger()); }
public void testDeleteQueryExecutingMultipleTimes() { insert(3); String value = getSimpleString(1); DeleteQuery<TestEntity> deleteQuery = dao.queryBuilder().where(Properties.SimpleString.eq(value)).buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); insert(3); assertEquals(5, dao.count()); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(4, dao.count()); }
public void testBuildQueryAndDeleteQuery() { insert(3); int value = getSimpleInteger(1); QueryBuilder<TestEntity> builder = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)); Query<TestEntity> query = builder.build(); DeleteQuery<TestEntity> deleteQuery = builder.buildDelete(); assertEquals(1, query.list().size()); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(0, query.list().size()); }
public void testGetForCurrentThread_ParametersAreReset() { insert(3); int value = getSimpleInteger(1); DeleteQuery<TestEntity> query = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).buildDelete(); query.setParameter(0, value + 100); query.executeDeleteWithoutDetachingEntities(); assertEquals(3, dao.count()); query = query.forCurrentThread(); query.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); }
public void testSimpleQuery() { insert(3); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder().where(Properties.A.eq(1)).orderAsc(Properties.A); List<AbcdefEntity> result = queryBuilder.list(); assertEquals(1, result.size()); assertEquals(1, queryBuilder.count()); AbcdefEntity resultEntity = result.get(0); assertEquals(1, (int) resultEntity.getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOr3() { insert(5); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(1), Properties.A.eq(101), Properties.B.eq(302)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(1, (int) result.get(0).getA()); assertEquals(101, (int) result.get(1).getA()); assertEquals(301, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOr() { insert(3); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(1), Properties.A.eq(101)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(2, result.size()); assertEquals(2, queryBuilder.count()); assertEquals(1, (int) result.get(0).getA()); assertEquals(101, (int) result.get(1).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testDeleteQueryChangeParameter() { insert(3); String value = getSimpleString(1); DeleteQuery<TestEntity> deleteQuery = dao.queryBuilder().where(Properties.SimpleString.eq(value)).buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); deleteQuery.setParameter(0, getSimpleString(0)); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(1, dao.count()); TestEntity remaining = dao.loadAll().get(0); assertEquals(getSimpleString(2), remaining.getSimpleString()); }
public void testOrNested() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(101), // Properties.B.eq(302), Properties.C.eq(603)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(101, (int) result.get(0).getA()); assertEquals(301, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testAnd() { insert(5); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.where(Properties.A.eq(201), Properties.B.eq(202)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(1, result.size()); assertEquals(1, queryBuilder.count()); assertEquals(201, (int) result.get(0).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOrAnd() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(201), // queryBuilder.and(Properties.B.gt(402), Properties.C.lt(703))); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(201, (int) result.get(0).getA()); assertEquals(501, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testGetForCurrentThread_TwoThreads() throws InterruptedException { insert(3); createQueryFromOtherThread(); DeleteQuery<TestEntity> query = queryFromOtherThread.forCurrentThread(); assertNotSame(queryFromOtherThread, query); query.setParameter(0, getSimpleInteger(2)); query.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); }
public void testOrNestedNested() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(101), // queryBuilder.or(Properties.B.eq(302), // queryBuilder.or(Properties.C.eq(503), Properties.D.eq(804)))); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(4, result.size()); assertEquals(4, queryBuilder.count()); assertEquals(101, (int) result.get(0).getA()); assertEquals(301, (int) result.get(1).getA()); assertEquals(501, (int) result.get(2).getA()); assertEquals(801, (int) result.get(3).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testJoinDelete() { prepareData(); QueryBuilder<RelationEntity> queryBuilder = createQueryBuilder(5); try { queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); } catch (DaoException e) { assertEquals("JOINs are not supported for DELETE queries", e.getMessage()); return; } // Never executed, unsupported by SQLite assertEquals(9, relationEntityDao.count()); assertEquals(10, testEntityDao.count()); assertNull(relationEntityDao.queryBuilder().where(Properties.SimpleString.eq("entity-5")).unique()); }
public void testWhereWithSpecialNames() { QueryBuilder<SpecialNamesEntity> queryBuilder = dao.queryBuilder(); queryBuilder.where(Properties.Avg.isNotNull()); queryBuilder.where(Properties.Count.isNotNull()); queryBuilder.where(Properties.Distinct.isNotNull()); queryBuilder.where(Properties.Index.isNotNull()); queryBuilder.where(Properties.Join.isNotNull()); queryBuilder.where(Properties.On.isNotNull()); queryBuilder.where(Properties.Select.isNotNull()); queryBuilder.where(Properties.Sum.isNotNull()); queryBuilder.where(Properties.Order.isNotNull()); queryBuilder.list(); queryBuilder.buildCount().count(); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testWhereWithSpecialNamesWithValues() { QueryBuilder<SpecialNamesEntity> queryBuilder = dao.queryBuilder(); queryBuilder.where(Properties.Avg.eq("test")); queryBuilder.where(Properties.Count.notIn("test", "test2")); queryBuilder.where(Properties.Distinct.ge("test")); queryBuilder.where(Properties.Index.le("test")); queryBuilder.where(Properties.Join.like("test")); queryBuilder.where(Properties.On.notEq("test")); queryBuilder.where(Properties.Select.in("test", "test2")); queryBuilder.where(Properties.Sum.lt(1)); queryBuilder.where(Properties.Order.gt(1)); queryBuilder.list(); queryBuilder.buildCount().count(); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }