beam-automigrate
beam-automigrate copied to clipboard
obsidiansystems
Generated migrations for beam databases
The current API does not provide a way to annotate a table with a foreign key constraint when the column is nullable. This type of constraint is very common, as...
When annotating foreign key constraints using [`foreignKeyOnPk`](https://github.com/obsidiansystems/beam-automigrate/blob/6e1f316576d8ad0b9a91f691059d67952e51c648/src/Database/Beam/AutoMigrate/Annotated.hs#L520) or [`foreignKeyOn`](https://github.com/obsidiansystems/beam-automigrate/blob/6e1f316576d8ad0b9a91f691059d67952e51c648/src/Database/Beam/AutoMigrate/Annotated.hs#L560), constraint names are automatically created based on the table and columns of the *referenced* unique constraint. The name is not necessarily...
https://github.com/obsidiansystems/beam-automigrate/blob/93f86a29b81150ac356107b82225ac7f151d6e51/src/Database/Beam/AutoMigrate/Types.hs#L213 does not currently represent creating/dropping an index (though it does for constraints)
Needed this alongside https://github.com/haskell-beam/beam/pull/563
I find it pretty common to have a migration system managing some but not all of the tables in a DB. Currently beam-automigrate always complains and tries to drop any...
For tables without a primary key, beam-automigrate tries to run the following SQL: ``` ALTER TABLE my_table ADD CONSTRAINT my_table_pkey PRIMARY KEY (); ``` This is invalid SQL because there...
It looks like the workhorse is `runMigrationWithEditUpdate` (is it intended that `tryRunMigrationsWithEditUpdate` doesn't specify a hook?), but it can be tricky to figure out how to encode things so that...
It's not clear how to mix in migrations that aren't yet representable with the ones that are, e.g. #17 & #18 Is there any alternative for users to forking &...
https://github.com/obsidiansystems/beam-automigrate/blob/93f86a29b81150ac356107b82225ac7f151d6e51/src/Database/Beam/AutoMigrate/Types.hs#L213 does not currently represent column renames (though it does represent column type changes)
I tried to use the `beam-automigrate` with a separate PG SQL server, but it seems to require `pg_ctl` to restart Postgres. Is usage of `beam-automigrate` with non-local Postgres supported?
