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

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

60
61
62
63
64
65
66
67
68
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " where la.album_name_search like ?"
        + " order by malb.album_name"
        + " offset ? limit ?";
    List<Album> albums = jdbcTemplate.query(sql,
        new Object[]{getNameQuery(userQuery), offset, limit}, new AlbumRowMapper());

    return new NameSearchResult<>(albums, offset);
  }
View Full Code Here
147
148
149
150
151
152
153
        + " left outer join music.albuminfo ai on ai.album_id = ma.id"
        + " where ma.artist_id = " + artistId + " and coalesce(mba.type_id, 1) > 0 order by"
        + (sortByYear ? " coalesce(mba.first_release_year, la.year) " : " ma.album_name ") 
        + (sortAscending ? "asc" : "desc");

    return jdbcTemplate.query(sql, new AlbumRowMapper());
  }
View Full Code Here
209
210
211
212
213
214
215
        + " left outer join library.file f2 on f2.id = la.coverartfile_id"
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " left outer join music.albuminfo ai on la.album_id = ai.album_id"
        + " where la.album_id = " + albumId;

    return jdbcTemplate.queryForObject(sql, new AlbumRowMapper());
  }
View Full Code Here
239
240
241
242
243
244
245
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by (ma.artist_id = " + artistId + ") desc,"
        + (sortByYear ? " la.year " : " ma.album_name ")
        + (sortAscending ? "asc" : "desc");

    return jdbcTemplate.query(sql, new AlbumRowMapper());
  }
View Full Code Here
279
280
281
282
283
284
285
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by sort_id desc";

    Object[] params = query == null ?
        new Object[]{offset, limit} : new Object[]{getNameQuery(query), offset, limit};
    return jdbcTemplate.query(sql, params, new AlbumRowMapper());
  }
View Full Code Here
320
321
322
323
324
325
326
        + " left outer join library.file f2 on f2.id = la.coverartfile_id"
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by last_invocation_time desc";

    return jdbcTemplate.query(sql, args.toArray(), new AlbumRowMapper());
  }
View Full Code Here
361
362
363
364
365
366
367
        + " left outer join library.file f2 on f2.id = la.coverartfile_id"
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by cnt desc";

    return jdbcTemplate.query(sql, args.toArray(), new AlbumRowMapper());
  }
View Full Code Here
384
385
386
387
388
389
390
        + " left outer join library.directory d1 on f1.directory_id = d1.id"
        + " left outer join library.file f2 on f2.id = la.coverartfile_id"
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id";

    return jdbcTemplate.query(sql, new AlbumRowMapper());
  }
View Full Code Here
424
425
426
427
428
429
430
        + " left outer join library.file f2 on f2.id = la.coverartfile_id"
        + " left outer join library.directory d2 on f2.directory_id = d2.id"
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by added desc";

    return jdbcTemplate.query(sql, args.toArray(), new AlbumRowMapper());
  }
View Full Code Here
75
76
77
78
79
80
81
        + " left outer join music.albuminfo ai on ai.album_id = la.album_id"
        + " order by a.artist_name_capitalization,"
        + (sortByYear ? " la.year " : " ma.album_name ")
        + (sortAscending ? "asc" : "desc");

    return jdbcTemplate.query(sql, new AlbumRowMapper());
  }
View Full Code Here
TOP

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

  • com.github.hakko.musiccabinet.dao.jdbc.JdbcDirectoryBrowserDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcLibraryBrowserDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcMusicBrainzAlbumDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcNameSearchDao
  • com.github.hakko.musiccabinet.domain.model.music.Album
    • 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.