Urgent Table Prefix Question

gtrennert · March 11, 2015, 9:30pm

hello

I allways setup table prefix - for this post lets say my prefix is abc_

So in common\config\main-local.php I have :

'components' =&gt; [


    'db' =&gt; [


        'class' =&gt; 'yii&#092;db&#092;Connection',


        'dsn' =&gt; 'mysql:host=localhost;dbname=database',


        'username' =&gt; 'user',


        'password' =&gt; 'pwd',


        'charset' =&gt; 'utf8',


        'tablePrefix' =&gt; 'abc_',


    ],


    ...

I have worked on Yii1 and used gii to generate models

In this version it generated files like : table.php

Now I work with Yii2 and learn the differences :

gii generate files like abc_table.php

yes I checked "Use Table Prefix"

This is not ok because prefix should be transparent

Could please anyone tell me what I’m doing wrong ?

johnsnails · March 12, 2015, 11:47am

Hey have tried a few different combos, so long as I have ‘tablePrefix’ set and it matches the table/s in questions prefix my model php files DO NOT include the prefix.

In fact here is happens for me:


'tablePrefix' => 'abc_'

and say i have a table called


abc_hello_John

then my php model file is called


HelloJohn.php

so something else could be at play with how you gii is working. do you have any other ‘tweaks’ or configurations set that could override the default gii behaviour?

Maybe something like this might help.

http://www.yiiframework.com/doc-2.0/yii-gii-generators-model-generator.html#generateTableName()-detail

Cheers!

gtrennert · March 12, 2015, 6:43pm

Sorry - I should have seen this - I always referred to suggested values

But I have to enter classname without prefix