@Override public Long createScheduledTask(ScheduledTask scheduledTask) throws UnifyException { return (Long) db().create(scheduledTask); }
@Override public <T extends Entity> int delete(Class<T> clazz, Object id) throws UnifyException { return db().delete(clazz, id); }
@Override public FileTransferConfig findFileTransferConfig(Long id) throws UnifyException { return db().find(FileTransferConfig.class, id); }
private int deleteRolePrivileges(RolePrivilegeQuery query) throws UnifyException { List<Long> rolePrivilegeIds = db().valueList(Long.class, "id", query); if (!rolePrivilegeIds.isEmpty()) { db().deleteAll(new RolePrivilegeWidgetQuery().rolePrivilegeIdIn(rolePrivilegeIds)); } return db().deleteAll(query); }
private void updateStaticReferenceTables() throws UnifyException { // Update reference tables logDebug("Updating static reference tables..."); List<Class<? extends EnumConst>> enumConstList = getAnnotatedClasses(EnumConst.class, StaticList.class); for (Class<? extends EnumConst> clazz : enumConstList) { StaticList ra = clazz.getAnnotation(StaticList.class); logDebug("Updating static reference table [{0}]...", ra.value()); Map<String, String> map = getListMap(LocaleType.APPLICATION, ra.value()); StaticReferenceQuery query = new StaticReferenceQuery(clazz); for (Map.Entry<String, String> entry : map.entrySet()) { String description = entry.getValue(); query.clear(); query.code(entry.getKey()); StaticReference staticData = db().find(query); if (staticData == null) { staticData = new StaticReference(clazz); staticData.setCode(entry.getKey()); staticData.setDescription(description); db().create(staticData); } else if (!description.equals(staticData.getDescription())) { staticData.setDescription(description); db().updateById(staticData); } } } }
@Override public Module findModule(Long id) throws UnifyException { return db().list(Module.class, id); }
@Override public List<SystemParameter> findSysParameters(SystemParameterQuery query) throws UnifyException { return db().listAll(query); }
@Override public int updateAll(Query<? extends Entity> query, Update update) throws UnifyException { return db().updateAll(query, update); }
@Override public int updateFileTransferConfig(FileTransferConfig fileTransferConfig) throws UnifyException { return db().updateByIdVersion(fileTransferConfig); }
@Override public void applyWorkflowAction(WfItemObject workflowItem, String actionName) throws UnifyException { WfUserActionDef wfUserActionDef = workflowItem.getWfStepDef().getWfUserActionDef(actionName); WfStepDef trgWfStep = getWfStepDef(wfUserActionDef.getTargetGlobalName()); // Check if current user holds workflow item Long wfItemId = workflowItem.getWfItemId(); String userLoginId = getUserToken().getUserLoginId(); WfItemQuery wfItemQuery = ((WfItemQuery) new WfItemQuery().id(wfItemId)).heldBy(userLoginId); if (db().countAll(wfItemQuery) > 0) { // Log history Date actionDt = db().getNow(); db().updateById(WfItemEvent.class, workflowItem.getWfHistEventId(), new Update().add("actionDt", actionDt) .add("actor", userLoginId).add("wfAction", actionName).add("notes", workflowItem.getNotes())); // Route to target step WfStepDef settleQ = pushIntoStep(trgWfStep, workflowItem); if (!settleQ.isEnd()) { // Release workflow item db().updateAll(wfItemQuery, new Update().add("heldBy", null)); } } else { throw new UnifyException(WorkflowModuleErrorConstants.WORKFLOW_APPLY_ACTION_UNHELD, actionName, workflowItem.getDescription()); } }
@Override public int deleteBatchFileReadConfig(Long id) throws UnifyException { String fileReader = db().value(String.class, "fileReader", new BatchFileReadConfigQuery().id(id)); getParameterService().deleteParameterValues(fileReader, BATCHFILE_READ_CONFIG, id); return db().delete(BatchFileReadConfig.class, id); }
private FeatureData getFeatureData(String code, String value, boolean createNew) throws UnifyException { FeatureData FeatureData = db().find(new FeatureQuery().code(code)); if (FeatureData == null) { FeatureData = new FeatureData(); FeatureData.setCode(code); FeatureData.setValue(value); db().create(FeatureData); } return FeatureData; } }
@Override public void logIn(UserToken userToken) throws UnifyException { SessionContext sessionContext = getRequestContext().getSessionContext(); // Add user session if not existing if (getUserSession(sessionContext.getId()) == null) { addUserSession(new LocalUserSession(sessionContext)); } // Update user session database record String userLoginId = userToken.getUserLoginId(); String sessionId = sessionContext.getId(); db().updateAll(new UserSessionTrackingQuery().id(sessionId), new Update().add("userLoginId", userLoginId) .add("userLoginId", userToken.getUserLoginId()).add("userName", userToken.getUserName())); if (!userToken.isAllowMultipleLogin()) { List<String> sessionIdList = db().valueList(String.class, "sessionId", new UserSessionTrackingQuery().userLoginId(userLoginId).idNot(sessionId)); if (!sessionIdList.isEmpty()) { // Log other user sessions out db().updateAll(new UserSessionTrackingQuery().idAmongst(sessionIdList), new Update().add("userLoginId", null).add("userLoginId", null).add("userName", null)); forceLogOut(sessionIdList.toArray(new String[sessionIdList.size()])); } } // Update session context sessionContext.setUserToken(userToken); }
@Override public List<Command> getClusterCommands() throws UnifyException { List<Command> resultList = Collections.emptyList(); List<ClusterCommand> clusterCommandList = db().findAll(new ClusterCommandQuery().nodeId(getNodeId())); if (!clusterCommandList.isEmpty()) { List<Long> clusterCommandIdList = new ArrayList<Long>(); resultList = new ArrayList<Command>(); for (ClusterCommand clusterCommandData : clusterCommandList) { Long clusterCommandId = clusterCommandData.getId(); clusterCommandIdList.add(clusterCommandId); resultList.add(new Command(clusterCommandData.getCommandCode(), db().valueList(String.class, "parameter", new ClusterCommandParamQuery().clusterCommandId(clusterCommandId)))); } db().deleteAll(new ClusterCommandParamQuery().clusterCommandIdIn(clusterCommandIdList)); db().deleteAll(new ClusterCommandQuery().idIn(clusterCommandIdList)); } return resultList; }
private void updateModuleStatus(String name, RecordStatus status) throws UnifyException { ModuleQuery query = new ModuleQuery().name(name); if (!db().value(boolean.class, "deactivatable", query)) { throw new UnifyException(SystemModuleErrorConstants.MODULE_DATA_NOT_DEACTIVATABLE, name); } db().updateAll(query, new Update().add("status", status)); }
@Override public RoleLargeData findRoleForm(Long roleId) throws UnifyException { Role role = db().list(Role.class, roleId); List<Long> privilegeIdList = db().valueList(Long.class, "privilegeId", new RolePrivilegeQuery().roleId(roleId).orderById()); List<Long> wfStepIdList = getWfStepIdListForRole(roleId); return new RoleLargeData(role, privilegeIdList, wfStepIdList); }
@Override protected boolean stale(String name, DashboardDef dashboardDef) throws Exception { boolean stale = false; try { Date updateDt = db().value(Date.class, "updateDt", new DashboardQuery().name(name)); stale = !updateDt.equals(dashboardDef.getTimestamp()); } catch (Exception e) { logError(e); } return stale; }
@Synchronized("update-privilege") @Override public boolean updateRegisteredPrivilege(String categoryName, String moduleName, String privilegeName, String privilegeDesc) throws UnifyException { Privilege privilege = db().find(new PrivilegeQuery().categoryName(categoryName).moduleName(moduleName).name(privilegeName)); if (privilege != null) { privilege.setDescription(privilegeDesc); db().updateById(privilege); return true; } return false; }
@Synchronized("register-privilege-category") @Override public Long registerPrivilegeCategory(String categoryName, String descriptionKey) throws UnifyException { PrivilegeCategory privilegeCategory = findPrivilegeCategory(categoryName); String description = getApplicationMessage(descriptionKey); if (privilegeCategory == null) { privilegeCategory = new PrivilegeCategory(); privilegeCategory.setName(categoryName); privilegeCategory.setDescription(description); privilegeCategory.setStatus(RecordStatus.ACTIVE); return (Long) db().create(privilegeCategory); } privilegeCategory.setDescription(description); privilegeCategory.setStatus(RecordStatus.ACTIVE); db().updateById(privilegeCategory); return privilegeCategory.getId(); }