/*
GET PASSED EXAMS
*/
public Cursor getPassedExams() {
database = course_dbHelper.getWritableDatabase();
String where = DB_ABSTRACTS.DBCourse.PASSED_COLUMN + " = " + 1;
Cursor cursor =
database.query(
DB_ABSTRACTS.DBCourse.DATABASE_TABLE,
examColumns,
where,
null,
null,
null,
DB_ABSTRACTS.DBCourse.PASS_MARK_COLUMN + " ASC");
if (cursor.moveToFirst()) {
do {
Course course = new Course();
course.setId(cursor.getInt(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.KEY_ID)));
course.setName(cursor.getString(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.NAME_COLUMN)));
course.setPassed(cursor.getInt(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.PASSED_COLUMN)));
course.setPass_mark(
cursor.getString(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.PASS_MARK_COLUMN)));
} while (cursor.moveToNext());
}
return cursor;
}
