Skip to content

Schema: delete rows and sequences in the SQLite file strategy #145

Open

Description

@temp

Split from #124, part of #102. Moved to 8.0 because it changes what the following tests see.

  • SqliteFileBasedSchemaStrategy::deleteData() and resetSequences() are no-ops. With USE_PRE_INITIALIZED_SCHEMA the rows of the previous test stay in the database.

Review note on the first implementation (branch feat/8.0): deleting in sqlite_master order fails with "FOREIGN KEY constraint failed" when PRAGMA foreign_keys=ON and child rows exist. Disable or defer the foreign key checks while deleting, like the MySQL strategy does.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions