yeah like this:
kwargs = {}
kwargs['osplatform'] = 'win32'
kwargs['osnameversid'] = 8
query.select_by(**kwargs)
On Oct 16, 2006, at 2:00 PM, Rick S. wrote:
>
> I want to be able to dynamically generate selection contraints.
> However, at the final step where I pass a generated parameter list to
> the select-by() statement, I am getting errors. Any suggestions would
> be appreciated.
>
> This works fine:
> ormHostList = query.select_by(osplatform = 'win32', osnameversid =
> 8)
>
> 1) I tried passing in the parameters as a list.
> fooList = ["osplatform = 'win32'", "osnameversid = 8"]
> ormHostList = query.select_by(fooList)
>
> That resulted in:
> "T:\win32\python-2.4.3\lib\site-packages\sqlalchemy-0.2.8-py2.4.egg
> \sqlalchemy\sql.py",
> line 1508, in _append_condition
> AttributeError: 'list' object has no attribute 'accept_visitor'
>
> 2) So, how about a string?
> fooStr= "osplatform = 'win32', osnameversid = 8"
> ormHostList = query.select_by(fooStr)
>
> SQLError: (ProgrammingError) syntax error at or near "," at character
> 346
>
> 3) I have tried query objects based on objects and on mappers. While
> the underlying SQL statements differ quite a bit, the SQLError is the
> same.
>
> query = session.query(BuildHostORM)
> --same result--
> query = session.query(BuildHostORM_Mapper)
>
>
> Am I missing something really basic here?
>
> Thanks,
> Rick
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
