search

scraperwiki / dumptruck

Painlessly move data in and out of a SQLite database.
http://sensiblecode.io
BSD 2-Clause "Simplified" License
43 stars 11 forks source link

Doesn't work with timezones in datetimes #8

Closed frabcus closed 10 years ago

frabcus commented 12 years ago

print dt.execute('select * from twitter limit 1') Traceback (most recent call last): File "", line 1, in File "/usr/local/lib/python2.7/dist-packages/dumptruck/dumptruck.py", line 112, in execute self.cursor.execute(sql, *args) File "/usr/local/lib/python2.7/dist-packages/dumptruck/adapters_and_converters.py", line 93, in convert_datetime hours, minutes, seconds = map(int, timepart_full[0].split(':')) ValueError: invalid literal for int() with base 10: '42+00'

This is a column with a value like '2012-09-22 07:49:42+00:00'

pwaller commented 10 years ago

I'm closing old issues so that we can pluck signal from the noise. Please reopen if you encounter this or believe it is important.