On Mon, Dec 8, 2008 at 9:12 PM, Paul Hummer <[EMAIL PROTECTED]> wrote:
> I have a need to basically clear out all the records from a table. I could
> probably use store.execute, but the reason I'm using an ORM in the first place
> is to avoid writing SQL. So I have the following code:
>
> result = self._store.find(FooBarBaz)
> self._store.rollback()
>
> for foo in result:
> self._store.remove(foo)
> self._store.commit()
>
> This raises a 'OperationalError : database is locked' on a sqlite database.
> There are no other operations going on in this instance, so I'm not sure
> what's
> going on.
>
> This is using storm 0.12. Is there a way that I can debug this and see what's
> really going on?
You can delete all records from a table with the following:
store.find(FooBarBaz).remove()
This will work for simple find expressions: it won't work if you have
any joins (yet).
James.
--
storm mailing list
[email protected]
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/storm
