@Override protected long lastPK() { return jdbc.queryForLong("SELECT lastval()"); }
@Override protected long lastPK() { return jdbc.queryForLong("SELECT last_insert_rowid()"); }
@Override public long getEntryCount() { return jdbc.queryForLong("SELECT COUNT(*) FROM " + ENTRY); }
public long getEntryCount() { return jdbc.queryForLong("SELECT COUNT(*) FROM " + ENTRY); }
public long getTick(String name) { String sql = "SELECT " + LMFIELD_TICK + " FROM " + LASTMODS_TABLE + " WHERE " + LMFIELD_NAME + " = ?"; return jdbc.queryForLong(sql, name); }
public long currentTick() { return jdbc.queryForLong("SELECT " + TFIELD_TICK + " FROM " + TICKS_TABLE); }
public void addLink(final String srcId, final String dstId, final String type, final Double weight, final String label) throws RelationGraphException { jdbc.queryForLong("SELECT add_link(?, ?, ?, ?, ?)", srcId, dstId, type, (weight == null) ? 1.0 : weight, label); }
public void addNode(String id, String type, String label) throws RelationGraphException { jdbc.queryForLong("SELECT add_node(?, ?, ?)", id, type, label); }
public void removeNode(String id) throws RelationGraphException { jdbc.queryForLong("SELECT remove_node(?)", id); }
public void mergeNodes(Set<String> ids, String groupId) throws RelationGraphException { for (String id : ids) jdbc.queryForLong("SELECT set_group(?, ?)", id, groupId); long code = jdbc.queryForLong("SELECT finish_group(?)", groupId); if (code != 0) throw new RelationGraphException("Cannot merge nodes"); }
public long nextTick() { /* TODO Optimizations * First: Implement in PostgreSQL as a SEQUENCE (easy). * Second: Replace with one SEQUENCE per relation: * instead of waiting on one global lock, each edit operation * would wait on a lock associated with the relation on which * the operation is performed (more complex, some changes required * in Browser and JDBCBrowser). */ jdbc.update("UPDATE " + TICKS_TABLE + " SET " + TFIELD_TICK + " = " + TFIELD_TICK + " + 1"); return jdbc.queryForLong("SELECT " + TFIELD_TICK + " FROM " + TICKS_TABLE); }
public long selectCurrentEventLog(String key) { return _jdbc().queryForLong(logLoaderQuerySql, key); }
public void initialize() { /* Unfortunately it's backend-dependent, but we cannot allow any error, * since it will rollback the entire transaction. */ if (1 == jdbc.queryForLong("SELECT COUNT(tablename) FROM pg_tables WHERE tablename ILIKE ?", VERSION)) return; log.info("Initializing database"); try { execute(this.getClass().getClassLoader().getResourceAsStream(DROP_SCRIPT)); execute(this.getClass().getClassLoader().getResourceAsStream(INIT_SCRIPT)); } catch (Exception e) { } }
@Override public void initialize() { /* Unfortunately it's backend-dependent, but we cannot allow any error, * since it will rollback the entire transaction. */ if (1 == jdbc.queryForLong("SELECT COUNT(tablename) FROM pg_tables WHERE tablename ILIKE ?", VERSION)) return; log.info("Initializing database"); execute(this.getClass().getClassLoader().getResourceAsStream(DROP_SCRIPT)); execute(this.getClass().getClassLoader().getResourceAsStream(INIT_SCRIPT)); }
public long currValue(String segmentName) { try { long next_value = _jdbc().queryForLong(_lookup("curr_val"), //$NON-NLS-1$ segmentName); return next_value; } catch (EmptyResultDataAccessException erdae) { return -1l; } }
public long nodeId(String internal_uuid) { return _jdbc().queryForLong(_lookup("internal_uuid"), //$NON-NLS-1$ internal_uuid); }
public Long sessionId(String uuid) { return _jdbc().queryForLong(_lookup("session_id"), uuid); //$NON-NLS-1$ }
protected long getPK(RelationInfo relationInfo) { String sql = "SELECT " + FIELD_PK + " FROM " + RELATIONS_TABLE + " WHERE " + FIELD_NAME + " = ? AND " + FIELD_VERSION + " = ?"; return jdbc.queryForLong(sql, relationInfo.getBaseName(), relationInfo.getVersion()); }
public Long findRepoImageFromPixels(long id) { return _jdbc().queryForLong(_lookup("find_repo_image_from_pixels"), id); //$NON-NLS-1$ }
public Long nextSessionId() { return _jdbc().queryForLong(_lookup("next_session")); //$NON-NLS-1$ }