Schema.php

<?php
class ZendDbSchema_Tool_Project_Provider_Schema
    extends Zend_Tool_Project_Provider_Abstract
    implements Zend_Tool_Framework_Provider_Pretendable
{
    public function createResource(Zend_Tool_Project_Profile $profile, $schemaName, $contents, $force = false)
    {
        if (!is_string($schemaName)) {
            throw new Zend_Tool_Project_Provider_Exception(
                'schema name must be a string'
            );
        }

        if ($this->_findfile($profile, $schemaName) !== false && $force == false) {
            throw new Zend_Tool_Project_Provider_Exception(
                'File named ' . $schemaName. ' already exists within the models directory.'
            );
        }

        $newFile = $profile->createResourceAt(
            'schemaDirectory',                  // where to create at
            'file',                        // what to create
            array(
                'schemaName' => $schemaName,
                'fileContents' => $contents)    // attrs to initiate with
        );

        return $newFile;
    }

    public function getContextClasses()
    {
        return array(
            'ZendDbSchema_Tool_Project_Context_Schema_File',
            'ZendDbSchema_Tool_Project_Context_Schema_Directory'
        );
    }

    protected function _findfile($profile, $name)
    {
        // check to see if a model already exists
        $existingFile = $profile->search(array(
            'schemaDirectory',
            'file' => array('filesystemName' => $name))
        );
        return $existingFile;
    }


    protected function _getSchema($type, $name)
    {
        if (empty($name)) {
            throw new Zend_Tool_Project_Provider_Exception('Schema name must not be empty');
        }

        switch ($type) {
            case 'table':
                $schema = new ZendDbSchema_Db_Schema_Table($name);
                break;
            case 'database':
                $schema = new ZendDbSchema_Db_Schema_Database($name);
                break;
            default:
                throw new Zend_Tool_Project_Provider_Exception(
                    "Type must be table or database, '{$type}' is given."
                );
        }
        return $schema;
    }

    public function pull($type = 'table', $name = '', $force = false)
    {
        $profile = $this->_bootstrap();

        $schema = $this->_getSchema($type, $name);
        if (!$schema->isExist()) {
            throw new Zend_Tool_Project_Provider_Exception(
                "No {$type} with name '{$name}' found"
            );
        }

        $name = $this->_getFilename($type, $name);

        $writer = new Zend_Config_Writer_Array();
        $writer->setConfig(new Zend_Config($schema->toArray()));

        $file = $this->createResource($profile, $name, $writer->render(), $force);

        if ($this->_registry->getRequest()->isPretend()) {
            $this->_registry->getResponse()->appendContent(
                'Would create schema at ' . $file->getPath()
            );
        } else {
            $this->_registry->getResponse()->appendContent(
                'Creating schema at ' . $file->getPath()
            );
            $file->create();
            $this->_storeProfile();
        }
    }

    public function push($type = 'table', $name = '', $force = false)
    {
        $profile = $this->_bootstrap();

        $schema = $this->_getSchema($type, $name);
        if ($schema->isExist() && !$force) {
            throw new Zend_Tool_Project_Provider_Exception(
                "{$type} with name {$name} already exists in database. User force for overwrite"
            );
        }

        $name = $this->_getFilename($type, $name);

        if (!$file = $this->_findfile($profile, $name)) {
            throw new Zend_Tool_Project_Provider_Exception(
                "Schema file '{$name}' is not found"
            );
        }

        $config = include $file->getPath();

        $schema->setFromArray($config);

        if (!$schema->isDirty()) {
            throw new Zend_Tool_Project_Provider_Exception(
                "{$type} with name {$name} is not modified"
            );
        }
        if ($this->_registry->getRequest()->isPretend()) {
            $this->_registry->getResponse()->appendContent(
                'Would exequte following sql code' .PHP_EOL . $schema->toSql(true)
            );
        } else {
            $this->_registry->getResponse()->appendContent(
                'Altering database'
            );
            $schema->save();
            $this->_storeProfile();
        }
    }

    public function status($type, $name)
    {
        $profile = $this->_bootstrap();

        $schema = $this->_getSchema($type, $name);

        $name = $this->_getFilename($type, $name);

        if (!$file = $this->_findfile($profile, $name)) {
            throw new Zend_Tool_Project_Provider_Exception(
                "Schema file '{$name}' is not found"
            );
        }

        $config = include $file->getPath();

        $schema->setFromArray($config);

        $status = 'Ok';
        if ($schema->isDirty()) {
            $status = 'Dirty';
        }
        echo $status;
    }

    protected function _getFilename($type, $name)
    {
        return $name . '.' . $type . '.php';
    }

    protected function _bootstrap()
    {
        $profile = $this->_loadProfile(self::NO_PROFILE_THROW_EXCEPTION);

        $bootstrapResource = $this->_loadedProfile->search('BootstrapFile');

        /* @var $zendApp Zend_Application */
        $zendApp = $bootstrapResource->getApplicationInstance();

        try {
            $zendApp->bootstrap('db');
            Zend_Loader_Autoloader::getInstance()->registerNamespace('ZendDbSchema');
        } catch (Zend_Application_Exception $e) {
            throw new Zend_Tool_Project_Provider_Exception('Db resource not available, you might need to configure a DbAdapter.');
            return;
        }
        return $profile;
    }
}