public void saveAndWriteRecent(boolean saveEmpty) { Database database = new Database(c); // We need server address or SSH server to be filled out to save. Otherwise, // we keep adding empty connections. // However, if there is partial data from a URI, we can present the edit screen. // Alternately, perhaps we could process some extra data if ((getConnectionType() == Constants.CONN_TYPE_SSH && getSshServer().equals("") || getAddress().equals("")) && !saveEmpty) { return; } SQLiteDatabase db = database.getWritableDatabase(); db.beginTransaction(); try { save(db); MostRecentBean mostRecent = getMostRecent(db); if (mostRecent == null) { mostRecent = new MostRecentBean(); mostRecent.setConnectionId(get_Id()); mostRecent.Gen_insert(db); } else { mostRecent.setConnectionId(get_Id()); mostRecent.Gen_update(db); } db.setTransactionSuccessful(); } finally { db.endTransaction(); db.close(); } if (db.isOpen()) { db.close(); } }
public JSONArray insertObservationData( String patientUuid, String visitUuid, JSONArray observationData) throws JSONException { SQLiteDatabase db = mDBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); for (int index = 0; index < observationData.length(); index++) { JSONObject observation = observationData.getJSONObject(index); String observationUuid = observation.getString("uuid"); if (observation.getJSONArray("groupMembers").length() > 0) { values.put("uuid", observationUuid); values.put("patientUuid", patientUuid); values.put("visitUuid", visitUuid); values.put("conceptName", observation.getJSONObject("concept").getString("name")); values.put("encounterUuid", observation.getString("encounterUuid")); values.put("observationJson", String.valueOf(observation)); db.insertWithOnConflict("observation", null, values, SQLiteDatabase.CONFLICT_REPLACE); } else { deleteObservationByUuid(db, observationUuid, patientUuid); } } db.close(); return observationData; }