// update all the current quiz results for the score/maxscore etc protected void upgradeV54() { DbHelper db = DbHelper.getInstance(ctx); ArrayList<QuizAttempt> quizAttempts = db.getAllQuizAttempts(); long userId = db.getUserId(SessionManager.getUsername(ctx)); ArrayList<Course> courses = db.getAllCourses(); ArrayList<v54UpgradeQuizObj> quizzes = new ArrayList<>(); for (Course c : courses) { try { CourseXMLReader cxr = new CourseXMLReader(c.getCourseXMLLocation(), c.getCourseId(), ctx); ArrayList<Activity> baseActs = cxr.getBaselineActivities(); for (Activity a : baseActs) { if (a.getActType().equalsIgnoreCase("quiz")) { String quizContent = a.getContents("en"); try { JSONObject quizJson = new JSONObject(quizContent); v54UpgradeQuizObj q = new v54UpgradeQuizObj(); q.id = quizJson.getInt("id"); q.digest = quizJson.getJSONObject("props").getString("digest"); q.threshold = quizJson.getJSONObject("props").getInt("passthreshold"); quizzes.add(q); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } // now add the standard activities ArrayList<Activity> acts = cxr.getActivities(c.getCourseId()); for (Activity a : acts) { if (a.getActType().equalsIgnoreCase("quiz")) { String quizContent = a.getContents("en"); try { JSONObject quizJson = new JSONObject(quizContent); v54UpgradeQuizObj q = new v54UpgradeQuizObj(); q.id = quizJson.getInt("id"); q.digest = quizJson.getJSONObject("props").getString("digest"); q.threshold = quizJson.getJSONObject("props").getInt("passthreshold"); quizzes.add(q); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } catch (InvalidXMLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } for (QuizAttempt qa : quizAttempts) { // data back to json obj try { JSONObject jsonData = new JSONObject(qa.getData()); qa.setMaxscore((float) jsonData.getDouble("maxscore")); qa.setScore((float) jsonData.getDouble("score")); int quizId = jsonData.getInt("quiz_id"); v54UpgradeQuizObj currentQuiz = null; // find the relevant quiz in quizzes for (v54UpgradeQuizObj tmpQuiz : quizzes) { if (tmpQuiz.id == quizId) { currentQuiz = tmpQuiz; break; } } if (currentQuiz == null) { Log.d(TAG, "not found"); } else { Log.d(TAG, "Found"); qa.setActivityDigest(currentQuiz.digest); if (qa.getScoreAsPercent() >= currentQuiz.threshold) { qa.setPassed(true); } else { qa.setPassed(false); } } // make the actual updates qa.setUserId(userId); db.updateQuizAttempt(qa); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } ArrayList<QuizAttempt> checkQuizAttempts = db.getAllQuizAttempts(); for (QuizAttempt qa : checkQuizAttempts) { // display current data Log.d(TAG, "data: " + qa.getData()); Log.d(TAG, "digest: " + qa.getActivityDigest()); Log.d(TAG, "userid: " + qa.getUserId()); Log.d(TAG, "courseid: " + qa.getCourseId()); Log.d(TAG, "score: " + qa.getScore()); Log.d(TAG, "maxscore: " + qa.getMaxscore()); Log.d(TAG, "passed: " + qa.isPassed()); } }