Generate SQL migration from Entity defenitions.

[marknefedov]

Is there any plans to provide schema generation from entities like in Hibernate / GORM?

[billy1624]

Hi @markusgod, welcome! Yes, you can use Schema::create_table_from_entity.
https://www.sea-ql.org/SeaORM/docs/write-test/sqlite#setup-database-schema

[marknefedov]

Thanks! Will it create also referenced entities and foreign key constraints? I'm also can't find in the docs how to specify default value (I found in the TableCreateStatement example, but it is not clear how to specify all of this from enity).

Here example of what ideally would be nice to be able to generate.

CREATE TABLE "users" (
  "id" uuid PRIMARY KEY DEFAULT (gen_random_uuid()),
  "name" text NOT NULL,
  "password" text NOT NULL,
  "email" text NOT NULL
);

CREATE TABLE "projects" (
  "id" uuid PRIMARY KEY,
  "name" text NOT NULL,
  "description" text NOT NULL,
  "owner" uuid NOT NULL
);
ALTER TABLE "projects" ADD FOREIGN KEY ("owner") REFERENCES "users" ("id");

[billy1624]

Will it create also referenced entities and foreign key constraints?

It will create foreign key constraints if you have Relation defined in your Entity.

Referenced entities are just tables, you have do pass your Entity one by one to Schema::create_table_from_entity in order to create all the tables.

I'm also can't find in the docs how to specify default value.

Default value is currently not supported by Schema::create_table_from_entity.

[billy1624]

You can look at here as an example.

[billy1624]

If you do need the DEFAULT value, I suggest you to build the SQL statement manually with sea_query::table::TableCreateStatement like below.

sea-orm/tests/common/bakery_chain/schema.rs

Lines 185 to 219 in b2985a9

	let stmt = Table::create()
	.table(cakes_bakers::Entity)
	.col(
	ColumnDef::new(cakes_bakers::Column::CakeId)
	.integer()
	.not_null(),
	)
	.col(
	ColumnDef::new(cakes_bakers::Column::BakerId)
	.integer()
	.not_null(),
	)
	.primary_key(
	Index::create()
	.name("pk-cakes_bakers")
	.col(cakes_bakers::Column::CakeId)
	.col(cakes_bakers::Column::BakerId),
	)
	.foreign_key(
	ForeignKey::create()
	.name("fk-cakes_bakers-cake")
	.from(cakes_bakers::Entity, cakes_bakers::Column::CakeId)
	.to(cake::Entity, cake::Column::Id)
	.on_delete(ForeignKeyAction::Cascade)
	.on_update(ForeignKeyAction::Cascade),
	)
	.foreign_key(
	ForeignKey::create()
	.name("fk-cakes_bakers-baker")
	.from(cakes_bakers::Entity, cakes_bakers::Column::BakerId)
	.to(baker::Entity, baker::Column::Id)
	.on_delete(ForeignKeyAction::Cascade)
	.on_update(ForeignKeyAction::Cascade),
	)
	.to_owned();