/**
* this action allows you to give the path of a track on disk, and it will be resolved to the
* tracks internal ID. this can then be used normally for playing music. the path coming in is
* assumed to have forward slashes to delimit path components, but this needs to be converted to
* whatever the actual path separator is for the current system BEFORE we try and query the
* database, otherwise, well, it just won't work.
*
* <p>NB! ATM, this feature is only here for the the folder browsing stuff, so if that's not
* turned on this this won't work.
*/
protected void resolvePath() throws BadRequestException, SQLException, IOException {
// check folder browsing is enabled
Utils.checkFeatureEnabled(getProperties(), "browse.folders.enabled");
ResultSet rs = null;
PreparedStatement st = null;
try {
final Database db = getDatabase();
final Locale locale = getLocale();
final Request req = getRequest();
final String path = convertPath(req.getArgument("path"));
final String sql = Track.getSelectFromSql() + " where t.path = ? ";
st = db.prepare(sql);
st.setString(1, path);
rs = st.executeQuery();
if (!rs.next())
throw new BadRequestException(locale.getString("www.error.trackNotFound"), 404);
final Track track = Track.createFromResultSet(rs);
final TResolvePath tpl = new TResolvePath();
tpl.setTrack(track);
getResponse().showJson(tpl.makeRenderer());
} finally {
Utils.close(rs);
Utils.close(st);
}
}
/**
* this method extracts the full path in the request where the relative path after the json action
* name is prefixed by the collection path specified in the query string.
*
* <p>e.g. /json/action/File/System/Path?collectionId=2
*
* <p>Will return /home/rod/File/System/Path because the collection with id = 2 is rooted at
* /home/rod
*
* @return String
*/
private String getPathFromRequest() throws SQLException, BadRequestException {
final Request req = getRequest();
final Locale locale = getLocale();
final int collectionId = Integer.parseInt(req.getArgument("collectionId"));
String path = "";
ResultSet rs = null;
PreparedStatement st = null;
for (int i = 2; i < req.getParamCount(); i++) {
final String pathElement = req.getUrlParam(i);
// don't allow going up directories
if (!pathElement.equals("..")) path += "/" + req.getUrlParam(i);
}
try {
final Database db = getDatabase();
final String sql = " select c.path " + " from collection c " + " where c.id = ? ";
st = db.prepare(sql);
st.setInt(1, collectionId);
rs = st.executeQuery();
// check the collection exists and we got it's root path
if (rs.next()) {
// we need to trim the trailing slash off the collection path
final String collPath = rs.getString("path");
path = collPath.substring(0, collPath.length() - 1) + path;
} else throw new BadRequestException(locale.getString("www.error.invalidCollectionId"), 404);
path = path.replaceAll("\\/\\/", "\\/");
} finally {
Utils.close(rs);
Utils.close(st);
}
log.debug("pathFromRequest: " + path);
return path;
}
/**
* this method outputs the tracks that lie below a given path
*
* @throws com.pugh.sockso.web.BadRequestException
* @throws java.sql.SQLException
* @throws java.io.IOException
*/
protected void tracksForPath() throws BadRequestException, SQLException, IOException {
Utils.checkFeatureEnabled(getProperties(), Constants.WWW_BROWSE_FOLDERS_ENABLED);
ResultSet rs = null;
PreparedStatement st = null;
try {
final Database db = getDatabase();
final Request req = getRequest();
final String path = req.getArgument("path");
final TTracksForPath tpl = new TTracksForPath();
tpl.setTracks(Track.getTracksFromPath(db, path));
getResponse().showJson(tpl.makeRenderer());
} finally {
Utils.close(rs);
Utils.close(st);
}
}
