Bundle migrations

[GrandChaman]

Hello!

Is there a way to bundle the migrations file and to apply them when first connecting to the database ?

In the same fashion that sqlx does it.

[tyt2y3]

sea-orm/examples/rocket_example/src/main.rs

Lines 166 to 176 in 349108d

	async fn run_migrations(rocket: Rocket<Build>) -> fairing::Result {
	let conn = &Db::fetch(&rocket).unwrap().conn;
	let _ = setup::create_post_table(conn).await;
	Ok(rocket)
	}
	#[launch]
	fn rocket() -> _ {
	rocket::build()
	.attach(Db::init())
	.attach(AdHoc::try_on_ignite("Migrations", run_migrations))

I think the way integration should work will depend on the framework you use.
You can reference the Rocket example for now.
You can, actually, still use sqlx migration, if writing schema in SQL is your choice.

[GrandChaman]

I think the way integration should work will depend on the framework you use.

I think it makes sense!

However, it'd may be interesting to allow accessing the inner value of Sqlx<Something>PoolConnection so that one could run sqlx::migrate on start-up.

[tyt2y3]

I think currently you can do it the other way around. You setup a sqlx connection yourself, run the necessary migrations you want, and then convert it into a SeaORM connection using from_sqlx_*_pool