README

See Akrabat_Db_Schema_Manager: Zend Framework database migrations for full details. This code is licensed under the New-BSD license.

Akrabat_Db_Schema_Manager is a tool for use with ZF1. If you need a standalone tool, then have a look at South for the Winter.

ZF1:

To get the Zend_Tool provider working:

Place a copy of ZF1 in /usr/local/include/zf1/, so that the Zend folder is in zf1/library/Zend
Update your ~/.bash_profile to set up an alias to the zf.sh script
```
 alias zf='export ZF_CONFIG_FILE=~/.zf.ini; /usr/local/include/zf1/bin/zf.sh'
```
Restart your terminal or source ~/.bash_profile
If you haven't already done so, setup the storage directory and config file:
```
 zf --setup storage-directory
 zf --setup config-file
```

Place a copy of the Akrabat Tools in /usr/local/include/Akrabat:

 cd /usr/local/include
 git clone http://github.com/akrabat/Akrabat.git

Edit the created ~/.zf.ini. Change path so that it includes ZF1 and Akrabat/library, allow for auotoloading Akrabat and set up the provider:

 php.include_path = "/usr/local/include/zf1/library:/usr/local/include/Akrabat/library/"
 autoloadernamespaces.0 = "Akrabat_"
 basicloader.classes.0 = "Akrabat_Tool_DatabaseSchemaProvider"

zf should provide a help screen with the DatabaseSchema provider at the bottom.

Akrabat_Db_Schema_Manager

Create scripts/migrations folder in your ZF application
Create migration files within migrations with the file name format of nnn-Xxxx.php. e.g. 001-Users.php where:
nnn => any number. The lower numbered files are executed first
Xxx => any name. This is the class name within the file.

In up(), database changes are applied, in down(), changes are reverted. If changes cannot be reverted, then down() should throw a Akrabat_Db_Schema_Exception.

Create a class in your migrations file. Example for 001-Users.php:

 class Users extends Akrabat_Db_Schema_AbstractChange 
 {
     function up()
     {
         $tableName = $this->_tablePrefix . 'users';
         $sql = "
             CREATE TABLE IF NOT EXISTS $tableName (
               id int(11) NOT NULL AUTO_INCREMENT,
               username varchar(50) NOT NULL,
               password varchar(75) NOT NULL,
               roles varchar(200) NOT NULL DEFAULT 'user',
               PRIMARY KEY (id)
             ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
         $this->_db->query($sql);
 
         $data = array();
         $data['username'] = 'admin';
         $data['password'] = sha1('password');
         $data['roles'] = 'user,admin';
         $this->_db->insert($tableName, $data);
     }
     
     function down()
     {
         $tableName = $this->_tablePrefix . 'users';
         $sql= "DROP TABLE IF EXISTS $tableName";
         $this->_db->query($sql);
     }
 
 }

If you want a table prefix, add this to your application.ini:
```
 resources.db.table_prefix = "prefix"
```

Phing Task

Define the phing task in the build.xml

 <taskdef name="dbmigration" classname="phing.tasks.PhingAkrabatDbSchemaManager" />

Setup a phing target with the database options in the build.xml

 <target name="database-migration">
 	<dbmigration adapter="mysqli" host="${db.host}" dbname="${db.name}" username="${db.user}" password="${db.pass}" />
 </target>

Run phing using the command line, by phing database-migration

akrabat / akrabat_db_schema_manager

Maintainers

Details

README

ZF1:

Akrabat_Db_Schema_Manager

Phing Task