But I don't know why make this decision. Because "where NULL" will get nothing. And in 0.8.X version, I need to combine multiple condition according user input to one condition, so my code just like:
cond = None for c in conditions: cond = c & cond So in 0.9.X, the result will be something like: WHERE todo.id = 1 AND NULL, so I got nothing. Above code is totally wrong in 0.9.X. And I think maybe the old way makes sence. On Tue, Jan 7, 2014 at 10:42 PM, Michael Bayer <mike...@zzzcomputing.com>wrote: > that’s this: > http://docs.sqlalchemy.org/en/rel_0_9/changelog/migration_09.html#improved-rendering-of-boolean-constants-null-constants-conjunctions > > > On Jan 7, 2014, at 4:13 AM, limodou <limo...@gmail.com> wrote: > > I found a problem in 0.9.1 version: > > in 0.8.x : > >>> print (Blog.c.id <http://blog.c.id/>==5) & None > blog.id = :id_1 > > But in 0.9.1: > >>> print (Blog.c.id <http://blog.c.id/>==5) & None > blog.id = :id_1 AND NULL > > So I don't know if it's a bug? > > > On Tue, Jan 7, 2014 at 2:25 AM, Jonathan Vanasco <jonat...@findmeon.com>wrote: > >> automap sounds neat! thanks! >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > I like python! > UliPad <<The Python Editor>>: http://code.google.com/p/ulipad/ > UliWeb <<simple web framework>>: https://github.com/limodou/uliweb > My Blog: http://my.oschina.net/limodou > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- I like python! UliPad <<The Python Editor>>: http://code.google.com/p/ulipad/ UliWeb <<simple web framework>>: https://github.com/limodou/uliweb My Blog: http://my.oschina.net/limodou -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.