def test_count_all(self):
ids = [self.user.id]
for _ in range(3):
user = yield User(first_name="blah").save()
ids.append(user.id)
results = yield User.count()
self.assertEqual(4, results)
def test_count(self):
ids = []
for _ in range(3):
user = yield User(first_name="blah").save()
ids.append(user.id)
yield User(first_name="not blah").save()
results = yield User.count(where=["first_name = ?", "blah"])
self.assertEqual(3, results)
def test_joinMultipleWheres(self):
yield User(first_name="First", last_name="Last", age=20).save()
first = ['first_name = ?', "First"]
last = ['last_name = ?', "Last"]
age = ['age <> ?', 20]
where = utils.joinMultipleWheres([first, last, age], joiner='AND')
results = yield User.count(where=where)
self.assertEqual(1, results)
def test_joinMultipleWheres(self):
yield User(first_name="First", last_name="Last", age=20).save()
first = ['first_name = ?', "First"]
last = ['last_name = ?', "Last"]
age = ['age <> ?', 20]
where = utils.joinMultipleWheres([first, last, age], joiner='AND')
results = yield User.count(where=where)
self.assertEqual(1, results)
def test_joinWheres_precedence(self):
yield User(first_name="Second").save()
first = ['first_name = ?', "First"]
last = ['last_name = ?', "Last"]
second = ['first_name = ?', "Second"]
last_or_second = utils.joinWheres(last, second, joiner='OR')
where = utils.joinWheres(first, last_or_second, joiner='AND')
results = yield User.count(where=where)
self.assertEqual(1, results)
def test_joinWheres_precedence(self):
yield User(first_name="Second").save()
first = ['first_name = ?', "First"]
last = ['last_name = ?', "Last"]
second = ['first_name = ?', "Second"]
last_or_second = utils.joinWheres(last, second, joiner='OR')
where = utils.joinWheres(first, last_or_second, joiner='AND')
results = yield User.count(where=where)
self.assertEqual(1, results)
