/** * Decreases a property. */ public <ID> void decreaseProperty(final Class entityType, final ID id, final String name, final Number delta) { query(dbOom.entities().increaseColumn(entityType, id, name, delta, false)).autoClose().executeUpdate(); }
/** * Updates single entity. */ public void update(final Object entity) { query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate(); }
/** * Increases a property. */ public <ID> void increaseProperty(final Class entityType, final ID id, final String name, final Number delta) { query(dbOom.entities().increaseColumn(entityType, id, name, delta, true)).autoClose().executeUpdate(); }
/** * Deleted single entity by its id. */ public <ID> void deleteById(final Class entityType, final ID id) { query(dbOom.entities().deleteById(entityType, id)).autoClose().executeUpdate(); }
/** * Updates single property in database and in the bean. */ public <E> E updateProperty(final E entity, final String name, final Object newValue) { query(dbOom.entities().updateColumn(entity, name, newValue)).autoClose().executeUpdate(); BeanUtil.declared.setProperty(entity, name, newValue); return entity; }
/** * Updates property in the database by storing the current property value. */ public <E> E updateProperty(final E entity, final String name) { Object value = BeanUtil.declared.getProperty(entity, name); query(dbOom.entities().updateColumn(entity, name, value)).autoClose().executeUpdate(); return entity; }
/** * Delete single object by its id. Resets ID value. */ public void deleteById(final Object entity) { if (entity != null) { int result = query(dbOom.entities().deleteById(entity)).autoClose().executeUpdate(); if (result != 0) { // now reset the ID value Class type = entity.getClass(); DbEntityDescriptor ded = dbOom.entityManager().lookupType(type); setEntityId(ded, entity, 0); } } }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Girl2.class); dbEntityManager.registerEntity(Boy.class); dbSession = new DbThreadSession(cp); final DbEntitySql dbEntitySql = dbOom.entities(); assertEquals(1, dbEntitySql.insert(new Girl2(1, "Anna", "swim")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Girl2(2, "Sandra", "piano")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Girl2(3, "Emma", "nothing")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(1, "Johny", 2)).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(2, "Marco", 2)).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(3, "Hugo", 1)).query().executeUpdate()); }
assertEquals(1, dbOom.entities().insert(new Room(1, "Room1")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Room(2, "Room2")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Boy4(1, 1, "Oleg")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Boy4(2, 2, "Stephene")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Boy4(3, 2, "Joe")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Girl4(1, 1, "Anna")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Girl4(2, 2, "Sandra")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Girl4(3, 3, "Jossy")).query().executeUpdate());
@Test void testGroupNames() { DbSession session = new DbThreadSession(cp); // ---------------------------------------------------------------- insert assertEquals(1, dbOom.entities().insert(new Group("g1")).query().autoClose().executeUpdate()); List<Group> groups; groups = dbOom.entities().findAll(Group.class).query().list(); assertEquals(1, groups.size()); groups = dbOom.entities().findByColumn(Group.class, "column", "g1").query().list(); assertEquals(1, groups.size()); groups = dbOom.entities().findByColumn(Group.class, "column", "g1").query().list(); assertEquals(1, groups.size()); session.close(); }
query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate();
doq.executeUpdate(); doq.executeUpdate();
assertEquals(1, dbOom.entities().insert(new Girl(1, "Anna", "swim")).query().autoClose().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Girl(2, "Sandra", "piano")).query().autoClose().executeUpdate()); assertEquals(0, session.getTotalQueries()); q2.init(); assertEquals("insert into GIRL (ID, NAME) values (3, 'Monica')", q2.getQueryString()); assertEquals(1, q2.autoClose().executeUpdate()); assertTrue(q2.isClosed()); assertEquals(1, dbOom.entities().insert(new BadBoy(Integer.valueOf(1), "Johny", Integer.valueOf(3))).query().autoClose().executeUpdate()); assertEquals(0, session.getTotalQueries()); assertEquals(1, q.executeUpdate()); assertEquals(1, q.executeUpdate()); f.executeUpdate(); assertTrue(f.isClosed()); dbOom.entities().update(badGirl).query().executeUpdate(); dbOom.entities().updateAll(badGirl).query().executeUpdate();
q.executeUpdate(); long key = q.getGeneratedKey(); assertEquals(4, key); q.executeUpdate(); Long Key = q.findGeneratedKey(Long.class); assertEquals(5, Key.longValue()); q.executeUpdate(); ResultSet rs = q.getGeneratedColumns(); assertEquals(1, q.getOpenResultSetCount()); assertEquals("insert into GIRL (NAME) values (:girl2.name)", q.getQueryString()); q.setGeneratedColumns("ID"); q.executeUpdate(); q.populateGeneratedKeys(g2);
DbSession session = new DbThreadSession(cp); assertEquals(1, dbOom.entities().insert(new Girl(1, "Anna", "swim")).query().autoClose().executeUpdate()); assertEquals(0, session.getTotalQueries());
assertEquals(1, dbOom.entities().insert(new Girl(1, "Anna", "swim")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Girl(2, "Sandra", "piano")).query().executeUpdate()); assertEquals(1, dbOom.entities().insert(new Boy2(1, "John", 1)).query().executeUpdate());
/** * Increases a property. */ public <ID> void increaseProperty(final Class entityType, final ID id, final String name, final Number delta) { query(dbOom.entities().increaseColumn(entityType, id, name, delta, true)).autoClose().executeUpdate(); }
/** * Updates single entity. */ public void update(final Object entity) { query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate(); }
/** * Decreases a property. */ public <ID> void decreaseProperty(final Class entityType, final ID id, final String name, final Number delta) { query(dbOom.entities().increaseColumn(entityType, id, name, delta, false)).autoClose().executeUpdate(); }
/** * Updates single property in database and in the bean. */ public <E> E updateProperty(final E entity, final String name, final Object newValue) { query(dbOom.entities().updateColumn(entity, name, newValue)).autoClose().executeUpdate(); BeanUtil.declared.setProperty(entity, name, newValue); return entity; }