>>2) you can now do: >>row = db(db.mytable.id>0).select().first() >>row = db(db.mytable.id>0).select().last() >>and row is None if no records are selected.
Here is a list of other functions that may be of interest (I borrowed these from .net extension methods). Some of these won't make sense for web2py but others may be handy if implemented. Some may already be implemented: all - returns True if all elements in a sequence match a condition any - return True if the sequence contains any elements average - returns the average of a sequence of elements contains - returns True is the sequence contains a given element distinct - returns unique elements for a sequence intersect - produces the set of common elements between two sequences min - returns the lowest element in a sequence max - returns the highest element in a sequence single - returns the only element of a sequence and throws an error if there is not exactly one element. skip - bypass a specified contiguous number of elements in a sequence skip_while - bypass elements of a sequence that match a condition and return the remaining elements take - returns a contiguous number of elements in a sequence take_while - returns a contiguous number of elements that match a sequence where - returns elements in a sequence that match a condition except - produces the difference between two sequences union - produces the union of two sequences reverse - reverses the order of elements in a sequence On Sep 11, 12:12 am, mdipierro <[email protected]> wrote: > I have made some changes to the code in trunk: > > 1) Since tonight I attended a presentation about how SQLAlchemy can do > on delete cascade in SQLite even if SQLite does not support it, I > implemented this feature in web2py too. There is nothing you have to > do it now there by default. For example: > > db=DAL('sqlite://test.db') > db.define_table('a',Field('name')) > db.define_table('b',Field('a',db.a,ondelete='CASCADE'),Field('name')) > db.a.insert(name='xxx1') > db.a.insert(name='xxx2') > db.a.insert(name='xxx3') > db.a.insert(name='xxx4') > db.b.insert(a=2,name='yyy1') #(1) > db.b.insert(a=2,name='yyy2') #(1) > db.b.insert(a=3,name='yyy3') > db(db.a.id==2).delete() > for row in db(db.b.a==2).select(): print row # prints nothing as it > should > > Notice ondelete='CASCADE' is default. > > 2) you can now do: > > row = db(db.mytable.id>0).select().first() > row = db(db.mytable.id>0).select().last() > > and row is None if no records are selected. > > 3) I fixed the problem with the memory leak reported by zahariash > > 4) I refactored some code in main.py, compileapp.py and globals.py. > This should make the code cleaner. Hopefully I did not break it. > Please give it a try. > > Massimo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
