Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Make an easier way to create full schema SQL files #6476

Closed
anoadragon453 opened this issue Dec 5, 2019 · 1 comment
Closed

Make an easier way to create full schema SQL files #6476

anoadragon453 opened this issue Dec 5, 2019 · 1 comment
Assignees

Comments

@anoadragon453
Copy link
Member

anoadragon453 commented Dec 5, 2019

Currently full schema SQL files are made manually from creating Synapse SQLite and Postgres DBs from scratch, and then dumping them into SQL files. This is problematic as it only saves the final schema, but does not keep any of the data that is inserted into the DB.

Some of the delta files insert data in the DB which Synapse then assumes is there, causing bugs like #6311.

We should make sure that the schema and the data of a freshly migrated DB are saved in the delta file.

@anoadragon453
Copy link
Member Author

Fixed in #6394

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant