@POST
@Path("/getSavedSearches")
@Consumes(MediaType.APPLICATION_FORM_URLENCODED)
@Produces("application/json")
public String getSavedSearches(@FormParam("user") String user) {
JSONArray queryList = new JSONArray();
System.out.println(user);
CouchConnection couch = new CouchConnection("http://localhost:5984/", "savedsearches/");
JSONObject viewDocument = new JSONObject();
JSONArray searches = new JSONArray();
JSONArray keys = new JSONArray();
boolean existingViews = true;
try {
viewDocument = new JSONObject(couch.queryDB(user));
keys = viewDocument.names();
System.out.println(keys.toString());
} catch (Exception e) {
existingViews = false;
}
return keys.toString();
}
@POST
@Consumes(MediaType.APPLICATION_FORM_URLENCODED)
@Produces("application/json")
public ReturnMessage saveSearch(
@FormParam("user") String user,
@FormParam("endDate") String endDate,
@FormParam("startDate") String startDate,
@FormParam("make") String make,
@FormParam("model") String model,
@FormParam("year") String year,
@FormParam("searchName") String searchName) {
JSONArray queryList = new JSONArray();
System.out.println(user);
CouchConnection couch = new CouchConnection("http://localhost:5984/", "savedsearches/");
String db = "gm";
if (!make.equals("undefined") && !make.equals("All Makes") && !make.equals("")) {
db = make.toLowerCase();
}
if (!model.equals("undefined") && !model.equals("All Models") && !model.equals("")) {
db = model.toLowerCase();
}
if (!year.equals("undefined") && !year.equals("All Years") && !year.equals("")) {
db = model.toLowerCase() + year;
}
JSONObject viewDocument = new JSONObject();
boolean existingViews = true;
try {
viewDocument = new JSONObject(couch.queryDB(user));
JSONObject search = new JSONObject();
search.put("viewName", "_design/(" + startDate + ")(" + endDate + ")");
search.put("db", db);
viewDocument.put(searchName, search);
couch.updateDocument(user, viewDocument);
} catch (Exception e) {
existingViews = false;
}
if (!existingViews) {
viewDocument.put("_id", user);
JSONObject search = new JSONObject();
search.put("viewName", "_design/(" + startDate + ")(" + endDate + ")");
search.put("db", db);
viewDocument.put(searchName, search);
couch.createDocuments(viewDocument, false);
}
ReturnMessage rm = new ReturnMessage();
rm.setResult("success");
return rm;
}
@DELETE
@Consumes(MediaType.APPLICATION_FORM_URLENCODED)
@Produces("application/json")
public ReturnMessage deleteSearch(
@FormParam("user") String user, @FormParam("searchName") String searchName) {
CouchConnection couch = new CouchConnection("http://localhost:5984/", "savedsearches/");
ReturnMessage rm = new ReturnMessage();
try {
JSONObject userViews = new JSONObject(couch.queryDB(user));
userViews.remove(searchName);
couch.updateDocument(user, userViews);
rm.setResult("success");
} catch (Exception e) {
rm.setResult("failure");
}
return rm;
}
@POST
@Path("/getSavedSearch")
@Consumes(MediaType.APPLICATION_FORM_URLENCODED)
@Produces("application/json")
public String getSavedSearch(
@FormParam("user") String user, @FormParam("searchName") String searchName) {
JSONArray queryList = new JSONArray();
System.out.println(user);
CouchConnection couch = new CouchConnection("http://localhost:5984/", "savedsearches/");
JSONObject viewDocument = new JSONObject();
JSONObject search = new JSONObject();
JSONObject returnJSON = new JSONObject();
String response = "error";
try {
viewDocument = new JSONObject(couch.queryDB(user));
search = (JSONObject) viewDocument.get(searchName);
String viewName = (String) search.get("viewName");
String viewDBString = (String) search.get("db");
System.out.println("Getting from view: " + viewName);
System.out.println("Getting from db: " + viewDBString);
CouchConnection viewDB = new CouchConnection("http://localhost:5984/", viewDBString + "/");
System.out.println(search);
System.out.println(viewName);
System.out.println(viewDBString);
System.out.println(viewDB.queryDB(viewName + "/_view/wordCount?group=true"));
System.out.println(viewDB.queryDB(viewName + "/_view/sentiment"));
returnJSON.put("wordCount", viewDB.queryDB(viewName + "/_view/wordCount?group=true"));
returnJSON.put("sentiment", viewDB.queryDB(viewName + "/_view/sentiment"));
response = returnJSON.toString();
} catch (Exception e) {
response = "error";
}
return response;
}