How to use

executeUpdate

method

in

jodd.db.oom.DbOomQuery

/**
 * 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();
}

/**
 * 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();
}

/**
 * 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 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;
}

/**
 * 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;
}

/**
 * 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;
}