Re: [sqlalchemy] dialect issue with pyodbc.Row type

2018-01-09 Thread Mike Bayer
On Tue, Jan 9, 2018 at 8:45 PM, Russ Wilson wrote: > So i loaded and tested the mmsql dialect and it gave the same results. It > returns a list of pyodbc.Row > > from sqlalchemy import Column, Integer, String > from sqlalchemy.ext.declarative import declarative_base > from

Re: [sqlalchemy] dialect issue with pyodbc.Row type

2018-01-09 Thread Russ Wilson
So i loaded and tested the mmsql dialect and it gave the same results. It returns a list of pyodbc.Row from sqlalchemy import Column, Integer, String from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import create_engine from sqlalchemy import Table, Column, Integer,

Re: [sqlalchemy] dialect issue with pyodbc.Row type

2018-01-09 Thread Mike Bayer
There's the README at https://github.com/zzzeek/sqlalchemy/blob/master/README.dialects.rst which also includes some links to an example dialect. On Jan 9, 2018 12:35 PM, "Russ Wilson" wrote: Is there a good doc that covered at at min needs to be extended to create a dialect?

Re: [sqlalchemy] dialect issue with pyodbc.Row type

2018-01-09 Thread Russ Wilson
Is there a good doc that covered at at min needs to be extended to create a dialect? On Mon, Jan 8, 2018 at 3:15 PM Mike Bayer wrote: > On Sun, Jan 7, 2018 at 9:07 PM, Russ Wilson wrote: > > I noticed if you use the cursor.fetchmany it returns the

Re: [sqlalchemy] check enums?

2018-01-09 Thread Mike Bayer
On Tue, Jan 9, 2018 at 3:15 AM, Tolstov Sergey wrote: > I create enums with this code > > MonthDay = > sqlalchemy.types.Enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31', >

[sqlalchemy] check enums?

2018-01-09 Thread Tolstov Sergey
I create enums with this code *MonthDay = sqlalchemy.types.Enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31', name= 'monthday',metadata=Base.metadata)* But i can set it to season.startDate =