/*
* Copyright (C) 2013-2018 microG Project Team
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.microg.nlp.backend.apple;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.location.Location;
import android.os.Bundle;
import android.os.SystemClock;
import java.util.ArrayList;
import java.util.List;
public class WifiLocationDatabase extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 2;
private static final String TABLE_NAME = "location";
/**
* The field containing the BSSID of a wifi network, which is the Mac address of the Access
* Point.
*/
private static final String FIELD_MAC = "mac";
private static final String FIELD_LATITUDE = "latitude";
private static final String FIELD_LONGITUDE = "longitude";
private static final String FIELD_ALTITUDE = "altitude";
private static final String FIELD_ACCURACY = "accuracy";
/**
* The field containing the unix timestamp in milliseconds of retrieval for this location.
*/
private static final String FIELD_TIME = "time";
/**
* The field containing the unix timestamp in milliseconds of the last verification for this
* location
*/
private static final String FIELD_VERIFIED = "verified";
private static final String SQL_CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + "(" +
FIELD_MAC + " TEXT PRIMARY KEY, " +
FIELD_LATITUDE + " REAL, " +
FIELD_LONGITUDE + " REAL, " +
FIELD_ALTITUDE + " REAL, " +
FIELD_ACCURACY + " REAL," +
FIELD_TIME + " REAL," +
FIELD_VERIFIED + " REAL " + ")";
private static final String SQL_UPDATE_1_TO_2 = "ALTER TABLE " + TABLE_NAME + " ADD " +
FIELD_VERIFIED + " REAL";
public WifiLocationDatabase(Context context) {
super(context, "wifiloc.db", null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(SQL_CREATE_TABLE);
}
public Location get(String mac) {
Cursor cursor = getReadableDatabase().query(TABLE_NAME, null, FIELD_MAC + "=?",
new String[]{mac}, null, null, null);
if (cursor != null) {
if (cursor.moveToNext()) {
Location location = getLocation(cursor);
cursor.close();
return location;
}
cursor.close();
}
return null;
}
private Location getLocation(Cursor cursor) {
Location location = new Location("database");
Bundle extras = new Bundle();
int i = cursor.getColumnIndex(FIELD_MAC);
if (i != -1 && !cursor.isNull(i)) {
extras.putString(LocationRetriever.EXTRA_MAC_ADDRESS, cursor.getString(i));
}
i = cursor.getColumnIndex(FIELD_LATITUDE);
if (i != -1 && !cursor.isNull(i)) {
location.setLatitude(cursor.getDouble(i));
}
i = cursor.getColumnIndex(FIELD_LONGITUDE);
if (i != -1 && !cursor.isNull(i)) {
location.setLongitude(cursor.getDouble(i));
}
i = cursor.getColumnIndex(FIELD_ALTITUDE);
if (i != -1 && !cursor.isNull(i)) {
location.setAltitude(cursor.getDouble(i));
}
i = cursor.getColumnIndex(FIELD_ACCURACY);
if (i != -1 && !cursor.isNull(i)) {
location.setAccuracy(cursor.getFloat(i));
}
i = cursor.getColumnIndex(FIELD_TIME);
if (i != -1 && !cursor.isNull(i)) {
location.setTime(cursor.getLong(i));
}
i = cursor.getColumnIndex(FIELD_VERIFIED);
if (i != -1 && !cursor.isNull(i)) {
extras.putLong(LocationRetriever.EXTRA_VERIFIED_TIME, cursor.getLong(i));
}
location.setExtras(extras);
return location;
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (oldVersion == 1) {
db.execSQL(SQL_UPDATE_1_TO_2);
oldVersion = 2;
}
if (oldVersion != newVersion) {
throw new RuntimeException("Upgrade not supported, sorry!");
}
}
public List<Location> getNear(Location location, int limit, long maxAge) {
// TODO: Pythagoras is wrong for LatLon...
String order = "((" + FIELD_LATITUDE + "-(" + location.getLatitude() + "))*(" +
FIELD_LATITUDE + "-(" + location.getLatitude() + "))+(" + FIELD_LONGITUDE + "-("
+ location.getLongitude() + "))*(" + FIELD_LONGITUDE + "-(" + location
.getLongitude() + ")))";
Cursor cursor = getReadableDatabase().query(TABLE_NAME, null, FIELD_TIME + " > ?", new String[]{Float.toString(System.currentTimeMillis() - maxAge)}, null, null,
order, Integer.toString(limit));
if (cursor != null) {
List<Location> locations = new ArrayList<Location>();
while (cursor.moveToNext()) {
locations.add(getLocation(cursor));
}
cursor.close();
return locations;
}
return null;
}
public Editor edit() {
return new Editor();
}
public class Editor {
private final SQLiteDatabase db;
public Editor() {
db = getWritableDatabase();
db.beginTransaction();
}
public void put(Location location) {
if (location == null) return;
ContentValues values = new ContentValues();
values.put(FIELD_MAC, location.getExtras().getString(LocationRetriever
.EXTRA_MAC_ADDRESS));
values.put(FIELD_LATITUDE, location.getLatitude());
values.put(FIELD_LONGITUDE, location.getLongitude());
if (location.hasAltitude()) {
values.put(FIELD_ALTITUDE, location.getAltitude());
}
if (location.hasAccuracy()) {
values.put(FIELD_ACCURACY, location.getAccuracy());
}
values.put(FIELD_TIME, location.getTime());
values.put(FIELD_VERIFIED, location.getExtras().getLong(LocationRetriever
.EXTRA_VERIFIED_TIME));
db.insertWithOnConflict(TABLE_NAME, null, values, SQLiteDatabase.CONFLICT_REPLACE);
}
public void end() {
db.setTransactionSuccessful();
db.endTransaction();
}
}
}
