@Override protected AbcdefEntity createEntity(Long key) { AbcdefEntity entity = new AbcdefEntity(); entity.setId(key); return entity; }
Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); Integer a = entity.getA(); if (a != null) { stmt.bindLong(2, a); Integer b = entity.getB(); if (b != null) { stmt.bindLong(3, b); Integer c = entity.getC(); if (c != null) { stmt.bindLong(4, c); Integer d = entity.getD(); if (d != null) { stmt.bindLong(5, d); Integer e = entity.getE(); if (e != null) { stmt.bindLong(6, e); Integer f = entity.getF(); if (f != null) { stmt.bindLong(7, f); Integer g = entity.getG();
@Override public void readEntity(Cursor cursor, AbcdefEntity entity, int offset) { entity.setId(cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0)); entity.setA(cursor.isNull(offset + 1) ? null : cursor.getInt(offset + 1)); entity.setB(cursor.isNull(offset + 2) ? null : cursor.getInt(offset + 2)); entity.setC(cursor.isNull(offset + 3) ? null : cursor.getInt(offset + 3)); entity.setD(cursor.isNull(offset + 4) ? null : cursor.getInt(offset + 4)); entity.setE(cursor.isNull(offset + 5) ? null : cursor.getInt(offset + 5)); entity.setF(cursor.isNull(offset + 6) ? null : cursor.getInt(offset + 6)); entity.setG(cursor.isNull(offset + 7) ? null : cursor.getInt(offset + 7)); entity.setH(cursor.isNull(offset + 8) ? null : cursor.getInt(offset + 8)); entity.setJ(cursor.isNull(offset + 9) ? null : cursor.getInt(offset + 9)); entity.setI(cursor.isNull(offset + 10) ? null : cursor.getInt(offset + 10)); entity.setK(cursor.isNull(offset + 11) ? null : cursor.getInt(offset + 11)); }
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(); }
@Override public AbcdefEntity readEntity(Cursor cursor, int offset) { AbcdefEntity entity = new AbcdefEntity( // cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id cursor.isNull(offset + 1) ? null : cursor.getInt(offset + 1), // a cursor.isNull(offset + 2) ? null : cursor.getInt(offset + 2), // b cursor.isNull(offset + 3) ? null : cursor.getInt(offset + 3), // c cursor.isNull(offset + 4) ? null : cursor.getInt(offset + 4), // d cursor.isNull(offset + 5) ? null : cursor.getInt(offset + 5), // e cursor.isNull(offset + 6) ? null : cursor.getInt(offset + 6), // f cursor.isNull(offset + 7) ? null : cursor.getInt(offset + 7), // g cursor.isNull(offset + 8) ? null : cursor.getInt(offset + 8), // h cursor.isNull(offset + 9) ? null : cursor.getInt(offset + 9), // j cursor.isNull(offset + 10) ? null : cursor.getInt(offset + 10), // i cursor.isNull(offset + 11) ? null : cursor.getInt(offset + 11) // k ); return entity; }
@Override protected final Long updateKeyAfterInsert(AbcdefEntity entity, long rowId) { entity.setId(rowId); return rowId; }
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(); }
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; }
Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); Integer a = entity.getA(); if (a != null) { stmt.bindLong(2, a); Integer b = entity.getB(); if (b != null) { stmt.bindLong(3, b); Integer c = entity.getC(); if (c != null) { stmt.bindLong(4, c); Integer d = entity.getD(); if (d != null) { stmt.bindLong(5, d); Integer e = entity.getE(); if (e != null) { stmt.bindLong(6, e); Integer f = entity.getF(); if (f != null) { stmt.bindLong(7, f); Integer g = entity.getG();
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 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 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 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(); }