csvsql with timestamps doesn't work for sqlite

[haridsv]

If you have a file named t.csv with timestamps, like this:

time
2011-12-13 23:43:52.684
2011-12-13 23:43:52.563

and run csvsql like this:

$ csvsql --db sqlite:///test.db --table t --insert t.csv

You get the below error:

SQLite DateTime type only accepts Python datetime and date objects as input.

It is also strange that it takes more than 5 minutes to give this error, on a file containing 4500 lines with 35 or so columns (one which is the time). The process consumes 100% cpu during this time.

[onyxfish]

Thanks for the bug report. It sounds like python-dateutil may be getting flummoxed by that particular format. I'll take a closer look at it when I have a chance.

[haridsv]

Thank you, I can verify that the original problem is fixed.