H8NjKjua

1    
2        table_creation_string = '''CREATE TABLE IF NOT EXISTS `filter` (
3        `id` int(11) NOT NULL AUTO_INCREMENT,
4        `key_id` varchar(100),
5        `model` varchar(20),
6        `type` varchar(15),
7        `parameter` varchar(50),
8        `range` varchar(30),
9        `excluded` varchar(30),
10        `constant` varchar(5) NOT NULL,
11        `deleted` varchar(5),
12        PRIMARY KEY (`id`)
13        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
14        AUTO_INCREMENT=1 ;'''
15       
16
17 """INSERT INTO 
18        filter (key_id, model, type, parameter, range, excluded, constant, deleted) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"""
19
20('bike-model_gps_speed', 'bike-model', 'gps', 'speed', '0,180', '0, 70', '0', '0')