Ticket #349 (closed defect: worksforme)

Opened 5 years ago

Last modified 4 years ago

SQLite structure population should be more tolerant

Reported by: SmileyChris Owned by: andrew
Priority: major Milestone: 0.7
Component: commands Version: 0.6.2
Keywords: Cc:

Description

In the sqlite backend, _populate_current_structure has some regex which assumes field names are quoted with double quotes.

I've been working with a sqlite db exported from an mdb, and it uses single quotes instead.

Running a delete_column migration destroyed all fields in the table (due to the _rebuild_table method not containing the original fields).

Change History

comment:1 Changed 5 years ago by andrew

  • Status changed from new to assigned
  • Milestone set to 0.7

0.7 has a completely rewritten SQLite module that uses Python's built-in introspection rather than regexes; could you try that, please?

comment:2 Changed 4 years ago by andrew

  • Status changed from assigned to infoneeded

comment:3 Changed 4 years ago by andrew

  • Status changed from infoneeded to closed
  • Resolution set to worksforme
Note: See TracTickets for help on using tickets.