protected ArrayList<AbcdefEntity> insert(int count) { ArrayList<AbcdefEntity> list = new ArrayList<AbcdefEntity>(); for (int i = 0; i < count; i++) { int base = i * 100; AbcdefEntity entity = new AbcdefEntity(null, base + 1, base + 2, base + 3, base + 4, base + 5, base + 6, base + 7, base + 8, base + 9, base + 10, base + 11); list.add(entity); } dao.insertInTx(list); return list; }
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(); }
dateEntityDao = new DateEntityDao(dateEntityDaoConfig, this); specialNamesEntityDao = new SpecialNamesEntityDao(specialNamesEntityDaoConfig, this); abcdefEntityDao = new AbcdefEntityDao(abcdefEntityDaoConfig, this); toManyTargetEntityDao = new ToManyTargetEntityDao(toManyTargetEntityDaoConfig, this); toManyEntityDao = new ToManyEntityDao(toManyEntityDaoConfig, this);
/** Creates underlying database table using DAOs. */ public static void createAllTables(Database db, boolean ifNotExists) { SimpleEntityDao.createTable(db, ifNotExists); SimpleEntityNotNullDao.createTable(db, ifNotExists); TestEntityDao.createTable(db, ifNotExists); RelationEntityDao.createTable(db, ifNotExists); DateEntityDao.createTable(db, ifNotExists); SpecialNamesEntityDao.createTable(db, ifNotExists); AbcdefEntityDao.createTable(db, ifNotExists); ToManyTargetEntityDao.createTable(db, ifNotExists); ToManyEntityDao.createTable(db, ifNotExists); JoinManyToDateEntityDao.createTable(db, ifNotExists); TreeEntityDao.createTable(db, ifNotExists); AnActiveEntityDao.createTable(db, ifNotExists); ExtendsImplementsEntityDao.createTable(db, ifNotExists); StringKeyValueEntityDao.createTable(db, ifNotExists); AutoincrementEntityDao.createTable(db, ifNotExists); CustomTypeEntityDao.createTable(db, ifNotExists); IndexedStringEntityDao.createTable(db, ifNotExists); }
/** Drops underlying database table using DAOs. */ public static void dropAllTables(Database db, boolean ifExists) { SimpleEntityDao.dropTable(db, ifExists); SimpleEntityNotNullDao.dropTable(db, ifExists); TestEntityDao.dropTable(db, ifExists); RelationEntityDao.dropTable(db, ifExists); DateEntityDao.dropTable(db, ifExists); SpecialNamesEntityDao.dropTable(db, ifExists); AbcdefEntityDao.dropTable(db, ifExists); ToManyTargetEntityDao.dropTable(db, ifExists); ToManyEntityDao.dropTable(db, ifExists); JoinManyToDateEntityDao.dropTable(db, ifExists); TreeEntityDao.dropTable(db, ifExists); AnActiveEntityDao.dropTable(db, ifExists); ExtendsImplementsEntityDao.dropTable(db, ifExists); StringKeyValueEntityDao.dropTable(db, ifExists); AutoincrementEntityDao.dropTable(db, ifExists); CustomTypeEntityDao.dropTable(db, ifExists); IndexedStringEntityDao.dropTable(db, ifExists); }
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 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 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 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(); }