Well, MIchael, in my case a notnull() function could be very interesting because
I'm using it in a function, and would like pass values as parameters in such
way:
def search( self, **kw ):
by_where_clause = []
for k,v in kw.items():
if k == 'myfield1':
if v == 'nn': # I use 'nn' to generate a NOT NULL
because we don't have a notnull() function
by_where_clause.append( self.c.field1 <> None)
else:
by_where_clause.append( self.c.field1 == v)
elif k == 'myfield2':
if v == 'nn': # I use 'nn' to generate a NOT NULL
because we don't have a notnull() function
by_where_clause.append( self.c.field2 <> None)
else:
by_where_clause.append( self.c.field2 == v)
elif k == 'myfield3':
if v == 'nn': # I use 'nn' to generate a NOT NULL
because we don't have a notnull() function
by_where_clause.append( self.c.field3 <> None)
else:
by_where_clause.append( self.c.field3 == v)
...
Mytb.search(myfield=None) -- generates WHERE myfield IS NULL
Mytb.search(myfield=null()) -- generates WHERE myfield IS NULL
Mytb.search(myfield='nn') -- generates WHERE myfield IS NOT NULL
if we have a notnull() function these thing could be easier:
def search( self, **kw ):
by_where_clause = {}
for k,v in kw.items():
by_where_clause[ k ] = v
Mytb.search(myfield=None) -- generates WHERE myfield IS NULL
Mytb.search(myfield=null()) -- generates WHERE myfield IS NULL
Mytb.search(myfield=notnull()) -- generates WHERE myfield IS NOT NULL
Michael Bayer wrote:
> well usually null() and not_(null()) aren't needed as explicit
> constructs. comparisons like somecol == None and somecol != None
> will generate the appropriate NULL/NOT NULL expression.
>
>
> On Mar 19, 2009, at 4:48 AM, jo wrote:
>
>
>> Hi all,
>>
>> I would like to know if there's a notnull() function in sqlalchemy
>> similar to null()
>> to avoid things like not_(null()) ?
>>
>> thank you
>>
>> j
>>
>>
>>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
