public ArrayList<Group> getGroupList(Long facultetId) {
ArrayList<Group> result = new ArrayList<Group>();
Cursor c =
mDb.rawQuery(
TextUtils.concat(
"SELECT * FROM ",
Group.TABLE_NAME,
" WHERE ",
Group.FACULTET_ID,
"=?",
" ORDER BY ",
Group.LEVEL,
", ",
Group.GROUP_TITLE)
.toString(),
new String[] {facultetId.toString()});
Group group = null;
while (c.moveToNext()) {
group = new Group();
group.setId(c.getLong(c.getColumnIndex(Group.ID)));
group.setTitle(c.getString(c.getColumnIndex(Group.GROUP_TITLE)));
group.setLevel(c.getInt(c.getColumnIndex(Group.LEVEL)));
group.setFacultetId(c.getLong(c.getColumnIndex(Group.FACULTET_ID)));
result.add(group);
}
return result;
}
