does gii automatically create relations for generated models?

1
votes

I'm new to Yii here. In the documentation, it seems to imply that gii will create the relations for related models. But when using gii to generate models from DB, it doesn't seem to be the case. For example, I have a user table and a profile table with a column "user_id INTEGER DEFAULT 0", but the relations array is empty in the generated model. Did I do something wrong, or gii just doesn't automatically recognize the relations? Thanks,

2
yiigii
if you define relations in database, yes it will - Kamil Klimek
Is the foreign key constraint in the database set correctly? user_id INTEGER DEFAULT 0 to me does not imply there is a foreign key constraint on this field - T I
awesome, thanks! I thought yii would infer from the column name (coming from CakePHP) - Anh Pham

2 Answers

3
votes

Gii will create relations for MyISAM tables if you include a format like the following in the comment of the referenced columns:

CONSTRAINT FOREIGN KEY (name_of_this_field) REFERENCES related_table_name(related_field_name)
1
votes

Gii can automatically create relations for generated models if corresponding tables in your DB have foreign keys, but not all storage engines support foreign keys. For example, if you use MyISAM tables in MySQL, you have no way to define it.