private static ArrayList<Application> select(String whereClause, String[] selectionArgs) {
ArrayList<Application> applications = new ArrayList<>();
DataAccess da = new DataAccess();
SQLiteDatabase db = da.getReadableDB();
Cursor cursor = null;
try {
String query = "Select * From " + TableName + " " + whereClause;
cursor = db.rawQuery(query, selectionArgs);
if (cursor != null && cursor.moveToFirst()) {
do {
Application app =
new Application(
cursor.getInt(cursor.getColumnIndex(Id)),
cursor.getInt(cursor.getColumnIndex(Uid)),
cursor.getString(cursor.getColumnIndex(AppName)),
cursor.getString(cursor.getColumnIndex(PackageName)),
cursor.getInt(cursor.getColumnIndex(Removed)) == 1);
applications.add(app);
} while (cursor.moveToNext());
}
} catch (MyRuntimeException e) {
e.printStackTrace();
} finally {
if (cursor != null && !cursor.isClosed()) cursor.close();
if (db != null && db.isOpen()) db.close();
}
return applications;
}
private static ArrayList<SystemSetting> select(String whereClause, String[] selectionArgs) {
ArrayList<SystemSetting> settings = new ArrayList<>();
DataAccess da = new DataAccess();
SQLiteDatabase db = da.getReadableDB();
Cursor cursor = null;
try {
String query = "Select * From " + TableName + " " + whereClause;
cursor = db.rawQuery(query, selectionArgs);
if (cursor != null && cursor.moveToFirst()) {
do {
SystemSetting systemSetting =
new SystemSetting(
cursor.getInt(cursor.getColumnIndex(Id)),
cursor.getInt(cursor.getColumnIndex(Installed)) == 1,
cursor.getString(cursor.getColumnIndex(RingingToneUri)),
cursor.getString(cursor.getColumnIndex(AlarmRingingTone)),
cursor.getInt(cursor.getColumnIndex(VibrateInAlarms)) == 1,
cursor.getInt(cursor.getColumnIndex(SoundInAlarms)) == 1);
settings.add(systemSetting);
} while (cursor.moveToNext());
}
} catch (MyRuntimeException e) {
e.printStackTrace();
} finally {
if (cursor != null && !cursor.isClosed()) cursor.close();
if (db != null && db.isOpen()) db.close();
}
return settings;
}
