Changeset 4495 for DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcAnnotationDao.java
- Timestamp:
- 02/11/14 18:01:34 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcAnnotationDao.java
r4491 r4495 67 67 StringBuilder sql = new StringBuilder("SELECT DISTINCT "); 68 68 sql.append(target_id).append(" FROM ").append(annotationsTargetsTableName).append(" WHERE ").append(annotation_id).append("= ?"); 69 return getSimpleJdbcTemplate().query(sql.toString(), TargetIDRowMapper, annotationID);69 return getSimpleJdbcTemplate().query(sql.toString(), targetIDRowMapper, annotationID); 70 70 } else { 71 71 loggerAnnotationDao.debug(nullArgument); … … 94 94 }; 95 95 96 97 98 96 @Override 99 97 public Permission getPermission(Number annotationID, Number userID) { … … 128 126 }; 129 127 130 131 132 133 128 //////////////////////////////////////////////////////////////////////// 134 129 @Override … … 143 138 params.put("ownerId", ownerID); 144 139 } 145 140 146 141 if (after != null) { 147 142 sql.append(" AND ").append(last_modified).append(" > :afterTimestamp"); … … 161 156 } 162 157 163 158 /////////////////////////////////////////////////////////////////////////////////// 164 159 @Override 165 160 public List<Number> getAnnotationIDsForUserWithPermission(Number userID, String access) { 166 161 167 162 if (userID == null) { 168 163 loggerAnnotationDao.debug("userID: " + nullArgument); 169 164 return null; 170 165 } 171 166 172 167 if (access == null) { 173 168 logger.info("The access argument is null. I assign it a default value 'reader'."); … … 175 170 } 176 171 177 172 178 173 StringBuilder sql = new StringBuilder("SELECT "); 179 174 sql.append(annotation_id).append(" FROM ").append(permissionsTableName).append(" WHERE "). … … 183 178 } 184 179 185 186 187 188 189 180 ////////////////////////////// 190 181 @Override … … 203 194 return getSimpleJdbcTemplate().query(query.toString(), internalIDRowMapper); 204 195 } 205 206 207 208 196 209 197 ///////////////////////////////////////// 210 198 @Override … … 215 203 } 216 204 205 @Override 206 public List<Number> sublistOrderedAnnotationIDs(List<Number> annotationIDs, int offset, int limit, String orderedBy, String direction) { 207 if (annotationIDs == null) { 208 return null; 209 } 210 211 if (annotationIDs.isEmpty()) { 212 return annotationIDs; 213 } 214 215 216 String values = makeListOfValues(annotationIDs); 217 Map<String, Object> params = new HashMap<String, Object>(); 218 params.put("offset", offset); 219 params.put("limit", limit); 220 221 StringBuilder query = new StringBuilder("SELECT DISTINCT "); 222 query.append(annotation_id).append(" FROM ").append(annotationsTargetsTableName).append(" WHERE ").append(annotation_id).append(" IN "); 223 query.append(values).append(" ORDER BY ").append(orderedBy); 224 225 if (limit > -1) { 226 query.append(direction).append(" LIMIT :limit "); 227 } 228 229 query.append(" OFFSET :offset "); 230 return getSimpleJdbcTemplate().query(query.toString(), internalIDRowMapper, params); 231 } 232 233 ////////////////////////////////////////////////////////////////////// 217 234 @Override 218 235 public AnnotationInfo getAnnotationInfoWithoutTargets(Number annotationID) { … … 265 282 String values = makeListOfValues(annotationIDs); 266 283 StringBuilder sql = new StringBuilder("SELECT DISTINCT "); 267 sql.append(external_id).append(" FROM ").append(annotationTableName).append(" WHERE ").append(annotation Annotation_id).append(" IN ").append(values);284 sql.append(external_id).append(" FROM ").append(annotationTableName).append(" WHERE ").append(annotation_id).append(" IN ").append(values); 268 285 return getSimpleJdbcTemplate().query(sql.toString(), annotationREFRowMapper); 269 286 } … … 283 300 } 284 301 StringBuilder sql = new StringBuilder("SELECT "); 285 sql.append(annotationStar).append(" FROM ").append(annotationTableName).append(" WHERE ").append(annotation Annotation_id).append("= ? LIMIT 1");302 sql.append(annotationStar).append(" FROM ").append(annotationTableName).append(" WHERE ").append(annotation_id).append("= ? LIMIT 1"); 286 303 List<Annotation> respond = getSimpleJdbcTemplate().query(sql.toString(), annotationRowMapper, annotationID); 287 304 return (respond.isEmpty() ? null : respond.get(0)); … … 327 344 return (respond.isEmpty() ? null : respond.get(0)); 328 345 } 329 330 331 346 332 347 ///////////////////////////// … … 342 357 StringBuilder sqlTargets = new StringBuilder("SELECT "); 343 358 sqlTargets.append(target_id).append(" FROM ").append(annotationsTargetsTableName).append(" WHERE ").append(annotation_id).append("= ? LIMIT 1"); 344 List<Number> resultTargets = getSimpleJdbcTemplate().query(sqlTargets.toString(), TargetIDRowMapper, annotationID);359 List<Number> resultTargets = getSimpleJdbcTemplate().query(sqlTargets.toString(), targetIDRowMapper, annotationID); 345 360 if (resultTargets.size() > 0) { 346 361 return true; … … 449 464 if (annotation == null) { 450 465 loggerAnnotationDao.debug("annotation: " + nullArgument); 451 return 0; 466 return null; 467 } 468 469 if (ownerID == null) { 470 loggerAnnotationDao.debug("ownerID: " + nullArgument); 471 return null; 452 472 } 453 473 … … 575 595 StringBuilder sqlPermissions = new StringBuilder("DELETE FROM "); 576 596 sqlPermissions.append(permissionsTableName).append(" WHERE ").append(annotation_id).append(" = :annotationId AND "). 577 append(principal_id).append(" = :userId");578 return getSimpleJdbcTemplate().update(sqlPermissions.toString(), params); 597 append(principal_id).append(" = :userId"); 598 return getSimpleJdbcTemplate().update(sqlPermissions.toString(), params); 579 599 } else { 580 600 loggerAnnotationDao.debug("userID: " + nullArgument);
Note: See TracChangeset
for help on using the changeset viewer.