// Getting All Features
public List<Feature> getAllFeatures() {
List<Feature> featureList = new ArrayList<Feature>();
// Select All Query
String selectQuery = "SELECT * FROM " + TABLE_FEATURES;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
Feature feature = new Feature();
feature.setID(Integer.parseInt(cursor.getString(0)));
feature.setName(cursor.getString(1));
feature.setL1Norm(Double.parseDouble(cursor.getString(2)));
feature.setL2Norm(Double.parseDouble(cursor.getString(3)));
feature.setLinfNorm(Double.parseDouble(cursor.getString(4)));
feature.setTimestamp(Double.parseDouble(cursor.getString(5)));
feature.setDiffSecs(Double.parseDouble(cursor.getString(6)));
feature.setMfccsAsString(cursor.getString(7));
feature.setPsdAcrossFrequencyBandsAsString(cursor.getString(8));
// Adding feature to list
featureList.add(feature);
} while (cursor.moveToNext());
}
db.close(); // Closing database connection
// return feature list
return featureList;
}
