Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static final String LATITUDE = "latitude";
- private static final String LONGITUDE = "longitude";
- String CREATE_SETTINGS_TABLE = "CREATE TABLE "
- + TABLE_SETTINGS + "("
- + KEY_ID + " INTEGER PRIMARY KEY,"
- + KEY_NAME + " TEXT UNIQUE NOT NULL, "
- + KEY_VALUE + " TEXT, "
- + DATA_TYPE + " TEXT "
- + ")";
- db.execSQL(CREATE_SETTINGS_TABLE);
- insertSetting(LATITUDE, "");
- insertSetting(LONGITUDE, "");
- private void insertSetting(String name, String value) {
- SQLiteDatabase myDb = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(KEY_NAME, name);
- values.put(KEY_VALUE, value);
- values.put(DATA_TYPE, "text");
- // Inserting Row
- myDb.insert(TABLE_SETTINGS, null, values);
- Log.d(TAG, "Default settings inserted into sqlite: ");
- }
- public void updateTableSettings(String keyName, String keyValue) {
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(KEY_NAME, keyName);
- values.put(KEY_VALUE, keyValue);
- String[] whereArgs = {"" + keyName};
- db.update(TABLE_NOTIFICATIONS, values, KEY_NAME + "=?", whereArgs);
- db.close(); // Closing database connection
- Log.d(TAG, "User updated in sqlite db: " + keyName);
- }
- public HashMap<String, String> getSettings() {
- HashMap<String, String> settings = new HashMap<>();
- String selectQuery = "SELECT * FROM " + TABLE_SETTINGS;
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.rawQuery(selectQuery, null);
- cursor.moveToFirst();
- if (cursor.getCount() > 0) {
- cursor.moveToFirst();
- settings.put(KEY_NAME, cursor.getString(1));
- settings.put(KEY_VALUE, cursor.getString(2));
- cursor.close();
- db.close();
- } else {
- insertDefaultNotificationSettings();
- return getSettings();
- }
- cursor.close();
- db.close();
- // return user
- Log.d(TAG, "Fetching notification settings from sqlite db");
- return settings;
- }
- db = new SQLiteHandler(getApplicationContext());
- HashMap<String, String> settings = db.getSettings();
- map.setOnMapLongClickListener(arg0 -> {
- map.clear();
- db.updateTableSettings("latitude", String.valueOf(arg0.latitude));
- db.updateTableSettings("longitude", String.valueOf(arg0.longitude));
- map.addMarker(marker);
- }
Add Comment
Please, Sign In to add comment