Akrabat ZF library

See Akrabat_Db_Schema_Manager: Zend Framework database migrations for full details

ZF1:

To get the Zend_Tool provider working:

1. Place a copy of ZF1 in /usr/local/include/zf1/, so that the Zend folder is in zf1/library/Zend

2. 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/M5/1.0/bin/zf.sh'
   

   Restart your terminal or source ~/.bash_profile

3. If you haven't already done so, setup the storage directory and config file:

    zf --setup storage-directory
    zf --setup config-file
   

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

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

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

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

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

Akrabat_Db_Schema_Manager

1. Create scripts/migrations folder in your ZF application

2. 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.

3. 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);
        }
    
    }
   

4. If you want a table prefix, add this to your application.ini:

    resources.db.table_prefix = "prefix"
   

ZF2:

To get the Zend\Tool provider working:

1. Place a copy of ZF2 in /usr/local/include/zf2/, so that the Zend folder is in zf2/library/Zend:

    cd /usr/local/include
    git clone git://git.zendframework.com/zf.git zf2
   

   Don't forget to periodically update with git pull origin master

2. Update your ~/.bash_profile to set up an alias to the ZF2 zf.sh script

    alias zf2='export ZF_CONFIG_FILE=~/.zf2.ini; /www/zend-framework/zf2/bin/zf.sh'
   

   Restart your terminal or source ~/.bash_profile

3. Place a copy of the Akrabat Tools in /usr/local/include/Akrabat if you haven't already done so:

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

4. Create ~/.zf2.ini so that it contains:

    php.include_path = "/usr/local/include/zf2/library:/usr/local/include/Akrabat/zf2/"
    autoloadernamespaces.0 = "Akrabat\"
    basicloader.classes.0 = "Akrabat\Tool\DatabaseSchemaProvider"
   

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

Akrabat\Db\Schema\Manager

1. Create scripts/migrations folder in your ZF application

2. 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.

3. 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);
        }
    
    }
   

4. If you want a table prefix, add this to your application.ini:

    resources.db.table_prefix = "prefix"