public static City getById(Context context, long id) { Log.i(Global.TAG, City.class.getSimpleName() + ": getById"); City city = null; MyDbHelper dbHelper = new MyDbHelper(context); SQLiteDatabase db = dbHelper.getWritableDatabase(); Cursor c = db.rawQuery("SELECT * FROM tbl_place WHERE id_place = " + id, null); if (c != null && c.moveToFirst()) { // 0-id, 1-name, 2-latitude, 3-longitude, 4-country, 5-description city = new City( c.getLong(0), c.getString(1), c.getString(4), c.getString(5), c.getDouble(2), c.getDouble(3)); } c.close(); db.close(); db = null; return city; }
public static void getAll(Context context, ArrayList<City> cities) { Log.i(Global.TAG, City.class.getSimpleName() + ": getAll"); MyDbHelper dbHelper = new MyDbHelper(context); SQLiteDatabase db = dbHelper.getWritableDatabase(); cities.clear(); Cursor c = db.rawQuery("SELECT * FROM tbl_place ORDER BY name ASC", null); if (c != null && c.moveToFirst()) { do { // 0-id, 1-name, 2-latitude, 3-longitude, 4-country, 5-description City city = new City( c.getLong(0), c.getString(1), c.getString(4), c.getString(5), c.getDouble(2), c.getDouble(3)); cities.add(city); } while (c.moveToNext()); } c.close(); db.close(); db = null; }
@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.notification); Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar); setSupportActionBar(toolbar); getSupportActionBar().setDisplayHomeAsUpEnabled(true); toolbar.setTitle("Notifications"); RecyclerView recyclerView = (RecyclerView) findViewById(R.id.recycler_view_notification); MyDbHelper dbHelper = new MyDbHelper(this); ArrayList<NotificationItem> list = dbHelper.readData(); NotificationAdapter adapter = new NotificationAdapter(list); recyclerView.setAdapter(adapter); recyclerView.setLayoutManager(new LinearLayoutManager(this)); }
@Override public boolean onCreate() { myDb = new MyDbHelper(getContext()); db = myDb.getWritableDatabase(); TelephonyManager tel = (TelephonyManager) getContext().getSystemService(Context.TELEPHONY_SERVICE); self_avd = tel.getLine1Number().substring(tel.getLine1Number().length() - 4); port_avd = Integer.parseInt(self_avd); try { self_hash = genHash(self_avd); hash0 = genHash("5556"); hash1 = genHash("5554"); hash2 = genHash("5558"); } catch (NoSuchAlgorithmException e) { e.printStackTrace(); } if (self_avd.compareTo("5556") == 0) { suc_pointer1 = 11108; suc_pointer2 = 11116; } else if (self_avd.compareTo("5554") == 0) { suc_pointer1 = 11116; suc_pointer2 = 11112; } else if (self_avd.compareTo("5558") == 0) { suc_pointer1 = 11112; suc_pointer2 = 11108; } Thread serv = new Thread(new Server()); serv.start(); Thread recov = new Thread(new Recovery()); recov.start(); return false; }
@Override public Uri insert(Uri uri, ContentValues values) { db = myDb.getWritableDatabase(); String key = (String) values.get(MyDbHelper.KEY); String value = (String) values.get(MyDbHelper.VALUE); String version = "0"; key_recov = key; String keyhash = null; try { keyhash = genHash(key); } catch (NoSuchAlgorithmException e) { e.printStackTrace(); } Cursor c1 = db.rawQuery( "select * from " + MyDbHelper.TABLE_NAME + " where key like '" + key + "'", null); if (c1 != null && c1.getCount() > 0) { Log.d("values in content provider checking version", "Insert"); int ind = c1.getColumnIndex(MyDbHelper.VERSION); while (c1.moveToNext()) { version_tracker = Integer.parseInt(c1.getString(ind)) + 1; version = Integer.toString(version_tracker); break; } } else { Log.d("First time version", "Insert"); version_tracker = 1; version = Integer.toString(version_tracker); } if (keyhash.compareTo(self_hash) <= 0) { r1 = isalive(suc_pointer1); r2 = isalive(suc_pointer2); if (r1 == true) { String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, suc_pointer1)); cli.start(); } if (r2 == true) { String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, suc_pointer2)); cli.start(); } Log.d("Content Provider", "Insert"); Cursor c = db.rawQuery( "select * from " + MyDbHelper.TABLE_NAME + " where key like '" + key + "'", null); if (c != null && c.getCount() > 0) { Log.d("values in content provider", "Insert"); int a = db.delete(MyDbHelper.TABLE_NAME, MyDbHelper.KEY + "=" + key, null); } values.put(MyDbHelper.VERSION, version); long rowId = db.insert(MyDbHelper.TABLE_NAME, MyDbHelper.VALUE, values); if (rowId > 0) { Uri newuri = ContentUris.withAppendedId(CONTENT_URI, rowId); getContext().getContentResolver().notifyChange(uri, null); return newuri; } } else { String nodes = findkeypos(keyhash); StringTokenizer s = new StringTokenizer(nodes, " "); coordinator = Integer.parseInt(s.nextToken()); rep1 = Integer.parseInt(s.nextToken()); rep2 = Integer.parseInt(s.nextToken()); if (isalive(coordinator) == false) { quorum = 2; String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, rep1)); cli.start(); Thread cli1 = new Thread(new Client(msg1, rep2)); cli1.start(); } else if ((isalive(coordinator) == true) && (isalive(rep1) == true) && (isalive(rep2) == true)) { quorum = 3; String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, coordinator)); cli.start(); Thread cli1 = new Thread(new Client(msg1, rep1)); cli1.start(); Thread cli2 = new Thread(new Client(msg1, rep2)); cli2.start(); } else { if (isalive(rep1) == false) { String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, coordinator)); cli.start(); Thread cli1 = new Thread(new Client(msg1, rep2)); cli1.start(); } else if (isalive(rep2) == false) { String msg1 = "I" + " " + key + " " + value + " " + version; Thread cli = new Thread(new Client(msg1, coordinator)); cli.start(); Thread cli1 = new Thread(new Client(msg1, rep1)); cli1.start(); } } } return null; }