diff --git a/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java b/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java index 5fa77bf..ff24059 100644 --- a/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java +++ b/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java @@ -192,4 +192,23 @@ } db.close(); } + + public ArrayList getPoiOptions(long _poi_id){ + ArrayList optList = new ArrayList<>(); + SQLiteDatabase db = this.getReadableDatabase(); + Cursor cursor = db.query(TABLE_PROPERTIES, + new String[]{KEY_PROPERTIES_ID, KEY_PROPERTIES_OPT_ID}, + KEY_PROPERTIES_POI_ID + "=?", + new String[]{String.valueOf(_poi_id)}, null, null, null, null); + if(cursor.moveToFirst()){ + do { + long _id = Long.parseLong(cursor.getString(0)); + long _opt_id = Long.parseLong(cursor.getString(1)); + Properties prop = new Properties(_id, _poi_id, _opt_id); + optList.add(prop); + } while(cursor.moveToNext()); + } + db.close(); + return optList; + } }