public JSONObject removeTestQuestion(JSONRPC2Request req, HttpServletRequest request)
throws Exception, SQLException {
JSONObject jsonResult = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(testNp.getInt(("id")));
dao = new MySQLDAO();
Question q = dao.loadQuestion(questNp.getInt("id"));
User u = getCurrentUser(request);
if (u.getId() == t.getOwnerId()) {
dao = new MySQLDAO();
t = dao.deleteTestQuestion(t, q);
} else {
throw new Exception("no privileges : you do not own this test");
}
JSONObject jsonTest = t.toJSONObject();
JSONObject jsonQuestion = q.toJSONObject();
jsonResult.put("test", jsonTest);
jsonResult.put("question", jsonQuestion);
return jsonResult;
}
public JSONObject addTestQuestion(JSONRPC2Request req, HttpServletRequest request)
throws Exception, SQLException {
JSONObject jsonResult = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
int tid = testNp.getInt(("id"));
int qid = questNp.getInt(("id"));
// load test and question
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
dao = new MySQLDAO();
Question q = dao.loadQuestion(qid);
// load current user
User u = getCurrentUser(request);
if (u.getId() == t.getOwnerId()) {
// check for duplicates
boolean duplicate = false;
for (Question quest : t.getQuestions()) {
if (quest.getId() == qid) {
duplicate = true;
}
}
if (!duplicate) {
dao = new MySQLDAO();
t = dao.saveTestQuestion(t, q);
}
} else {
throw new Exception("no privileges : you do not own this test!");
}
// set result
JSONObject jsonTest = t.toJSONObject();
JSONObject jsonQuestion = q.toJSONObject();
jsonResult.put("test", jsonTest);
jsonResult.put("question", jsonQuestion);
return jsonResult;
}
public JSONObject updateQuestion(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
JSONObject jsonUpdateQuestion = new JSONObject();
// get question
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questionNp = new NamedParamsRetriever(qParams);
int questionId = questionNp.getInt("id");
String questionBody = questionNp.getString("body");
String questionAnswer = questionNp.getString("answer");
int qOwnerId = questionNp.getInt("ownerId");
User u = getCurrentUser(request);
// check if this is the owner of the question
if (u.getId() == qOwnerId) {
// update question in database
Question qUpdated =
QuestionController.updateQuestion(questionId, questionBody, questionAnswer);
// return result
jsonUpdateQuestion.put("question", qUpdated.toJSONObject());
return jsonUpdateQuestion;
} else {
throw new Exception("no privileges");
}
}
public JSONObject deleteQuestion(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
// create json object for the result
JSONObject jsonDeleteQuestion = new JSONObject();
// get question id
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questionNp = new NamedParamsRetriever(qParams);
int questionId = questionNp.getInt("id");
int qOwnwerId = questionNp.getInt("ownerId");
User u = getCurrentUser(request);
// check for user privilleges
if (u.getId() == qOwnwerId) {
// remove question from database
QuestionController.deleteQuestion(questionId);
// send result
return jsonDeleteQuestion;
} else {
System.out.println("current user id: " + u.getId());
System.out.println("question owner id: " + qOwnwerId);
throw new Exception("no privileges");
}
}
public JSONObject addQuestion(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error {
// json object for the result
JSONObject jsonAddQuestion = new JSONObject();
// get question
System.out.println(req.toString());
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questionNp = new NamedParamsRetriever(qParams);
String body = questionNp.getString("body");
String answer = questionNp.getString("answer");
// get user
User u = getCurrentUser(request);
int userID = (int) u.getId();
System.out.println("current user id" + userID);
// return ID of Question if added successfully
Question q = QuestionController.addQuestion(body, answer, userID);
jsonAddQuestion.put("question", q.toJSONObject());
return jsonAddQuestion;
}
public JSONObject deleteTest(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
// create json object for the result
JSONObject jsonDeleteTest = new JSONObject();
// get question id
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int testId = testNp.getInt("id");
int tOwnerId = testNp.getInt("ownerId");
User u = getCurrentUser(request);
// check for privileges
if (u.getId() == tOwnerId) {
// remove question from database
TestController.deleteTest(testId);
// send result
return jsonDeleteTest;
} else {
throw new Exception("no privileges");
}
}
public JSONObject updateTest(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
JSONObject jsonUpdateTest = new JSONObject();
// get question
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int testId = testNp.getInt("id");
String testName = testNp.getString("name");
int tOwnerId = testNp.getInt("ownerId");
User u = getCurrentUser(request);
// check for privileges
if (u.getId() == tOwnerId) {
// update question in database
Test testUpdated = TestController.updateTest(testId, testName);
// return result
jsonUpdateTest.put("updatedTest", testUpdated.toJSONObject());
return jsonUpdateTest;
} else {
throw new Exception("no privileges");
}
}
public JSONObject loadTestAndAllQuestions(JSONRPC2Request req, HttpServletRequest request)
throws Exception {
JSONObject jsonResult = new JSONObject();
JSONArray jsonAllQuestions = new JSONArray();
JSONObject jsonTest = new JSONObject();
// retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int tid = testNp.getInt("id");
// get data from DB
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
QuestionsList allQuestions = QuestionController.loadAllQuestions();
// set result
jsonTest = t.toJSONObject();
jsonAllQuestions = allQuestions.toJSONArray();
jsonResult.put("test", jsonTest);
jsonResult.put("questions", jsonAllQuestions);
return jsonResult;
}
public JSONObject checkTest(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
JSONObject jsonResult = new JSONObject();
JSONArray jsonWrongQuestions = new JSONArray();
QuestionsList wrongQuestions = new QuestionsList();
// retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
// get guessed questions values
QuestionsList guessQuestions = new QuestionsList();
List<Object> questions = testNp.getList("questions");
for (Object q : questions) {
// set new retriever for each question
NamedParamsRetriever questNp = new NamedParamsRetriever((Map<String, Object>) q);
// retrieve values
String answer = questNp.getString("answer");
String body = questNp.getString("body");
int id = questNp.getInt("id");
// create question with the values and add it to the guessed questions
Question quest = new Question();
quest.setId(id);
quest.setBody(body);
quest.setAnswer(answer);
guessQuestions.add(quest);
}
// get test
int tid = testNp.getInt("id");
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
// get true questions
MySQLDAO questionsDao = new MySQLDAO();
QuestionsList trueQuestions = questionsDao.loadQuestionsByTest(tid);
// cycle through questions and find these with same id
for (Question tq : trueQuestions) {
for (Question gq : guessQuestions) {
if (tq.getId() == gq.getId()) {
// if answers are different, than there is mistake
System.out.println("id match!");
if (!tq.getAnswer().equals(gq.getAnswer())) {
System.out.println("Wrong question!");
wrongQuestions.add(gq);
}
}
}
}
jsonWrongQuestions = wrongQuestions.toJSONArray();
jsonResult.put("test", t);
jsonResult.put("wrongQuestions", jsonWrongQuestions);
return jsonResult;
}
public JSONArray loadQuestionsByTest(JSONRPC2Request req, HttpServletRequest request)
throws Exception, JSONRPC2Error {
JSONArray jsonTestQuestions = new JSONArray();
// get testId
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int testId = testNp.getInt("id");
// get test questions
MySQLDAO dao = new MySQLDAO();
QuestionsList qByTest = dao.loadQuestionsByTest(testId);
// set result
jsonTestQuestions = qByTest.toJSONArray();
return jsonTestQuestions;
}
public JSONObject addTest(JSONRPC2Request req, HttpServletRequest request) throws JSONRPC2Error {
// json object for the result
JSONObject jsonAddTest = new JSONObject();
// get test
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
String name = testNp.getString("name");
// get user
User u = getCurrentUser(request);
int userID = (int) u.getId();
// return test if added successfully
Test t = TestController.addTest(name, userID);
System.out.println("add test: " + t.toJSONObject().toString());
jsonAddTest.put("test", t.toJSONObject());
return jsonAddTest;
}
public JSONObject loadQuestion(JSONRPC2Request req, HttpServletRequest request) throws Exception {
JSONObject jsonResult = new JSONObject();
JSONObject jsonQuestion = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
int qid = questNp.getInt("id");
// load question
MySQLDAO dao = new MySQLDAO();
Question q = dao.loadQuestion(qid);
// set result
jsonQuestion = q.toJSONObject();
jsonResult.put("question", jsonQuestion);
return jsonResult;
}