Just Launched: You can now import projects and releases from Google Code onto SourceForge
We are excited to release new functionality to enable a 1-click import from Google Code onto the Allura platform on SourceForge. You can import tickets, wikis, source, releases, and more with a few simple steps. Read More
From: gary ng <garyng2000@ya...> - 2005-09-25 04:28:19
I frequently need to do SQL statement with "col IS NOT
NULL" or "col IS NULL". 0.7 now support IS NULL by
"col=None" in selectBy, is it possible to add also
something like col="NOT NULL" ?
Yahoo! Mail - PC Magazine Editors' Choice 2005
From: Ian Bicking <ianb@co...> - 2005-09-25 06:11:35
gary ng wrote:
> I frequently need to do SQL statement with "col IS NOT
> NULL" or "col IS NULL". 0.7 now support IS NULL by
> "col=None" in selectBy, is it possible to add also
> something like col="NOT NULL" ?
Well, I dunno... col="NOT NULL" specifically would not be supported, as
that means col = 'NOT NULL', and I don't want to put a special case in
for that string, that smells bad to me. Maybe a not_col=None would be
possible, or a col=sqlobject.NOT_NULL. Of course,
cls.select(cls.q.col!=None) works right now.