[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2018-09-23 Thread Karthikeyan Singaravelan
Change by Karthikeyan Singaravelan : -- nosy: +xtreak ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2016-10-10 Thread Aviv Palivoda
Aviv Palivoda added the comment: Attached is patch with a fix for this issue. This is not as comprehensive as the solution in apsw but I think this should cover most of the cases. The result for Ronny dump after this fix is: BEGIN TRANSACTION; PRAGMA writable_schema=ON; INSERT INTO

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2015-08-19 Thread Gerhard Häring
Gerhard Häring added the comment: apsw contains code that handles the issues with dumping SQLite databases very well. I plan to integrate this code into pysqlite. We can then later port the fix to the sqlite3 module. See https://github.com/ghaering/pysqlite/issues/10 for the tasks and

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2015-01-10 Thread Gerhard Häring
Changes by Gerhard Häring g...@ghaering.de: -- assignee: - ghaering ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue20463 ___ ___ Python-bugs-list

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2014-01-31 Thread Ronny Pfannschmidt
New submission from Ronny Pfannschmidt: when using virtual tables, dumpiter generates a broken db script virtual table entries must be created as master table entries the sqlite tools dump does that correctly however pythons iterdump seems to do that rather different and wrong sqlite3 test.db

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2014-01-31 Thread Ronny Pfannschmidt
Changes by Ronny Pfannschmidt ronny.pfannschm...@gmail.com: -- components: +Extension Modules type: - behavior ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue20463 ___

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2014-01-31 Thread Yury Selivanov
Changes by Yury Selivanov yselivanov...@gmail.com: -- nosy: +ghaering ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue20463 ___ ___ Python-bugs-list

[issue20463] sqlite dumpiter dumps invalid script when virtual tables are used

2014-01-31 Thread R. David Murray
Changes by R. David Murray rdmur...@bitdance.com: -- nosy: +r.david.murray ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue20463 ___ ___