Fails with wagtail and sqlite3 #38

Activity

1. iurisilvio commented on Jun 1, 2023

   

   iurisilvio

   on Jun 1, 2023

   CollaboratorAuthor

   More actions

   I tried to fix the iterdump output.

   1. It must have a first PRAGMA foreign_keys=OFF; statement before start transaction.
   2. Instead of a CREATE VIRTUAL TABLE, it must enable writable schema and write direct to sqlite_schema table. It must be changed in Python implementation.

   PRAGMA writable_schema=ON;
   INSERT INTO sqlite_schema(type,name,tbl_name,rootpage,sql)VALUES('table','wagtailsearch_indexentry_fts','wagtailsearch_indexentry_fts',0,'CREATE VIRTUAL TABLE wagtailsearch_indexentry_fts USING fts5(autocomplete, body, title)');
   
2. iurisilvio commented on Jun 1, 2023

   

   iurisilvio

   on Jun 1, 2023

   CollaboratorAuthor

   More actions

   For now, I'll just change implementation to use sqlite3 binary .dump command.

   👍React with 👍1Reacted by Erlend E. Aasland
3. iurisilvio commented on Jun 1, 2023

   

   iurisilvio

   on Jun 1, 2023

   CollaboratorAuthor

   More actions

   It is a known issue. python/cpython#64662

   👍React with 👍1Reacted by Erlend E. Aasland
4. iurisilvio

   closed this as completedon Jun 1, 2023