protected boolean isWebserviceInvocationAllowed(Calltype callType, Track track) {
String sql =
"select max(invocation_time) from library.webservice_history h"
+ " inner join music.track t on t.id = h.track_id"
+ " inner join music.artist a on a.id = t.artist_id"
+ " where calltype_id = "
+ callType.getDatabaseId()
+ " and a.artist_name = upper(?) and t.track_name = upper(?)";
Timestamp lastInvocation =
jdbcTemplate.queryForObject(
sql, new Object[] {track.getArtist().getName(), track.getName()}, Timestamp.class);
return isWebserviceInvocationAllowed(callType, lastInvocation);
}
