Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ArrayList<Monument> retrieveMonumentsOnRoute(int RouteID) {
- ArrayList<Monument> monumentList = new ArrayList<>();
- String query = "SELECT * FROM MONUMENT JOIN ROUTEMONUMENT ON id = ROUTEMONUMENT.MonumentID WHERE ROUTEMONUMENT.RouteID =" + RouteID + ";";
- Log.d("QUERYMONUMENT", query);
- Cursor cursor = this.getReadableDatabase().rawQuery(query, null);
- if(cursor != null) {
- cursor.moveToFirst();
- } else {
- throw new Error("CURSOR IS NULL");
- }
- if(cursor.getCount() > 0 ) {
- do {
- Monument monument = new Monument.Builder()
- .name(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_MONUMENTNAME)))
- .description(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_DESCRIPTION)))
- .creator(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_CREATOR)))
- .soundURL(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_SOUNDFILEURL)))
- .imageURL(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_IMAGEURL)))
- .latitude(cursor.getDouble(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_LATITUDE)))
- .longitude(cursor.getDouble(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_LONGITUDE)))
- .constructionYear(cursor.getInt(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_CONSTRUCTIONYEAR)))
- .build();
- if(cursor.getInt(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_ISVISITED)) == 1) {
- monument.setVisited(true);
- } else
- {
- monument.setVisited(false);
- }
- monumentList.add(monument);
- }while (cursor.moveToNext());
- return monumentList;
- } else {
- cursor.close();
- throw new Error("ROUTE COULD NOT BE FOUND BECAUSE EITHER IT DOES NOT EXIST OR INVALID PARAMETERS!");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement