1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
|
/*
This file is part of Subsonic.
Subsonic is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
Subsonic is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Subsonic. If not, see <http://www.gnu.org/licenses/>.
Copyright 2009 (C) Sindre Mehus
*/
package net.sourceforge.subsonic.dao;
import net.sourceforge.subsonic.Logger;
import net.sourceforge.subsonic.domain.Artist;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.ParameterizedRowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;
/**
* Provides database services for artists.
*
* @author Sindre Mehus
*/
public class ArtistDao extends AbstractDao {
private static final Logger LOG = Logger.getLogger(ArtistDao.class);
private static final String COLUMNS = "id, name, cover_art_path, album_count, last_scanned, present";
private final RowMapper rowMapper = new ArtistMapper();
/**
* Returns the artist with the given name.
*
* @param artistName The artist name.
* @return The artist or null.
*/
public Artist getArtist(String artistName) {
return queryOne("select " + COLUMNS + " from artist where name=?", rowMapper, artistName);
}
/**
* Returns the artist with the given ID.
*
* @param id The artist ID.
* @return The artist or null.
*/
public Artist getArtist(int id) {
return queryOne("select " + COLUMNS + " from artist where id=?", rowMapper, id);
}
/**
* Creates or updates an artist.
*
* @param artist The artist to create/update.
*/
public synchronized void createOrUpdateArtist(Artist artist) {
String sql = "update artist set " +
"cover_art_path=?," +
"album_count=?," +
"last_scanned=?," +
"present=? " +
"where name=?";
int n = update(sql, artist.getCoverArtPath(), artist.getAlbumCount(), artist.getLastScanned(), artist.isPresent(), artist.getName());
if (n == 0) {
update("insert into artist (" + COLUMNS + ") values (" + questionMarks(COLUMNS) + ")", null,
artist.getName(), artist.getCoverArtPath(), artist.getAlbumCount(), artist.getLastScanned(), artist.isPresent());
}
int id = queryForInt("select id from artist where name=?", null, artist.getName());
artist.setId(id);
}
/**
* Returns artists in alphabetical order.
*
* @param offset Number of artists to skip.
* @param count Maximum number of artists to return.
* @return Artists in alphabetical order.
*/
public List<Artist> getAlphabetialArtists(int offset, int count) {
return query("select " + COLUMNS + " from artist where present order by name limit ? offset ?", rowMapper, count, offset);
}
/**
* Returns the most recently starred artists.
*
* @param offset Number of artists to skip.
* @param count Maximum number of artists to return.
* @param username Returns artists starred by this user.
* @return The most recently starred artists for this user.
*/
public List<Artist> getStarredArtists(int offset, int count, String username) {
return query("select " + prefix(COLUMNS, "artist") + " from artist, starred_artist where artist.id = starred_artist.artist_id and " +
"artist.present and starred_artist.username=? order by starred_artist.created desc limit ? offset ?",
rowMapper, username, count, offset);
}
public void markPresent(String artistName, Date lastScanned) {
update("update artist set present=?, last_scanned=? where name=?", true, lastScanned, artistName);
}
public void markNonPresent(Date lastScanned) {
int minId = queryForInt("select id from artist where true limit 1", 0);
int maxId = queryForInt("select max(id) from artist", 0);
final int batchSize = 1000;
for (int id = minId; id <= maxId; id += batchSize) {
update("update artist set present=false where id between ? and ? and last_scanned != ? and present", id, id + batchSize, lastScanned);
}
}
public void expunge() {
int minId = queryForInt("select id from artist where true limit 1", 0);
int maxId = queryForInt("select max(id) from artist", 0);
final int batchSize = 1000;
for (int id = minId; id <= maxId; id += batchSize) {
update("delete from artist where id between ? and ? and not present", id, id + batchSize);
}
}
public void starArtist(int artistId, String username) {
unstarArtist(artistId, username);
update("insert into starred_artist(artist_id, username, created) values (?,?,?)", artistId, username, new Date());
}
public void unstarArtist(int artistId, String username) {
update("delete from starred_artist where artist_id=? and username=?", artistId, username);
}
public Date getArtistStarredDate(int artistId, String username) {
return queryForDate("select created from starred_artist where artist_id=? and username=?", null, artistId, username);
}
private static class ArtistMapper implements ParameterizedRowMapper<Artist> {
public Artist mapRow(ResultSet rs, int rowNum) throws SQLException {
return new Artist(
rs.getInt(1),
rs.getString(2),
rs.getString(3),
rs.getInt(4),
rs.getTimestamp(5),
rs.getBoolean(6));
}
}
}
|
