Re: [sqlalchemy] Change the logical column order

2016-10-11 Thread Charles Heizer
Thanks, I could modify the model. But I did find a solution. Solution: I modified the model a little and added the "doc" attribute to the column and set a numerical number, by default "50" and then set date to be "80". cols = Client.__table__.columns sortedCols = sorted(cols, key=getDoc) def

Re: [sqlalchemy] Change the logical column order

2016-10-10 Thread Mike Bayer
On 10/10/2016 01:44 PM, Charles Heizer wrote: Hello, I'm not sure if I'm asking this correctly. I'm fairly new to using SQLAlchemy so I'm sorry if I'm not using the correct terminology. How do I change the returning column order on a query? Is there an easy way? I would like to make 'mdate' be

[sqlalchemy] Change the logical column order

2016-10-10 Thread Charles Heizer
Hello, I'm not sure if I'm asking this correctly. I'm fairly new to using SQLAlchemy so I'm sorry if I'm not using the correct terminology. How do I change the returning column order on a query? Is there an easy way? I would like to make 'mdate' be the last column. Thanks! Example: *Model* c