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)