public List<CellGroup> loadCellGroup(String type) {
List<CellGroup> list = new ArrayList<>();
Cursor cursor = null;
try {
cursor =
getReadableDatabase()
.query(
CellGroup.NAME,
null,
"type=?",
new String[] {type},
"type, name",
null,
"status desc, name");
if (cursor.getCount() > 0) {
cursor.moveToFirst();
do {
CellGroup cellGroup =
new CellGroup(cursor.getString(1), cursor.getString(2), cursor.getInt(3));
cellGroup.setId(cursor.getInt(0));
list.add(cellGroup);
} while (cursor.moveToNext());
}
} finally {
if (cursor != null) {
cursor.close();
}
}
return list;
}
public long addOrUpdateCellGroup(CellGroup cellGroup) {
ContentValues content = new ContentValues();
content.put("status", cellGroup.getStatus());
content.put("name", cellGroup.getName());
content.put("type", cellGroup.getType());
return addOrUpdate(cellGroup.getId(), CellGroup.NAME, content);
}
public int toggleCellGroup(CellGroup group) {
ContentValues content = new ContentValues();
content.put(
"status",
group.getStatus() == CellGroup.STATUS.ENABLED.getValue()
? CellGroup.STATUS.DISABLED.getValue()
: CellGroup.STATUS.ENABLED.getValue());
return getWritableDatabase().update(CellGroup.NAME, content, "id=" + group.getId(), null);
}