How to refresh table metadata

Yii 1.1 Tips, Snippets and Tutorials
1

Hi,everyone!

Could someone explain me, how I can implement refreshMetaData() function for model. My deevelopment process often includes some changes in tables, so, I don’t want to recreate model each and every time, writing all the code, I’ve used earlier. How to refresh table metadata for all my tables in mysql db, so I don’t have to recreate my models.

Thank you very much!

2

im guessing you need to empty (trunc) the yiicache table ?

nz

3

ModelName::model()->refreshMetaData() ?

4

Doesn’t Yii do this automatically? I use SQLite and when I enable database profiling I get a load of PRAGMA queries on each pageview looking for foreign keys and table columns. I find that if I add a new column to a modeled table, I can access the $model->columnname property instantly. But maybe this is different for MySQL?