Yii Relational Databank Objects and Gii

Yii is great in creating objects/models for your tables and their relations.
Here I’ll show how you can generate objects/models with gii using a mysql databank.

Lets assume you have created the hello world project using ‘yiic’

Step 1 – Enable Databank Connection

Under appname/protected/config/main.php db array should look like below example


'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=jlool',
			'emulatePrepare' => true,
			'username' => 'my_db_user', //or root..
			'password' => 'mypass',     //if no pass enter ''
			'charset' => 'utf8',
		),

'db'=>array(

'connectionString' => 'mysql:host=localhost;dbname=jlool',

'emulatePrepare' => true,

'username' => 'my_db_user', //or root..

'password' => 'mypass', //if no pass enter ''

'charset' => 'utf8',

Step 2 – Enable Gii

Under appname/protected/config/main.php uncomment gii module, should look like below example


...
'gii'=>array(
			'class'=>'system.gii.GiiModule',
			'password'=>'mypassword',
			// If removed, Gii defaults to localhost only. Edit carefully to taste.
			'ipFilters'=>array('127.0.0.1','::1'),
		),
...

...

'gii'=>array(

'class'=>'system.gii.GiiModule',

'password'=>'mypassword',

// If removed, Gii defaults to localhost only. Edit carefully to taste.

'ipFilters'=>array('127.0.0.1','::1'),

...

Step 3 – Create Tables in mysql


CREATE TABLE JUser(
  userid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  username varchar(40) DEFAULT NULL,
  email varchar(40) DEFAULT NULL
)

CREATE TABLE JProfile(
  profileid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name varchar(40) DEFAULT NULL,
  surname varchar(40) DEFAULT NULL,
  fk_userid int(11) NOT NULL,
  FOREIGN KEY (fk_userid) references JUser(userid)
)

CREATE TABLE JUser(

userid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

username varchar(40) DEFAULT NULL,

email varchar(40) DEFAULT NULL

)

CREATE TABLE JProfile(

profileid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

name varchar(40) DEFAULT NULL,

surname varchar(40) DEFAULT NULL,

fk_userid int(11) NOT NULL,

FOREIGN KEY (fk_userid) references JUser(userid)

)

Step 4 – Generate objects in Gii

In your Browser visit http://localhost/appname/index.php?r=gii or http://localhost/index.php?r=gii if your app is in root folder

Enter your password defined in main.php and to the left click the model generator
After that fill the tablename and modelclass will be auto filled
Finally press Preview and then Generate

Note

Make sure the folder(s) under your yii app have write permissions or gii will fail in creating the model files
After generating the models you should restore the original permissions

This entry was posted in Yii and tagged gii model generate,relational databank,relational model,yii on June 15, 2013