Hi everyone, I'm trying to use oursql module with sqlalchemy (0.9.10) for managing a table with TIME columns, but I'm encountering an error, here a code snippet showing the problem:
import sqlalchemy from sqlalchemy import select, create_engine, MetaData, Table, Column import datetime engine = create_engine('mysql+oursql://root:password@localhost/test') metadata = MetaData(engine) t = Table('mysql_time', metadata, Column('t1', sqlalchemy.dialects.mysql.TIME()) ) t.create() t.insert().values(t1=datetime.time(8, 37, 35)).execute() res = select([t.c.t1]).execute().fetchall() for i, row in enumerate(res): res[i] = list(row) If you run the code, you will get the following error: Traceback (most recent call last): File "C:\Users\Impara 01\Desktop\t.py", line 15, in <module> res[i] = list(row) File "C:\Python27\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 1003, in process microseconds = value.microseconds AttributeError: 'datetime.time' object has no attribute 'microseconds' Process terminated with an exit code of 1 If you run the code changing the engine creation to: engine = create_engine('mysql://root:password@localhost/test') everything's ok. Of course I NEED to use oursql. Is it a bug? or am i missing something? Thanks in advance! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.