public int persistShred(final Shred shred) {
// Persist shred
long t1 = System.currentTimeMillis();
final String sql = "INSERT INTO Shred VALUES (DEFAULT,?,?,?,?,?,?)";
KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(
new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection connection)
throws SQLException {
PreparedStatement ps = connection.prepareStatement(sql, new String[] {"id"});
ps.setString(1, shred.getDescription());
ps.setLong(2, shred.getOwner().getId());
ps.setDate(3, shred.getTimeCreated());
ps.setString(4, shred.getVideoPath());
ps.setString(5, shred.getShredType());
ps.setString(6, shred.getThumbnailpath());
return ps;
}
},
keyHolder);
shred.setId((Integer) keyHolder.getKey());
// Persist tags
String insertTag = "INSERT INTO TagsForShred VALUES (?,?)";
;
if (shred.getTags() != null) {
for (Tag t : shred.getTags()) {
this.jdbcTemplate.update(insertTag, shred.getId(), t.getId());
}
}
// insert rating for this shred
jdbcTemplate.update("INSERT INTO Rating VALUES(?, DEFAULT, DEFAULT)", shred.getId());
System.out.println("Persist shred: " + (System.currentTimeMillis() - t1));
logger.info("Persist shred: " + (System.currentTimeMillis() - t1));
return shred.getId();
}
