- 论坛徽章:
- 33
|
- Traceback (most recent call last):
- File "/root/bin/traffic.py", line 176, in <module>
- traffic_week(timestamp)
- File "/root/bin/traffic.py", line 156, in traffic_week
- cur.executemany(sql, params)
- File "/usr/lib64/python2.6/site-packages/MySQL_python-1.2.4-py2.6-linux-x86_64.egg/MySQLdb/cursors.py", line 245, in executemany
- self.errorhandler(self, TypeError, msg)
- File "/usr/lib64/python2.6/site-packages/MySQL_python-1.2.4-py2.6-linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
- raise errorclass, errorvalue
- TypeError: not all arguments converted during string formatting
复制代码- ## ----------------------------------------------------------------
- sql = """INSERT INTO traffic_hz_week(tr_time, tr_week, tr_hour,
- tr_min, tr_road, tr_road_level,
- tr_speed_total, tr_speed_count)
- VALUES(%s, %s, %s, %s, %s, %s, %s, %s)
- ON DUPLICATE KEY UPDATE
- tr_speed_total = tr_speed_total + %s,
- tr_speed_count = tr_speed_count + 1
- """
- params = ()
- for d1 in data:
- param = d1 + (d1[6],)
- params = params + ((param),)
- for pa in params:
- print pa
- cur.executemany(sql, params)
复制代码 上面这段代码有问题么? 为啥会报错呢 ... |
|