def test_insert(self): """Test inserting in the sqlite table.""" c = city.City(name="Freiburg") p1 = city.Citizen(name="Peter") p2 = city.Citizen(name="Georg") c.add(p1, p2, rel=city.hasInhabitant) with DataspaceSession(URI) as session: wrapper = city.CityWrapper(session=session) wrapper.add(c) session.commit() check_state(self, c, p1, p2, db=DB)
def test_update(self): """Test updating the sqlite table.""" c = city.City(name="Paris") p1 = city.Citizen(name="Peter") c.add(p1, rel=city.hasInhabitant) with TransportSessionClient(SqliteSession, URI, path=DB) as session: wrapper = city.CityWrapper(session=session) cw = wrapper.add(c) session.commit() p2 = city.Citizen(name="Georg") cw.add(p2, rel=city.hasInhabitant) cw.name = "Freiburg" session.commit() check_state(self, c, p1, p2, db=DB)
def test_delete(self): """Test to delete cuds_objects from the sqlite table.""" c = city.City(name="Freiburg") p1 = city.Citizen(name="Peter") p2 = city.Citizen(name="Georg") p3 = city.Citizen(name="Hans") c.add(p1, p2, p3, rel=city.hasInhabitant) with DataspaceSession(URI) as session: wrapper = city.CityWrapper(session=session) cw = wrapper.add(c) session.commit() cw.remove(p3.uid) session.prune() session.commit() check_state(self, c, p1, p2, db=DB)