On Thu, 2006-05-18 at 23:26 +0400, Oleg Broytmann wrote:
> On Thu, May 18, 2006 at 05:51:47PM +0100, Christopher Arndt wrote:
> > class MySelectResult:
> > def __nonzero__(self):
> > return self.count() > 0
> >
> > SQLObject.SelectResultsClass.__bases__ += (MySelectResult,)
> >
> > class Person(SQLObject):
> > name = StringCol(alternateID=True, length=20)
> > org = StringCol(length=100)
> >
> > if __name__ == '__main__':
> > Person.createTable()
> > u1 = Person(name="joe", org="doe.com")
> > u2 = Person(name="alice", org="foo.com")
> > u3 = Person(name="bob", org="foo.com")
> >
> > pl = Person.select(Person.q.org == 'foo.com')
> > if pl:
> > for p in pl:
> > print p.name
> > else:
> > print "No records found."
>
> You ran two query. Is it really neccessary? Why not just
>
> pl = list(Person.select(Person.q.org == 'foo.com'))
> if pl:
> for p in pl:
>
> without __nonzero__() i.e. without SELECT COUNT()?
This seems like a good place for a for/else:
for p in Person.select(Person.q.org == 'foo.com'):
print p.name
else:
print "No records found."
--
Matt Good <[EMAIL PROTECTED]>
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
