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

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

40
41
42
43
44
45
46
47
        + " inner join music.artist ma on la.artist_id = ma.id"
        + " where la.artist_name_search like ?"
        + " order by la.hasalbums desc, ma.artist_name"
        + " offset ? limit ?";
    List<Artist> artists = jdbcTemplate.query(sql,
        new Object[]{getNameQuery(userQuery), offset, limit}, new ArtistRowMapper());
    return new NameSearchResult<>(artists, offset);
  }
View Full Code Here
45
46
47
48
49
50
51
   
    String sql = "select id, artist_name_capitalization from music.artist"
        + " where id in (" + PostgreSQLUtil.getIdParameters(artistIds) + ")"
        + " order by artist_name_capitalization";
   
    return jdbcTemplate.query(sql, new ArtistRowMapper());
  }
View Full Code Here
57
58
59
60
61
62
63
  public List<Artist> getArtists() {
    String sql = "select ma.id, ma.artist_name_capitalization from music.artist ma"
        + " inner join library.artist la on la.artist_id = ma.id where la.hasalbums"
        + " order by ma.artist_name";

    return jdbcTemplate.query(sql, new ArtistRowMapper());
  }
View Full Code Here
71
72
73
74
75
76
77
        + " " + topTagsTable + " att"
        + " inner join music.tag t on att.tag_id = t.id"
        + " where att.artist_id = ma.id and att.tag_count > ? and"
        + " coalesce(t.corrected_id, t.id) in (select id from music.tag where tag_name = ?))";

    return jdbcTemplate.query(sql, new Object[]{treshold, tag}, new ArtistRowMapper());
  }
View Full Code Here
83
84
85
86
87
88
89
        + (indexLetter < 'A' || indexLetter > 'Z' ?
            " where ascii(artist_name) < 65 or ascii(artist_name) > 90" :
            " where ascii(artist_name) = " + indexLetter)
        + " and la.hasalbums order by artist_name";

    return jdbcTemplate.query(sql, new ArtistRowMapper());
  }
View Full Code Here
93
94
95
96
97
98
99
        + " inner join music.artist ma on la.artist_id = ma.id where hasalbums"
        + " and not exists (select 1 from music.mb_artist mba where mba.artist_id = ma.id)"
        + " and not exists (select 1 from library.webservice_history h where h.artist_id = ma.id"
        + "  and h.calltype_id = " + MB_ARTIST_QUERY.getDatabaseId() + ")"
        + " and ma.artist_name != 'VARIOUS ARTISTS' order by ma.artist_name limit 3000",
        new ArtistRowMapper());
  }
View Full Code Here
TOP

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

  • com.github.hakko.musiccabinet.dao.jdbc.JdbcLibraryBrowserDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcMusicBrainzArtistDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcMusicDao
  • com.github.hakko.musiccabinet.dao.jdbc.JdbcNameSearchDao
  • com.github.hakko.musiccabinet.domain.model.music.Artist
    • 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.