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
|
/*
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 java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.simple.ParameterizedRowMapper;
import net.sourceforge.subsonic.domain.Share;
/**
* Provides database services for shared media.
*
* @author Sindre Mehus
*/
public class ShareDao extends AbstractDao {
private static final String COLUMNS = "id, name, description, username, created, expires, last_visited, visit_count";
private ShareRowMapper shareRowMapper = new ShareRowMapper();
private ShareFileRowMapper shareFileRowMapper = new ShareFileRowMapper();
/**
* Creates a new share.
*
* @param share The share to create. The ID of the share will be set by this method.
*/
public synchronized void createShare(Share share) {
String sql = "insert into share (" + COLUMNS + ") values (" + questionMarks(COLUMNS) + ")";
update(sql, null, share.getName(), share.getDescription(), share.getUsername(), share.getCreated(),
share.getExpires(), share.getLastVisited(), share.getVisitCount());
int id = getJdbcTemplate().queryForInt("select max(id) from share");
share.setId(id);
}
/**
* Returns all shares.
*
* @return Possibly empty list of all shares.
*/
public List<Share> getAllShares() {
String sql = "select " + COLUMNS + " from share";
return query(sql, shareRowMapper);
}
public Share getShareByName(String shareName) {
String sql = "select " + COLUMNS + " from share where name=?";
return queryOne(sql, shareRowMapper, shareName);
}
public Share getShareById(int id) {
String sql = "select " + COLUMNS + " from share where id=?";
return queryOne(sql, shareRowMapper, id);
}
/**
* Updates the given share.
*
* @param share The share to update.
*/
public void updateShare(Share share) {
String sql = "update share set name=?, description=?, username=?, created=?, expires=?, last_visited=?, visit_count=? where id=?";
update(sql, share.getName(), share.getDescription(), share.getUsername(), share.getCreated(), share.getExpires(),
share.getLastVisited(), share.getVisitCount(), share.getId());
}
/**
* Creates shared files.
*
* @param shareId The share ID.
* @param paths Paths of the files to share.
*/
public void createSharedFiles(int shareId, String... paths) {
String sql = "insert into share_file (share_id, path) values (?, ?)";
for (String path : paths) {
update(sql, shareId, path);
}
}
/**
* Returns files for a share.
*
* @param shareId The ID of the share.
* @return The paths of the shared files.
*/
public List<String> getSharedFiles(int shareId) {
return query("select path from share_file where share_id=?", shareFileRowMapper, shareId);
}
/**
* Deletes the share with the given ID.
*
* @param id The ID of the share to delete.
*/
public void deleteShare(Integer id) {
update("delete from share where id=?", id);
}
private static class ShareRowMapper implements ParameterizedRowMapper<Share> {
public Share mapRow(ResultSet rs, int rowNum) throws SQLException {
return new Share(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getTimestamp(5),
rs.getTimestamp(6), rs.getTimestamp(7), rs.getInt(8));
}
}
private static class ShareFileRowMapper implements ParameterizedRowMapper<String> {
public String mapRow(ResultSet rs, int rowNum) throws SQLException {
return rs.getString(1);
}
}
}
|
