public boolean isRebuildRequested(String name) { String sql = "SELECT " + LMFIELD_REBUILD + " FROM " + LASTMODS_TABLE + " WHERE " + LMFIELD_NAME + " = ?"; return jdbc.queryForObject(sql, Boolean.class, name); }
public Date getTimestamp(String name) { String sql = "SELECT " + LMFIELD_STAMP + " FROM " + LASTMODS_TABLE + " WHERE " + LMFIELD_NAME + " = ?"; return jdbc.queryForObject(sql, dateRowMapper, name); }
@Override public String toMainName(String name, Context context) { UUID id = toId(name, context); if (id == null) return null; String text = jdbc.queryForObject("SELECT " + NAME_TEXT + " FROM " + NAME + " WHERE " + NAME_ENTRY + " = ? AND " + NAME_MAIN + " = ?", String.class, id.toString(), true); return text; }
public String toMainName(String name, Context context) { UUID id = toId(name, context); if (id == null) return null; String text = jdbc.queryForObject("SELECT " + NAME_TEXT + " FROM " + NAME + " WHERE " + NAME_ENTRY + " = ? AND " + NAME_MAIN + " = ?", String.class, id.toString(), true); return text; }
@Override public boolean isLdapExperimenter(Long id) { String query = _lookup("is_ldap_experimenter"); //$NON-NLS-1$ Map<String, Object> params = new HashMap<String, Object>(); params.put("id", id); return _jdbc().queryForObject(query, Boolean.class, params); }
@Override protected DbObjectMeta findMetaNoPTs(String id) throws DataAccessException { DbObjectMeta meta = jdbc.queryForObject( "SELECT * FROM "+tablePrefix+METAS_TABLE_NAME+ " WHERE "+META_ID+"=?"+ " AND "+META_HISTORY+"="+sqlSelectBoolFalse, metaRowMapper, id ); meta.setTags(findTags(meta)); return meta; }
public String findRepoRootPath(String uuid) { try { return _jdbc().queryForObject(_lookup("find_repo_root_path"), //$NON-NLS-1$ String.class, uuid); } catch (EmptyResultDataAccessException erdae) { return null; } }
public String getPasswordHash(Long experimenterID) { String stored; try { stored = _jdbc().queryForObject( _lookup("password_hash"), //$NON-NLS-1$ String.class, experimenterID); } catch (EmptyResultDataAccessException e) { stored = null; // This means there's not one. } return stored; }
public String fileRepo(long fileId) { return _jdbc().queryForObject( _lookup("file_repo"), String.class, //$NON-NLS-1$ fileId); }
public String configValue(String key) { try { return _jdbc().queryForObject(_lookup("config_value_select"), //$NON-NLS-1$ String.class, key); } catch (EmptyResultDataAccessException erdae) { return null; } }
public String findRepoFilePath(String uuid, long id) { try { return _jdbc().queryForObject(_lookup("find_repo_file_path"), //$NON-NLS-1$ String.class, id, uuid); } catch (EmptyResultDataAccessException erdae) { return null; } }
@Override public String getUsername(long userId) { String name; try { name = _jdbc().queryForObject(_lookup("user_name"), //$NON-NLS-1$ String.class, userId); } catch (EmptyResultDataAccessException e) { name = null; // This means there's not one. } return name; }
public long getGroupPermissions(long groupId) { return _jdbc().queryForObject( _lookup("get_group_permissions"), Long.class, //$NON-NLS-1$ groupId); }
public Long getUserId(String userName) { Long id; try { id = _jdbc().queryForObject(_lookup("user_id"), //$NON-NLS-1$ Long.class, userName); } catch (EmptyResultDataAccessException e) { id = null; // This means there's not one. } return id; }
public String scriptRepo(long fileId, Set<String> mimetypes) { String query = _lookup("file_repo_of_script"); //$NON-NLS-1$ Map<String, Object> params = new HashMap<String, Object>(); params.put("file", fileId); query += addMimetypes(mimetypes, params); try { return _jdbc().queryForObject(query, String.class, params); } catch (EmptyResultDataAccessException erdae) { return null; } }
public JobInstance getJobInstance(Long instanceId) { try { return getJdbcTemplate().queryForObject(getQuery(GET_JOB_FROM_ID), new JobInstanceRowMapper(), instanceId); } catch (EmptyResultDataAccessException e) { return null; } }
public JobExecution getJobExecution(Long executionId) { try { JobExecution jobExecution = getJdbcTemplate().queryForObject(getQuery(GET_EXECUTION_BY_ID), new JobExecutionRowMapper(), executionId); return jobExecution; } catch (EmptyResultDataAccessException e) { return null; } }
public JobInstance getJobInstance(JobExecution jobExecution) { try { return getJdbcTemplate().queryForObject( getQuery(GET_JOB_FROM_EXECUTION_ID), new JobInstanceRowMapper(), jobExecution.getId()); } catch (EmptyResultDataAccessException e) { return null; } }
@Override protected DbObjectMeta findMetaNoPTs(YaddaObjectID oid) throws DataAccessException { DbObjectMeta meta = jdbc.queryForObject( "SELECT * FROM "+tablePrefix+METAS_TABLE_NAME+ " WHERE "+META_ID+"=? AND "+META_BRANCH+"=? AND "+META_VERSION+"=?"+ (history?"":" AND "+META_HISTORY+"="+sqlSelectBoolFalse), metaRowMapper, oid.getId(), oid.getBranch(), oid.getVersion() ); meta.setTags(findTags(meta)); return meta; }
public void synchronizeStatus(JobExecution jobExecution) { int currentVersion = getJdbcTemplate().queryForInt(getQuery(CURRENT_VERSION_JOB_EXECUTION), jobExecution.getId()); if (currentVersion != jobExecution.getVersion().intValue()) { String status = getJdbcTemplate().queryForObject(getQuery(GET_STATUS), String.class, jobExecution.getId()); jobExecution.upgradeStatus(BatchStatus.valueOf(status)); jobExecution.setVersion(currentVersion); } }