@Test
public void TestPurgeServiceRunLogNoLimit() {
Calendar cal = Calendar.getInstance(Locale.getDefault());
cal.add(Calendar.DATE, -400);
Date start1 = cal.getTime();
cal.add(Calendar.HOUR, 1);
Date end1 = cal.getTime();
ServiceRunProvider.ServiceRun r1 = new ServiceRunProvider.ServiceRun(1, start1, end1, 0, 0);
cal.add(Calendar.DATE, 200);
Date start2 = cal.getTime();
cal.add(Calendar.HOUR, 1);
Date end2 = cal.getTime();
ServiceRunProvider.ServiceRun r2 = new ServiceRunProvider.ServiceRun(2, start2, end2, 2, 1);
long rid1 = ServiceRunProvider.InsertRow(myDb, r1);
long rid2 = ServiceRunProvider.InsertRow(myDb, r2);
// insert calls
LoggedCallProvider.InsertRow(
myDb, new LoggedCallProvider.LoggedCall(rid1, null, "123", "dummy"));
LoggedCallProvider.InsertRow(
myDb, new LoggedCallProvider.LoggedCall(rid2, null, "456", "dummy"));
Cursor latest = ServiceRunProvider.LatestRuns(myDb, -1);
assertEquals("There should be two records", 2, latest.getCount());
Cursor calls = LoggedCallProvider.LatestCalls(myDb, -1);
assertEquals("There should be two records", 2, latest.getCount());
ServiceRunProvider.PurgeLog(myDb, myContext, "no limit");
latest = ServiceRunProvider.LatestRuns(myDb, -1);
assertEquals("No purging", 2, latest.getCount());
assertEquals("No purging", 2, calls.getCount());
latest.close();
calls.close();
}
@Test
public void GetLatestServiceRunWhenTableIsNotEmpty() {
Calendar cal = Calendar.getInstance(Locale.getDefault());
Date start = cal.getTime();
cal.add(Calendar.HOUR, 1);
Date end = cal.getTime();
ServiceRunProvider.InsertRow(myDb, new ServiceRunProvider.ServiceRun(-1, start, end, 2, 1));
cal.add(Calendar.HOUR, 1);
start = cal.getTime();
cal.add(Calendar.HOUR, 1);
end = cal.getTime();
ServiceRunProvider.InsertRow(myDb, new ServiceRunProvider.ServiceRun(-1, start, end, 4, 1));
ServiceRunProvider.ServiceRun latest = ServiceRunProvider.LatestRun(myDb);
assertEquals("id", 2, latest.getId());
assertEquals("received", 4, latest.getNumReceived());
assertEquals("triggered", 1, latest.getNumTriggered());
}
@Test
public void ServiceRunsInsertRow() {
Calendar cal = Calendar.getInstance(Locale.getDefault());
Date start = cal.getTime();
cal.add(Calendar.HOUR, 1);
Date end = cal.getTime();
ServiceRunProvider.InsertRow(myDb, new ServiceRunProvider.ServiceRun(-1, start, end, 2, 1));
Cursor c = myDb.rawQuery("select * from serviceruns", null);
assertEquals("one row expected", 1, c.getCount());
c.moveToFirst();
long id = c.getLong(c.getColumnIndexOrThrow(DbContract.ServiceRuns._ID));
assertEquals("First id equal to 1", 1, id);
long received =
c.getLong(c.getColumnIndexOrThrow(DbContract.ServiceRuns.COLUMN_NAME_TOTAL_RECEIVED));
assertEquals("Expected calls received", 2, received);
long triggered =
c.getLong(c.getColumnIndexOrThrow(DbContract.ServiceRuns.COLUMN_NAME_TOTAL_TRIGGERED));
assertEquals("Expected calls triggered", 1, triggered);
c.close();
}