private LessonListElement getLessonFromCursor(Cursor c) {
LessonListElement lesson;
lesson = new LessonListElement();
lesson.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID)));
lesson.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY)));
lesson.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER)));
lesson.setInformation(getLessonInformation(c.getLong(c.getColumnIndex(LessonTableModel.ID))));
return lesson;
}
public LessonListElement getLesson(Long lesonId) {
LessonListElement result = new LessonListElement();
Cursor c =
mDb.rawQuery(
TextUtils.concat(
"SELECT * FROM ",
LessonTableModel.TABLE_NAME,
" WHERE ",
LessonTableModel.ID,
"=?")
.toString(),
new String[] {lesonId.toString()});
c.moveToFirst();
if (c.getCount() != 0) {
result.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID)));
result.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY)));
result.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER)));
result.setInformation(getLessonInformation(lesonId));
}
return result;
}
