Assert.assertEquals(4, result.getInt("count"));
result.close();
connection.commit();
// list programs should return the same number and equal programs
List<Program> dbPrograms1 = asList(connection.listPrograms());
Assert.assertEquals(4, dbPrograms1.size());
Assert.assertEquals("list of original programs differs from list of database",programs,dbPrograms1);
// delete all programs and check if the database does not contain any remaining entries in the different tables
for(Program p : programs) {