Guest User

Untitled

a guest
Feb 18th, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. private static final String LATITUDE = "latitude";
  2. private static final String LONGITUDE = "longitude";
  3.  
  4. String CREATE_SETTINGS_TABLE = "CREATE TABLE "
  5. + TABLE_SETTINGS + "("
  6. + KEY_ID + " INTEGER PRIMARY KEY,"
  7. + KEY_NAME + " TEXT UNIQUE NOT NULL, "
  8. + KEY_VALUE + " TEXT, "
  9. + DATA_TYPE + " TEXT "
  10. + ")";
  11. db.execSQL(CREATE_SETTINGS_TABLE);
  12.  
  13. insertSetting(LATITUDE, "");
  14. insertSetting(LONGITUDE, "");
  15.  
  16. private void insertSetting(String name, String value) {
  17. SQLiteDatabase myDb = this.getWritableDatabase();
  18.  
  19. ContentValues values = new ContentValues();
  20. values.put(KEY_NAME, name);
  21. values.put(KEY_VALUE, value);
  22. values.put(DATA_TYPE, "text");
  23. // Inserting Row
  24. myDb.insert(TABLE_SETTINGS, null, values);
  25.  
  26. Log.d(TAG, "Default settings inserted into sqlite: ");
  27. }
  28.  
  29. public void updateTableSettings(String keyName, String keyValue) {
  30. SQLiteDatabase db = this.getWritableDatabase();
  31.  
  32. ContentValues values = new ContentValues();
  33. values.put(KEY_NAME, keyName);
  34. values.put(KEY_VALUE, keyValue);
  35.  
  36. String[] whereArgs = {"" + keyName};
  37. db.update(TABLE_NOTIFICATIONS, values, KEY_NAME + "=?", whereArgs);
  38. db.close(); // Closing database connection
  39.  
  40. Log.d(TAG, "User updated in sqlite db: " + keyName);
  41. }
  42.  
  43. public HashMap<String, String> getSettings() {
  44. HashMap<String, String> settings = new HashMap<>();
  45. String selectQuery = "SELECT * FROM " + TABLE_SETTINGS;
  46.  
  47. SQLiteDatabase db = this.getReadableDatabase();
  48. Cursor cursor = db.rawQuery(selectQuery, null);
  49. cursor.moveToFirst();
  50. if (cursor.getCount() > 0) {
  51. cursor.moveToFirst();
  52. settings.put(KEY_NAME, cursor.getString(1));
  53. settings.put(KEY_VALUE, cursor.getString(2));
  54.  
  55. cursor.close();
  56. db.close();
  57. } else {
  58. insertDefaultNotificationSettings();
  59. return getSettings();
  60. }
  61. cursor.close();
  62. db.close();
  63. // return user
  64. Log.d(TAG, "Fetching notification settings from sqlite db");
  65.  
  66. return settings;
  67. }
  68.  
  69. db = new SQLiteHandler(getApplicationContext());
  70. HashMap<String, String> settings = db.getSettings();
  71.  
  72. map.setOnMapLongClickListener(arg0 -> {
  73. map.clear();
  74. db.updateTableSettings("latitude", String.valueOf(arg0.latitude));
  75. db.updateTableSettings("longitude", String.valueOf(arg0.longitude));
  76. map.addMarker(marker);
  77. }
Add Comment
Please, Sign In to add comment