Phalcon Ext

Various extensions and utilities for Phalcon Framework, _(*1)

Pre-requisites

Phalcon framework 2.x or 3.x

Installation

Using Composer

You can use the composer package manager to install. Either run:, _(*2)

$ php composer.phar require davihu/phalcon-ext "^1.2"

or add:, _(*3)

"davihu/phalcon-ext": "^1.2"

to your composer.json file, _(*4)

Whats new?

Version 1.2

Added nested set support

Adds nested set support to your model. Simply use trait \PhalconExt\Mvc\Model\Traits\NestedSetTrait in your model., _(*5)

Version 1.1

Added SQL database migrations support

Can be easily attached to your console application., _(*6)

Supported commands:

php console.php migrations generate                        # generates new migration class
php console.php migrations migrate                         # migrates database to last version
php console.php migrations migrate 160910160944            # migrates database to selected version
php console.php migrations sql > migrate.sql               # saves SQL statements for migration to last version to file migrate.sql
php console.php migrations sql 160910160944 > migrate.sql  # saves SQL statements for migration to selected version to file migrate.sql

Set up in console bootstrap file:

1) Choose migrations directory, _(*7)

define('MIGRATIONS_DIR', '... your migrations dir ...');

2) Register dir to your loader, _(*8)

Without namespace usage, _(*9)

$loader->registerDirs([ ... , MIGRATIONS_DIR]);

With namespace usage, _(*10)

$loader->registerNamespaces([ ... , 'Your\\Namespace' => MIGRATIONS_DIR]);

3) Register migrations service to DI, _(*11)

Without namespace usage, _(*12)

$di->set('migrations', function () {
    return new \PhalconExt\Db\SqlMigrations($this->get('db'), MIGRATIONS_DIR);
}, true);

With namespace usage, _(*13)

$di->set('migrations', function () {
    return new \PhalconExt\Db\SqlMigrations($this->get('db'), MIGRATIONS_DIR, 'Your\\Namespace');
}, true);

Writing migrations classes

use PhalconExt\Db\SqlMigrations\AbstractMigration;

class Migration160910160944 extends AbstractMigration
{
    public function up()
    {
        # simple statements
        $this->addSql("ALTER TABLE robots ADD COLUMN number VARCHAR(20)");

        # routine statements like triggers, procedures and functions
        $this->addSql("CREATE TRIGGER MyTrigger ...", true);
    }

    public function down()
    {
        $this->addSql("ALTER TABLE robots DROP COLUMN number");
        $this->addSql("DROP TRIGGER MyTrigger");
    }
}

Thats all, very simple but powerfull!, _(*14)

Db

PhalconExt\Mvc\Db\SqlMigrations - Database migrations service directly via. SQL statements
PhalconExt\Mvc\Db\SqlMigrations\AbstractMigration - Abstract SQL migration, all migrations must extend this class