I managed to create one using these steps.
- Grab or create a container (I used ipython and a ContainerBroker). - Open the db in sqlite:
sqlite3 my_malfored_schema.db
- Turn on editable schemas:
PRAGMA writable_schema=ON
- Update (put a syntax error in the existing schema)
update sqlite_master set sql = 'CRREAT TABLE object (ROWID INTEGER name TEXT)' where type='table' and name='object';
- for safe measure I turned off the updateable schemas:
PRAGMA writable_schema=OFF
And there you have it.
sqlite> select * from object; Error: malformed database schema (object_delete_policy_stat) - no such table: main.object
Attached you'll find the one I currupted.
I managed to create one using these steps.
- Grab or create a container (I used ipython and a ContainerBroker).
- Open the db in sqlite:
sqlite3 my_malfored_ schema. db
- Turn on editable schemas:
PRAGMA writable_schema=ON
- Update (put a syntax error in the existing schema)
update sqlite_master set sql = 'CRREAT TABLE object (ROWID INTEGER name TEXT)' where type='table' and name='object';
- for safe measure I turned off the updateable schemas:
PRAGMA writable_schema=OFF
And there you have it.
sqlite> select * from object; delete_ policy_ stat) - no such table: main.object
Error: malformed database schema (object_
Attached you'll find the one I currupted.