def test_all_reversed_bad_paging(self, sqlalchemy):
service = SensorReadingPersistenceService()
older = AnalogSensorReading()
older.timestamp = datetime.now()
newer = DigitalSensorReading()
newer.timestamp = datetime.now()
service.create(older)
service.create(newer)
paged = service.all_reversed(1000, 1)
assert paged.elements == []
paged = service.all_reversed(-1, 1)
assert paged.elements == []
def test_all_reversed_bad_paging(self, sqlalchemy):
service = SensorReadingPersistenceService()
older = AnalogSensorReading()
older.timestamp = datetime.now()
newer = DigitalSensorReading()
newer.timestamp = datetime.now()
service.create(older)
service.create(newer)
paged = service.all_reversed(1000, 1)
assert paged.elements == []
paged = service.all_reversed(-1, 1)
assert paged.elements == []
def test_all_reversed(self, sqlalchemy):
service = SensorReadingPersistenceService()
older = AnalogSensorReading()
older.timestamp = datetime.now()
newer = DigitalSensorReading()
newer.timestamp = datetime.now()
service.create(older)
service.create(newer)
paged = service.all_reversed(0, 100)
assert paged.page_number == 0
assert paged.page_size == 100
assert paged.total_pages == 1
readings = paged.elements
assert readings[0].timestamp == newer.timestamp
assert readings[1].timestamp == older.timestamp
assert len(readings) == 2
def test_all_reversed(self, sqlalchemy):
service = SensorReadingPersistenceService()
older = AnalogSensorReading()
older.timestamp = datetime.now()
newer = DigitalSensorReading()
newer.timestamp = datetime.now()
service.create(older)
service.create(newer)
paged = service.all_reversed(0, 100)
assert paged.page_number == 0
assert paged.page_size == 100
assert paged.total_pages == 1
readings = paged.elements
assert readings[0].timestamp == newer.timestamp
assert readings[1].timestamp == older.timestamp
assert len(readings) == 2
