Skip to content

Create a drop.sql to support version rollbacks #11483

@steven-sheehy

Description

@steven-sheehy

Problem

As part of CITR, ops needs the capability to reset an environment and rollback its version. The current cleanup.sql only truncates and can't handle scenarios where the schema changes.

Solution

  • Add a drop.sql next to cleanup.sql
  • Implement drop.sql like the previous deleted script or by looping through PostgreSQL tables/types/etc and dropping them.
  • Test thoroughly that an existing database can be dropped and restarted with an older version of the importer with schema changes.

Alternatives

No response

Metadata

Metadata

Assignees

Labels

Projects

Status

👀 In review

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions