@Test
public void testGetResidentialSpecification() throws SQLException {
DataBaseQuery dbq = new DataBaseQuery();
rp = new ResidentialProperty();
Specification sp = new Specification(dbq);
sp.setSpecificationId(20);
ResultSet rs_expected = sp.getResidentialSpecification();
rp.setSpecification(5, 5, 5, 5, 1, 1);
rp.updatePropertySpecification(20);
rp.setSpecificationId(20);
ResultSet rs_actual = rp.getResidentialSpecification();
while (rs_expected.next() && rs_actual.next()) {
assertEquals(rs_actual.getLong("specificationid"), rs_expected.getLong("specificationid"));
assertEquals(rs_actual.getLong("nobedroom"), rs_expected.getLong("nobedroom"));
assertEquals(rs_actual.getLong("nobathroom"), rs_expected.getLong("nobathroom"));
assertEquals(rs_actual.getLong("nokitchen"), rs_expected.getLong("nokitchen"));
assertEquals(rs_actual.getLong("nostorey"), rs_expected.getLong("nostorey"));
assertEquals(rs_actual.getLong("teriss"), rs_expected.getLong("teriss"));
assertEquals(rs_actual.getLong("balcony"), rs_expected.getLong("balcony"));
}
}
