Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
net.gdface.facelog.BaseDao Maven / Gradle / Ivy
// ______________________________________________________
// Generated by sql2java - https://github.com/10km/sql2java
// JDBC driver used at code generation time: com.mysql.jdbc.Driver
// template: base.dao.java.vm
// ______________________________________________________
package net.gdface.facelog;
import static com.google.common.base.Preconditions.*;
import static gu.sql2java.Managers.*;
import com.google.common.base.Throwables;
import java.text.SimpleDateFormat;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.util.concurrent.Callable;
import com.google.common.base.Function;
import com.google.common.collect.ImmutableList;
import com.google.common.collect.Lists;
import gu.sql2java.TableManager;
import gu.sql2java.BaseBean;
import gu.sql2java.Managers;
import net.gdface.facelog.db.Constant;
import net.gdface.facelog.db.*;
import gu.sql2java.exception.ObjectRetrievalException;
import gu.sql2java.exception.RuntimeDaoException;
/**
* 数据库访问基础方法
* @author guyadong
*
*/
class BaseDao implements CommonConstant,Constant {
static{
TableManagerInitializer.INSTANCE.init();
}
/** 生成 SQL where 语句,example: {@code WHERE create_time >'2017-09-02 12:12:12'} */
static private String makeWhere(Date timestamp,String field){
SimpleDateFormat formatter = new SimpleDateFormat(TIMESTAMP_FORMATTER_STR);
return String.format(
"WHERE %s > '%s'",
field,
formatter.format(checkNotNull(timestamp)));
}
/**
* 事务执行
* @throws RuntimeDaoException
*/
protected static T daoRunAsTransaction(Callable fun)
throws RuntimeDaoException{
return Managers.getSqlRunner().runAsTransaction(checkNotNull(fun));
}
/**
* 事务执行
* @throws RuntimeDaoException
*/
protected static void daoRunAsTransaction(Runnable fun)
throws RuntimeDaoException{
Managers.getSqlRunner().runAsTransaction(checkNotNull(fun));
}
/**
* 查询 {@code table}表的{@code column}字段的数据
* @param table 数据库表名
* @param column 有效的table表字段名或table对应java类的字段名
* @param distinct 为{@code true}只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @return {@code column}字段记录
* @see TableManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protectedList daoLoadColumnAsList(String table,String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return managerOf(table).loadColumnAsList(column, distinct, where, startRow, numRows);
}
/**
* 查询 {@code table}表的{@code column}字段的数据
* @param table 数据库表名
* @param column 有效的table表字段名或table对应java类的字段名
* @param distinct 为{@code true}只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @see TableManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protectedList daoLoadColumnAsList(String table,String column,boolean distinct,String where)
throws RuntimeDaoException{
return managerOf(table).loadColumnAsList(column, distinct, where, 1, -1);
}
protected static final void throwCauseIfInstanceOf(Exception error,Class expType) throws T {
if(null != error.getCause()){
Throwables.throwIfInstanceOf(error.getCause(),expType);
}
}
/**
* 数据库写操作类型
* @author guyadong
*
*/
protected enum WriteOp{
/** 增加记录 */insert,
/** 更新记录 */update,
/** 删除记录 */delete
}
//////////// FL_DEVICE /////////
final IDeviceManager deviceManager = instanceOf(IDeviceManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetDevices(Collection idCollection)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).loadByPrimaryKey(idCollection);
}
//3
/**
* 删除主键列表({@code idCollection})指定的记录
* @return 返回删除的记录条数
* @see IDeviceManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeleteDevicesByPrimaryKey(Collection idCollection)
throws RuntimeDaoException{
int count =0;
if(null != idCollection){
for(Integer id:idCollection){
count += daoDeleteDevice(id);
}
}
return count;
}
//3-5
/** transformer : DeviceBean to fl_device.id */
protected final Function daoCastDeviceToPk = new Function(){
@Override
public Integer apply(DeviceBean input) {
return null == input ? null : input.getId();
}};
//3-6
/** transformer : fl_device.id to DeviceBean */
protected final Function daoCastDeviceFromPk = new Function(){
@Override
public DeviceBean apply(Integer input) {
return daoGetDevice(input);
}};
//3-8
/**
* unwrap primary key from {@link DeviceBean} daoToPrimaryKeyListFromDevices(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IDeviceManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link DeviceBean} daoToPrimaryKeyListFromDevices(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastDeviceToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param id 设备id
* @see IDeviceManager#existsPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected boolean daoExistsDevice(Integer id)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).existsPrimaryKey(id);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsDevice(DeviceBean bean)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param id 设备id
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IDeviceManager#deleteByPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDevice(Integer id)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).deleteByPrimaryKey(id);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeleteDevice(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDevice(DeviceBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeleteDevice(bean.getId());
}
//5-3
/**
* 删除唯一键指定的记录
*
* @param mac 6字节MAC地址(HEX)
* @return 返回删除的记录条数(1),输入参数为{@code null}或记录不存在返回0
* @see #daoDeleteDevice(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceByIndexMac(String mac)
throws RuntimeDaoException{
return (null == mac)
? 0
: instanceOf(IDeviceManager.class).deleteByIndexMac(mac);
}
//5-3
/**
* 删除唯一键指定的记录
*
* @param serialNo 设备序列号
* @return 返回删除的记录条数(1),输入参数为{@code null}或记录不存在返回0
* @see #daoDeleteDevice(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceByIndexSerialNo(String serialNo)
throws RuntimeDaoException{
return (null == serialNo)
? 0
: instanceOf(IDeviceManager.class).deleteByIndexSerialNo(serialNo);
}
//6
/**
* 删除{@code deviceBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeleteDevice(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDevices(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(DeviceBean bean:beans){
count += daoDeleteDevice(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected DeviceBean daoCheckDuplicate(DeviceBean deviceBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IDeviceManager.class).checkDuplicate(deviceBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param id 设备id
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code idOfDevice}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected Integer daoCheckDuplicateDevice(Integer id)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IDeviceManager.class).existsPrimaryKey(id)){
throw new DuplicateRecordException();
}
return id;
}
//8
/**
* 返回外键(fl_error_log.device_id)引用指定记录(fl_device.id)的所有{@code fl_error_log}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#getErrorLogBeansByDeviceIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetErrorLogBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).getErrorLogBeansByDeviceIdAsList(idOfDevice);
}
//8-2
/**
* 删除外键(idOfDevice))引用指定记录(fl_device.id)的所有{@code fl_error_log}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#deleteErrorLogBeansByDeviceId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteErrorLogBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).deleteErrorLogBeansByDeviceId(idOfDevice);
}
//8
/**
* 返回外键(fl_image.device_id)引用指定记录(fl_device.id)的所有{@code fl_image}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#getImageBeansByDeviceIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetImageBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).getImageBeansByDeviceIdAsList(idOfDevice);
}
//8-2
/**
* 删除外键(idOfDevice))引用指定记录(fl_device.id)的所有{@code fl_image}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#deleteImageBeansByDeviceId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteImageBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).deleteImageBeansByDeviceId(idOfDevice);
}
//8
/**
* 返回外键(fl_log.device_id)引用指定记录(fl_device.id)的所有{@code fl_log}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#getLogBeansByDeviceIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetLogBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).getLogBeansByDeviceIdAsList(idOfDevice);
}
//8-2
/**
* 删除外键(idOfDevice))引用指定记录(fl_device.id)的所有{@code fl_log}记录
*
* @param idOfDevice 设备id
* @see IDeviceManager#deleteLogBeansByDeviceId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteLogBeansByDeviceIdOnDevice(Integer idOfDevice)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).deleteLogBeansByDeviceId(idOfDevice);
}
//8-3
/**
* 返回外键(fl_device.group_id)引用的 fl_device_group 记录
* @param bean
* @see IDeviceManager#getReferencedByGroupId(DeviceBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoGetReferencedByGroupIdOnDevice(DeviceBean bean)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).getReferencedByGroupId(bean);
}
//8-4
/**
* 设置外键fl_device(group_id)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IDeviceManager#setReferencedByGroupId(DeviceBean,DeviceGroupBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoSetReferencedByGroupIdOnDevice(DeviceBean bean,DeviceGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).setReferencedByGroupId(bean,beanToSet);
}
//8-6
/** transformer : DeviceBean to fl_device.group_id */
protected final Function daoCastDeviceToGroupId = new Function(){
@Override
public Integer apply(DeviceBean input) {
return null == input ? null : input.getGroupId();
}};
//8-8
/** transformer : fl_device.id to fl_device.group_id */
protected final Function daoCastDevicePkToGroupId = new Function(){
@Override
public Integer apply(Integer input) {
return null == input
? null
: daoCastDeviceToGroupId.apply(daoGetDevice(input));
}};
//14
/**
* 参见 {@link TableManager#save(BaseBean)}
* @throws RuntimeDaoException
*/
protected DeviceBean daoSaveDevice(DeviceBean deviceBean)
throws RuntimeDaoException{
daoCheckGroup(deviceBean);
return instanceOf(IDeviceManager.class).save(deviceBean);
}
//15
/** 同步保存 impErrorlogByDeviceId
, Collection impImageByDeviceId
, Collection impLogByDeviceId )throws RuntimeDaoException{
daoCheckGroup(deviceBean);
return instanceOf(IDeviceManager.class).save(deviceBean
, refDevicegroupByGroupId
, impErrorlogByDeviceId
, impImageByDeviceId
, impLogByDeviceId );
}
//12-3-3
/**
* 添加新记录 daoSaveDevices(Collection beans)
throws RuntimeDaoException {
if(null != beans){
for(DeviceBean bean : beans){
daoSaveDevice(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoSaveDevices(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoSaveDevicesAsTransaction(final Collection beans)
throws RuntimeDaoException {
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoSaveDevices(beans);
}});
}catch(RuntimeException e){
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_device 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IDeviceManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_device 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceUsingTemplate(DeviceBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_device 的{@code column}字段的数据
* @param column 有效的fl_device表字段名或{@link DeviceBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IDeviceManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfDeviceAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_device 表的所有记录
* @see IDeviceManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceAll()
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_device 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IDeviceManager.class).countWhere(where);
}
//18
/**
* 查询{@code where}条件指定的记录
* @return 返回查询结果记录的主键
* @see #daoLoadDeviceByWhere(String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceIdByWhere(String where)
throws RuntimeDaoException{
return daoToPrimaryKeyListFromDevices(daoLoadDeviceByWhere(where,1,-1));
}
//18-5
/**
* 索引(fl_device.mac)查询,没有找到记录返回{@code null} daoLoadDeviceByCreateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadDeviceByWhere(makeWhere(timestamp,"create_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadDeviceByCreateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceByCreateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_device.create_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountDeviceByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountDeviceByWhere(makeWhere(timestamp,"create_time"));
}
//21
/**
* (主动更新机制实现) daoLoadDeviceIdByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceIdByWhere(makeWhere(timestamp,"create_time"));
}
//19
/**
* (主动更新机制实现) daoLoadDeviceByUpdateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadDeviceByWhere(makeWhere(timestamp,"update_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadDeviceByUpdateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceByUpdateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_device.update_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountDeviceByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountDeviceByWhere(makeWhere(timestamp,"update_time"));
}
//21
/**
* (主动更新机制实现) daoLoadDeviceIdByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceIdByWhere(makeWhere(timestamp,"update_time"));
}
//////////// FL_DEVICE_GROUP /////////
final IDeviceGroupManager deviceGroupManager = instanceOf(IDeviceGroupManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetDeviceGroups(Collection idCollection)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).loadByPrimaryKey(idCollection);
}
//3
/**
* 删除主键列表({@code idCollection})指定的记录
* @return 返回删除的记录条数
* @see IDeviceGroupManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceGroupsByPrimaryKey(Collection idCollection)
throws RuntimeDaoException{
int count =0;
if(null != idCollection){
for(Integer id:idCollection){
count += daoDeleteDeviceGroup(id);
}
}
return count;
}
//3-5
/** transformer : DeviceGroupBean to fl_device_group.id */
protected final Function daoCastDeviceGroupToPk = new Function(){
@Override
public Integer apply(DeviceGroupBean input) {
return null == input ? null : input.getId();
}};
//3-6
/** transformer : fl_device_group.id to DeviceGroupBean */
protected final Function daoCastDeviceGroupFromPk = new Function(){
@Override
public DeviceGroupBean apply(Integer input) {
return daoGetDeviceGroup(input);
}};
//3-8
/**
* unwrap primary key from {@link DeviceGroupBean} daoToPrimaryKeyListFromDeviceGroups(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IDeviceGroupManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link DeviceGroupBean} daoToPrimaryKeyListFromDeviceGroups(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastDeviceGroupToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param id 设备组id
* @see IDeviceGroupManager#existsPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected boolean daoExistsDeviceGroup(Integer id)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).existsPrimaryKey(id);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsDeviceGroup(DeviceGroupBean bean)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param id 设备组id
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IDeviceGroupManager#deleteByPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceGroup(Integer id)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).deleteByPrimaryKey(id);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeleteDeviceGroup(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceGroup(DeviceGroupBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeleteDeviceGroup(bean.getId());
}
//6
/**
* 删除{@code deviceGroupBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeleteDeviceGroup(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceGroups(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(DeviceGroupBean bean:beans){
count += daoDeleteDeviceGroup(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected DeviceGroupBean daoCheckDuplicate(DeviceGroupBean deviceGroupBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IDeviceGroupManager.class).checkDuplicate(deviceGroupBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param id 设备组id
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code idOfDeviceGroup}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected Integer daoCheckDuplicateDeviceGroup(Integer id)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IDeviceGroupManager.class).existsPrimaryKey(id)){
throw new DuplicateRecordException();
}
return id;
}
//8
/**
* 返回属于{@code idOfDeviceGroup}指定组的所有{@code fl_device}记录
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#getDeviceBeansByGroupIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetDevicesOfGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).getDeviceBeansByGroupIdAsList(idOfDeviceGroup);
}
//8-2
/**
* 删除外键(idOfDeviceGroup))引用指定记录(fl_device_group.id)的所有{@code fl_device}记录
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#deleteDeviceBeansByGroupId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceBeansByGroupIdOnDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).deleteDeviceBeansByGroupId(idOfDeviceGroup);
}
//8
/**
* 返回{@code idOfDeviceGroup)}指定的组下的所有子节点,如果没有子节点则返回空表
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#getDeviceGroupBeansByParentAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetSubDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).getDeviceGroupBeansByParentAsList(idOfDeviceGroup);
}
//8-2
/**
* 删除外键(idOfDeviceGroup))引用指定记录(fl_device_group.id)的所有{@code fl_device_group}记录
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#deleteDeviceGroupBeansByParent(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteDeviceGroupBeansByParentOnDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).deleteDeviceGroupBeansByParent(idOfDeviceGroup);
}
//8
/**
* 返回外键(fl_permit.device_group_id)引用指定记录(fl_device_group.id)的所有{@code fl_permit}记录
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#getPermitBeansByDeviceGroupIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetPermitBeansByDeviceGroupIdOnDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).getPermitBeansByDeviceGroupIdAsList(idOfDeviceGroup);
}
//8-2
/**
* 删除外键(idOfDeviceGroup))引用指定记录(fl_device_group.id)的所有{@code fl_permit}记录
*
* @param idOfDeviceGroup 设备组id
* @see IDeviceGroupManager#deletePermitBeansByDeviceGroupId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePermitBeansByDeviceGroupIdOnDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).deletePermitBeansByDeviceGroupId(idOfDeviceGroup);
}
//8-3
/**
* 返回外键(fl_device_group.parent)引用的 fl_device_group 记录
* @param bean
* @see IDeviceGroupManager#getReferencedByParent(DeviceGroupBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoGetReferencedByParentOnDeviceGroup(DeviceGroupBean bean)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).getReferencedByParent(bean);
}
//8-4
/**
* 设置外键fl_device_group(parent)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IDeviceGroupManager#setReferencedByParent(DeviceGroupBean,DeviceGroupBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoSetReferencedByParentOnDeviceGroup(DeviceGroupBean bean,DeviceGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).setReferencedByParent(bean,beanToSet);
}
//9
/**
* 返回(idOfDeviceGroup))指定的fl_device_group记录的所有的父节点(包括自己) daoListOfParentForDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).listOfParent(idOfDeviceGroup);
}
//9-2
/**
* 返回{@code deviceGroupBean}指定的fl_device_group记录的所有的父节点(包括自己) daoListOfParentForDeviceGroup(DeviceGroupBean deviceGroupBean)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).listOfParent(deviceGroupBean);
}
//9-3
/**
* 返回(idOfDeviceGroup))指定的fl_device_group记录的所有的子节点(包括自己) daoChildListByParentForDeviceGroup(Integer idOfDeviceGroup)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).childListByParent(idOfDeviceGroup);
}
//9-4
/**
* 返回{@code deviceGroupBean}指定的fl_device_group记录的所有的子节点(包括自己) daoChildListByParentForDeviceGroup(DeviceGroupBean deviceGroupBean)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).childListByParent(deviceGroupBean);
}
//10
/**
* 如果没有默认组则向 fl_device_group 表中增加默认组,失败则抛出异常
*
* @throws IllegalStateException 创建失败
* @throws RuntimeDaoException
*/
protected void daoSaveDefaultDeviceGroupIfAbsent()
throws RuntimeDaoException{
if(!daoExistsDeviceGroup(DEFAULT_GROUP_ID)){
try{
DeviceGroupBean bean = new DeviceGroupBean(DEFAULT_GROUP_ID);
bean.setName(DEFAULT_GROUP_NAME);
daoSaveDeviceGroup(bean);
}catch(RuntimeDaoException e){
// do nothing
}
if(!daoExistsDeviceGroup(DEFAULT_GROUP_ID)){
throw new IllegalStateException("can't create default group for device_group");
}
}
}
//11
/**
* 检查{@link DeviceBean}的'group_id'字段是否为默认组{@link CommonConstant#DEFAULT_GROUP_ID},
* 如果是,且默认组记录不存在则创建默认组
* @return {@code deviceBean}
* @see #daoSaveDefaultDeviceGroupIfAbsent()
* @throws RuntimeDaoException
*/
protected DeviceBean daoCheckGroup(DeviceBean deviceBean)
throws RuntimeDaoException{
if(null != deviceBean && Objects.equals(deviceBean.getGroupId(), DEFAULT_GROUP_ID)){
daoSaveDefaultDeviceGroupIfAbsent();
}
return deviceBean;
}
//14
/**
* 参见 {@link TableManager#save(BaseBean)}
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoSaveDeviceGroup(DeviceGroupBean deviceGroupBean)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).save(deviceGroupBean);
}
//15
/** 同步保存 impDeviceByGroupId
, Collection impDevicegroupByParent
, Collection impPermitByDeviceGroupId )throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).save(deviceGroupBean
, refDevicegroupByParent
, impDeviceByGroupId
, impDevicegroupByParent
, impPermitByDeviceGroupId );
}
//12-3-3
/**
* 添加新记录 daoSaveDeviceGroups(Collection beans)
throws RuntimeDaoException {
if(null != beans){
for(DeviceGroupBean bean : beans){
daoSaveDeviceGroup(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoSaveDeviceGroups(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoSaveDeviceGroupsAsTransaction(final Collection beans)
throws RuntimeDaoException {
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoSaveDeviceGroups(beans);
}});
}catch(RuntimeException e){
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_device_group 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IDeviceGroupManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_device_group 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupUsingTemplate(DeviceGroupBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_device_group 的{@code column}字段的数据
* @param column 有效的fl_device_group表字段名或{@link DeviceGroupBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IDeviceGroupManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfDeviceGroupAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_device_group 表的所有记录
* @see IDeviceGroupManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupAll()
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_device_group 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceGroupByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IDeviceGroupManager.class).countWhere(where);
}
//18
/**
* 查询{@code where}条件指定的记录
* @return 返回查询结果记录的主键
* @see #daoLoadDeviceGroupByWhere(String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupIdByWhere(String where)
throws RuntimeDaoException{
return daoToPrimaryKeyListFromDeviceGroups(daoLoadDeviceGroupByWhere(where,1,-1));
}
//19
/**
* (主动更新机制实现) daoLoadDeviceGroupByCreateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadDeviceGroupByWhere(makeWhere(timestamp,"create_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadDeviceGroupByCreateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceGroupByCreateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_device_group.create_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountDeviceGroupByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceGroupByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountDeviceGroupByWhere(makeWhere(timestamp,"create_time"));
}
//21
/**
* (主动更新机制实现) daoLoadDeviceGroupIdByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceGroupIdByWhere(makeWhere(timestamp,"create_time"));
}
//19
/**
* (主动更新机制实现) daoLoadDeviceGroupByUpdateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadDeviceGroupByWhere(makeWhere(timestamp,"update_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadDeviceGroupByUpdateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadDeviceGroupByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceGroupByUpdateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_device_group.update_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountDeviceGroupByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountDeviceGroupByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountDeviceGroupByWhere(makeWhere(timestamp,"update_time"));
}
//21
/**
* (主动更新机制实现) daoLoadDeviceGroupIdByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadDeviceGroupIdByWhere(makeWhere(timestamp,"update_time"));
}
//////////// FL_PERSON /////////
final IPersonManager personManager = instanceOf(IPersonManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetPersons(Collection idCollection)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).loadByPrimaryKey(idCollection);
}
//3
/**
* 删除主键列表({@code idCollection})指定的记录
* @return 返回删除的记录条数
* @see IPersonManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonsByPrimaryKey(Collection idCollection)
throws RuntimeDaoException{
int count =0;
if(null != idCollection){
for(Integer id:idCollection){
count += daoDeletePerson(id);
}
}
return count;
}
//3-5
/** transformer : PersonBean to fl_person.id */
protected final Function daoCastPersonToPk = new Function(){
@Override
public Integer apply(PersonBean input) {
return null == input ? null : input.getId();
}};
//3-6
/** transformer : fl_person.id to PersonBean */
protected final Function daoCastPersonFromPk = new Function(){
@Override
public PersonBean apply(Integer input) {
return daoGetPerson(input);
}};
//3-8
/**
* unwrap primary key from {@link PersonBean} daoToPrimaryKeyListFromPersons(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IPersonManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link PersonBean} daoToPrimaryKeyListFromPersons(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastPersonToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param id 用户id
* @see IPersonManager#existsPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected boolean daoExistsPerson(Integer id)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).existsPrimaryKey(id);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsPerson(PersonBean bean)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param id 用户id
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IPersonManager#deleteByPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePerson(Integer id)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).deleteByPrimaryKey(id);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeletePerson(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePerson(PersonBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeletePerson(bean.getId());
}
//5-3
/**
* 删除唯一键指定的记录
*
* @param imageMd5 用户默认照片(证件照,标准照)的md5校验码,外键
* @return 返回删除的记录条数(1),输入参数为{@code null}或记录不存在返回0
* @see #daoDeletePerson(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonByIndexImageMd5(String imageMd5)
throws RuntimeDaoException{
return (null == imageMd5)
? 0
: instanceOf(IPersonManager.class).deleteByIndexImageMd5(imageMd5);
}
//5-3
/**
* 删除唯一键指定的记录
*
* @param mobilePhone 手机号码
* @return 返回删除的记录条数(1),输入参数为{@code null}或记录不存在返回0
* @see #daoDeletePerson(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonByIndexMobilePhone(String mobilePhone)
throws RuntimeDaoException{
return (null == mobilePhone)
? 0
: instanceOf(IPersonManager.class).deleteByIndexMobilePhone(mobilePhone);
}
//5-3
/**
* 删除唯一键指定的记录
*
* @param papersNum 证件号码
* @return 返回删除的记录条数(1),输入参数为{@code null}或记录不存在返回0
* @see #daoDeletePerson(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonByIndexPapersNum(String papersNum)
throws RuntimeDaoException{
return (null == papersNum)
? 0
: instanceOf(IPersonManager.class).deleteByIndexPapersNum(papersNum);
}
//6
/**
* 删除{@code personBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeletePerson(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersons(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(PersonBean bean:beans){
count += daoDeletePerson(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected PersonBean daoCheckDuplicate(PersonBean personBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IPersonManager.class).checkDuplicate(personBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param id 用户id
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code idOfPerson}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected Integer daoCheckDuplicatePerson(Integer id)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IPersonManager.class).existsPrimaryKey(id)){
throw new DuplicateRecordException();
}
return id;
}
//8
/**
* 返回外键(fl_error_log.person_id)引用指定记录(fl_person.id)的所有{@code fl_error_log}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#getErrorLogBeansByPersonIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetErrorLogBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).getErrorLogBeansByPersonIdAsList(idOfPerson);
}
//8-2
/**
* 删除外键(idOfPerson))引用指定记录(fl_person.id)的所有{@code fl_error_log}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#deleteErrorLogBeansByPersonId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteErrorLogBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).deleteErrorLogBeansByPersonId(idOfPerson);
}
//8
/**
* 返回外键(fl_feature.person_id)引用指定记录(fl_person.id)的所有{@code fl_feature}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#getFeatureBeansByPersonIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetFeatureBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).getFeatureBeansByPersonIdAsList(idOfPerson);
}
//8-2
/**
* 删除外键(idOfPerson))引用指定记录(fl_person.id)的所有{@code fl_feature}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#deleteFeatureBeansByPersonId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteFeatureBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).deleteFeatureBeansByPersonId(idOfPerson);
}
//8
/**
* 返回外键(fl_log.person_id)引用指定记录(fl_person.id)的所有{@code fl_log}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#getLogBeansByPersonIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetLogBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).getLogBeansByPersonIdAsList(idOfPerson);
}
//8-2
/**
* 删除外键(idOfPerson))引用指定记录(fl_person.id)的所有{@code fl_log}记录
*
* @param idOfPerson 用户id
* @see IPersonManager#deleteLogBeansByPersonId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteLogBeansByPersonIdOnPerson(Integer idOfPerson)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).deleteLogBeansByPersonId(idOfPerson);
}
//8-3
/**
* 返回外键(fl_person.image_md5)引用的 fl_image 记录
* @param bean
* @see IPersonManager#getReferencedByImageMd5(PersonBean)
* @throws RuntimeDaoException
*/
protected ImageBean daoGetReferencedByImageMd5OnPerson(PersonBean bean)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).getReferencedByImageMd5(bean);
}
//8-4
/**
* 设置外键fl_person(image_md5)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IPersonManager#setReferencedByImageMd5(PersonBean,ImageBean)
* @throws RuntimeDaoException
*/
protected ImageBean daoSetReferencedByImageMd5OnPerson(PersonBean bean,ImageBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).setReferencedByImageMd5(bean,beanToSet);
}
//8-6
/** transformer : PersonBean to fl_person.image_md5 */
protected final Function daoCastPersonToImageMd5 = new Function(){
@Override
public String apply(PersonBean input) {
return null == input ? null : input.getImageMd5();
}};
//8-8
/** transformer : fl_person.id to fl_person.image_md5 */
protected final Function daoCastPersonPkToImageMd5 = new Function(){
@Override
public String apply(Integer input) {
return null == input
? null
: daoCastPersonToImageMd5.apply(daoGetPerson(input));
}};
//8-3
/**
* 返回外键(fl_person.group_id)引用的 fl_person_group 记录
* @param bean
* @see IPersonManager#getReferencedByGroupId(PersonBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoGetReferencedByGroupIdOnPerson(PersonBean bean)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).getReferencedByGroupId(bean);
}
//8-4
/**
* 设置外键fl_person(group_id)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IPersonManager#setReferencedByGroupId(PersonBean,PersonGroupBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoSetReferencedByGroupIdOnPerson(PersonBean bean,PersonGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).setReferencedByGroupId(bean,beanToSet);
}
//8-6
/** transformer : PersonBean to fl_person.group_id */
protected final Function daoCastPersonToGroupId = new Function(){
@Override
public Integer apply(PersonBean input) {
return null == input ? null : input.getGroupId();
}};
//8-8
/** transformer : fl_person.id to fl_person.group_id */
protected final Function daoCastPersonPkToGroupId = new Function(){
@Override
public Integer apply(Integer input) {
return null == input
? null
: daoCastPersonToGroupId.apply(daoGetPerson(input));
}};
//14
/**
* 参见 {@link TableManager#save(BaseBean)}
* @throws RuntimeDaoException
*/
protected PersonBean daoSavePerson(PersonBean personBean)
throws RuntimeDaoException{
daoCheckGroup(personBean);
return instanceOf(IPersonManager.class).save(personBean);
}
//15
/** 同步保存 impErrorlogByPersonId
, Collection impFeatureByPersonId
, Collection impLogByPersonId )throws RuntimeDaoException{
daoCheckGroup(personBean);
return instanceOf(IPersonManager.class).save(personBean
, refImageByImageMd5
, refPersongroupByGroupId
, impErrorlogByPersonId
, impFeatureByPersonId
, impLogByPersonId );
}
//12-3-3
/**
* 添加新记录 daoSavePersons(Collection beans)
throws RuntimeDaoException {
if(null != beans){
for(PersonBean bean : beans){
daoSavePerson(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoSavePersons(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoSavePersonsAsTransaction(final Collection beans)
throws RuntimeDaoException {
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoSavePersons(beans);
}});
}catch(RuntimeException e){
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_person 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPersonManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_person 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonUsingTemplate(PersonBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_person 的{@code column}字段的数据
* @param column 有效的fl_person表字段名或{@link PersonBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPersonManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfPersonAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_person 表的所有记录
* @see IPersonManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadPersonAll()
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_person 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IPersonManager.class).countWhere(where);
}
//18
/**
* 查询{@code where}条件指定的记录
* @return 返回查询结果记录的主键
* @see #daoLoadPersonByWhere(String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonIdByWhere(String where)
throws RuntimeDaoException{
return daoToPrimaryKeyListFromPersons(daoLoadPersonByWhere(where,1,-1));
}
//18-5
/**
* 索引(fl_person.image_md5)查询,没有找到记录返回{@code null} daoLoadPersonByCreateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadPersonByWhere(makeWhere(timestamp,"create_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadPersonByCreateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadPersonByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonByCreateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_person.create_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountPersonByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountPersonByWhere(makeWhere(timestamp,"create_time"));
}
//21
/**
* (主动更新机制实现) daoLoadPersonIdByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonIdByWhere(makeWhere(timestamp,"create_time"));
}
//19
/**
* (主动更新机制实现) daoLoadPersonByUpdateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadPersonByWhere(makeWhere(timestamp,"update_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadPersonByUpdateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadPersonByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonByUpdateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_person.update_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountPersonByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountPersonByWhere(makeWhere(timestamp,"update_time"));
}
//21
/**
* (主动更新机制实现) daoLoadPersonIdByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonIdByWhere(makeWhere(timestamp,"update_time"));
}
//////////// FL_PERSON_GROUP /////////
final IPersonGroupManager personGroupManager = instanceOf(IPersonGroupManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetPersonGroups(Collection idCollection)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).loadByPrimaryKey(idCollection);
}
//3
/**
* 删除主键列表({@code idCollection})指定的记录
* @return 返回删除的记录条数
* @see IPersonGroupManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonGroupsByPrimaryKey(Collection idCollection)
throws RuntimeDaoException{
int count =0;
if(null != idCollection){
for(Integer id:idCollection){
count += daoDeletePersonGroup(id);
}
}
return count;
}
//3-5
/** transformer : PersonGroupBean to fl_person_group.id */
protected final Function daoCastPersonGroupToPk = new Function(){
@Override
public Integer apply(PersonGroupBean input) {
return null == input ? null : input.getId();
}};
//3-6
/** transformer : fl_person_group.id to PersonGroupBean */
protected final Function daoCastPersonGroupFromPk = new Function(){
@Override
public PersonGroupBean apply(Integer input) {
return daoGetPersonGroup(input);
}};
//3-8
/**
* unwrap primary key from {@link PersonGroupBean} daoToPrimaryKeyListFromPersonGroups(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IPersonGroupManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link PersonGroupBean} daoToPrimaryKeyListFromPersonGroups(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastPersonGroupToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param id 用户组id
* @see IPersonGroupManager#existsPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected boolean daoExistsPersonGroup(Integer id)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).existsPrimaryKey(id);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsPersonGroup(PersonGroupBean bean)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param id 用户组id
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IPersonGroupManager#deleteByPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonGroup(Integer id)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).deleteByPrimaryKey(id);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeletePersonGroup(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonGroup(PersonGroupBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeletePersonGroup(bean.getId());
}
//6
/**
* 删除{@code personGroupBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeletePersonGroup(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonGroups(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(PersonGroupBean bean:beans){
count += daoDeletePersonGroup(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected PersonGroupBean daoCheckDuplicate(PersonGroupBean personGroupBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IPersonGroupManager.class).checkDuplicate(personGroupBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param id 用户组id
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code idOfPersonGroup}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected Integer daoCheckDuplicatePersonGroup(Integer id)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IPersonGroupManager.class).existsPrimaryKey(id)){
throw new DuplicateRecordException();
}
return id;
}
//8
/**
* 返回外键(fl_permit.person_group_id)引用指定记录(fl_person_group.id)的所有{@code fl_permit}记录
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#getPermitBeansByPersonGroupIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetPermitBeansByPersonGroupIdOnPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).getPermitBeansByPersonGroupIdAsList(idOfPersonGroup);
}
//8-2
/**
* 删除外键(idOfPersonGroup))引用指定记录(fl_person_group.id)的所有{@code fl_permit}记录
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#deletePermitBeansByPersonGroupId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePermitBeansByPersonGroupIdOnPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).deletePermitBeansByPersonGroupId(idOfPersonGroup);
}
//8
/**
* 返回属于{@code idOfPersonGroup}指定组的所有{@code fl_person}记录
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#getPersonBeansByGroupIdAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetPersonsOfGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).getPersonBeansByGroupIdAsList(idOfPersonGroup);
}
//8-2
/**
* 删除外键(idOfPersonGroup))引用指定记录(fl_person_group.id)的所有{@code fl_person}记录
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#deletePersonBeansByGroupId(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonBeansByGroupIdOnPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).deletePersonBeansByGroupId(idOfPersonGroup);
}
//8
/**
* 返回{@code idOfPersonGroup)}指定的组下的所有子节点,如果没有子节点则返回空表
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#getPersonGroupBeansByParentAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetSubPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).getPersonGroupBeansByParentAsList(idOfPersonGroup);
}
//8-2
/**
* 删除外键(idOfPersonGroup))引用指定记录(fl_person_group.id)的所有{@code fl_person_group}记录
*
* @param idOfPersonGroup 用户组id
* @see IPersonGroupManager#deletePersonGroupBeansByParent(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeletePersonGroupBeansByParentOnPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).deletePersonGroupBeansByParent(idOfPersonGroup);
}
//8-3
/**
* 返回外键(fl_person_group.parent)引用的 fl_person_group 记录
* @param bean
* @see IPersonGroupManager#getReferencedByParent(PersonGroupBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoGetReferencedByParentOnPersonGroup(PersonGroupBean bean)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).getReferencedByParent(bean);
}
//8-4
/**
* 设置外键fl_person_group(parent)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IPersonGroupManager#setReferencedByParent(PersonGroupBean,PersonGroupBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoSetReferencedByParentOnPersonGroup(PersonGroupBean bean,PersonGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).setReferencedByParent(bean,beanToSet);
}
//9
/**
* 返回(idOfPersonGroup))指定的fl_person_group记录的所有的父节点(包括自己) daoListOfParentForPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).listOfParent(idOfPersonGroup);
}
//9-2
/**
* 返回{@code personGroupBean}指定的fl_person_group记录的所有的父节点(包括自己) daoListOfParentForPersonGroup(PersonGroupBean personGroupBean)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).listOfParent(personGroupBean);
}
//9-3
/**
* 返回(idOfPersonGroup))指定的fl_person_group记录的所有的子节点(包括自己) daoChildListByParentForPersonGroup(Integer idOfPersonGroup)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).childListByParent(idOfPersonGroup);
}
//9-4
/**
* 返回{@code personGroupBean}指定的fl_person_group记录的所有的子节点(包括自己) daoChildListByParentForPersonGroup(PersonGroupBean personGroupBean)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).childListByParent(personGroupBean);
}
//10
/**
* 如果没有默认组则向 fl_person_group 表中增加默认组,失败则抛出异常
*
* @throws IllegalStateException 创建失败
* @throws RuntimeDaoException
*/
protected void daoSaveDefaultPersonGroupIfAbsent()
throws RuntimeDaoException{
if(!daoExistsPersonGroup(DEFAULT_GROUP_ID)){
try{
PersonGroupBean bean = new PersonGroupBean(DEFAULT_GROUP_ID);
bean.setName(DEFAULT_GROUP_NAME);
daoSavePersonGroup(bean);
}catch(RuntimeDaoException e){
// do nothing
}
if(!daoExistsPersonGroup(DEFAULT_GROUP_ID)){
throw new IllegalStateException("can't create default group for person_group");
}
}
}
//11
/**
* 检查{@link PersonBean}的'group_id'字段是否为默认组{@link CommonConstant#DEFAULT_GROUP_ID},
* 如果是,且默认组记录不存在则创建默认组
* @return {@code personBean}
* @see #daoSaveDefaultPersonGroupIfAbsent()
* @throws RuntimeDaoException
*/
protected PersonBean daoCheckGroup(PersonBean personBean)
throws RuntimeDaoException{
if(null != personBean && Objects.equals(personBean.getGroupId(), DEFAULT_GROUP_ID)){
daoSaveDefaultPersonGroupIfAbsent();
}
return personBean;
}
//14
/**
* 参见 {@link TableManager#save(BaseBean)}
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoSavePersonGroup(PersonGroupBean personGroupBean)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).save(personGroupBean);
}
//15
/** 同步保存 impPermitByPersonGroupId
, Collection impPersonByGroupId
, Collection impPersongroupByParent )throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).save(personGroupBean
, refPersongroupByParent
, impPermitByPersonGroupId
, impPersonByGroupId
, impPersongroupByParent );
}
//12-3-3
/**
* 添加新记录 daoSavePersonGroups(Collection beans)
throws RuntimeDaoException {
if(null != beans){
for(PersonGroupBean bean : beans){
daoSavePersonGroup(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoSavePersonGroups(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoSavePersonGroupsAsTransaction(final Collection beans)
throws RuntimeDaoException {
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoSavePersonGroups(beans);
}});
}catch(RuntimeException e){
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_person_group 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPersonGroupManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_person_group 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupUsingTemplate(PersonGroupBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_person_group 的{@code column}字段的数据
* @param column 有效的fl_person_group表字段名或{@link PersonGroupBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPersonGroupManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfPersonGroupAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_person_group 表的所有记录
* @see IPersonGroupManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupAll()
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_person_group 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonGroupByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IPersonGroupManager.class).countWhere(where);
}
//18
/**
* 查询{@code where}条件指定的记录
* @return 返回查询结果记录的主键
* @see #daoLoadPersonGroupByWhere(String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupIdByWhere(String where)
throws RuntimeDaoException{
return daoToPrimaryKeyListFromPersonGroups(daoLoadPersonGroupByWhere(where,1,-1));
}
//19
/**
* (主动更新机制实现) daoLoadPersonGroupByCreateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadPersonGroupByWhere(makeWhere(timestamp,"create_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadPersonGroupByCreateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonGroupByCreateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_person_group.create_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountPersonGroupByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonGroupByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountPersonGroupByWhere(makeWhere(timestamp,"create_time"));
}
//21
/**
* (主动更新机制实现) daoLoadPersonGroupIdByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonGroupIdByWhere(makeWhere(timestamp,"create_time"));
}
//19
/**
* (主动更新机制实现) daoLoadPersonGroupByUpdateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadPersonGroupByWhere(makeWhere(timestamp,"update_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadPersonGroupByUpdateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadPersonGroupByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonGroupByUpdateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_person_group.update_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountPersonGroupByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPersonGroupByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountPersonGroupByWhere(makeWhere(timestamp,"update_time"));
}
//21
/**
* (主动更新机制实现) daoLoadPersonGroupIdByUpdateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPersonGroupIdByWhere(makeWhere(timestamp,"update_time"));
}
//////////// FL_PERMIT /////////
final IPermitManager permitManager = instanceOf(IPermitManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(PermitBean bean:beans){
count += daoDeletePermit(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected PermitBean daoCheckDuplicate(PermitBean permitBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IPermitManager.class).checkDuplicate(permitBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param deviceGroupId 外键,设备组id
* @param personGroupId 外键,人员组id
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
*
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected void daoCheckDuplicatePermit(Integer deviceGroupId,Integer personGroupId)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IPermitManager.class).existsPrimaryKey(deviceGroupId,personGroupId)){
throw new DuplicateRecordException();
}
}
//8-3
/**
* 返回外键(fl_permit.device_group_id)引用的 fl_device_group 记录
* @param bean
* @see IPermitManager#getReferencedByDeviceGroupId(PermitBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoGetReferencedByDeviceGroupIdOnPermit(PermitBean bean)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).getReferencedByDeviceGroupId(bean);
}
//8-4
/**
* 设置外键fl_permit(device_group_id)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IPermitManager#setReferencedByDeviceGroupId(PermitBean,DeviceGroupBean)
* @throws RuntimeDaoException
*/
protected DeviceGroupBean daoSetReferencedByDeviceGroupIdOnPermit(PermitBean bean,DeviceGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).setReferencedByDeviceGroupId(bean,beanToSet);
}
//8-6
/** transformer : PermitBean to fl_permit.device_group_id */
protected final Function daoCastPermitToDeviceGroupId = new Function(){
@Override
public Integer apply(PermitBean input) {
return null == input ? null : input.getDeviceGroupId();
}};
//8-3
/**
* 返回外键(fl_permit.person_group_id)引用的 fl_person_group 记录
* @param bean
* @see IPermitManager#getReferencedByPersonGroupId(PermitBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoGetReferencedByPersonGroupIdOnPermit(PermitBean bean)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).getReferencedByPersonGroupId(bean);
}
//8-4
/**
* 设置外键fl_permit(person_group_id)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IPermitManager#setReferencedByPersonGroupId(PermitBean,PersonGroupBean)
* @throws RuntimeDaoException
*/
protected PersonGroupBean daoSetReferencedByPersonGroupIdOnPermit(PermitBean bean,PersonGroupBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).setReferencedByPersonGroupId(bean,beanToSet);
}
//8-6
/** transformer : PermitBean to fl_permit.person_group_id */
protected final Function daoCastPermitToPersonGroupId = new Function(){
@Override
public Integer apply(PermitBean input) {
return null == input ? null : input.getPersonGroupId();
}};
//14
/**
* 参见 {@link TableManager#save(BaseBean)}
* @throws RuntimeDaoException
*/
protected PermitBean daoSavePermit(PermitBean permitBean)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).save(permitBean);
}
//15
/** 同步保存 daoSavePermits(Collection beans)
throws RuntimeDaoException {
if(null != beans){
for(PermitBean bean : beans){
daoSavePermit(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoSavePermits(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoSavePermitsAsTransaction(final Collection beans)
throws RuntimeDaoException {
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoSavePermits(beans);
}});
}catch(RuntimeException e){
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_permit 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPermitManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPermitByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_permit 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadPermitUsingTemplate(PermitBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_permit 的{@code column}字段的数据
* @param column 有效的fl_permit表字段名或{@link PermitBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IPermitManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfPermitAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_permit 表的所有记录
* @see IPermitManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadPermitAll()
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_permit 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPermitByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IPermitManager.class).countWhere(where);
}
//19
/**
* (主动更新机制实现) daoLoadPermitByCreateTime(Date timestamp,int startRow, int numRows)
throws RuntimeDaoException{
return daoLoadPermitByWhere(makeWhere(timestamp,"create_time"),startRow,numRows);
}
//20
/**
* 参见 {@link #daoLoadPermitByCreateTime(Date,int,int)}
* @throws RuntimeDaoException
*/
protected List daoLoadPermitByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoLoadPermitByCreateTime(timestamp,1,-1);
}
//20-5
/**
* 返回fl_permit.create_time 字段大于指定时间戳({@code timestamp})的记录总数
* @see #daoCountPermitByWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountPermitByCreateTime(Date timestamp)
throws RuntimeDaoException{
return daoCountPermitByWhere(makeWhere(timestamp,"create_time"));
}
//////////// FL_FACE /////////
final IFaceManager faceManager = instanceOf(IFaceManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetFaces(Collection idCollection)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).loadByPrimaryKey(idCollection);
}
//3
/**
* 删除主键列表({@code idCollection})指定的记录
* @return 返回删除的记录条数
* @see IFaceManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeleteFacesByPrimaryKey(Collection idCollection)
throws RuntimeDaoException{
int count =0;
if(null != idCollection){
for(Integer id:idCollection){
count += daoDeleteFace(id);
}
}
return count;
}
//3-5
/** transformer : FaceBean to fl_face.id */
protected final Function daoCastFaceToPk = new Function(){
@Override
public Integer apply(FaceBean input) {
return null == input ? null : input.getId();
}};
//3-6
/** transformer : fl_face.id to FaceBean */
protected final Function daoCastFaceFromPk = new Function(){
@Override
public FaceBean apply(Integer input) {
return daoGetFace(input);
}};
//3-8
/**
* unwrap primary key from {@link FaceBean} daoToPrimaryKeyListFromFaces(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IFaceManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link FaceBean} daoToPrimaryKeyListFromFaces(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastFaceToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param id 主键
* @see IFaceManager#existsPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected boolean daoExistsFace(Integer id)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).existsPrimaryKey(id);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsFace(FaceBean bean)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param id 主键
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IFaceManager#deleteByPrimaryKey(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteFace(Integer id)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).deleteByPrimaryKey(id);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeleteFace(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteFace(FaceBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeleteFace(bean.getId());
}
//6
/**
* 删除{@code faceBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeleteFace(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteFaces(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(FaceBean bean:beans){
count += daoDeleteFace(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected FaceBean daoCheckDuplicate(FaceBean faceBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IFaceManager.class).checkDuplicate(faceBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param id 主键
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code idOfFace}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected Integer daoCheckDuplicateFace(Integer id)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IFaceManager.class).existsPrimaryKey(id)){
throw new DuplicateRecordException();
}
return id;
}
//8
/**
* 返回外键(fl_log.compare_face)引用指定记录(fl_face.id)的所有{@code fl_log}记录
*
* @param idOfFace 主键
* @see IFaceManager#getLogBeansByCompareFaceAsList(Integer)
* @throws RuntimeDaoException
*/
protected List daoGetLogBeansByCompareFaceOnFace(Integer idOfFace)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).getLogBeansByCompareFaceAsList(idOfFace);
}
//8-2
/**
* 删除外键(idOfFace))引用指定记录(fl_face.id)的所有{@code fl_log}记录
*
* @param idOfFace 主键
* @see IFaceManager#deleteLogBeansByCompareFace(Integer)
* @throws RuntimeDaoException
*/
protected int daoDeleteLogBeansByCompareFaceOnFace(Integer idOfFace)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).deleteLogBeansByCompareFace(idOfFace);
}
//8-3
/**
* 返回外键(fl_face.feature_md5)引用的 fl_feature 记录
* @param bean
* @see IFaceManager#getReferencedByFeatureMd5(FaceBean)
* @throws RuntimeDaoException
*/
protected FeatureBean daoGetReferencedByFeatureMd5OnFace(FaceBean bean)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).getReferencedByFeatureMd5(bean);
}
//8-4
/**
* 设置外键fl_face(feature_md5)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IFaceManager#setReferencedByFeatureMd5(FaceBean,FeatureBean)
* @throws RuntimeDaoException
*/
protected FeatureBean daoSetReferencedByFeatureMd5OnFace(FaceBean bean,FeatureBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).setReferencedByFeatureMd5(bean,beanToSet);
}
//8-6
/** transformer : FaceBean to fl_face.feature_md5 */
protected final Function daoCastFaceToFeatureMd5 = new Function(){
@Override
public String apply(FaceBean input) {
return null == input ? null : input.getFeatureMd5();
}};
//8-8
/** transformer : fl_face.id to fl_face.feature_md5 */
protected final Function daoCastFacePkToFeatureMd5 = new Function(){
@Override
public String apply(Integer input) {
return null == input
? null
: daoCastFaceToFeatureMd5.apply(daoGetFace(input));
}};
//8-3
/**
* 返回外键(fl_face.image_md5)引用的 fl_image 记录
* @param bean
* @see IFaceManager#getReferencedByImageMd5(FaceBean)
* @throws RuntimeDaoException
*/
protected ImageBean daoGetReferencedByImageMd5OnFace(FaceBean bean)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).getReferencedByImageMd5(bean);
}
//8-4
/**
* 设置外键fl_face(image_md5)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IFaceManager#setReferencedByImageMd5(FaceBean,ImageBean)
* @throws RuntimeDaoException
*/
protected ImageBean daoSetReferencedByImageMd5OnFace(FaceBean bean,ImageBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).setReferencedByImageMd5(bean,beanToSet);
}
//8-6
/** transformer : FaceBean to fl_face.image_md5 */
protected final Function daoCastFaceToImageMd5 = new Function(){
@Override
public String apply(FaceBean input) {
return null == input ? null : input.getImageMd5();
}};
//8-8
/** transformer : fl_face.id to fl_face.image_md5 */
protected final Function daoCastFacePkToImageMd5 = new Function(){
@Override
public String apply(Integer input) {
return null == input
? null
: daoCastFaceToImageMd5.apply(daoGetFace(input));
}};
//12
/**
* 添加新记录 impLogByCompareFace )throws RuntimeDaoException,DuplicateRecordException{
checkArgument(null == faceBean || faceBean.isNew(),"can be add,delete,but modify record for fl_face,so the _isNew field must be true");
daoCheckDuplicate(faceBean);
return instanceOf(IFaceManager.class).save(faceBean
, refFeatureByFeatureMd5
, refImageByImageMd5
, impLogByCompareFace );
}
//12-3-3
/**
* 添加新记录 daoAddFaces(Collection beans)
throws RuntimeDaoException ,DuplicateRecordException{
if(null != beans){
for(FaceBean bean : beans){
daoAddFace(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoAddFaces(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoAddFacesAsTransaction(final Collection beans)
throws RuntimeDaoException ,DuplicateRecordException{
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection call() throws Exception {
return daoAddFaces(beans);
}});
}catch(RuntimeException e){
throwCauseIfInstanceOf(e,DuplicateRecordException.class);
throw e;
}
}
//16
/**
* 查询{@code where} SQL条件语句指定的 fl_face 记录
* @param where SQL 条件语句,为{@code null}或空时加载所有记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IFaceManager#loadByWhereAsList(String,int[],int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadFaceByWhere(String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).loadByWhereAsList(where,null,startRow,numRows);
}
//16-2
/**
* 以{@code bean} 为模板查询 fl_face 记录
* @param bean 模板对象
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see TableManager#loadUsingTemplate(BaseBean,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadFaceUsingTemplate(FaceBean bean,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).loadUsingTemplateAsList(bean,startRow,numRows);
}
//16-3
/**
* 查询 fl_face 的{@code column}字段的数据
* @param column 有效的fl_face表字段名或{@link FaceBean} 字段名
* @param distinct 只返回不重复记录
* @param where 'where'起始的SQL 查询条件语句,可为{@code null}
* @return {@code column}字段记录
* @param startRow 返回记录的起始行(首行=1,尾行=-1)
* @param numRows 返回记录条数(小于0时返回所有记录)
* @see IFaceManager#loadColumnAsList(String,boolean,String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadColumnOfFaceAsList(String column,boolean distinct,String where,int startRow, int numRows)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).loadColumnAsList(column, distinct, where, startRow, numRows);
}
//17
/**
* 返回 fl_face 表的所有记录
* @see IFaceManager#loadAllAsList()
* @throws RuntimeDaoException
*/
protected List daoLoadFaceAll()
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).loadAllAsList();
}
//17-2
/**
* 返回满足{@code where} SQL条件语句的 fl_face 记录总数
* @see TableManager#countWhere(String)
* @throws RuntimeDaoException
*/
protected int daoCountFaceByWhere(String where)
throws RuntimeDaoException{
return instanceOf(IFaceManager.class).countWhere(where);
}
//18
/**
* 查询{@code where}条件指定的记录
* @return 返回查询结果记录的主键
* @see #daoLoadFaceByWhere(String,int,int)
* @throws RuntimeDaoException
*/
protected List daoLoadFaceIdByWhere(String where)
throws RuntimeDaoException{
return daoToPrimaryKeyListFromFaces(daoLoadFaceByWhere(where,1,-1));
}
//////////// FL_FEATURE /////////
final IFeatureManager featureManager = instanceOf(IFeatureManager.class);
//1
/**
* 根据主键从数据库读取记录,没有找到记录返回{@code null} daoGetFeatures(Collection md5Collection)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).loadByPrimaryKey(md5Collection);
}
//3
/**
* 删除主键列表({@code md5Collection})指定的记录
* @return 返回删除的记录条数
* @see IFeatureManager#deleteByPrimaryKey(Collection)
* @throws RuntimeDaoException
*/
protected int daoDeleteFeaturesByPrimaryKey(Collection md5Collection)
throws RuntimeDaoException{
int count =0;
if(null != md5Collection){
for(String md5:md5Collection){
count += daoDeleteFeature(md5);
}
}
return count;
}
//3-5
/** transformer : FeatureBean to fl_feature.md5 */
protected final Function daoCastFeatureToPk = new Function(){
@Override
public String apply(FeatureBean input) {
return null == input ? null : input.getMd5();
}};
//3-6
/** transformer : fl_feature.md5 to FeatureBean */
protected final Function daoCastFeatureFromPk = new Function(){
@Override
public FeatureBean apply(String input) {
return daoGetFeature(input);
}};
//3-8
/**
* unwrap primary key from {@link FeatureBean} daoToPrimaryKeyListFromFeatures(Collection beans){
if (null == beans){
return ImmutableList.of();
}else{
return instanceOf(IFeatureManager.class).toPrimaryKeyList(beans);
}
}
//3-9
/**
* unwrap primary key from {@link FeatureBean} daoToPrimaryKeyListFromFeatures(List beans){
if(null == beans){
return ImmutableList.of();
}else{
return Lists.transform(beans,daoCastFeatureToPk);
}
}
//4
/**
* 判断主键指定的记录是否存在
*
* @param md5 主键,特征码md5校验码
* @see IFeatureManager#existsPrimaryKey(String)
* @throws RuntimeDaoException
*/
protected boolean daoExistsFeature(String md5)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).existsPrimaryKey(md5);
}
//4-2
/**
* 判断指定的记录是否存在
* @see TableManager#existsByPrimaryKey(BaseBean)
* @throws RuntimeDaoException
*/
protected boolean daoExistsFeature(FeatureBean bean)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).existsByPrimaryKey(bean);
}
//5
/**
* 删除主键指定的记录
*
* @param md5 主键,特征码md5校验码
* @return 返回删除的记录条数(1),如果记录不存在返回0
* @see IFeatureManager#deleteByPrimaryKey(String)
* @throws RuntimeDaoException
*/
protected int daoDeleteFeature(String md5)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).deleteByPrimaryKey(md5);
}
//5-2
/**
* 删除指定的记录
* @param bean 要删除的记录
* @return 返回删除的记录条数(1),如果{@code bean}为{@code null}或记录不存在返回0
* @see #daoDeleteFeature(String)
* @throws RuntimeDaoException
*/
protected int daoDeleteFeature(FeatureBean bean)
throws RuntimeDaoException{
return null == bean ? 0 : daoDeleteFeature(bean.getMd5());
}
//6
/**
* 删除{@code featureBeanCollection}列表指定的记录
* @return 返回删除的记录条数
* @see #daoDeleteFeature(String)
* @throws RuntimeDaoException
*/
protected int daoDeleteFeatures(Collection beans)
throws RuntimeDaoException{
int count =0;
if(null != beans){
for(FeatureBean bean:beans){
count += daoDeleteFeature(bean);
}
}
return count;
}
//7
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
* @see TableManager#checkDuplicate(BaseBean)
* @throws RuntimeDaoException
* @throws DuplicateRecordException if exists duplicated row
*/
protected FeatureBean daoCheckDuplicate(FeatureBean featureBean)
throws RuntimeDaoException,DuplicateRecordException{
try{
return instanceOf(IFeatureManager.class).checkDuplicate(featureBean);
}catch(ObjectRetrievalException e){
throw new DuplicateRecordException();
}
}
//7-3
/**
* 检查数据库中是否有(主键)相同的记录,如果有则抛出异常
*
* @param md5 主键,特征码md5校验码
* @see TableManager#checkDuplicate(BaseBean)
* @throws DuplicateRecordException if exists duplicated row
* @return always {@code md5OfFeature}
* @throws RuntimeDaoException
* @throws DuplicateRecordException
*/
protected String daoCheckDuplicateFeature(String md5)
throws RuntimeDaoException,DuplicateRecordException{
if(instanceOf(IFeatureManager.class).existsPrimaryKey(md5)){
throw new DuplicateRecordException();
}
return md5;
}
//8
/**
* 返回外键(fl_face.feature_md5)引用指定记录(fl_feature.md5)的所有{@code fl_face}记录
*
* @param md5OfFeature 主键,特征码md5校验码
* @see IFeatureManager#getFaceBeansByFeatureMd5AsList(String)
* @throws RuntimeDaoException
*/
protected List daoGetFaceBeansByFeatureMd5OnFeature(String md5OfFeature)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).getFaceBeansByFeatureMd5AsList(md5OfFeature);
}
//8-2
/**
* 删除外键(md5OfFeature))引用指定记录(fl_feature.md5)的所有{@code fl_face}记录
*
* @param md5OfFeature 主键,特征码md5校验码
* @see IFeatureManager#deleteFaceBeansByFeatureMd5(String)
* @throws RuntimeDaoException
*/
protected int daoDeleteFaceBeansByFeatureMd5OnFeature(String md5OfFeature)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).deleteFaceBeansByFeatureMd5(md5OfFeature);
}
//8
/**
* 返回外键(fl_log.verify_feature)引用指定记录(fl_feature.md5)的所有{@code fl_log}记录
*
* @param md5OfFeature 主键,特征码md5校验码
* @see IFeatureManager#getLogBeansByVerifyFeatureAsList(String)
* @throws RuntimeDaoException
*/
protected List daoGetLogBeansByVerifyFeatureOnFeature(String md5OfFeature)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).getLogBeansByVerifyFeatureAsList(md5OfFeature);
}
//8-2
/**
* 删除外键(md5OfFeature))引用指定记录(fl_feature.md5)的所有{@code fl_log}记录
*
* @param md5OfFeature 主键,特征码md5校验码
* @see IFeatureManager#deleteLogBeansByVerifyFeature(String)
* @throws RuntimeDaoException
*/
protected int daoDeleteLogBeansByVerifyFeatureOnFeature(String md5OfFeature)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).deleteLogBeansByVerifyFeature(md5OfFeature);
}
//8-3
/**
* 返回外键(fl_feature.person_id)引用的 fl_person 记录
* @param bean
* @see IFeatureManager#getReferencedByPersonId(FeatureBean)
* @throws RuntimeDaoException
*/
protected PersonBean daoGetReferencedByPersonIdOnFeature(FeatureBean bean)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).getReferencedByPersonId(bean);
}
//8-4
/**
* 设置外键fl_feature(person_id)引用为{@code beanToSet}指定的记录,
* 如果{@code beanToSet}没有保存则先save
* @param bean
* @param beanToSet 被引用的记录
* @see IFeatureManager#setReferencedByPersonId(FeatureBean,PersonBean)
* @throws RuntimeDaoException
*/
protected PersonBean daoSetReferencedByPersonIdOnFeature(FeatureBean bean,PersonBean beanToSet)
throws RuntimeDaoException{
return instanceOf(IFeatureManager.class).setReferencedByPersonId(bean,beanToSet);
}
//8-6
/** transformer : FeatureBean to fl_feature.person_id */
protected final Function daoCastFeatureToPersonId = new Function(){
@Override
public Integer apply(FeatureBean input) {
return null == input ? null : input.getPersonId();
}};
//8-8
/** transformer : fl_feature.md5 to fl_feature.person_id */
protected final Function daoCastFeaturePkToPersonId = new Function(){
@Override
public Integer apply(String input) {
return null == input
? null
: daoCastFeatureToPersonId.apply(daoGetFeature(input));
}};
//12
/**
* 添加新记录 impFaceByFeatureMd5
, Collection impLogByVerifyFeature )throws RuntimeDaoException,DuplicateRecordException{
checkArgument(null == featureBean || featureBean.isNew(),"can be add,delete,but modify record for fl_feature,so the _isNew field must be true");
daoCheckDuplicate(featureBean);
return instanceOf(IFeatureManager.class).save(featureBean
, refPersonByPersonId
, impFaceByFeatureMd5
, impLogByVerifyFeature );
}
//12-3-3
/**
* 添加新记录 daoAddFeatures(Collection beans)
throws RuntimeDaoException ,DuplicateRecordException{
if(null != beans){
for(FeatureBean bean : beans){
daoAddFeature(bean);
}
}
return beans;
}
//12-3-5
/**
* {@link #daoAddFeatures(Collection)}的事务化版本
* @throws RuntimeDaoException
*/
protected Collection daoAddFeaturesAsTransaction(final Collection beans)
throws RuntimeDaoException ,DuplicateRecordException{
try{
return daoRunAsTransaction(new Callable>(){
@Override
public Collection 