@Override public void getContentValues(DBToolsContentValues values) { values.put(IndividualConst.C_INDIVIDUAL_TYPE, individualType.ordinal()); values.put(IndividualConst.C_INDIVIDUAL_TYPE_TEXT, individualTypeText.toString()); values.put(IndividualConst.C_FIRST_NAME, firstName); values.put(IndividualConst.C_LAST_NAME, lastName); values.put(IndividualConst.C_SAMPLE_DATE_TIME, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToDBString(sampleDateTime)); values.put(IndividualConst.C_BIRTH_DATE, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToDBString(birthDate)); values.put(IndividualConst.C_LAST_MODIFIED, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToLong(lastModified)); values.put(IndividualConst.C_NUMBER, number); values.put(IndividualConst.C_PHONE, phone); values.put(IndividualConst.C_EMAIL, email); values.put(IndividualConst.C_DATA, data); values.put(IndividualConst.C_AMOUNT1, amount1); values.put(IndividualConst.C_AMOUNT2, amount2); values.put(IndividualConst.C_ENABLED, enabled != null ? (enabled ? 1 : 0) : 0); values.put(IndividualConst.C_SPOUSE_INDIVIDUAL_ID, spouseIndividualId); }
@Override public void getContentValues(DBToolsContentValues values) { values.put(IndividualConst.C_INDIVIDUAL_TYPE, individualType.ordinal()); values.put(IndividualConst.C_INDIVIDUAL_TYPE_TEXT, individualTypeText.toString()); values.put(IndividualConst.C_FIRST_NAME, firstName); values.put(IndividualConst.C_LAST_NAME, lastName); values.put(IndividualConst.C_SAMPLE_DATE_TIME, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToDBString(sampleDateTime)); values.put(IndividualConst.C_BIRTH_DATE, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToDBString(birthDate)); values.put(IndividualConst.C_LAST_MODIFIED, org.dbtools.android.domain.date.DBToolsDateFormatter.dateToLong(lastModified)); values.put(IndividualConst.C_NUMBER, number); values.put(IndividualConst.C_PHONE, phone); values.put(IndividualConst.C_EMAIL, email); values.put(IndividualConst.C_DATA, data); values.put(IndividualConst.C_AMOUNT1, amount1); values.put(IndividualConst.C_AMOUNT2, amount2); values.put(IndividualConst.C_ENABLED, enabled != null ? (enabled ? 1 : 0) : 0); values.put(IndividualConst.C_SPOUSE_INDIVIDUAL_ID, spouseIndividualId); }
private void updateDatabaseMetaViewVersion(@Nonnull AndroidDatabase androidDatabase, int version) { createMetaTableIfNotExists(androidDatabase); int currentVersion = findViewVersion(androidDatabase); String keyName = getViewVersionKey(androidDatabase); String table = DBToolsMetaData.TABLE; DBToolsContentValues<?> contentValues = androidDatabase.getDatabaseWrapper().newContentValues(); contentValues.put(DBToolsMetaData.C_KEY, keyName); contentValues.put(DBToolsMetaData.C_VALUE, version); if (currentVersion != -1) { String selection = DBToolsMetaData.KEY_SELECTION; String[] whereArgs = new String[]{keyName}; androidDatabase.getDatabaseWrapper().update(table, contentValues, selection, whereArgs); } else { androidDatabase.getDatabaseWrapper().insert(table, null, contentValues); } }
@Test public void testUpdate() throws Exception { // === INSERT === Individual individual = createIndividual("Jeff"); individualManager.save(individual); // test save assertEquals(1, individualManager.findCount()); assertCountValues(1, 0, 0); // === Record UPDATE === individual.setFirstName("Jeff1"); individualManager.save(individual); assertCountValues(1, 1, 0); // == Update single column DBToolsContentValues contentValues = individualManager.createNewDBToolsContentValues(); contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, individual.getId()); assertCountValues(1, 2, 0); // Update a record that does not exist (no event should trigger) contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, 1000); // 1000 is a primary key that should NEVER exist in this test assertCountValues(1, 2, 0); }
@Test public void testUpdate() throws Exception { // === INSERT === Individual individual = createIndividual("Jeff"); individualManager.save(individual); // test save assertEquals(1, individualManager.findCount()); assertCountValues(1, 0, 0); // === Record UPDATE === individual.setFirstName("Jeff1"); individualManager.save(individual); assertCountValues(1, 1, 0); // == Update single column DBToolsContentValues contentValues = individualManager.createNewDBToolsContentValues(); contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, individual.getId()); assertCountValues(1, 2, 0); // Update a record that does not exist (no event should trigger) contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, 1000); // 1000 is a primary key that should NEVER exist in this test assertCountValues(1, 2, 0); }
@Test public void testUpdate() throws Exception { // === INSERT === Individual individual = createIndividual("Jeff"); individualManager.save(individual); // test save assertEquals(1, individualManager.findCount()); assertCountValues(1, 0, 0); // === Record UPDATE === individual.setFirstName("Jeff1"); individualManager.save(individual); assertCountValues(1, 1, 0); // == Update single column DBToolsContentValues contentValues = individualManager.createNewDBToolsContentValues(); contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, individual.getId()); assertCountValues(1, 2, 0); // Update a record that does not exist (no event should trigger) contentValues.put(IndividualConst.C_FIRST_NAME, "Jeff2"); individualManager.update(contentValues, 1000); // 1000 is a primary key that should NEVER exist in this test assertCountValues(1, 2, 0); }