Package com.github.hakko.musiccabinet.dao.jdbc.rowmapper

Examples of com.github.hakko.musiccabinet.dao.jdbc.rowmapper.PlaylistItemRowMapper

52
53
54
55
56
57
58
      + " inner join library.track lt on lt.track_id = t.id"
      + " where tr.source_id = " + trackId
      + " order by tr.weight desc, t.id"
      + " limit 25";

    return jdbcTemplate.query(sql, new PlaylistItemRowMapper());
  }
View Full Code Here
96
97
98
99
100
101
102
      + "      on ar.target_id = att.artist_id and ar.source_id = " + artistId
      + "  ) ranked_tracks"
      + "  where ranked_tracks.artist_rank <= " + artistCount
      + "  order by random() * ranked_tracks.artist_weight * ranked_tracks.artist_weight desc limit " + totalCount;

    return jdbcTemplate.query(sql, new PlaylistItemRowMapper());
  }
View Full Code Here
138
139
140
141
142
143
144
        + "    ) ranked_tracks"
        + "    where ranked_tracks.artist_rank <= " + artistCount
        + "    order by random() * ranked_tracks.tag_weight * ranked_tracks.tag_weight desc"
        + " limit " + totalCount;

    return jdbcTemplate.query(sql, tags, new PlaylistItemRowMapper());
  }
View Full Code Here
152
153
154
155
156
157
158
        + "    inner join music.lastfmgroup g on gwac.lastfmgroup_id = g.id where g.group_name = upper(?)"
        + "  ) ranked_tracks"
        + "  where ranked_tracks.artist_rank <= " + artistCount
        + "  order by random() * ranked_tracks.artist_weight * ranked_tracks.artist_weight desc limit " + totalCount;

    return jdbcTemplate.query(sql, new Object[]{lastFmGroup}, new PlaylistItemRowMapper());
  }
View Full Code Here
TOP

Related Classes of com.github.hakko.musiccabinet.dao.jdbc.rowmapper.PlaylistItemRowMapper

  • com.github.hakko.musiccabinet.dao.jdbc.JdbcPlaylistGeneratorDao
  • com.github.hakko.musiccabinet.domain.model.aggr.PlaylistItem
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.