SANDBOX_PATH . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . 'Model'

set_include_path( '.' . PATH_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . PATH_SEPARATOR . '.' . DIRECTORY_SEPARATOR . 'lib' . PATH_SEPARATOR . get_include_path());

require_once 'Doctrine.php';
 
/**
 * Setup autoload function
 */
spl_autoload_register( array(
    'Doctrine',
    'autoload'
));

set_include_path( '.' . PATH_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . PATH_SEPARATOR . '.' . DIRECTORY_SEPARATOR . 'lib' . PATH_SEPARATOR . get_include_path());
 
require_once 'Doctrine.php';
 
/**
 * Setup autoload function
 */
spl_autoload_register( array(
	'Doctrine',
	'autoload'
));
 
define('SANDBOX_PATH', dirname(__FILE__));
define('DATA_FIXTURES_PATH', SANDBOX_PATH . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'fixtures');
define( 'MODELS_PATH',        SANDBOX_PATH . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . 'Model');
define('MIGRATIONS_PATH', SANDBOX_PATH . DIRECTORY_SEPARATOR . 'migrations');
define('SQL_PATH', SANDBOX_PATH . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'sql');
define('YAML_SCHEMA_PATH', SANDBOX_PATH . DIRECTORY_SEPARATOR . 'schema');
define('DB_PATH', SANDBOX_PATH . DIRECTORY_SEPARATOR . 'sandbox.db');
define('DSN', 'mysql://root:123@localhost/mydbname');
 
Doctrine_Manager::connection( DSN, 'sandbox');
 
Doctrine_Manager::getInstance()->setAttribute('model_loading', 'conservative');

/**
 * Class SandboxCli
 * Extends default Doctrine Client functionality
 *
 * @package Sandbox
 */
class SandboxCli extends Doctrine_Cli {
 
	/**
	 * Public function to run the loaded task with a given argument
	 *
	 * @param  array $args
	 * @return void
	 */
	public function run( $args) {
		ob_start();
		parent::run( $args);
		$msg = ob_get_clean();
		$this->_chmod();
 
		if (isset( $args[1]) && ($args[1] == 'generate-models-yaml')) {
			$this->_genBaseClasses();
			$this->_genSgMethods();
			$this->_chmod();
		}
		echo $msg;
	}
 
	/**
         * Automatically creates base table and record classes if they are not exists
         *
         * @param void
         * @return void
         */
        protected function _genBaseClasses() {
                $dir = $this->_config['models_path'] . DIRECTORY_SEPARATOR . 'Base' . DIRECTORY_SEPARATOR;
                if (!is_dir( $dir)) {
                        mkdir( $dir);
                }
                if (!file_exists( $dir . 'Table.php')) {
                        file_put_contents( $dir . 'Table.php', '<?php
 
/**
 * Class Model_Base_Table - abstraction parent layer for table objects
 *
 * This class was automatically generated by Doctrine sandbox client.
 * All project table classed MUST be inherited from this class.
 * You can add an extra functionality for all tables here if
 * required. This class generates automatically only if not exists and
 * it is available for manual editing.
 */
abstract class Model_Base_Table extends Doctrine_Table {
}
');
                }
                if (!file_exists( $dir . 'Record.php')) {
                        file_put_contents( $dir . 'Record.php', '<?php
 
/**
 * Class Model_Base_Record - abstraction parent layer for record objects.
 *
 * This class was automatically generated by Doctrine sandbox client.
 * All project record classed MUST be inherited from this class.
 * You can add an extra functionality for all records here if
 * required. This class generates automatically only if not exists and
 * it is available for manual editing.
 */
abstract class Model_Base_Record extends Doctrine_Record {
}');
                }
        }
 
         /**
         * Automatically generates getter and setter methods for hand-make classes.
         * This method works fine to add a new methods if new DB properties has been added.
         * NOTE! REMOVAL of all methods for excluded properties should be done manually
         *
         * @param  void
         * @return void
         */
        protected function _genSgMethods() {
                $yml = new Doctrine_Parser_Yml();
                $result = $yml->load( $this->_config['yaml_schema_path'] . DIRECTORY_SEPARATOR . 'schema.yml', 'yml');
 
                foreach ($result as $class => $data) {
                        require_once $this->_config ['models_path'] . DIRECTORY_SEPARATOR . $class . '.php';
                        $rClass = new ReflectionClass( $class);
                        foreach ($data ['columns'] as $column => $options) {
                                $methods = $this->_buildMethodName( $column);
                                foreach ($methods as $k => $name) {
                                        if (! $rClass->hasMethod( $name)) {
                                                $type = is_array ($options) ? $options['type'] : $options;
                                                $this->_addMethod ($class, $name, $column, $k, $type); 
                                        }
                                }
                        }
                        $this->_fixParents( $class);
                        $this->_createTableClass( $class);
                }
        }
 
 
 
        /**
         * Fixes parent for base classes from Doctrine_Record to Model_Base_Record
         *
         * @param  string $class - original class name
         * @return void
         */
        protected function _fixParents($class) {
                $dir = $this->_config['models_path'] . DIRECTORY_SEPARATOR . 'generated' . DIRECTORY_SEPARATOR;
                $baseClass = 'Base' . $class;
                if (file_exists( $dir . $baseClass . '.php')) {
                        $content = file_get_contents( $dir . $baseClass . '.php');
                        $content = preg_replace( '/extends\s+Doctrine_Record\s+{/is', 'extends Model_Base_Record {', $content);
                        file_put_contents( $dir . $baseClass . '.php', $content);
                }
        }
 
	/**
	 * Fixes parent for base classes from Doctrine_Record to Model_Base_Record
	 *
	 * @param  string $class - original class name
	 * @return void
	 */
	protected function _fixParents($class) {
		$dir = $this->_config['models_path'] . DIRECTORY_SEPARATOR . 'generated' . DIRECTORY_SEPARATOR;
		$baseClass = 'Base' . $class;
		if (file_exists( $dir . $baseClass . '.php')) {
			$content = file_get_contents( $dir . $baseClass . '.php');
			$content = preg_replace( '/extends\s+Doctrine_Record\s+{/is', 'extends Model_Base_Record {', $content);
			file_put_contents( $dir . $baseClass . '.php', $content);
		}
	}
 
	/**
         * Creates table classes if they have not been already exist
         *
         * @param  string $class - original class name
         * @return void
         */
        protected function _createTableClass( $class) {
                $dir = $this->_config['models_path'] . DIRECTORY_SEPARATOR . 'Tables' . DIRECTORY_SEPARATOR;
                if (!is_dir( $dir)) {
                        mkdir( $dir);
                }
                $tblClass = $class . 'Table';
                if (! file_exists( $dir . $tblClass . '.php')) {
                        $content = "<?php
 
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class $tblClass extends Model_Base_Table {
 
}
";
                        file_put_contents( $dir . $tblClass . '.php', $content);
                }
        }
 
	/**
         * Naturally adds a method definition content to a class definition
         *
         * @param  string $class - original class name
         * @param  string $methodName - method name required to be defined
         * @param  string $propertyName - property associated with a method
         * @param  string $methodType - setter or getter ('set'|'get')
         * @param  string $propertyType - type of a property obtained from YAML
         * @return void
         */
        protected function _addMethod( $class, $methodName, $propertyName, $methodType, $propertyType) {
                $content = file_get_contents( $this->_config ['models_path'] . DIRECTORY_SEPARATOR . $class . '.php');
 
                $propType = $this->_type2php( $propertyType);
 
                if ($methodType == 'get') {
                        $comment = "Returns a value of '$propertyName' field";
                        $args = '';
                        $implementation = "return \$this->$propertyName;";
                        $prms = ' void';
                        $rets = "$propType \$$propertyName $propertyType";
                } elseif ($methodType == 'set') {
                        $comment = "Sets '$propertyName' field to a given value";
                        $args = ' $' . $propertyName;
                        $implementation = '$this->' . $propertyName . ' = $' . $propertyName . ';
                return $this;';
                        $prms = $args;
                        $rets = $class;
                } else {
                        return;
                }
 
                $addCode = "    /**
         * $comment
         *
         * @param $prms
         * @return $rets
         */
        public function $methodName($args) {
                $implementation
        }
 
";
 
                $content = preg_replace( '/(class\s+' . preg_quote( $class) . '\s+.*?\{.*?)(\})([^}]*)$/is', '$1' . $addCode . '$2$3', $content);
                file_put_contents( $this->_config['models_path'] . DIRECTORY_SEPARATOR . $class . '.php', $content);
        }
 
	/**
	 * Returns PHP type from YAML definition type
	 *
	 * @param  string $type - YAML type
	 * @return string PHP type
	 */
	protected function _type2php( $type) {
		$type = explode ( '(', $type );
		$type = $type [0];
 
		$types = array(
			'boolean' => 'bool',
			'integer' => 'int',
			'float' => 'float',
			'decimal' => 'float',
			'string' => 'string',
			'array' => 'array',
			'object' => 'string',
			'blob' => 'string',
			'clob' => 'string',
			'timestamp' => 'string',
			'time' => 'string',
			'date' => 'string',
			'enum' => 'string',
			'gzip' => 'string'
		);
 
		return $types[$type];
	}
 
	/**
	 * Builds method names from a property name
	 *
	 * @param  string $column_name - original property name
	 * @return array
	 */
	protected function _buildMethodName($column_name) {
		$method = preg_split( '/_+/', $column_name, - 1, PREG_SPLIT_NO_EMPTY);
		foreach ($method as $k => $part) {
			$method [$k] = ucfirst( $part);
		}
		$method = join( '', $method);
		$return = array(
			'get' =&gt; "get$method",
			'set' =&gt; "set$method"
		);
		return $return;
	}
 
	/**
	 * Fixes group permissions for generated files
	 *
	 * @param  void
	 * @return void
	 */
	protected function _chmod() {
		$cmd = 'chmod -R g+w ' . MODELS_PATH;
		echo `$cmd`;
	}
 
}

require_once('config.php');
require_once 'SandboxCli.php';
 
// Configure Doctrine Cli
// Normally these are arguments to the cli tasks but if they are set here the arguments will be auto-filled
$config = array('data_fixtures_path'  =>  DATA_FIXTURES_PATH,
                'models_path'         =>  MODELS_PATH,
                'migrations_path'     =>  MIGRATIONS_PATH,
                'sql_path'            =>  SQL_PATH,
                'yaml_schema_path'    =>  YAML_SCHEMA_PATH);
 
$cli = new SandboxCli( $config);
$cli->run( $_SERVER['argv']);

require '..' . DIRECTORY_SEPARATOR . 'application' . DIRECTORY_SEPARATOR . 'default' . DIRECTORY_SEPARATOR . 'run' . DIRECTORY_SEPARATOR . 'bootstrap.php';

setAttribute( Doctrine::ATTR_AUTOLOAD_TABLE_CLASSES, true);
 
/**
 * Turn all Doctrine validators on
 */
Doctrine_Manager::getInstance()->setAttribute( Doctrine::ATTR_VALIDATE, Doctrine::VALIDATE_ALL);
 
/**
 * Setup Doctrine connection
 */
Doctrine_Manager::connection( 'mysql://root:123@localhost/mydbname');
 
/**
 * Set the model loading to conservative/lazy loading
 */
Doctrine_Manager::getInstance()->setAttribute( 'model_loading', 'conservative');
 
/**
 * Load the models for the autoloader
 */
Doctrine::loadModels( '..' . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . 'Model');
 
/**
 * Setup controller
 */
$controller = Zend_Controller_Front::getInstance();
$controller->setControllerDirectory( '../application/default/controllers');
$controller->throwExceptions( true); // should be turned on in development time 
 
/**
 * bootstrap layouts
 */
Zend_Layout::startMvc( array(
    'layoutPath' => '../application/default/layouts',
    'layout' => 'main'
));
 
/**
 * Run front controller
 */
$controller->dispatch();

public function indexAction() {
    $artist = new Artist();
    $artist->setName( 'DDT')
             ->setDescription( 'Very cool russian rock-band')
             ->save();
 
    $artist = Doctrine::getTable( 'Artist')->find( 1);    
 
    echo '<pre>';
    print_r( $artist);
}