unfortunately upgrading sqlite is not an option in my situation. And we are locked into sqlite at the moment.
So I'm going to need to solve this through the DAL. Is there a single query that could delete all my A's and B's? Or do I need to iterate through the A's and remove them all manually? Richard On Aug 13, 5:47 am, Yarko Tymciurak <[email protected]> wrote: > If you must use sqlite, then google for sqlite cascade - there are C program > files that will convert your SQL to sqlite triggers which will accomplish > this (according to all that I saw - I have no experience); there is even a > website where you can paste your table definition, and it will generate the > equivalent sql for sqlite for you. > > I think it would be just as easy / easier to install postgres (or something > of your choice) and use that. Of course, if you are writing something to > run on a mobile device, you may not have any choice; for pretty much > everything else, you have choices... > > On Wed, Aug 12, 2009 at 2:13 PM, Richard <[email protected]> wrote: > > > hmm, that's a pity. Thanks for the link. > > Is there a single query that could delete all my A's and B's? Or do I > > need to iterate through the A's and remove them all manually? > > > Richard > > > On Aug 12, 5:52 pm, Yarko Tymciurak <[email protected]> wrote: > > > It apprears that sqlite does not support this - seehttp:// > >www.sqlite.org/omitted.html > > > > On Wed, Aug 12, 2009 at 2:41 AM, Richard <[email protected]> wrote: > > > > > hello, > > > > > Does sqlite support cascade or am I doing something wrong? > > > > > I have these tables: > > > > db.define_table('A', > > > > db.Field('B', db.B, ondelete='CASCADE'), > > > > ) > > > > db.define_table('B', > > > > db.Field('name'), > > > > ) > > > > > And when I run db(db.A.id > 0).delete(), the B's are still there. > > > > > Richard --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
