How can i get the actual full table name?

Yii 1.1 General Discussion
1

i define the table name in model like:


public function tableName()

{

    return '{{node}}';

}

if my tablePrefix set to "yii_" in db config,

how can i get "yii_node" through the model~?

2

Try AR::model()->tableSchema->rawName.

I haven’t used tablePrefix before so just guessing.

3

it will be return ‘{{node}}’

just wrap by quote~

4

qiang?

5

Have just had to do this myself from within an active record.


preg_replace('/{{(.*?)}}/',$this->getDbConnection()->tablePrefix.'\1',$this->tableName())

This is the way its done in CDbCommand. Don’t know why theres no dedicated method for it!

6

Wouldn’t this do just fine ?




//Your model : 

public function getOriginalTableName()

{

   return Yii::app()->db->tablePrefix.str_replace(array('{{','}}'),'',$this->tableName());

}
7

Probably, just going with what Yii already uses. Maybe theres some performance considerations?

8

str_* functions are faster than preg_* functions.

9 

Model::model()->tableSchema->name;
10

$productTableName = ProductModel::getTableSchema()->fullName;