How to Generate a Model with a Foreign Key Relationship Using "cargo loco generate model" command?

[alokmahor]

Suppose I have a table named website_users with a primary key column id. Now, I want to create another table named good_users that includes a user_id column referencing the id column of website_users.

I want to use cargo loco generate model to generate the model for good_users. However, I am unsure how to define the foreign key relationship between good_users.user_id and website_users.id using the CLI.

Is there a way to specify the relationship directly when generating the model? Or do I need to manually define it in the generated model file? If so, what is the best approach to properly set up the relationship in SeaORM with Loco?

[lizard-Szilard]

You can create relation such as in docs loco example then you can make detail changes in migration file. Also you can refer in seaoorm docs another good reference https://docs.rs/loco-rs/latest/loco_rs/tests_cfg/db/struct.TableAlterStatement.html#method.add_foreign_key.

[kaplanelad]

You can achieve this by using a reference. Here's an example to guide you:

cargo loco generate model good_users users:references:id [....]

This command generates a model named good_users with a reference to the users table via its id column."

[alokmahor]

In the new table named good_users should have a column named user_id which is a column named id of another table named website_users.

The syntax cargo loco generate model good_users users:references:id [....] does not have details that user_id column is id column of website_users.

How will references will tell the table name to be website_users?

That syntax will only work when column name is user_id and reference table name is users. But in my case names are different.