def test_delete(self): row_dict = {'type': 'weight'} row_dict = db.insert('data', row_dict) db.delete('data', row_dict) assert_equal(None, row_dict.get('id')) assert_equal([], db.rows('select * from data'))
def data(params): if params.get('post'): db.insert('data', { 'type': 'weight', 'value': params['post']['value'], 'user_id': 1, 'date': date.isoformat(date.today()) }) return elif len(params['path']) > 1: dt = params['path'][1] if dt == 'today': dt = date.isoformat(date.today()) return db.row('select type, date, value from data where user_id=%s and type=%s and date=%s', (1, 'weight', dt)) else: # The whole data set return db.rows('select type, date, value from data where user_id=%s and type=%s', (1, 'weight'))
def test_rows(self): for i in range(5): db.insert('data', {'type': 'weight'}) assert_equal(5, len(db.rows('select * from data')))
def test_create_all(self): db.create_all() assert_equal([], db.rows('select * from data'))
def test_drop_all(self): db.drop_all() db.rows('select * from data')