def limit_test(self):
one = gateModel.create(**baseData)
two = gateModel.create(**newData)
three = gateModel.create(**newData2)
limitValue = 2
collection = RethinkCollection(gateModel)
collection.limit(limitValue)
results = collection.fetch()
assert len(results) <= limitValue
if limitValue > 1:
collection = RethinkCollection(gateModel)
collection.orderBy('episodes', 'asc').limit(limitValue)
results = collection.fetch()
assert results[0].episodes < results[1].episodes
collection = RethinkCollection(gateModel)
collection.orderBy('episodes', 'asc').offset(1).limit(limitValue)
results = collection.fetch()
assert results[0].episodes < results[1].episodes
one.delete()
two.delete()
three.delete()
def offset_test(self):
one = gateModel.create(**baseData)
two = gateModel.create(**newData)
three = gateModel.create(**newData2)
offsetValue = 1
collection = RethinkCollection(gateModel)
results = collection.fetch()
totalRows = len(results)
collection.offset(offsetValue)
results = collection.fetch()
offsetRows = len(results)
assert offsetRows == (totalRows - offsetValue)
collection = RethinkCollection(gateModel)
collection.orderBy('episodes').offset(offsetValue)
results = collection.fetch()
if len(results) > 1:
assert results[0].episodes > results[1].episodes
one.delete()
two.delete()
three.delete()
def orderBy_test(self):
one = gateModel.create(**baseData)
two = gateModel.create(**newData)
three = episodeModel.create(**classmethodData)
four = episodeModel.create(**secondJoinData)
collection = RethinkCollection(gateModel)
collection.orderBy('episodes', 'asc')
results = collection.fetch()
assert results[0].episodes < results[1].episodes
collection = RethinkCollection(gateModel)
collection.orderBy('episodes')
results = collection.fetch()
assert results[0].episodes > results[1].episodes
one.delete()
two.delete()
three.delete()
four.delete()
def orderBy_test(self):
one = gateModel.create(**baseData)
two = gateModel.create(**newData)
three = episodeModel.create(**classmethodData)
four = episodeModel.create(**secondJoinData)
collection = RethinkCollection(gateModel)
collection.orderBy('episodes', 'asc')
results = collection.fetch()
assert results[0].episodes < results[1].episodes
collection = RethinkCollection(gateModel)
collection.orderBy('episodes')
results = collection.fetch()
assert results[0].episodes > results[1].episodes
one.delete()
two.delete()
three.delete()
four.delete()
