[sqlalchemy] What should be the preferred data type for primary key colum if in database(MSSQL) it is defined as Numeric(18,0)

2015-02-03 Thread Anurag Vaishwade
Hello Everyone, I am facing issues with defining table's primary key column as Numeric(18,0).I am connecting to a MSSQL and in database all tables are defined as Numeric(18,0) for primary key. So to match with the database table schema I updated Sqlalchemy tables as Numeric(18,0)

Re: [sqlalchemy] column_property order_by error

2015-02-03 Thread Kevin S
Both actually. I like the simplicity of just using the column_property as is, but until the next release I will just use an explicit label and order by that. In case anyone else has this problem, my workaround was to add to the column_property definition like so: markerstatus = db.column_