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()