def test_update():
Car.delete_all()
c = Car.update(make=u'ford', year=2010, model=u'test')
assert Car.count() == 1
Car.update(c.id, year=2011)
assert Car.count() == 1
assert c.year == 2011
def test_count_and_delete_all():
Car.delete_all()
Car.add(**{'make': u'test', 'model': u'count', 'year': 2010})
Car.add(**{'make': u'test', 'model': u'count', 'year': 2009})
Car.add(**{'make': u'test', 'model': u'count2', 'year': 2010})
assert Car.count() == 3
assert Car.count_by(model=u'count') == 2
assert Car.count_where(Car.model == u'count') == 2
eq_(Car.delete_all(), 3)
def test_delete_where():
Car.delete_all()
Car.add(**{'make': u'test', 'model': u'count', 'year': 2010})
Car.add(**{'make': u'test', 'model': u'count', 'year': 2009})
Car.add(**{'make': u'test', 'model': u'count2', 'year': 2010})
# two clauses
assert Car.delete_where(Car.model == u'count', Car.year == 2009) == 1
assert Car.count() == 2
# one clause
assert Car.delete_where(Car.model == u'count2') == 1