[extension] Yii DB Migrations - very early alpha release

pclaerhout · August 30, 2009, 1:43pm

I’m doing something like that in my own applications. In the index.php and yiic.php scripts, I’ve added a check to see if I’m in the development or production environment. Based on that, I’m setting the YII_DEBUG constant.

Additionally, in the config files, I’m checking if YII_DEBUG is true or not and include the correct database configuration file.

Depending on how you distinguish the development from the production system, you will need a different kind of check.

For me, the rule is:

For index.php: if the server name is localhost, I’m in the development environment
For yiic.php: I’m checking for the existance of an environment variable that indicates the enviroment

Cheers,

pieter

pclaerhout · August 30, 2009, 1:45pm

Yes, you can just replace the entire yii-dbmigrations directory with the new version.

Regards,

pieter

Q-efx · September 14, 2009, 4:35pm

Note: If you are on in windows, and from germany, you have to set the right timezone

Suggestion: Why not change those "hundred" array`s to something like this:




public function up

{

    $this->createTable(

        'tablename: field1 :: type1,

                    field2 :: type2,

                    field3 :: type3'

    )


}

Speed shouldn’t have a big impact, and would look much cleaner

pclaerhout · September 14, 2009, 6:16pm

Q-efx:

Note: If you are on in windows, and from germany, you have to set the right timezone

Suggestion: Why not change those "hundred" array`s to something like this:
public function up

{

    $this->createTable(

        'tablename: field1 :: type1,

                    field2 :: type2,

                    field3 :: type3'

    )


}
Speed shouldn’t have a big impact, and would look much cleaner

I will see what I can do for version 2.0 to make it less verbose.

pieter

donyaee · September 16, 2009, 6:55am

pclaerhout:

If you download the latest version from github, you will see that I added a new command that creates a blank migration:
protected yiic migrate create MyTestMigration
That will create the timestamped file with an empty migration in there.

Regards,

pieter

Hello Pieter,

I am getting the following error message after running "protected/yiic migrate -create mymigration":

ERROR: Invalid migration: -create

It seems the "create" option is not implemented or I am using a wrong version.

Thanks,

Ramin

pclaerhout · September 16, 2009, 6:59am

You’ve made an error in the command. You should use the following (without the dash in front of the create command):


protected/yiic migrate create mymigration

Cheers,

pieter

donyaee · September 16, 2009, 11:06pm

The dash was a typo when I replied to your post. This is what I’ve got:

ramin$ protected/yiic migrate create mymigration

ERROR: Invalid migration: create

ramin$

Thanks,

Ramin

donyaee · September 19, 2009, 9:39pm

The ‘timestamp’ type mapping creates ‘datetime’ type.

Regards,

Ramin

Santiago_Carmo · October 23, 2009, 1:32am

Hi guys,

I’m having some problens when I try to create new migrations.

I created a new application using version 1.0.10 of yii, and when I try create a new migration, the console show this error:

I 'm calling this line on command line:


$ ./protected/yiic migrate create users

And the configuration is that:




'commandMap' => array('migrate' => array('class' => 'application.extensions.yii-dbmigrations.CDbMigrationCommand')),


'components' => array('db' => array('class' => 'system.db.CDbConnection', 

              		      'connectionString' => 'mysql:host=localhost;dbname=nagloria;unix_socket=/tmp/mysql.sock', 

              		      'username' => 'root', 

              		      'password' => '',

              		      'emulatePrepare' => true)),

I did some tests with version 1.0.8 of yii and the extansion run well, but with 1.0.10 the problem happened.

Could you help me to fix up this?

Thanks.

pclaerhout · October 27, 2009, 8:36am

Please download the latest version from github. It has this problem fixed.

Regards,

pieter

GodFather:

Hi guys,

I’m having some problens when I try to create new migrations.

I created a new application using version 1.0.10 of yii, and when I try create a new migration, the console show this error:

I 'm calling this line on command line:


$ ./protected/yiic migrate create users

And the configuration is that:




'commandMap' => array('migrate' => array('class' => 'application.extensions.yii-dbmigrations.CDbMigrationCommand')),


'components' => array('db' => array('class' => 'system.db.CDbConnection', 

              		      'connectionString' => 'mysql:host=localhost;dbname=nagloria;unix_socket=/tmp/mysql.sock', 

              		      'username' => 'root', 

              		      'password' => '',

              		      'emulatePrepare' => true)),

I did some tests with version 1.0.8 of yii and the extansion run well, but with 1.0.10 the problem happened.

Could you help me to fix up this?

Thanks.

Santiago_Carmo · October 27, 2009, 1:25pm

Hi,

actualy, I needed to do a downgrade to 1.0.8 version of yii, becouse I need to finish this job asap, but I have a new project to start on few days and I intent to test the last version of yii with yii-dbmigrations.

Thanks for your help.

Santiago_Carmo · October 27, 2009, 1:27pm

To clarify, the downgrade was necessary to use dbmigrations, becouse I knew that dbmigration work on this version.

Thanks.

coyote · December 3, 2009, 1:52am

Hello!

Have the same error like GodFather:

…




#4  PDOStatement->execute(id) called at [Z:\home\vc\framework\db\CDbCommand.php:

355]

#5  CDbCommand->queryInternal(fetchAll, 7, id) called at [Z:\home\vc\framework\d

b\CDbCommand.php:324]

#6  CDbCommand->queryColumn(id) called at [Z:\home\vc\preview\protected\extensio

ns\yii-dbmigrations\CDbMigrationEngine.php:162]

#7  CDbMigrationEngine->getAppliedMigrations() called at [Z:\home\vc\preview\pro

tected\extensions\yii-dbmigrations\CDbMigrationEngine.php:277]

#8  CDbMigrationEngine->applyMigrations(create) called at [Z:\home\vc\preview\pr

otected\extensions\yii-dbmigrations\CDbMigrationEngine.php:73]

#9  CDbMigrationEngine->run(Array ([0] => create,[1] => UserMigration)) called a

t [Z:\home\vc\preview\protected\extensions\yii-dbmigrations\CDbMigrationCommand.

php:39]

#10 CDbMigrationCommand->run(Array ([0] => create,[1] => UserMigration)) called

at [Z:\home\vc\framework\console\CConsoleCommandRunner.php:62]

#11 CConsoleCommandRunner->run(Array ([0] => Z:\home\vc\preview\protected\yiic.p

hp,[1] => migrate,[2] => create,[3] => UserMigration)) called at [Z:\home\vc\fra

mework\console\CConsoleApplication.php:88]

#12 CConsoleApplication->processRequest() called at [Z:\home\vc\framework\base\C

Application.php:135]

#13 CApplication->run() called at [Z:\home\vc\framework\yiic.php:31]

#14 require_once(Z:\home\vc\framework\yiic.php) called at [Z:\home\vc\preview\pr

otected\yiic.php:7]

I tried to use Yii 1.1beta is there any chance to continue without downgrading?

Please, specify the last supported version

Thank you!

coyote · December 3, 2009, 2:01am

Oh! I’ve just downloaded version from

http://www.yiiframework.com/extension/yii-dbmigrations/

not GitHub and it perfectly works!

Thank you for such a great extension!

vollust · December 29, 2009, 5:22pm

DB connection works well for application.

but yii-dbmigrations (current git version) has a problem @ my install:

why app config is not acceptable by dbmigrations?

Santiago_Carmo · February 19, 2010, 11:38am

Hi,

I had the same problem and fix putting this on connection string

unix_socket=/tmp/mysql.sock

Santiago_Carmo · February 19, 2010, 12:08pm

Hi,

I’m using the lastest version of yii-dbmigrations, and I saw that the form of create tables changed (from arrays to objects), and I can’t declare a field like int(11), so I’d like know:

How can I pass my own arguments to table fields?

Thanks

imehesz · September 21, 2010, 8:44pm

Hello,

I have the exact same problem, but I’m using SQLite (so the socket thing wouldn’t work)

thx,

–iM

imehesz · September 22, 2010, 1:26am

never mind, I should learn to read the documentation first … ()forgot to setup the connection to the DB itself),

so it works so far

thx,

–iM

Santiago_Carmo · January 30, 2011, 10:12pm

Hi folks,

I have a new problem using the latest version of yii-dbmigration, when I run the migration the console shows the message below and the migration not work




$ ./protected/yiic migrate

Migrations directory: protected/migrations/


=== Applying: m20110123200901_create_eav_table =================================

ERROR: m20110123200901_create_eav_table does not have a method named "performTransactional".

The code of migration is:




<?php


class m20110123200901_create_eav_table extends CDbMigration {

    

    public function up() {

      $t = $this->newTable('eav');

      $t->primary_key('id');

      $t->integer('section_id');

      $t->integer('entry_id');

      $t->integer('field_id');

      $t->string('attribute');

      $t->text('value');

      $t->datetime('created_at');

      $t->datetime('updated_at');

      $this->addTable($t);

    }

    

    public function down() {

      $this->removeTable('eav');

    }

    

}

Anyone know what happens?

Thanks.