[storm] Truncating a table

Paul Hummer paul.hummer at canonical.com
Tue Dec 9 05:12:41 GMT 2008


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?

Cheers,
Paul



More information about the storm mailing list