Правильная интеграция Doctrine в CodeIgniter

1. <?php if (!defined('BASEPATH')) exit('No direct script access allowed');
2.  
3. /**
4. * Doctrine initialization class
5. */
6. class DoctrineORM
7. {
8.  function __construct() {
9.     // Получаем конфиг базы данных
10.     require_once(APPPATH . 'config/database.php');
11.  
12.     // Создаем DSN из полученной инфы
13.     $db['default']['dsn'] = $db['default']['dbdriver'] .
14.                             '://' . $db['default']['username'] .
15.                             ':' . $db['default']['password'].
16.                             '@' . $db['default']['hostname'] .
17.                             '/' . $db['default']['database'];
18.  
19.     // Подключаем Doctrine.php
20.     require_once(BASEPATH . 'database/doctrine/Doctrine.php');
21.  
22.     // Устанавливаем autoloader
23.     spl_autoload_register(array('Doctrine', 'autoload'));
24.  
25.     // Инициализируем соединение
26.     Doctrine_Manager::connection($db['default']['dsn'], $db['default']['database']);
27.  
28.     // Устанавливаем тип загрузки моделей в "conservative/lazy"
29.     Doctrine_Manager::getInstance()->setAttribute('model_loading', 'conservative');
30.  
31.     // Загружаем модели в autoloader
32.     Doctrine::loadModels(APPPATH . 'models');
33.  }
34. }

* This source code was highlighted with Source Code Highlighter.

1. #!php
2. <?php
3.  
4.  // Директории system и application относительно текущей
5.  $sys_folder = '../';
6.  $app_folder = '.';
7.  
8.  include('doctrine.php');

* This source code was highlighted with Source Code Highlighter.

1. <?php
2.  
3. define('BASEPATH', str_replace('\\', '/', $sys_folder) . '/');
4. define('APPPATH',  str_replace('\\', '/', $app_folder) . '/');
5.  
6. require_once(APPPATH . 'libraries/doctrineORM.php');
7. new DoctrineORM();
8.  
9. // Конфигурируем "Doctrine Cli"
10. $config = array(
11.                 'data_fixtures_path' => APPPATH . '/fixtures',
12.                 'models_path'         => APPPATH . '/models',
13.                 'migrations_path'     => APPPATH . '/migrations',
14.                 'sql_path'            => APPPATH . '/sql',
15.                 'yaml_schema_path'    => APPPATH . '/schema'
16.               );
17.  
18. $cli = new Doctrine_Cli($config);
19. $cli->run($_SERVER['argv']);

* This source code was highlighted with Source Code Highlighter.

• application/fixtures;
• application/migrations;
• application/schema;
• application/sql.

1. $autoload['libraries'] = array('doctrineORM', 'session');

* This source code was highlighted with Source Code Highlighter.

1. ---
2. User:
3.  columns:
4.     id:
5.      primary: true
6.      autoincrement: true
7.      type: integer(4)
8.     username: string(255)
9.     password: string(255)
10.  relations:
11.     Groups:                    # Relation alias or class name
12.      class: Group             # Class name. Optional if alias is the class name
13.      local: user_id          # Local: User.id = UserGroup.user_id. Optional
14.      foreign: group_id        # Foreign: Group.id = UserGroup.group_id. Optional
15.      refClass: UserGroup     # xRefClass for relating Users to Groups
16.      foreignAlias: Users     # Opposite relationship alias. Group hasMany Users
17.  
18. Group:
19.  tableName: groups
20.  columns:
21.     id:
22.      primary: true
23.      autoincrement: true
24.      type: integer(4)
25.     name: string(255)
26.  
27. UserGroup:
28.  columns:
29.     user_id:
30.      type: integer(4)
31.      primary: true
32.     group_id:
33.      type: integer(4)
34.      primary: true
35.  relations:
36.     User:
37.      local: user_id        # Local key
38.      foreign: id          # Foreign key
39.      onDelete: CASCADE     # Database constraint
40.     Group:
41.      local: group_id
42.      foreign: id
43.      onDelete: CASCADE

* This source code was highlighted with Source Code Highlighter.

$ php doctrine generate-models-yaml<br>generate-models-yaml - Generated models successfully from YAML schema<br><br>* This source code was highlighted with Source Code Highlighter.

1. ---
2. User:
3.  jwage:
4.     username: jwage
5.     password: test

* This source code was highlighted with Source Code Highlighter.

$ php doctrine build-all-reload<br>build-all-reload - Are you sure you wish to drop your databases? (y/n)<br>y<br><br>* This source code was highlighted with Source Code Highlighter.

1. $user = new User();
2. $user->username = 'zYne-';
3. $user->setPassword('password');
4. $user->save();
5.  
6. $userTable = Doctrine::getTable('User');
7. $user = $userTable->findOneByUsername('zYne-');
8.  
9. echo $user->username; // prints 'zYne-'

* This source code was highlighted with Source Code Highlighter.