@Override
public List<QuotaUpdate> findLimited(int limit) throws StorageException {
ArrayList<QuotaUpdate> resultList;
try {
Connection conn = mysqlConnector.obtainSession();
PreparedStatement s = conn.prepareStatement(FIND_QUERY + limit);
ResultSet result = s.executeQuery();
resultList = new ArrayList<QuotaUpdate>();
while (result.next()) {
int id = result.getInt(ID);
int inodeId = result.getInt(INODE_ID);
int namespaceDelta = result.getInt(NAMESPACE_DELTA);
long diskspaceDelta = result.getLong(DISKSPACE_DELTA);
resultList.add(new QuotaUpdate(id, inodeId, namespaceDelta, diskspaceDelta));
}
} catch (SQLException ex) {
throw HopsSQLExceptionHelper.wrap(ex);
} finally {
mysqlConnector.closeSession();
}
return resultList;
}
