示例#1
0
    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'))
示例#2
0
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'))
示例#3
0
 def test_rows(self):
     for i in range(5):
         db.insert('data', {'type': 'weight'})
     assert_equal(5, len(db.rows('select * from data')))
示例#4
0
 def test_create_all(self):
     db.create_all()
     assert_equal([], db.rows('select * from data'))
示例#5
0
 def test_drop_all(self):
     db.drop_all()
     db.rows('select * from data')