its looking for a Column object. menus_table.c.weight instead of 'weight'.
On Nov 15, 2010, at 10:03 AM, Enrico Morelli wrote:
> Dear all,
>
> I've a lot of applications using SA 0.5.6. Now I upgraded my personal
> computer and now I can use SA 0.6.5 but my applications stops to work.
>
> I receive the error:
> ArgumentError: Column-based expression object expected for argument
> 'order_by'; got: 'weight', type <type 'str'>
>
> I try to search in google but I don't understand why I receive this
> error. Someone can explain to me?
>
> Thanks in advance
>
> This is the table declaration:
>
> menus_table = Table('menus', metadata,
> Column('id', types.Integer, primary_key=True),
> Column('parent_id', types.Integer, ForeignKey('menus.id')),
> Column('name', types.Unicode(80), nullable=False),
> Column('title', types.Unicode(80)),
> Column('url', types.Unicode(80)),
> Column('weight', types.Integer, index=True),
> Column('lang', types.Unicode(2))
> )
>
> This is the mapper declaration:
> mapper(Menu, menus_table,
> properties={
> 'children': relation(Menu, order_by='weight'),
> 'permissions': relation(Permissions, backref='menus',
> secondary=menus_permissions_table)
> })
>
> At the end the query:
> main_menu = Session.query(Menu).filter(and_(Menu.parent_id==None,
> Menu.lang==session['lang'])).order_by(Menu.weight.asc()).all()
>
> --
> -------------------------------------------------------------------
> (o_
> (o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
> (/)_ V_/_
> +------------------------------------------------------------------+
> | ENRICO MORELLI | email: [email protected] |
> | * * * * | phone: +39 055 4574269 |
> | University of Florence | fax : +39 055 4574253 |
> | CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
> +------------------------------------------------------------------+
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
