/** * 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); } }