Find a way to provide and update migrations

[tpendragon]

No description provided.

[no-reply]

what are the requirements for this?

is this just a generator for https://github.com/samvera-labs/valkyrie-sequel/blob/26fddaf50045cb6c83d43c8699b1f56f7aa72895/db/migrations/001_create_orm_resources.rb, or is something more needed?

[tpendragon]

The real issue is how to run those migrations against a given database configuration, I think.

For instance - right now our test setup does

valkyrie-sequel/spec/support/db_setup.rb

Line 6 in a7c9411

METADATA_ADAPTER.reset_database!

which then does

valkyrie-sequel/lib/valkyrie/sequel/metadata_adapter.rb

Lines 34 to 43 in a7c9411

	def perform_migrations!
	Sequel.extension :migration
	Sequel::Migrator.run(connection, "#{__dir__}/../../../db/migrations")
	end
	def reset_database!
	Sequel.extension :migration
	Sequel::Migrator.run(connection, "#{__dir__}/../../../db/migrations", target: 0)
	perform_migrations!
	end

but I sort of doubt that's actually the process we want? Like what if folks want to run their own migrations? Is it sufficient to add to the readme somewhere, "as part of deployment call #perform_migrations! on your metadata adapter"?

Normally I'd test this in Figgy, but we actually have quite a few custom indexes and such and we migrated from the AR adapter to Sequel, so it's just running off all the old AR migrations.

[no-reply]

isn't it sufficient to point to sequel -m?

EDIT: comet does https://gitlab.com/surfliner/surfliner/-/blob/trunk/comet/scripts/db-migrate-seed.sh#L7

[tpendragon]

I didn't know sequel -m existed! So maybe we just need a way to copy migrations locally?