[Sqlalchemy-tickets] [sqlalchemy] #2758: Time field types

[sqlalchemy <mi...@zz...>]

#2758: Time field types
--------------------+-----------------------------------------
 Reporter:  iurie   |           Owner:
     Type:  defect  |          Status:  new
 Priority:  medium  |       Milestone:
Component:  mysql   |        Severity:  no triage selected yet
 Keywords:          |  Progress State:  awaiting triage
--------------------+-----------------------------------------
 Running SQLAlchemy 0.7.10 + MySqlConnector 1.0.10

   File "C:\Python33\lib\site-packages\sqlalchemy\orm\query.py", line 2349,
 in instances
     rows = [process[0](row, None) for row in fetch]
   File "C:\Python33\lib\site-packages\sqlalchemy\orm\query.py", line 2349,
 in <listcomp>
     rows = [process[0](row, None) for row in fetch]
   File "C:\Python33\lib\site-packages\sqlalchemy\orm\mapper.py", line
 2120, in _instance
     populate_state(state, dict_, row, isnew, only_load_props)
   File "C:\Python33\lib\site-packages\sqlalchemy\orm\mapper.py", line
 1974, in populate_state
     populator(state, dict_, row)
   File "C:\Python33\lib\site-packages\sqlalchemy\orm\strategies.py", line
 150, in fetch_col
     dict_[key] = row[col]
   File "C:\Python33\lib\site-packages\sqlalchemy\engine\base.py", line
 2635, in __getitem__
     return processor(self._row[index])
   File "C:\Python33\lib\site-packages\sqlalchemy\dialects\mysql\base.py",
 line 676, in process
     return time(minutes / 60, minutes % 60, seconds - minutes * 60)
 TypeError: integer argument expected, got float

 As can be seen from trace datetime.time waits for an integer value not
 float so args need to be cast.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2758>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python