Differential D56 Diff 189 src/it/reyboz/bustorino/data/NextGenDB.java

Changeset View

Standalone View

src/it/reyboz/bustorino/data/NextGenDB.java

Show First 20 Lines • Show All 151 Lines • ▼ Show 20 Lines	public class NextGenDB extends SQLiteOpenHelper{
* double latTo = bb.getLatNorthE6() / 1E6;		* double latTo = bb.getLatNorthE6() / 1E6;
* double lngFrom = bb.getLonWestE6() / 1E6;		* double lngFrom = bb.getLonWestE6() / 1E6;
* double lngTo = bb.getLonEastE6() / 1E6;		* double lngTo = bb.getLonEastE6() / 1E6;
*/		*/
public synchronized Stop[] queryAllInsideMapView(double minLat, double maxLat, double minLng, double maxLng) {		public synchronized Stop[] queryAllInsideMapView(double minLat, double maxLat, double minLng, double maxLng) {
Stop[] stops = new Stop[0];		Stop[] stops = new Stop[0];
SQLiteDatabase db = this.getReadableDatabase();		SQLiteDatabase db = this.getReadableDatabase();

Cursor result;		//Cursor result=null;
int count;		int count;

// coordinates must be strings in the where condition		// coordinates must be strings in the where condition
String minLatRaw = String.valueOf(minLat);		String minLatRaw = String.valueOf(minLat);
String maxLatRaw = String.valueOf(maxLat);		String maxLatRaw = String.valueOf(maxLat);
String minLngRaw = String.valueOf(minLng);		String minLngRaw = String.valueOf(minLng);
String maxLngRaw = String.valueOf(maxLng);		String maxLngRaw = String.valueOf(maxLng);


if(db == null) {		if(db == null) {
return stops;		return stops;
}		}

try {		try {
result = db.query(StopsTable.TABLE_NAME, QUERY_COLUMN_stops_all, QUERY_WHERE_LAT_AND_LNG_IN_RANGE,		final Cursor result = db.query(StopsTable.TABLE_NAME, QUERY_COLUMN_stops_all, QUERY_WHERE_LAT_AND_LNG_IN_RANGE,
new String[] {minLatRaw, maxLatRaw, minLngRaw, maxLngRaw},		new String[] {minLatRaw, maxLatRaw, minLngRaw, maxLngRaw},
null, null, null);		null, null, null);
stops = getStopsFromCursorAllFields(result);		stops = getStopsFromCursorAllFields(result);
		result.close();
} catch(SQLiteException e) {		} catch(SQLiteException e) {
Log.e(DEBUG_TAG, "SQLiteException occurred");		Log.e(DEBUG_TAG, "SQLiteException occurred");
e.printStackTrace();		e.printStackTrace();
return stops;		return stops;
}		}finally {

result.close();
db.close();		db.close();
		}

return stops;		return stops;
}		}

/**		/**
* Get the list of stop in the query, with all the possible fields {NextGenDB.QUERY_COLUMN_stops_all}		* Get the list of stop in the query, with all the possible fields {NextGenDB.QUERY_COLUMN_stops_all}
* @param result cursor from query		* @param result cursor from query
* @return an Array of the stops found in the query		* @return an Array of the stops found in the query
▲ Show 20 Lines • Show All 161 Lines • Show Last 20 Lines