How to define db prefix in Yii?

Archives Yii 1.0.x Discussions
1

Same as the title, how to define db prefix in Yii?

2

Do you mean common table prefix? You may define it as an application parameter (configure it in 'params' property in app config). And then in your AR's tableName() method, use Yii::app()->params['tablePrefix'] to refer to this prefix.

3

this means I should write a base class to inherit the CActiveRecord and rewrite the tableName method?

4

You ARE subclassing CActiveRecord and rewriting tableName() even if you don't need this prefix feature. :wink: Yes, creating a new base class can make your life easier:



<?php


class MyActiveRecord extends CActiveRecord


{


	public function tableName()


	{


		return $this->tableNamePrefix().$this->rawTableName();


	}


	


	protected function tableNamePrefix()


	{


		return Yii::app()->params['tablePrefix'];


	}


	


	abstract protected function rawTableName();


}