jodd.db.oom.dao.GenericDao Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jodd-all Show documentation
Show all versions of jodd-all Show documentation
Jodd bundle - all classes in one jar
// Copyright (c) 2003-present, Jodd Team (http://jodd.org)
// All rights reserved.
//
// Redistribution and use in source and binary forms, with or without
// modification, are permitted provided that the following conditions are met:
//
// 1. Redistributions of source code must retain the above copyright notice,
// this list of conditions and the following disclaimer.
//
// 2. Redistributions in binary form must reproduce the above copyright
// notice, this list of conditions and the following disclaimer in the
// documentation and/or other materials provided with the distribution.
//
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
// AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
// IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
// ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
// LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
// CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
// SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
// INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
// CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
// ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
// POSSIBILITY OF SUCH DAMAGE.
package jodd.db.oom.dao;
import jodd.bean.BeanUtil;
import jodd.db.DbOom;
import jodd.db.DbQuery;
import jodd.db.oom.DbEntityDescriptor;
import jodd.db.oom.DbOomException;
import java.util.List;
import static jodd.db.oom.DbOomQuery.query;
/**
* Generic DAO. Contains many convenient wrappers.
*/
public class GenericDao {
private final DbOom dbOom;
public GenericDao(final DbOom dbOom) {
this.dbOom = dbOom;
}
// ---------------------------------------------------------------- store
/**
* Returns true if entity is persistent.
*/
protected boolean isPersistent(final DbEntityDescriptor ded, final E entity) {
final Object key = ded.getIdValue(entity);
if (key == null) {
return false;
}
if (key instanceof Number) {
final long value = ((Number)key).longValue();
if (value == 0) {
return false;
}
}
return true;
}
/**
* Sets new ID value for entity.
*/
protected void setEntityId(final DbEntityDescriptor ded, final E entity, final ID newIdValue) {
ded.setIdValue(entity, newIdValue);
}
/**
* Generates next id for given type.
*/
protected ID generateNextId(final DbEntityDescriptor dbEntityDescriptor) {
throw new UnsupportedOperationException("Use Joy");
}
/**
* Saves or updates entity. If ID is not null, entity will be updated.
* Otherwise, entity will be inserted into the database.
*/
public E store(final E entity) {
final Class type = entity.getClass();
final DbEntityDescriptor ded = dbOom.entityManager().lookupType(type);
if (ded == null) {
throw new DbOomException("Not an entity: " + type);
}
if (!isPersistent(ded, entity)) {
final DbQuery q;
if (dbOom.config().isKeysGeneratedByDatabase()) {
q = query(dbOom.entities().insert(entity));
q.setGeneratedKey();
q.executeUpdate();
final Object nextId = q.getGeneratedKey();
setEntityId(ded, entity, nextId);
}
else {
final Object nextId = generateNextId(ded);
setEntityId(ded, entity, nextId);
q = query(dbOom.entities().insert(entity));
q.executeUpdate();
}
q.close();
}
else {
query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate();
}
return entity;
}
/**
* Simply inserts object into the database.
*/
public void save(final Object entity) {
final DbQuery q = query(dbOom.entities().insert(entity));
q.autoClose().executeUpdate();
}
/**
* Inserts bunch of objects into the database.
* @see #save(Object)
*/
public void saveAll(final Iterable entities) {
for (final Object entity: entities) {
save(entity);
}
}
// ---------------------------------------------------------------- update
/**
* Updates single entity.
*/
public void update(final Object entity) {
query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate();
}
/**
* Updates all entities.
* @see #update(Object)
*/
public void updateAll(final Iterable entities) {
for (final Object entity : entities) {
update(entity);
}
}
/**
* Updates single property in database and in the bean.
*/
public 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 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;
}
// ---------------------------------------------------------------- find
/**
* Finds single entity by its id.
*/
public E findById(final Class entityType, final ID id) {
return query(dbOom.entities().findById(entityType, id)).autoClose().find(entityType);
}
/**
* Finds single entity by matching property.
*/
public E findOneByProperty(final Class entityType, final String name, final Object value) {
return query(dbOom.entities().findByColumn(entityType, name, value)).autoClose().find(entityType);
}
/**
* Finds one entity for given criteria.
*/
@SuppressWarnings({"unchecked"})
public E findOne(final Object criteria) {
return (E) query(dbOom.entities().find(criteria)).autoClose().find(criteria.getClass());
}
/**
* Finds list of entities matching given criteria.
*/
@SuppressWarnings({"unchecked"})
public List find(final Object criteria) {
return query(dbOom.entities().find(criteria)).autoClose().list(criteria.getClass());
}
/**
* Finds list of entities matching given criteria.
*/
public List find(final Class entityType, final Object criteria) {
return query(dbOom.entities().find(entityType, criteria)).autoClose().list(entityType);
}
// ---------------------------------------------------------------- delete
/**
* Deleted single entity by its id.
*/
public void deleteById(final Class entityType, final ID id) {
query(dbOom.entities().deleteById(entityType, id)).autoClose().executeUpdate();
}
/**
* 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);
}
}
}
/**
* Deletes all objects by their ids.
*/
public void deleteAllById(final Iterable objects) {
for (final Object entity : objects) {
deleteById(entity);
}
}
// ---------------------------------------------------------------- count
/**
* Counts number of all entities.
*/
public long count(final Class entityType) {
return query(dbOom.entities().count(entityType)).autoClose().executeCount();
}
// ---------------------------------------------------------------- increase
/**
* Increases a property.
*/
public 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();
}
/**
* Decreases a property.
*/
public 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();
}
// ---------------------------------------------------------------- related
/**
* Finds related entity.
*/
public List findRelated(final Class target, final Object source) {
return query(dbOom.entities().findForeign(target, source)).autoClose().list(target);
}
// ---------------------------------------------------------------- list
/**
* List all entities.
*/
public List listAll(final Class target) {
return query(dbOom.entities().from(target)).autoClose().list(target);
}
}