Completed
Pull Request — 4.0 (#48)
by Marc
04:00
created
src/Mouf/Database/TDBM/Controllers/TdbmInstallController.php 1 patch
Indentation   +174 added lines, -174 removed lines patch added patch discarded remove patch
@@ -15,178 +15,178 @@
 block discarded – undo
15 15
  */
16 16
 class TdbmInstallController extends Controller
17 17
 {
18
-    /**
19
-     * @var HtmlBlock
20
-     */
21
-    public $content;
22
-
23
-    public $selfedit;
24
-
25
-    /**
26
-     * The active MoufManager to be edited/viewed.
27
-     *
28
-     * @var MoufManager
29
-     */
30
-    public $moufManager;
31
-
32
-    /**
33
-     * The template used by the main page for mouf.
34
-     *
35
-     * @Property
36
-     * @Compulsory
37
-     *
38
-     * @var TemplateInterface
39
-     */
40
-    public $template;
41
-
42
-    /**
43
-     * Displays the first install screen.
44
-     *
45
-     * @Action
46
-     * @Logged
47
-     *
48
-     * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
49
-     */
50
-    public function defaultAction($selfedit = 'false')
51
-    {
52
-        $this->selfedit = $selfedit;
53
-
54
-        if ($selfedit == 'true') {
55
-            $this->moufManager = MoufManager::getMoufManager();
56
-        } else {
57
-            $this->moufManager = MoufManager::getMoufManagerHiddenInstance();
58
-        }
59
-
60
-        $this->content->addFile(dirname(__FILE__).'/../../../../views/installStep1.php', $this);
61
-        $this->template->toHtml();
62
-    }
63
-
64
-    /**
65
-     * Skips the install process.
66
-     *
67
-     * @Action
68
-     * @Logged
69
-     *
70
-     * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
71
-     */
72
-    public function skip($selfedit = 'false')
73
-    {
74
-        InstallUtils::continueInstall($selfedit == 'true');
75
-    }
76
-
77
-    protected $daoNamespace;
78
-    protected $beanNamespace;
79
-    protected $autoloadDetected;
80
-    protected $storeInUtc;
81
-
82
-    /**
83
-     * Displays the second install screen.
84
-     *
85
-     * @Action
86
-     * @Logged
87
-     *
88
-     * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
89
-     */
90
-    public function configure($selfedit = 'false')
91
-    {
92
-        $this->selfedit = $selfedit;
93
-
94
-        if ($selfedit == 'true') {
95
-            $this->moufManager = MoufManager::getMoufManager();
96
-        } else {
97
-            $this->moufManager = MoufManager::getMoufManagerHiddenInstance();
98
-        }
99
-
100
-        // Let's start by performing basic checks about the instances we assume to exist.
101
-        if (!$this->moufManager->instanceExists('dbalConnection')) {
102
-            $this->displayErrorMsg("The TDBM install process assumes your database connection instance is already created, and that the name of this instance is 'dbalConnection'. Could not find the 'dbalConnection' instance.");
103
-
104
-            return;
105
-        }
106
-
107
-        if (!$this->moufManager->instanceExists('noCacheService')) {
108
-            $this->displayErrorMsg("The TDBM install process assumes that a cache instance named 'noCacheService' exists. Could not find the 'noCacheService' instance.");
109
-
110
-            return;
111
-        }
112
-
113
-        $this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace_tdbmService');
114
-        $this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace_tdbmService');
115
-
116
-        if ($this->daoNamespace == null && $this->beanNamespace == null) {
117
-            $classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json');
118
-
119
-            $autoloadNamespaces = $classNameMapper->getManagedNamespaces();
120
-            if ($autoloadNamespaces) {
121
-                $this->autoloadDetected = true;
122
-                $rootNamespace = $autoloadNamespaces[0];
123
-                $this->daoNamespace = $rootNamespace.'Dao';
124
-                $this->beanNamespace = $rootNamespace.'Dao\\Bean';
125
-            } else {
126
-                $this->autoloadDetected = false;
127
-                $this->daoNamespace = 'YourApplication\\Dao';
128
-                $this->beanNamespace = 'YourApplication\\Dao\\Bean';
129
-            }
130
-        } else {
131
-            $this->autoloadDetected = true;
132
-        }
133
-        $this->defaultPath = true;
134
-        $this->storePath = '';
135
-
136
-        $this->castDatesToDateTime = true;
137
-
138
-        $this->content->addFile(dirname(__FILE__).'/../../../../views/installStep2.php', $this);
139
-        $this->template->toHtml();
140
-    }
141
-
142
-    /**
143
-     * This action generates the TDBM instance, then the DAOs and Beans.
144
-     *
145
-     * @Action
146
-     *
147
-     * @param string $daonamespace
148
-     * @param string $beannamespace
149
-     * @param int    $storeInUtc
150
-     * @param string $selfedit
151
-     *
152
-     * @throws \Mouf\MoufException
153
-     */
154
-    public function generate($daonamespace, $beannamespace, $storeInUtc = 0, $selfedit = 'false', $defaultPath = false, $storePath = '')
155
-    {
156
-        $this->selfedit = $selfedit;
157
-
158
-        if ($selfedit == 'true') {
159
-            $this->moufManager = MoufManager::getMoufManager();
160
-        } else {
161
-            $this->moufManager = MoufManager::getMoufManagerHiddenInstance();
162
-        }
163
-
164
-        if (!$this->moufManager->instanceExists('doctrineApcCache')) {
165
-            $doctrineApcCache = $this->moufManager->createInstance('Doctrine\\Common\\Cache\\ApcCache')->setName('doctrineApcCache');
166
-            // TODO: set namespace
167
-        } else {
168
-            $doctrineApcCache = $this->moufManager->getInstanceDescriptor('doctrineApcCache');
169
-        }
170
-
171
-        if (!$this->moufManager->instanceExists('tdbmService')) {
172
-            $tdbmService = $this->moufManager->createInstance('Mouf\\Database\\TDBM\\TDBMService')->setName('tdbmService');
173
-            $tdbmService->getConstructorArgumentProperty('connection')->setValue($this->moufManager->getInstanceDescriptor('dbalConnection'));
174
-            $tdbmService->getConstructorArgumentProperty('cache')->setValue($doctrineApcCache);
175
-        }
176
-
177
-        $this->moufManager->rewriteMouf();
178
-
179
-        TdbmController::generateDaos($this->moufManager, 'tdbmService', $daonamespace, $beannamespace, 'DaoFactory', 'daoFactory', $selfedit, $storeInUtc, $defaultPath, $storePath);
180
-
181
-        InstallUtils::continueInstall($selfedit == 'true');
182
-    }
183
-
184
-    protected $errorMsg;
185
-
186
-    private function displayErrorMsg($msg)
187
-    {
188
-        $this->errorMsg = $msg;
189
-        $this->content->addFile(dirname(__FILE__).'/../../../../views/installError.php', $this);
190
-        $this->template->toHtml();
191
-    }
18
+	/**
19
+	 * @var HtmlBlock
20
+	 */
21
+	public $content;
22
+
23
+	public $selfedit;
24
+
25
+	/**
26
+	 * The active MoufManager to be edited/viewed.
27
+	 *
28
+	 * @var MoufManager
29
+	 */
30
+	public $moufManager;
31
+
32
+	/**
33
+	 * The template used by the main page for mouf.
34
+	 *
35
+	 * @Property
36
+	 * @Compulsory
37
+	 *
38
+	 * @var TemplateInterface
39
+	 */
40
+	public $template;
41
+
42
+	/**
43
+	 * Displays the first install screen.
44
+	 *
45
+	 * @Action
46
+	 * @Logged
47
+	 *
48
+	 * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
49
+	 */
50
+	public function defaultAction($selfedit = 'false')
51
+	{
52
+		$this->selfedit = $selfedit;
53
+
54
+		if ($selfedit == 'true') {
55
+			$this->moufManager = MoufManager::getMoufManager();
56
+		} else {
57
+			$this->moufManager = MoufManager::getMoufManagerHiddenInstance();
58
+		}
59
+
60
+		$this->content->addFile(dirname(__FILE__).'/../../../../views/installStep1.php', $this);
61
+		$this->template->toHtml();
62
+	}
63
+
64
+	/**
65
+	 * Skips the install process.
66
+	 *
67
+	 * @Action
68
+	 * @Logged
69
+	 *
70
+	 * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
71
+	 */
72
+	public function skip($selfedit = 'false')
73
+	{
74
+		InstallUtils::continueInstall($selfedit == 'true');
75
+	}
76
+
77
+	protected $daoNamespace;
78
+	protected $beanNamespace;
79
+	protected $autoloadDetected;
80
+	protected $storeInUtc;
81
+
82
+	/**
83
+	 * Displays the second install screen.
84
+	 *
85
+	 * @Action
86
+	 * @Logged
87
+	 *
88
+	 * @param string $selfedit If true, the name of the component must be a component from the Mouf framework itself (internal use only)
89
+	 */
90
+	public function configure($selfedit = 'false')
91
+	{
92
+		$this->selfedit = $selfedit;
93
+
94
+		if ($selfedit == 'true') {
95
+			$this->moufManager = MoufManager::getMoufManager();
96
+		} else {
97
+			$this->moufManager = MoufManager::getMoufManagerHiddenInstance();
98
+		}
99
+
100
+		// Let's start by performing basic checks about the instances we assume to exist.
101
+		if (!$this->moufManager->instanceExists('dbalConnection')) {
102
+			$this->displayErrorMsg("The TDBM install process assumes your database connection instance is already created, and that the name of this instance is 'dbalConnection'. Could not find the 'dbalConnection' instance.");
103
+
104
+			return;
105
+		}
106
+
107
+		if (!$this->moufManager->instanceExists('noCacheService')) {
108
+			$this->displayErrorMsg("The TDBM install process assumes that a cache instance named 'noCacheService' exists. Could not find the 'noCacheService' instance.");
109
+
110
+			return;
111
+		}
112
+
113
+		$this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace_tdbmService');
114
+		$this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace_tdbmService');
115
+
116
+		if ($this->daoNamespace == null && $this->beanNamespace == null) {
117
+			$classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json');
118
+
119
+			$autoloadNamespaces = $classNameMapper->getManagedNamespaces();
120
+			if ($autoloadNamespaces) {
121
+				$this->autoloadDetected = true;
122
+				$rootNamespace = $autoloadNamespaces[0];
123
+				$this->daoNamespace = $rootNamespace.'Dao';
124
+				$this->beanNamespace = $rootNamespace.'Dao\\Bean';
125
+			} else {
126
+				$this->autoloadDetected = false;
127
+				$this->daoNamespace = 'YourApplication\\Dao';
128
+				$this->beanNamespace = 'YourApplication\\Dao\\Bean';
129
+			}
130
+		} else {
131
+			$this->autoloadDetected = true;
132
+		}
133
+		$this->defaultPath = true;
134
+		$this->storePath = '';
135
+
136
+		$this->castDatesToDateTime = true;
137
+
138
+		$this->content->addFile(dirname(__FILE__).'/../../../../views/installStep2.php', $this);
139
+		$this->template->toHtml();
140
+	}
141
+
142
+	/**
143
+	 * This action generates the TDBM instance, then the DAOs and Beans.
144
+	 *
145
+	 * @Action
146
+	 *
147
+	 * @param string $daonamespace
148
+	 * @param string $beannamespace
149
+	 * @param int    $storeInUtc
150
+	 * @param string $selfedit
151
+	 *
152
+	 * @throws \Mouf\MoufException
153
+	 */
154
+	public function generate($daonamespace, $beannamespace, $storeInUtc = 0, $selfedit = 'false', $defaultPath = false, $storePath = '')
155
+	{
156
+		$this->selfedit = $selfedit;
157
+
158
+		if ($selfedit == 'true') {
159
+			$this->moufManager = MoufManager::getMoufManager();
160
+		} else {
161
+			$this->moufManager = MoufManager::getMoufManagerHiddenInstance();
162
+		}
163
+
164
+		if (!$this->moufManager->instanceExists('doctrineApcCache')) {
165
+			$doctrineApcCache = $this->moufManager->createInstance('Doctrine\\Common\\Cache\\ApcCache')->setName('doctrineApcCache');
166
+			// TODO: set namespace
167
+		} else {
168
+			$doctrineApcCache = $this->moufManager->getInstanceDescriptor('doctrineApcCache');
169
+		}
170
+
171
+		if (!$this->moufManager->instanceExists('tdbmService')) {
172
+			$tdbmService = $this->moufManager->createInstance('Mouf\\Database\\TDBM\\TDBMService')->setName('tdbmService');
173
+			$tdbmService->getConstructorArgumentProperty('connection')->setValue($this->moufManager->getInstanceDescriptor('dbalConnection'));
174
+			$tdbmService->getConstructorArgumentProperty('cache')->setValue($doctrineApcCache);
175
+		}
176
+
177
+		$this->moufManager->rewriteMouf();
178
+
179
+		TdbmController::generateDaos($this->moufManager, 'tdbmService', $daonamespace, $beannamespace, 'DaoFactory', 'daoFactory', $selfedit, $storeInUtc, $defaultPath, $storePath);
180
+
181
+		InstallUtils::continueInstall($selfedit == 'true');
182
+	}
183
+
184
+	protected $errorMsg;
185
+
186
+	private function displayErrorMsg($msg)
187
+	{
188
+		$this->errorMsg = $msg;
189
+		$this->content->addFile(dirname(__FILE__).'/../../../../views/installError.php', $this);
190
+		$this->template->toHtml();
191
+	}
192 192
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/Utils/TDBMDaoGenerator.php 2 patches
Doc Comments   +6 added lines, -3 removed lines patch added patch discarded remove patch
@@ -155,7 +155,7 @@  discard block
 block discarded – undo
155 155
     /**
156 156
      * Returns the name of the base bean class from the table name.
157 157
      *
158
-     * @param $tableName
158
+     * @param string $tableName
159 159
      *
160 160
      * @return string
161 161
      */
@@ -167,7 +167,7 @@  discard block
 block discarded – undo
167 167
     /**
168 168
      * Returns the name of the base DAO class from the table name.
169 169
      *
170
-     * @param $tableName
170
+     * @param string $tableName
171 171
      *
172 172
      * @return string
173 173
      */
@@ -185,6 +185,7 @@  discard block
 block discarded – undo
185 185
      * @param Table           $table           The table
186 186
      * @param string          $beannamespace   The namespace of the bean
187 187
      * @param ClassNameMapper $classNameMapper
188
+     * @param boolean $storeInUtc
188 189
      *
189 190
      * @throws TDBMException
190 191
      */
@@ -501,6 +502,8 @@  discard block
 block discarded – undo
501 502
      * Generates the factory bean.
502 503
      *
503 504
      * @param Table[] $tableList
505
+     * @param string $daoFactoryClassName
506
+     * @param string $daoNamespace
504 507
      */
505 508
     private function generateFactory(array $tableList, $daoFactoryClassName, $daoNamespace, ClassNameMapper $classNameMapper)
506 509
     {
@@ -647,7 +650,7 @@  discard block
 block discarded – undo
647 650
     /**
648 651
      * Absolute path to composer json file.
649 652
      *
650
-     * @param string $rootPath
653
+     * @param string $composerFile
651 654
      */
652 655
     public function setComposerFile($composerFile)
653 656
     {
Please login to merge, or discard this patch.
Indentation   +466 added lines, -466 removed lines patch added patch discarded remove patch
@@ -17,201 +17,201 @@  discard block
 block discarded – undo
17 17
  */
18 18
 class TDBMDaoGenerator
19 19
 {
20
-    /**
21
-     * @var SchemaAnalyzer
22
-     */
23
-    private $schemaAnalyzer;
24
-
25
-    /**
26
-     * @var Schema
27
-     */
28
-    private $schema;
29
-
30
-    /**
31
-     * The root directory of the project.
32
-     *
33
-     * @var string
34
-     */
35
-    private $rootPath;
36
-
37
-    /**
38
-     * Name of composer file.
39
-     *
40
-     * @var string
41
-     */
42
-    private $composerFile;
43
-
44
-    /**
45
-     * @var TDBMSchemaAnalyzer
46
-     */
47
-    private $tdbmSchemaAnalyzer;
48
-
49
-    /**
50
-     * Constructor.
51
-     *
52
-     * @param SchemaAnalyzer     $schemaAnalyzer
53
-     * @param Schema             $schema
54
-     * @param TDBMSchemaAnalyzer $tdbmSchemaAnalyzer
55
-     */
56
-    public function __construct(SchemaAnalyzer $schemaAnalyzer, Schema $schema, TDBMSchemaAnalyzer $tdbmSchemaAnalyzer)
57
-    {
58
-        $this->schemaAnalyzer = $schemaAnalyzer;
59
-        $this->schema = $schema;
60
-        $this->tdbmSchemaAnalyzer = $tdbmSchemaAnalyzer;
61
-        $this->rootPath = __DIR__.'/../../../../../../../../';
62
-        $this->composerFile = 'composer.json';
63
-    }
64
-
65
-    /**
66
-     * Generates all the daos and beans.
67
-     *
68
-     * @param string $daoFactoryClassName The classe name of the DAO factory
69
-     * @param string $daonamespace        The namespace for the DAOs, without trailing \
70
-     * @param string $beannamespace       The Namespace for the beans, without trailing \
71
-     * @param bool   $storeInUtc          If the generated daos should store the date in UTC timezone instead of user's timezone.
72
-     *
73
-     * @return \string[] the list of tables
74
-     *
75
-     * @throws TDBMException
76
-     */
77
-    public function generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc)
78
-    {
79
-        // TODO: extract ClassNameMapper in its own package!
80
-        $classNameMapper = ClassNameMapper::createFromComposerFile($this->rootPath.$this->composerFile);
81
-        // TODO: check that no class name ends with "Base". Otherwise, there will be name clash.
82
-
83
-        $tableList = $this->schema->getTables();
84
-
85
-        // Remove all beans and daos from junction tables
86
-        $junctionTables = $this->schemaAnalyzer->detectJunctionTables();
87
-        $junctionTableNames = array_map(function (Table $table) {
88
-            return $table->getName();
89
-        }, $junctionTables);
90
-
91
-        $tableList = array_filter($tableList, function (Table $table) use ($junctionTableNames) {
92
-            return !in_array($table->getName(), $junctionTableNames);
93
-        });
94
-
95
-        foreach ($tableList as $table) {
96
-            $this->generateDaoAndBean($table, $daonamespace, $beannamespace, $classNameMapper, $storeInUtc);
97
-        }
98
-
99
-        $this->generateFactory($tableList, $daoFactoryClassName, $daonamespace, $classNameMapper);
100
-
101
-        // Ok, let's return the list of all tables.
102
-        // These will be used by the calling script to create Mouf instances.
103
-
104
-        return array_map(function (Table $table) { return $table->getName(); }, $tableList);
105
-    }
106
-
107
-    /**
108
-     * Generates in one method call the daos and the beans for one table.
109
-     *
110
-     * @param Table           $table
111
-     * @param string          $daonamespace
112
-     * @param string          $beannamespace
113
-     * @param ClassNameMapper $classNameMapper
114
-     * @param bool            $storeInUtc
115
-     *
116
-     * @throws TDBMException
117
-     */
118
-    public function generateDaoAndBean(Table $table, $daonamespace, $beannamespace, ClassNameMapper $classNameMapper, $storeInUtc)
119
-    {
120
-        $tableName = $table->getName();
121
-        $daoName = $this->getDaoNameFromTableName($tableName);
122
-        $beanName = $this->getBeanNameFromTableName($tableName);
123
-        $baseBeanName = $this->getBaseBeanNameFromTableName($tableName);
124
-        $baseDaoName = $this->getBaseDaoNameFromTableName($tableName);
125
-
126
-        $beanDescriptor = new BeanDescriptor($table, $this->schemaAnalyzer, $this->schema, $this->tdbmSchemaAnalyzer);
127
-        $this->generateBean($beanDescriptor, $beanName, $baseBeanName, $table, $beannamespace, $classNameMapper, $storeInUtc);
128
-        $this->generateDao($beanDescriptor, $daoName, $baseDaoName, $beanName, $table, $daonamespace, $beannamespace, $classNameMapper);
129
-    }
130
-
131
-    /**
132
-     * Returns the name of the bean class from the table name.
133
-     *
134
-     * @param $tableName
135
-     *
136
-     * @return string
137
-     */
138
-    public static function getBeanNameFromTableName($tableName)
139
-    {
140
-        return self::toSingular(self::toCamelCase($tableName)).'Bean';
141
-    }
142
-
143
-    /**
144
-     * Returns the name of the DAO class from the table name.
145
-     *
146
-     * @param $tableName
147
-     *
148
-     * @return string
149
-     */
150
-    public static function getDaoNameFromTableName($tableName)
151
-    {
152
-        return self::toSingular(self::toCamelCase($tableName)).'Dao';
153
-    }
154
-
155
-    /**
156
-     * Returns the name of the base bean class from the table name.
157
-     *
158
-     * @param $tableName
159
-     *
160
-     * @return string
161
-     */
162
-    public static function getBaseBeanNameFromTableName($tableName)
163
-    {
164
-        return self::toSingular(self::toCamelCase($tableName)).'BaseBean';
165
-    }
166
-
167
-    /**
168
-     * Returns the name of the base DAO class from the table name.
169
-     *
170
-     * @param $tableName
171
-     *
172
-     * @return string
173
-     */
174
-    public static function getBaseDaoNameFromTableName($tableName)
175
-    {
176
-        return self::toSingular(self::toCamelCase($tableName)).'BaseDao';
177
-    }
178
-
179
-    /**
180
-     * Writes the PHP bean file with all getters and setters from the table passed in parameter.
181
-     *
182
-     * @param BeanDescriptor  $beanDescriptor
183
-     * @param string          $className       The name of the class
184
-     * @param string          $baseClassName   The name of the base class which will be extended (name only, no directory)
185
-     * @param Table           $table           The table
186
-     * @param string          $beannamespace   The namespace of the bean
187
-     * @param ClassNameMapper $classNameMapper
188
-     *
189
-     * @throws TDBMException
190
-     */
191
-    public function generateBean(BeanDescriptor $beanDescriptor, $className, $baseClassName, Table $table, $beannamespace, ClassNameMapper $classNameMapper, $storeInUtc)
192
-    {
193
-        $str = $beanDescriptor->generatePhpCode($beannamespace);
194
-
195
-        $possibleBaseFileNames = $classNameMapper->getPossibleFileNames($beannamespace.'\\'.$baseClassName);
196
-        if (empty($possibleBaseFileNames)) {
197
-            throw new TDBMException('Sorry, autoload namespace issue. The class "'.$beannamespace.'\\'.$baseClassName.'" is not autoloadable.');
198
-        }
199
-        $possibleBaseFileName = $this->rootPath.$possibleBaseFileNames[0];
200
-
201
-        $this->ensureDirectoryExist($possibleBaseFileName);
202
-        file_put_contents($possibleBaseFileName, $str);
203
-        @chmod($possibleBaseFileName, 0664);
204
-
205
-        $possibleFileNames = $classNameMapper->getPossibleFileNames($beannamespace.'\\'.$className);
206
-        if (empty($possibleFileNames)) {
207
-            // @codeCoverageIgnoreStart
208
-            throw new TDBMException('Sorry, autoload namespace issue. The class "'.$beannamespace.'\\'.$className.'" is not autoloadable.');
209
-            // @codeCoverageIgnoreEnd
210
-        }
211
-        $possibleFileName = $this->rootPath.$possibleFileNames[0];
212
-        if (!file_exists($possibleFileName)) {
213
-            $tableName = $table->getName();
214
-            $str = "<?php
20
+	/**
21
+	 * @var SchemaAnalyzer
22
+	 */
23
+	private $schemaAnalyzer;
24
+
25
+	/**
26
+	 * @var Schema
27
+	 */
28
+	private $schema;
29
+
30
+	/**
31
+	 * The root directory of the project.
32
+	 *
33
+	 * @var string
34
+	 */
35
+	private $rootPath;
36
+
37
+	/**
38
+	 * Name of composer file.
39
+	 *
40
+	 * @var string
41
+	 */
42
+	private $composerFile;
43
+
44
+	/**
45
+	 * @var TDBMSchemaAnalyzer
46
+	 */
47
+	private $tdbmSchemaAnalyzer;
48
+
49
+	/**
50
+	 * Constructor.
51
+	 *
52
+	 * @param SchemaAnalyzer     $schemaAnalyzer
53
+	 * @param Schema             $schema
54
+	 * @param TDBMSchemaAnalyzer $tdbmSchemaAnalyzer
55
+	 */
56
+	public function __construct(SchemaAnalyzer $schemaAnalyzer, Schema $schema, TDBMSchemaAnalyzer $tdbmSchemaAnalyzer)
57
+	{
58
+		$this->schemaAnalyzer = $schemaAnalyzer;
59
+		$this->schema = $schema;
60
+		$this->tdbmSchemaAnalyzer = $tdbmSchemaAnalyzer;
61
+		$this->rootPath = __DIR__.'/../../../../../../../../';
62
+		$this->composerFile = 'composer.json';
63
+	}
64
+
65
+	/**
66
+	 * Generates all the daos and beans.
67
+	 *
68
+	 * @param string $daoFactoryClassName The classe name of the DAO factory
69
+	 * @param string $daonamespace        The namespace for the DAOs, without trailing \
70
+	 * @param string $beannamespace       The Namespace for the beans, without trailing \
71
+	 * @param bool   $storeInUtc          If the generated daos should store the date in UTC timezone instead of user's timezone.
72
+	 *
73
+	 * @return \string[] the list of tables
74
+	 *
75
+	 * @throws TDBMException
76
+	 */
77
+	public function generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc)
78
+	{
79
+		// TODO: extract ClassNameMapper in its own package!
80
+		$classNameMapper = ClassNameMapper::createFromComposerFile($this->rootPath.$this->composerFile);
81
+		// TODO: check that no class name ends with "Base". Otherwise, there will be name clash.
82
+
83
+		$tableList = $this->schema->getTables();
84
+
85
+		// Remove all beans and daos from junction tables
86
+		$junctionTables = $this->schemaAnalyzer->detectJunctionTables();
87
+		$junctionTableNames = array_map(function (Table $table) {
88
+			return $table->getName();
89
+		}, $junctionTables);
90
+
91
+		$tableList = array_filter($tableList, function (Table $table) use ($junctionTableNames) {
92
+			return !in_array($table->getName(), $junctionTableNames);
93
+		});
94
+
95
+		foreach ($tableList as $table) {
96
+			$this->generateDaoAndBean($table, $daonamespace, $beannamespace, $classNameMapper, $storeInUtc);
97
+		}
98
+
99
+		$this->generateFactory($tableList, $daoFactoryClassName, $daonamespace, $classNameMapper);
100
+
101
+		// Ok, let's return the list of all tables.
102
+		// These will be used by the calling script to create Mouf instances.
103
+
104
+		return array_map(function (Table $table) { return $table->getName(); }, $tableList);
105
+	}
106
+
107
+	/**
108
+	 * Generates in one method call the daos and the beans for one table.
109
+	 *
110
+	 * @param Table           $table
111
+	 * @param string          $daonamespace
112
+	 * @param string          $beannamespace
113
+	 * @param ClassNameMapper $classNameMapper
114
+	 * @param bool            $storeInUtc
115
+	 *
116
+	 * @throws TDBMException
117
+	 */
118
+	public function generateDaoAndBean(Table $table, $daonamespace, $beannamespace, ClassNameMapper $classNameMapper, $storeInUtc)
119
+	{
120
+		$tableName = $table->getName();
121
+		$daoName = $this->getDaoNameFromTableName($tableName);
122
+		$beanName = $this->getBeanNameFromTableName($tableName);
123
+		$baseBeanName = $this->getBaseBeanNameFromTableName($tableName);
124
+		$baseDaoName = $this->getBaseDaoNameFromTableName($tableName);
125
+
126
+		$beanDescriptor = new BeanDescriptor($table, $this->schemaAnalyzer, $this->schema, $this->tdbmSchemaAnalyzer);
127
+		$this->generateBean($beanDescriptor, $beanName, $baseBeanName, $table, $beannamespace, $classNameMapper, $storeInUtc);
128
+		$this->generateDao($beanDescriptor, $daoName, $baseDaoName, $beanName, $table, $daonamespace, $beannamespace, $classNameMapper);
129
+	}
130
+
131
+	/**
132
+	 * Returns the name of the bean class from the table name.
133
+	 *
134
+	 * @param $tableName
135
+	 *
136
+	 * @return string
137
+	 */
138
+	public static function getBeanNameFromTableName($tableName)
139
+	{
140
+		return self::toSingular(self::toCamelCase($tableName)).'Bean';
141
+	}
142
+
143
+	/**
144
+	 * Returns the name of the DAO class from the table name.
145
+	 *
146
+	 * @param $tableName
147
+	 *
148
+	 * @return string
149
+	 */
150
+	public static function getDaoNameFromTableName($tableName)
151
+	{
152
+		return self::toSingular(self::toCamelCase($tableName)).'Dao';
153
+	}
154
+
155
+	/**
156
+	 * Returns the name of the base bean class from the table name.
157
+	 *
158
+	 * @param $tableName
159
+	 *
160
+	 * @return string
161
+	 */
162
+	public static function getBaseBeanNameFromTableName($tableName)
163
+	{
164
+		return self::toSingular(self::toCamelCase($tableName)).'BaseBean';
165
+	}
166
+
167
+	/**
168
+	 * Returns the name of the base DAO class from the table name.
169
+	 *
170
+	 * @param $tableName
171
+	 *
172
+	 * @return string
173
+	 */
174
+	public static function getBaseDaoNameFromTableName($tableName)
175
+	{
176
+		return self::toSingular(self::toCamelCase($tableName)).'BaseDao';
177
+	}
178
+
179
+	/**
180
+	 * Writes the PHP bean file with all getters and setters from the table passed in parameter.
181
+	 *
182
+	 * @param BeanDescriptor  $beanDescriptor
183
+	 * @param string          $className       The name of the class
184
+	 * @param string          $baseClassName   The name of the base class which will be extended (name only, no directory)
185
+	 * @param Table           $table           The table
186
+	 * @param string          $beannamespace   The namespace of the bean
187
+	 * @param ClassNameMapper $classNameMapper
188
+	 *
189
+	 * @throws TDBMException
190
+	 */
191
+	public function generateBean(BeanDescriptor $beanDescriptor, $className, $baseClassName, Table $table, $beannamespace, ClassNameMapper $classNameMapper, $storeInUtc)
192
+	{
193
+		$str = $beanDescriptor->generatePhpCode($beannamespace);
194
+
195
+		$possibleBaseFileNames = $classNameMapper->getPossibleFileNames($beannamespace.'\\'.$baseClassName);
196
+		if (empty($possibleBaseFileNames)) {
197
+			throw new TDBMException('Sorry, autoload namespace issue. The class "'.$beannamespace.'\\'.$baseClassName.'" is not autoloadable.');
198
+		}
199
+		$possibleBaseFileName = $this->rootPath.$possibleBaseFileNames[0];
200
+
201
+		$this->ensureDirectoryExist($possibleBaseFileName);
202
+		file_put_contents($possibleBaseFileName, $str);
203
+		@chmod($possibleBaseFileName, 0664);
204
+
205
+		$possibleFileNames = $classNameMapper->getPossibleFileNames($beannamespace.'\\'.$className);
206
+		if (empty($possibleFileNames)) {
207
+			// @codeCoverageIgnoreStart
208
+			throw new TDBMException('Sorry, autoload namespace issue. The class "'.$beannamespace.'\\'.$className.'" is not autoloadable.');
209
+			// @codeCoverageIgnoreEnd
210
+		}
211
+		$possibleFileName = $this->rootPath.$possibleFileNames[0];
212
+		if (!file_exists($possibleFileName)) {
213
+			$tableName = $table->getName();
214
+			$str = "<?php
215 215
 /*
216 216
  * This file has been automatically generated by TDBM.
217 217
  * You can edit this file as it will not be overwritten.
@@ -226,76 +226,76 @@  discard block
 block discarded – undo
226 226
 {
227 227
 
228 228
 }";
229
-            $this->ensureDirectoryExist($possibleFileName);
230
-            file_put_contents($possibleFileName, $str);
231
-            @chmod($possibleFileName, 0664);
232
-        }
233
-    }
234
-
235
-    /**
236
-     * Tries to find a @defaultSort annotation in one of the columns.
237
-     *
238
-     * @param Table $table
239
-     *
240
-     * @return array First item: column name, Second item: column order (asc/desc)
241
-     */
242
-    private function getDefaultSortColumnFromAnnotation(Table $table)
243
-    {
244
-        $defaultSort = null;
245
-        $defaultSortDirection = null;
246
-        foreach ($table->getColumns() as $column) {
247
-            $comments = $column->getComment();
248
-            $matches = [];
249
-            if (preg_match('/@defaultSort(\((desc|asc)\))*/', $comments, $matches) != 0) {
250
-                $defaultSort = $column->getName();
251
-                if (count($matches) === 3) {
252
-                    $defaultSortDirection = $matches[2];
253
-                } else {
254
-                    $defaultSortDirection = 'ASC';
255
-                }
256
-            }
257
-        }
258
-
259
-        return [$defaultSort, $defaultSortDirection];
260
-    }
261
-
262
-    /**
263
-     * Writes the PHP bean DAO with simple functions to create/get/save objects.
264
-     *
265
-     * @param BeanDescriptor  $beanDescriptor
266
-     * @param string          $className       The name of the class
267
-     * @param string          $baseClassName
268
-     * @param string          $beanClassName
269
-     * @param Table           $table
270
-     * @param string          $daonamespace
271
-     * @param string          $beannamespace
272
-     * @param ClassNameMapper $classNameMapper
273
-     *
274
-     * @throws TDBMException
275
-     */
276
-    public function generateDao(BeanDescriptor $beanDescriptor, $className, $baseClassName, $beanClassName, Table $table, $daonamespace, $beannamespace, ClassNameMapper $classNameMapper)
277
-    {
278
-        $tableName = $table->getName();
279
-        $primaryKeyColumns = $table->getPrimaryKeyColumns();
280
-
281
-        list($defaultSort, $defaultSortDirection) = $this->getDefaultSortColumnFromAnnotation($table);
282
-
283
-        // FIXME: lowercase tables with _ in the name should work!
284
-        $tableCamel = self::toSingular(self::toCamelCase($tableName));
285
-
286
-        $beanClassWithoutNameSpace = $beanClassName;
287
-        $beanClassName = $beannamespace.'\\'.$beanClassName;
288
-
289
-        list($usedBeans, $findByDaoCode) = $beanDescriptor->generateFindByDaoCode($beannamespace, $beanClassWithoutNameSpace);
290
-
291
-        $usedBeans[] = $beanClassName;
292
-        // Let's suppress duplicates in used beans (if any)
293
-        $usedBeans = array_flip(array_flip($usedBeans));
294
-        $useStatements = array_map(function ($usedBean) {
295
-            return "use $usedBean;\n";
296
-        }, $usedBeans);
297
-
298
-        $str = "<?php
229
+			$this->ensureDirectoryExist($possibleFileName);
230
+			file_put_contents($possibleFileName, $str);
231
+			@chmod($possibleFileName, 0664);
232
+		}
233
+	}
234
+
235
+	/**
236
+	 * Tries to find a @defaultSort annotation in one of the columns.
237
+	 *
238
+	 * @param Table $table
239
+	 *
240
+	 * @return array First item: column name, Second item: column order (asc/desc)
241
+	 */
242
+	private function getDefaultSortColumnFromAnnotation(Table $table)
243
+	{
244
+		$defaultSort = null;
245
+		$defaultSortDirection = null;
246
+		foreach ($table->getColumns() as $column) {
247
+			$comments = $column->getComment();
248
+			$matches = [];
249
+			if (preg_match('/@defaultSort(\((desc|asc)\))*/', $comments, $matches) != 0) {
250
+				$defaultSort = $column->getName();
251
+				if (count($matches) === 3) {
252
+					$defaultSortDirection = $matches[2];
253
+				} else {
254
+					$defaultSortDirection = 'ASC';
255
+				}
256
+			}
257
+		}
258
+
259
+		return [$defaultSort, $defaultSortDirection];
260
+	}
261
+
262
+	/**
263
+	 * Writes the PHP bean DAO with simple functions to create/get/save objects.
264
+	 *
265
+	 * @param BeanDescriptor  $beanDescriptor
266
+	 * @param string          $className       The name of the class
267
+	 * @param string          $baseClassName
268
+	 * @param string          $beanClassName
269
+	 * @param Table           $table
270
+	 * @param string          $daonamespace
271
+	 * @param string          $beannamespace
272
+	 * @param ClassNameMapper $classNameMapper
273
+	 *
274
+	 * @throws TDBMException
275
+	 */
276
+	public function generateDao(BeanDescriptor $beanDescriptor, $className, $baseClassName, $beanClassName, Table $table, $daonamespace, $beannamespace, ClassNameMapper $classNameMapper)
277
+	{
278
+		$tableName = $table->getName();
279
+		$primaryKeyColumns = $table->getPrimaryKeyColumns();
280
+
281
+		list($defaultSort, $defaultSortDirection) = $this->getDefaultSortColumnFromAnnotation($table);
282
+
283
+		// FIXME: lowercase tables with _ in the name should work!
284
+		$tableCamel = self::toSingular(self::toCamelCase($tableName));
285
+
286
+		$beanClassWithoutNameSpace = $beanClassName;
287
+		$beanClassName = $beannamespace.'\\'.$beanClassName;
288
+
289
+		list($usedBeans, $findByDaoCode) = $beanDescriptor->generateFindByDaoCode($beannamespace, $beanClassWithoutNameSpace);
290
+
291
+		$usedBeans[] = $beanClassName;
292
+		// Let's suppress duplicates in used beans (if any)
293
+		$usedBeans = array_flip(array_flip($usedBeans));
294
+		$useStatements = array_map(function ($usedBean) {
295
+			return "use $usedBean;\n";
296
+		}, $usedBeans);
297
+
298
+		$str = "<?php
299 299
 
300 300
 /*
301 301
  * This file has been automatically generated by TDBM.
@@ -372,9 +372,9 @@  discard block
 block discarded – undo
372 372
     }
373 373
     ";
374 374
 
375
-        if (count($primaryKeyColumns) === 1) {
376
-            $primaryKeyColumn = $primaryKeyColumns[0];
377
-            $str .= "
375
+		if (count($primaryKeyColumns) === 1) {
376
+			$primaryKeyColumn = $primaryKeyColumns[0];
377
+			$str .= "
378 378
     /**
379 379
      * Get $beanClassWithoutNameSpace specified by its ID (its primary key)
380 380
      * If the primary key does not exist, an exception is thrown.
@@ -389,8 +389,8 @@  discard block
 block discarded – undo
389 389
         return \$this->tdbmService->findObjectByPk('$tableName', ['$primaryKeyColumn' => \$id], [], \$lazyLoading);
390 390
     }
391 391
     ";
392
-        }
393
-        $str .= "
392
+		}
393
+		$str .= "
394 394
     /**
395 395
      * Deletes the $beanClassWithoutNameSpace passed in parameter.
396 396
      *
@@ -448,33 +448,33 @@  discard block
 block discarded – undo
448 448
     }
449 449
 ";
450 450
 
451
-        $str .= $findByDaoCode;
452
-        $str .= '}
451
+		$str .= $findByDaoCode;
452
+		$str .= '}
453 453
 ';
454 454
 
455
-        $possibleBaseFileNames = $classNameMapper->getPossibleFileNames($daonamespace.'\\'.$baseClassName);
456
-        if (empty($possibleBaseFileNames)) {
457
-            // @codeCoverageIgnoreStart
458
-            throw new TDBMException('Sorry, autoload namespace issue. The class "'.$baseClassName.'" is not autoloadable.');
459
-            // @codeCoverageIgnoreEnd
460
-        }
461
-        $possibleBaseFileName = $this->rootPath.$possibleBaseFileNames[0];
462
-
463
-        $this->ensureDirectoryExist($possibleBaseFileName);
464
-        file_put_contents($possibleBaseFileName, $str);
465
-        @chmod($possibleBaseFileName, 0664);
466
-
467
-        $possibleFileNames = $classNameMapper->getPossibleFileNames($daonamespace.'\\'.$className);
468
-        if (empty($possibleFileNames)) {
469
-            // @codeCoverageIgnoreStart
470
-            throw new TDBMException('Sorry, autoload namespace issue. The class "'.$className.'" is not autoloadable.');
471
-            // @codeCoverageIgnoreEnd
472
-        }
473
-        $possibleFileName = $this->rootPath.$possibleFileNames[0];
474
-
475
-        // Now, let's generate the "editable" class
476
-        if (!file_exists($possibleFileName)) {
477
-            $str = "<?php
455
+		$possibleBaseFileNames = $classNameMapper->getPossibleFileNames($daonamespace.'\\'.$baseClassName);
456
+		if (empty($possibleBaseFileNames)) {
457
+			// @codeCoverageIgnoreStart
458
+			throw new TDBMException('Sorry, autoload namespace issue. The class "'.$baseClassName.'" is not autoloadable.');
459
+			// @codeCoverageIgnoreEnd
460
+		}
461
+		$possibleBaseFileName = $this->rootPath.$possibleBaseFileNames[0];
462
+
463
+		$this->ensureDirectoryExist($possibleBaseFileName);
464
+		file_put_contents($possibleBaseFileName, $str);
465
+		@chmod($possibleBaseFileName, 0664);
466
+
467
+		$possibleFileNames = $classNameMapper->getPossibleFileNames($daonamespace.'\\'.$className);
468
+		if (empty($possibleFileNames)) {
469
+			// @codeCoverageIgnoreStart
470
+			throw new TDBMException('Sorry, autoload namespace issue. The class "'.$className.'" is not autoloadable.');
471
+			// @codeCoverageIgnoreEnd
472
+		}
473
+		$possibleFileName = $this->rootPath.$possibleFileNames[0];
474
+
475
+		// Now, let's generate the "editable" class
476
+		if (!file_exists($possibleFileName)) {
477
+			$str = "<?php
478 478
 
479 479
 /*
480 480
  * This file has been automatically generated by TDBM.
@@ -491,22 +491,22 @@  discard block
 block discarded – undo
491 491
 
492 492
 }
493 493
 ";
494
-            $this->ensureDirectoryExist($possibleFileName);
495
-            file_put_contents($possibleFileName, $str);
496
-            @chmod($possibleFileName, 0664);
497
-        }
498
-    }
499
-
500
-    /**
501
-     * Generates the factory bean.
502
-     *
503
-     * @param Table[] $tableList
504
-     */
505
-    private function generateFactory(array $tableList, $daoFactoryClassName, $daoNamespace, ClassNameMapper $classNameMapper)
506
-    {
507
-        // For each table, let's write a property.
508
-
509
-        $str = "<?php
494
+			$this->ensureDirectoryExist($possibleFileName);
495
+			file_put_contents($possibleFileName, $str);
496
+			@chmod($possibleFileName, 0664);
497
+		}
498
+	}
499
+
500
+	/**
501
+	 * Generates the factory bean.
502
+	 *
503
+	 * @param Table[] $tableList
504
+	 */
505
+	private function generateFactory(array $tableList, $daoFactoryClassName, $daoNamespace, ClassNameMapper $classNameMapper)
506
+	{
507
+		// For each table, let's write a property.
508
+
509
+		$str = "<?php
510 510
 
511 511
 /*
512 512
  * This file has been automatically generated by TDBM.
@@ -523,12 +523,12 @@  discard block
 block discarded – undo
523 523
 {
524 524
 ";
525 525
 
526
-        foreach ($tableList as $table) {
527
-            $tableName = $table->getName();
528
-            $daoClassName = $this->getDaoNameFromTableName($tableName);
529
-            $daoInstanceName = self::toVariableName($daoClassName);
526
+		foreach ($tableList as $table) {
527
+			$tableName = $table->getName();
528
+			$daoClassName = $this->getDaoNameFromTableName($tableName);
529
+			$daoInstanceName = self::toVariableName($daoClassName);
530 530
 
531
-            $str .= '    /**
531
+			$str .= '    /**
532 532
      * @var '.$daoClassName.'
533 533
      */
534 534
     private $'.$daoInstanceName.';
@@ -553,158 +553,158 @@  discard block
 block discarded – undo
553 553
     }
554 554
 
555 555
 ';
556
-        }
556
+		}
557 557
 
558
-        $str .= '
558
+		$str .= '
559 559
 }
560 560
 ';
561 561
 
562
-        $possibleFileNames = $classNameMapper->getPossibleFileNames($daoNamespace.'\\'.$daoFactoryClassName);
563
-        if (empty($possibleFileNames)) {
564
-            throw new TDBMException('Sorry, autoload namespace issue. The class "'.$daoNamespace.'\\'.$daoFactoryClassName.'" is not autoloadable.');
565
-        }
566
-        $possibleFileName = $this->rootPath.$possibleFileNames[0];
567
-
568
-        $this->ensureDirectoryExist($possibleFileName);
569
-        file_put_contents($possibleFileName, $str);
570
-        @chmod($possibleFileName, 0664);
571
-    }
572
-
573
-    /**
574
-     * Transforms a string to camelCase (except the first letter will be uppercase too).
575
-     * Underscores and spaces are removed and the first letter after the underscore is uppercased.
576
-     *
577
-     * @param $str string
578
-     *
579
-     * @return string
580
-     */
581
-    public static function toCamelCase($str)
582
-    {
583
-        $str = strtoupper(substr($str, 0, 1)).substr($str, 1);
584
-        while (true) {
585
-            if (strpos($str, '_') === false && strpos($str, ' ') === false) {
586
-                break;
587
-            }
588
-
589
-            $pos = strpos($str, '_');
590
-            if ($pos === false) {
591
-                $pos = strpos($str, ' ');
592
-            }
593
-            $before = substr($str, 0, $pos);
594
-            $after = substr($str, $pos + 1);
595
-            $str = $before.strtoupper(substr($after, 0, 1)).substr($after, 1);
596
-        }
597
-
598
-        return $str;
599
-    }
600
-
601
-    /**
602
-     * Tries to put string to the singular form (if it is plural).
603
-     * We assume the table names are in english.
604
-     *
605
-     * @param $str string
606
-     *
607
-     * @return string
608
-     */
609
-    public static function toSingular($str)
610
-    {
611
-        return Inflector::singularize($str);
612
-    }
613
-
614
-    /**
615
-     * Put the first letter of the string in lower case.
616
-     * Very useful to transform a class name into a variable name.
617
-     *
618
-     * @param $str string
619
-     *
620
-     * @return string
621
-     */
622
-    public static function toVariableName($str)
623
-    {
624
-        return strtolower(substr($str, 0, 1)).substr($str, 1);
625
-    }
626
-
627
-    /**
628
-     * Ensures the file passed in parameter can be written in its directory.
629
-     *
630
-     * @param string $fileName
631
-     *
632
-     * @throws TDBMException
633
-     */
634
-    private function ensureDirectoryExist($fileName)
635
-    {
636
-        $dirName = dirname($fileName);
637
-        if (!file_exists($dirName)) {
638
-            $old = umask(0);
639
-            $result = mkdir($dirName, 0775, true);
640
-            umask($old);
641
-            if ($result === false) {
642
-                throw new TDBMException("Unable to create directory: '".$dirName."'.");
643
-            }
644
-        }
645
-    }
646
-
647
-    /**
648
-     * Absolute path to composer json file.
649
-     *
650
-     * @param string $rootPath
651
-     */
652
-    public function setComposerFile($composerFile)
653
-    {
654
-        $this->rootPath = dirname($composerFile).'/';
655
-        $this->composerFile = basename($composerFile);
656
-    }
657
-
658
-    /**
659
-     * Transforms a DBAL type into a PHP type (for PHPDoc purpose).
660
-     *
661
-     * @param Type $type The DBAL type
662
-     *
663
-     * @return string The PHP type
664
-     */
665
-    public static function dbalTypeToPhpType(Type $type)
666
-    {
667
-        $map = [
668
-            Type::TARRAY => 'array',
669
-            Type::SIMPLE_ARRAY => 'array',
670
-            Type::JSON_ARRAY => 'array',
671
-            Type::BIGINT => 'string',
672
-            Type::BOOLEAN => 'bool',
673
-            Type::DATETIME => '\DateTimeInterface',
674
-            Type::DATETIMETZ => '\DateTimeInterface',
675
-            Type::DATE => '\DateTimeInterface',
676
-            Type::TIME => '\DateTimeInterface',
677
-            Type::DECIMAL => 'float',
678
-            Type::INTEGER => 'int',
679
-            Type::OBJECT => 'string',
680
-            Type::SMALLINT => 'int',
681
-            Type::STRING => 'string',
682
-            Type::TEXT => 'string',
683
-            Type::BINARY => 'string',
684
-            Type::BLOB => 'string',
685
-            Type::FLOAT => 'float',
686
-            Type::GUID => 'string',
687
-        ];
688
-
689
-        return isset($map[$type->getName()]) ? $map[$type->getName()] : $type->getName();
690
-    }
691
-
692
-    /**
693
-     * @param string $beanNamespace
694
-     *
695
-     * @return \string[] Returns a map mapping table name to beans name
696
-     */
697
-    public function buildTableToBeanMap($beanNamespace)
698
-    {
699
-        $tableToBeanMap = [];
700
-
701
-        $tables = $this->schema->getTables();
702
-
703
-        foreach ($tables as $table) {
704
-            $tableName = $table->getName();
705
-            $tableToBeanMap[$tableName] = $beanNamespace.'\\'.self::getBeanNameFromTableName($tableName);
706
-        }
707
-
708
-        return $tableToBeanMap;
709
-    }
562
+		$possibleFileNames = $classNameMapper->getPossibleFileNames($daoNamespace.'\\'.$daoFactoryClassName);
563
+		if (empty($possibleFileNames)) {
564
+			throw new TDBMException('Sorry, autoload namespace issue. The class "'.$daoNamespace.'\\'.$daoFactoryClassName.'" is not autoloadable.');
565
+		}
566
+		$possibleFileName = $this->rootPath.$possibleFileNames[0];
567
+
568
+		$this->ensureDirectoryExist($possibleFileName);
569
+		file_put_contents($possibleFileName, $str);
570
+		@chmod($possibleFileName, 0664);
571
+	}
572
+
573
+	/**
574
+	 * Transforms a string to camelCase (except the first letter will be uppercase too).
575
+	 * Underscores and spaces are removed and the first letter after the underscore is uppercased.
576
+	 *
577
+	 * @param $str string
578
+	 *
579
+	 * @return string
580
+	 */
581
+	public static function toCamelCase($str)
582
+	{
583
+		$str = strtoupper(substr($str, 0, 1)).substr($str, 1);
584
+		while (true) {
585
+			if (strpos($str, '_') === false && strpos($str, ' ') === false) {
586
+				break;
587
+			}
588
+
589
+			$pos = strpos($str, '_');
590
+			if ($pos === false) {
591
+				$pos = strpos($str, ' ');
592
+			}
593
+			$before = substr($str, 0, $pos);
594
+			$after = substr($str, $pos + 1);
595
+			$str = $before.strtoupper(substr($after, 0, 1)).substr($after, 1);
596
+		}
597
+
598
+		return $str;
599
+	}
600
+
601
+	/**
602
+	 * Tries to put string to the singular form (if it is plural).
603
+	 * We assume the table names are in english.
604
+	 *
605
+	 * @param $str string
606
+	 *
607
+	 * @return string
608
+	 */
609
+	public static function toSingular($str)
610
+	{
611
+		return Inflector::singularize($str);
612
+	}
613
+
614
+	/**
615
+	 * Put the first letter of the string in lower case.
616
+	 * Very useful to transform a class name into a variable name.
617
+	 *
618
+	 * @param $str string
619
+	 *
620
+	 * @return string
621
+	 */
622
+	public static function toVariableName($str)
623
+	{
624
+		return strtolower(substr($str, 0, 1)).substr($str, 1);
625
+	}
626
+
627
+	/**
628
+	 * Ensures the file passed in parameter can be written in its directory.
629
+	 *
630
+	 * @param string $fileName
631
+	 *
632
+	 * @throws TDBMException
633
+	 */
634
+	private function ensureDirectoryExist($fileName)
635
+	{
636
+		$dirName = dirname($fileName);
637
+		if (!file_exists($dirName)) {
638
+			$old = umask(0);
639
+			$result = mkdir($dirName, 0775, true);
640
+			umask($old);
641
+			if ($result === false) {
642
+				throw new TDBMException("Unable to create directory: '".$dirName."'.");
643
+			}
644
+		}
645
+	}
646
+
647
+	/**
648
+	 * Absolute path to composer json file.
649
+	 *
650
+	 * @param string $rootPath
651
+	 */
652
+	public function setComposerFile($composerFile)
653
+	{
654
+		$this->rootPath = dirname($composerFile).'/';
655
+		$this->composerFile = basename($composerFile);
656
+	}
657
+
658
+	/**
659
+	 * Transforms a DBAL type into a PHP type (for PHPDoc purpose).
660
+	 *
661
+	 * @param Type $type The DBAL type
662
+	 *
663
+	 * @return string The PHP type
664
+	 */
665
+	public static function dbalTypeToPhpType(Type $type)
666
+	{
667
+		$map = [
668
+			Type::TARRAY => 'array',
669
+			Type::SIMPLE_ARRAY => 'array',
670
+			Type::JSON_ARRAY => 'array',
671
+			Type::BIGINT => 'string',
672
+			Type::BOOLEAN => 'bool',
673
+			Type::DATETIME => '\DateTimeInterface',
674
+			Type::DATETIMETZ => '\DateTimeInterface',
675
+			Type::DATE => '\DateTimeInterface',
676
+			Type::TIME => '\DateTimeInterface',
677
+			Type::DECIMAL => 'float',
678
+			Type::INTEGER => 'int',
679
+			Type::OBJECT => 'string',
680
+			Type::SMALLINT => 'int',
681
+			Type::STRING => 'string',
682
+			Type::TEXT => 'string',
683
+			Type::BINARY => 'string',
684
+			Type::BLOB => 'string',
685
+			Type::FLOAT => 'float',
686
+			Type::GUID => 'string',
687
+		];
688
+
689
+		return isset($map[$type->getName()]) ? $map[$type->getName()] : $type->getName();
690
+	}
691
+
692
+	/**
693
+	 * @param string $beanNamespace
694
+	 *
695
+	 * @return \string[] Returns a map mapping table name to beans name
696
+	 */
697
+	public function buildTableToBeanMap($beanNamespace)
698
+	{
699
+		$tableToBeanMap = [];
700
+
701
+		$tables = $this->schema->getTables();
702
+
703
+		foreach ($tables as $table) {
704
+			$tableName = $table->getName();
705
+			$tableToBeanMap[$tableName] = $beanNamespace.'\\'.self::getBeanNameFromTableName($tableName);
706
+		}
707
+
708
+		return $tableToBeanMap;
709
+	}
710 710
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/Controllers/TdbmController.php 1 patch
Indentation   +154 added lines, -154 removed lines patch added patch discarded remove patch
@@ -16,158 +16,158 @@
 block discarded – undo
16 16
  */
17 17
 class TdbmController extends AbstractMoufInstanceController
18 18
 {
19
-    /**
20
-     * @var HtmlBlock
21
-     */
22
-    public $content;
23
-
24
-    protected $daoNamespace;
25
-    protected $beanNamespace;
26
-    protected $daoFactoryName;
27
-    protected $daoFactoryInstanceName;
28
-    protected $autoloadDetected;
29
-    protected $storeInUtc;
30
-
31
-    /**
32
-     * Admin page used to display the DAO generation form.
33
-     *
34
-     * @Action
35
-     * //@Admin
36
-     */
37
-    public function defaultAction($name, $selfedit = 'false')
38
-    {
39
-        $this->initController($name, $selfedit);
40
-
41
-        // Fill variables
42
-        if ($this->moufManager->getVariable('tdbmDefaultSourceDirectory_'.$name) != null) {
43
-            $this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace_'.$name);
44
-            $this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace_'.$name);
45
-            $this->daoFactoryName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryName_'.$name);
46
-            $this->daoFactoryInstanceName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryInstanceName_'.$name);
47
-            $this->storeInUtc = $this->moufManager->getVariable('tdbmDefaultStoreInUtc_'.$name);
48
-            $this->useCustomComposer = $this->moufManager->getVariable('tdbmDefaultUseCustomComposer_'.$name);
49
-            $this->composerFile = $this->moufManager->getVariable('tdbmDefaultComposerFile_'.$name);
50
-        } else {
51
-            $this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace');
52
-            $this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace');
53
-            $this->daoFactoryName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryName');
54
-            $this->daoFactoryInstanceName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryInstanceName');
55
-            $this->storeInUtc = $this->moufManager->getVariable('tdbmDefaultStoreInUtc');
56
-            $this->useCustomComposer = $this->moufManager->getVariable('tdbmDefaultUseCustomComposer');
57
-            $this->composerFile = $this->moufManager->getVariable('tdbmDefaultComposerFile');
58
-        }
59
-
60
-        if ($this->daoNamespace == null && $this->beanNamespace == null) {
61
-            $classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json');
62
-
63
-            $autoloadNamespaces = $classNameMapper->getManagedNamespaces();
64
-            if ($autoloadNamespaces) {
65
-                $this->autoloadDetected = true;
66
-                $rootNamespace = $autoloadNamespaces[0];
67
-                $this->daoNamespace = $rootNamespace.'Dao';
68
-                $this->beanNamespace = $rootNamespace.'Dao\\Bean';
69
-            } else {
70
-                $this->autoloadDetected = false;
71
-                $this->daoNamespace = 'YourApplication\\Dao';
72
-                $this->beanNamespace = 'YourApplication\\Dao\\Bean';
73
-            }
74
-        } else {
75
-            $this->autoloadDetected = true;
76
-        }
77
-
78
-        $this->content->addFile(dirname(__FILE__).'/../../../../views/tdbmGenerate.php', $this);
79
-        $this->template->toHtml();
80
-    }
81
-
82
-    /**
83
-     * This action generates the DAOs and Beans for the TDBM service passed in parameter.
84
-     *
85
-     * @Action
86
-     *
87
-     * @param string $name
88
-     * @param bool   $selfedit
89
-     */
90
-    public function generate($name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $storeInUtc = 0, $selfedit = 'false', $useCustomComposer = false, $composerFile = '')
91
-    {
92
-        $this->initController($name, $selfedit);
93
-
94
-        self::generateDaos($this->moufManager, $name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $selfedit, $storeInUtc, $useCustomComposer, $composerFile);
95
-
96
-        // TODO: better: we should redirect to a screen that list the number of DAOs generated, etc...
97
-        header('Location: '.ROOT_URL.'ajaxinstance/?name='.urlencode($name).'&selfedit='.$selfedit);
98
-    }
99
-
100
-    /**
101
-     * This function generates the DAOs and Beans for the TDBM service passed in parameter.
102
-     *
103
-     * @param MoufManager $moufManager
104
-     * @param string      $name
105
-     * @param string      $daonamespace
106
-     * @param string      $beannamespace
107
-     * @param string      $daofactoryclassname
108
-     * @param string      $daofactoryinstancename
109
-     * @param string      $selfedit
110
-     * @param bool        $storeInUtc
111
-     *
112
-     * @throws \Mouf\MoufException
113
-     */
114
-    public static function generateDaos(MoufManager $moufManager, $name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $selfedit = 'false', $storeInUtc = null, $useCustomComposer = null, $composerFile = null)
115
-    {
116
-        $moufManager->setVariable('tdbmDefaultDaoNamespace_'.$name, $daonamespace);
117
-        $moufManager->setVariable('tdbmDefaultBeanNamespace_'.$name, $beannamespace);
118
-        $moufManager->setVariable('tdbmDefaultDaoFactoryName_'.$name, $daofactoryclassname);
119
-        $moufManager->setVariable('tdbmDefaultDaoFactoryInstanceName_'.$name, $daofactoryinstancename);
120
-        $moufManager->setVariable('tdbmDefaultStoreInUtc_'.$name, $storeInUtc);
121
-        $moufManager->setVariable('tdbmDefaultUseCustomComposer_'.$name, $useCustomComposer);
122
-        $moufManager->setVariable('tdbmDefaultComposerFile_'.$name, $composerFile);
123
-
124
-        // In case of instance renaming, let's use the last used settings
125
-        $moufManager->setVariable('tdbmDefaultDaoNamespace', $daonamespace);
126
-        $moufManager->setVariable('tdbmDefaultBeanNamespace', $beannamespace);
127
-        $moufManager->setVariable('tdbmDefaultDaoFactoryName', $daofactoryclassname);
128
-        $moufManager->setVariable('tdbmDefaultDaoFactoryInstanceName', $daofactoryinstancename);
129
-        $moufManager->setVariable('tdbmDefaultStoreInUtc', $storeInUtc);
130
-        $moufManager->setVariable('tdbmDefaultUseCustomComposer', $useCustomComposer);
131
-        $moufManager->setVariable('tdbmDefaultComposerFile', $composerFile);
132
-
133
-        // Remove first and last slash in namespace.
134
-        if (strpos($daonamespace, '\\') === 0) {
135
-            $daonamespace = substr($daonamespace, 1);
136
-        }
137
-        if (strpos($daonamespace, '\\') === strlen($daonamespace) - 1) {
138
-            $daonamespace = substr($daonamespace, 0, strlen($daonamespace) - 1);
139
-        }
140
-        if (strpos($beannamespace, '\\') === 0) {
141
-            $beannamespace = substr($beannamespace, 1);
142
-        }
143
-        if (strpos($beannamespace, '\\') === strlen($beannamespace) - 1) {
144
-            $beannamespace = substr($beannamespace, 0, strlen($beannamespace) - 1);
145
-        }
146
-
147
-        $tdbmService = new InstanceProxy($name);
148
-        /* @var $tdbmService TDBMService */
149
-        $tables = $tdbmService->generateAllDaosAndBeans($daofactoryclassname, $daonamespace, $beannamespace, $storeInUtc, ($useCustomComposer ? $composerFile : null));
150
-
151
-        $moufManager->declareComponent($daofactoryinstancename, $daonamespace.'\\'.$daofactoryclassname, false, MoufManager::DECLARE_ON_EXIST_KEEP_INCOMING_LINKS);
152
-
153
-        $tableToBeanMap = [];
154
-
155
-        //$tdbmServiceDescriptor = $moufManager->getInstanceDescriptor('tdbmService');
156
-
157
-        foreach ($tables as $table) {
158
-            $daoName = TDBMDaoGenerator::getDaoNameFromTableName($table);
159
-
160
-            $instanceName = TDBMDaoGenerator::toVariableName($daoName);
161
-            if (!$moufManager->instanceExists($instanceName)) {
162
-                $moufManager->declareComponent($instanceName, $daonamespace.'\\'.$daoName);
163
-            }
164
-            $moufManager->setParameterViaConstructor($instanceName, 0, $name, 'object');
165
-            $moufManager->bindComponentViaSetter($daofactoryinstancename, 'set'.$daoName, $instanceName);
166
-
167
-            $tableToBeanMap[$table] = $beannamespace.'\\'.TDBMDaoGenerator::getBeanNameFromTableName($table);
168
-        }
169
-        $tdbmServiceDescriptor = $moufManager->getInstanceDescriptor($name);
170
-        $tdbmServiceDescriptor->getSetterProperty('setTableToBeanMap')->setValue($tableToBeanMap);
171
-        $moufManager->rewriteMouf();
172
-    }
19
+	/**
20
+	 * @var HtmlBlock
21
+	 */
22
+	public $content;
23
+
24
+	protected $daoNamespace;
25
+	protected $beanNamespace;
26
+	protected $daoFactoryName;
27
+	protected $daoFactoryInstanceName;
28
+	protected $autoloadDetected;
29
+	protected $storeInUtc;
30
+
31
+	/**
32
+	 * Admin page used to display the DAO generation form.
33
+	 *
34
+	 * @Action
35
+	 * //@Admin
36
+	 */
37
+	public function defaultAction($name, $selfedit = 'false')
38
+	{
39
+		$this->initController($name, $selfedit);
40
+
41
+		// Fill variables
42
+		if ($this->moufManager->getVariable('tdbmDefaultSourceDirectory_'.$name) != null) {
43
+			$this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace_'.$name);
44
+			$this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace_'.$name);
45
+			$this->daoFactoryName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryName_'.$name);
46
+			$this->daoFactoryInstanceName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryInstanceName_'.$name);
47
+			$this->storeInUtc = $this->moufManager->getVariable('tdbmDefaultStoreInUtc_'.$name);
48
+			$this->useCustomComposer = $this->moufManager->getVariable('tdbmDefaultUseCustomComposer_'.$name);
49
+			$this->composerFile = $this->moufManager->getVariable('tdbmDefaultComposerFile_'.$name);
50
+		} else {
51
+			$this->daoNamespace = $this->moufManager->getVariable('tdbmDefaultDaoNamespace');
52
+			$this->beanNamespace = $this->moufManager->getVariable('tdbmDefaultBeanNamespace');
53
+			$this->daoFactoryName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryName');
54
+			$this->daoFactoryInstanceName = $this->moufManager->getVariable('tdbmDefaultDaoFactoryInstanceName');
55
+			$this->storeInUtc = $this->moufManager->getVariable('tdbmDefaultStoreInUtc');
56
+			$this->useCustomComposer = $this->moufManager->getVariable('tdbmDefaultUseCustomComposer');
57
+			$this->composerFile = $this->moufManager->getVariable('tdbmDefaultComposerFile');
58
+		}
59
+
60
+		if ($this->daoNamespace == null && $this->beanNamespace == null) {
61
+			$classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json');
62
+
63
+			$autoloadNamespaces = $classNameMapper->getManagedNamespaces();
64
+			if ($autoloadNamespaces) {
65
+				$this->autoloadDetected = true;
66
+				$rootNamespace = $autoloadNamespaces[0];
67
+				$this->daoNamespace = $rootNamespace.'Dao';
68
+				$this->beanNamespace = $rootNamespace.'Dao\\Bean';
69
+			} else {
70
+				$this->autoloadDetected = false;
71
+				$this->daoNamespace = 'YourApplication\\Dao';
72
+				$this->beanNamespace = 'YourApplication\\Dao\\Bean';
73
+			}
74
+		} else {
75
+			$this->autoloadDetected = true;
76
+		}
77
+
78
+		$this->content->addFile(dirname(__FILE__).'/../../../../views/tdbmGenerate.php', $this);
79
+		$this->template->toHtml();
80
+	}
81
+
82
+	/**
83
+	 * This action generates the DAOs and Beans for the TDBM service passed in parameter.
84
+	 *
85
+	 * @Action
86
+	 *
87
+	 * @param string $name
88
+	 * @param bool   $selfedit
89
+	 */
90
+	public function generate($name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $storeInUtc = 0, $selfedit = 'false', $useCustomComposer = false, $composerFile = '')
91
+	{
92
+		$this->initController($name, $selfedit);
93
+
94
+		self::generateDaos($this->moufManager, $name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $selfedit, $storeInUtc, $useCustomComposer, $composerFile);
95
+
96
+		// TODO: better: we should redirect to a screen that list the number of DAOs generated, etc...
97
+		header('Location: '.ROOT_URL.'ajaxinstance/?name='.urlencode($name).'&selfedit='.$selfedit);
98
+	}
99
+
100
+	/**
101
+	 * This function generates the DAOs and Beans for the TDBM service passed in parameter.
102
+	 *
103
+	 * @param MoufManager $moufManager
104
+	 * @param string      $name
105
+	 * @param string      $daonamespace
106
+	 * @param string      $beannamespace
107
+	 * @param string      $daofactoryclassname
108
+	 * @param string      $daofactoryinstancename
109
+	 * @param string      $selfedit
110
+	 * @param bool        $storeInUtc
111
+	 *
112
+	 * @throws \Mouf\MoufException
113
+	 */
114
+	public static function generateDaos(MoufManager $moufManager, $name, $daonamespace, $beannamespace, $daofactoryclassname, $daofactoryinstancename, $selfedit = 'false', $storeInUtc = null, $useCustomComposer = null, $composerFile = null)
115
+	{
116
+		$moufManager->setVariable('tdbmDefaultDaoNamespace_'.$name, $daonamespace);
117
+		$moufManager->setVariable('tdbmDefaultBeanNamespace_'.$name, $beannamespace);
118
+		$moufManager->setVariable('tdbmDefaultDaoFactoryName_'.$name, $daofactoryclassname);
119
+		$moufManager->setVariable('tdbmDefaultDaoFactoryInstanceName_'.$name, $daofactoryinstancename);
120
+		$moufManager->setVariable('tdbmDefaultStoreInUtc_'.$name, $storeInUtc);
121
+		$moufManager->setVariable('tdbmDefaultUseCustomComposer_'.$name, $useCustomComposer);
122
+		$moufManager->setVariable('tdbmDefaultComposerFile_'.$name, $composerFile);
123
+
124
+		// In case of instance renaming, let's use the last used settings
125
+		$moufManager->setVariable('tdbmDefaultDaoNamespace', $daonamespace);
126
+		$moufManager->setVariable('tdbmDefaultBeanNamespace', $beannamespace);
127
+		$moufManager->setVariable('tdbmDefaultDaoFactoryName', $daofactoryclassname);
128
+		$moufManager->setVariable('tdbmDefaultDaoFactoryInstanceName', $daofactoryinstancename);
129
+		$moufManager->setVariable('tdbmDefaultStoreInUtc', $storeInUtc);
130
+		$moufManager->setVariable('tdbmDefaultUseCustomComposer', $useCustomComposer);
131
+		$moufManager->setVariable('tdbmDefaultComposerFile', $composerFile);
132
+
133
+		// Remove first and last slash in namespace.
134
+		if (strpos($daonamespace, '\\') === 0) {
135
+			$daonamespace = substr($daonamespace, 1);
136
+		}
137
+		if (strpos($daonamespace, '\\') === strlen($daonamespace) - 1) {
138
+			$daonamespace = substr($daonamespace, 0, strlen($daonamespace) - 1);
139
+		}
140
+		if (strpos($beannamespace, '\\') === 0) {
141
+			$beannamespace = substr($beannamespace, 1);
142
+		}
143
+		if (strpos($beannamespace, '\\') === strlen($beannamespace) - 1) {
144
+			$beannamespace = substr($beannamespace, 0, strlen($beannamespace) - 1);
145
+		}
146
+
147
+		$tdbmService = new InstanceProxy($name);
148
+		/* @var $tdbmService TDBMService */
149
+		$tables = $tdbmService->generateAllDaosAndBeans($daofactoryclassname, $daonamespace, $beannamespace, $storeInUtc, ($useCustomComposer ? $composerFile : null));
150
+
151
+		$moufManager->declareComponent($daofactoryinstancename, $daonamespace.'\\'.$daofactoryclassname, false, MoufManager::DECLARE_ON_EXIST_KEEP_INCOMING_LINKS);
152
+
153
+		$tableToBeanMap = [];
154
+
155
+		//$tdbmServiceDescriptor = $moufManager->getInstanceDescriptor('tdbmService');
156
+
157
+		foreach ($tables as $table) {
158
+			$daoName = TDBMDaoGenerator::getDaoNameFromTableName($table);
159
+
160
+			$instanceName = TDBMDaoGenerator::toVariableName($daoName);
161
+			if (!$moufManager->instanceExists($instanceName)) {
162
+				$moufManager->declareComponent($instanceName, $daonamespace.'\\'.$daoName);
163
+			}
164
+			$moufManager->setParameterViaConstructor($instanceName, 0, $name, 'object');
165
+			$moufManager->bindComponentViaSetter($daofactoryinstancename, 'set'.$daoName, $instanceName);
166
+
167
+			$tableToBeanMap[$table] = $beannamespace.'\\'.TDBMDaoGenerator::getBeanNameFromTableName($table);
168
+		}
169
+		$tdbmServiceDescriptor = $moufManager->getInstanceDescriptor($name);
170
+		$tdbmServiceDescriptor->getSetterProperty('setTableToBeanMap')->setValue($tableToBeanMap);
171
+		$moufManager->rewriteMouf();
172
+	}
173 173
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/MapIterator.php 1 patch
Indentation   +71 added lines, -71 removed lines patch added patch discarded remove patch
@@ -9,86 +9,86 @@
 block discarded – undo
9 9
  */
10 10
 class MapIterator implements Iterator
11 11
 {
12
-    /**
13
-     * @var Iterator
14
-     */
15
-    protected $iterator;
12
+	/**
13
+	 * @var Iterator
14
+	 */
15
+	protected $iterator;
16 16
 
17
-    /**
18
-     * @var callable Modifies the current item in iterator
19
-     */
20
-    protected $callable;
17
+	/**
18
+	 * @var callable Modifies the current item in iterator
19
+	 */
20
+	protected $callable;
21 21
 
22
-    /**
23
-     * @param $iterator Iterator|array
24
-     * @param $callable callable This can have two parameters
25
-     *
26
-     * @throws TDBMException
27
-     */
28
-    public function __construct($iterator, callable $callable)
29
-    {
30
-        if (is_array($iterator)) {
31
-            $this->iterator = new \ArrayIterator($iterator);
32
-        } elseif (!($iterator instanceof Iterator)) {
33
-            throw new TDBMException('$iterator parameter must be an instance of Iterator');
34
-        } else {
35
-            $this->iterator = $iterator;
36
-        }
22
+	/**
23
+	 * @param $iterator Iterator|array
24
+	 * @param $callable callable This can have two parameters
25
+	 *
26
+	 * @throws TDBMException
27
+	 */
28
+	public function __construct($iterator, callable $callable)
29
+	{
30
+		if (is_array($iterator)) {
31
+			$this->iterator = new \ArrayIterator($iterator);
32
+		} elseif (!($iterator instanceof Iterator)) {
33
+			throw new TDBMException('$iterator parameter must be an instance of Iterator');
34
+		} else {
35
+			$this->iterator = $iterator;
36
+		}
37 37
 
38
-        if ($callable instanceof \Closure) {
39
-            // make sure there's one argument
40
-            $reflection = new \ReflectionObject($callable);
41
-            if ($reflection->hasMethod('__invoke')) {
42
-                $method = $reflection->getMethod('__invoke');
43
-                if ($method->getNumberOfParameters() !== 1) {
44
-                    throw new TDBMException('$callable must accept one and only one parameter.');
45
-                }
46
-            }
47
-        }
38
+		if ($callable instanceof \Closure) {
39
+			// make sure there's one argument
40
+			$reflection = new \ReflectionObject($callable);
41
+			if ($reflection->hasMethod('__invoke')) {
42
+				$method = $reflection->getMethod('__invoke');
43
+				if ($method->getNumberOfParameters() !== 1) {
44
+					throw new TDBMException('$callable must accept one and only one parameter.');
45
+				}
46
+			}
47
+		}
48 48
 
49
-        $this->callable = $callable;
50
-    }
49
+		$this->callable = $callable;
50
+	}
51 51
 
52
-    /**
53
-     * Alters the current item with $this->callable and returns a new item.
54
-     * Be careful with your types as we can't do static type checking here!
55
-     *
56
-     * @return mixed
57
-     */
58
-    public function current()
59
-    {
60
-        $callable = $this->callable;
52
+	/**
53
+	 * Alters the current item with $this->callable and returns a new item.
54
+	 * Be careful with your types as we can't do static type checking here!
55
+	 *
56
+	 * @return mixed
57
+	 */
58
+	public function current()
59
+	{
60
+		$callable = $this->callable;
61 61
 
62
-        return $callable($this->iterator->current());
63
-    }
62
+		return $callable($this->iterator->current());
63
+	}
64 64
 
65
-    public function next()
66
-    {
67
-        $this->iterator->next();
68
-    }
65
+	public function next()
66
+	{
67
+		$this->iterator->next();
68
+	}
69 69
 
70
-    public function key()
71
-    {
72
-        return $this->iterator->key();
73
-    }
70
+	public function key()
71
+	{
72
+		return $this->iterator->key();
73
+	}
74 74
 
75
-    public function valid()
76
-    {
77
-        return $this->iterator->valid();
78
-    }
75
+	public function valid()
76
+	{
77
+		return $this->iterator->valid();
78
+	}
79 79
 
80
-    public function rewind()
81
-    {
82
-        $this->iterator->rewind();
83
-    }
80
+	public function rewind()
81
+	{
82
+		$this->iterator->rewind();
83
+	}
84 84
 
85
-    /**
86
-     * Casts the iterator to a PHP array.
87
-     *
88
-     * @return array
89
-     */
90
-    public function toArray()
91
-    {
92
-        return iterator_to_array($this);
93
-    }
85
+	/**
86
+	 * Casts the iterator to a PHP array.
87
+	 *
88
+	 * @return array
89
+	 */
90
+	public function toArray()
91
+	{
92
+		return iterator_to_array($this);
93
+	}
94 94
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/TDBMService.php 1 patch
Indentation   +1324 added lines, -1324 removed lines patch added patch discarded remove patch
@@ -41,213 +41,213 @@  discard block
 block discarded – undo
41 41
  */
42 42
 class TDBMService
43 43
 {
44
-    const MODE_CURSOR = 1;
45
-    const MODE_ARRAY = 2;
46
-
47
-    /**
48
-     * The database connection.
49
-     *
50
-     * @var Connection
51
-     */
52
-    private $connection;
53
-
54
-    /**
55
-     * @var SchemaAnalyzer
56
-     */
57
-    private $schemaAnalyzer;
58
-
59
-    /**
60
-     * @var MagicQuery
61
-     */
62
-    private $magicQuery;
63
-
64
-    /**
65
-     * @var TDBMSchemaAnalyzer
66
-     */
67
-    private $tdbmSchemaAnalyzer;
68
-
69
-    /**
70
-     * @var string
71
-     */
72
-    private $cachePrefix;
73
-
74
-    /**
75
-     * Cache of table of primary keys.
76
-     * Primary keys are stored by tables, as an array of column.
77
-     * For instance $primary_key['my_table'][0] will return the first column of the primary key of table 'my_table'.
78
-     *
79
-     * @var string[]
80
-     */
81
-    private $primaryKeysColumns;
82
-
83
-    /**
84
-     * Service storing objects in memory.
85
-     * Access is done by table name and then by primary key.
86
-     * If the primary key is split on several columns, access is done by an array of columns, serialized.
87
-     *
88
-     * @var StandardObjectStorage|WeakrefObjectStorage
89
-     */
90
-    private $objectStorage;
91
-
92
-    /**
93
-     * The fetch mode of the result sets returned by `getObjects`.
94
-     * Can be one of: TDBMObjectArray::MODE_CURSOR or TDBMObjectArray::MODE_ARRAY or TDBMObjectArray::MODE_COMPATIBLE_ARRAY.
95
-     *
96
-     * In 'MODE_ARRAY' mode (default), the result is an array. Use this mode by default (unless the list returned is very big).
97
-     * In 'MODE_CURSOR' mode, the result is a Generator which is an iterable collection that can be scanned only once (only one "foreach") on it,
98
-     * and it cannot be accessed via key. Use this mode for large datasets processed by batch.
99
-     * In 'MODE_COMPATIBLE_ARRAY' mode, the result is an old TDBMObjectArray (used up to TDBM 3.2).
100
-     * You can access the array by key, or using foreach, several times.
101
-     *
102
-     * @var int
103
-     */
104
-    private $mode = self::MODE_ARRAY;
105
-
106
-    /**
107
-     * Table of new objects not yet inserted in database or objects modified that must be saved.
108
-     *
109
-     * @var \SplObjectStorage of DbRow objects
110
-     */
111
-    private $toSaveObjects;
112
-
113
-    /**
114
-     * The content of the cache variable.
115
-     *
116
-     * @var array<string, mixed>
117
-     */
118
-    private $cache;
119
-
120
-    /**
121
-     * Map associating a table name to a fully qualified Bean class name.
122
-     *
123
-     * @var array
124
-     */
125
-    private $tableToBeanMap = [];
126
-
127
-    /**
128
-     * @var \ReflectionClass[]
129
-     */
130
-    private $reflectionClassCache = array();
131
-
132
-    /**
133
-     * @param Connection     $connection     The DBAL DB connection to use
134
-     * @param Cache|null     $cache          A cache service to be used
135
-     * @param SchemaAnalyzer $schemaAnalyzer The schema analyzer that will be used to find shortest paths...
136
-     *                                       Will be automatically created if not passed.
137
-     */
138
-    public function __construct(Connection $connection, Cache $cache = null, SchemaAnalyzer $schemaAnalyzer = null)
139
-    {
140
-        if (extension_loaded('weakref')) {
141
-            $this->objectStorage = new WeakrefObjectStorage();
142
-        } else {
143
-            $this->objectStorage = new StandardObjectStorage();
144
-        }
145
-        $this->connection = $connection;
146
-        if ($cache !== null) {
147
-            $this->cache = $cache;
148
-        } else {
149
-            $this->cache = new VoidCache();
150
-        }
151
-        if ($schemaAnalyzer) {
152
-            $this->schemaAnalyzer = $schemaAnalyzer;
153
-        } else {
154
-            $this->schemaAnalyzer = new SchemaAnalyzer($this->connection->getSchemaManager(), $this->cache, $this->getConnectionUniqueId());
155
-        }
156
-
157
-        $this->magicQuery = new MagicQuery($this->connection, $this->cache, $this->schemaAnalyzer);
158
-
159
-        $this->tdbmSchemaAnalyzer = new TDBMSchemaAnalyzer($connection, $this->cache, $this->schemaAnalyzer);
160
-        $this->cachePrefix = $this->tdbmSchemaAnalyzer->getCachePrefix();
161
-
162
-        $this->toSaveObjects = new \SplObjectStorage();
163
-    }
164
-
165
-    /**
166
-     * Returns the object used to connect to the database.
167
-     *
168
-     * @return Connection
169
-     */
170
-    public function getConnection()
171
-    {
172
-        return $this->connection;
173
-    }
174
-
175
-    /**
176
-     * Creates a unique cache key for the current connection.
177
-     *
178
-     * @return string
179
-     */
180
-    private function getConnectionUniqueId()
181
-    {
182
-        return hash('md4', $this->connection->getHost().'-'.$this->connection->getPort().'-'.$this->connection->getDatabase().'-'.$this->connection->getDriver()->getName());
183
-    }
184
-
185
-    /**
186
-     * Sets the default fetch mode of the result sets returned by `findObjects`.
187
-     * Can be one of: TDBMObjectArray::MODE_CURSOR or TDBMObjectArray::MODE_ARRAY.
188
-     *
189
-     * In 'MODE_ARRAY' mode (default), the result is a ResultIterator object that behaves like an array. Use this mode by default (unless the list returned is very big).
190
-     * In 'MODE_CURSOR' mode, the result is a ResultIterator object. If you scan it many times (by calling several time a foreach loop), the query will be run
191
-     * several times. In cursor mode, you cannot access the result set by key. Use this mode for large datasets processed by batch.
192
-     *
193
-     * @param int $mode
194
-     *
195
-     * @return $this
196
-     *
197
-     * @throws TDBMException
198
-     */
199
-    public function setFetchMode($mode)
200
-    {
201
-        if ($mode !== self::MODE_CURSOR && $mode !== self::MODE_ARRAY) {
202
-            throw new TDBMException("Unknown fetch mode: '".$this->mode."'");
203
-        }
204
-        $this->mode = $mode;
205
-
206
-        return $this;
207
-    }
208
-
209
-    /**
210
-     * Returns a TDBMObject associated from table "$table_name".
211
-     * If the $filters parameter is an int/string, the object returned will be the object whose primary key = $filters.
212
-     * $filters can also be a set of TDBM_Filters (see the findObjects method for more details).
213
-     *
214
-     * For instance, if there is a table 'users', with a primary key on column 'user_id' and a column 'user_name', then
215
-     * 			$user = $tdbmService->getObject('users',1);
216
-     * 			echo $user->name;
217
-     * will return the name of the user whose user_id is one.
218
-     *
219
-     * If a table has a primary key over several columns, you should pass to $id an array containing the the value of the various columns.
220
-     * For instance:
221
-     * 			$group = $tdbmService->getObject('groups',array(1,2));
222
-     *
223
-     * Note that TDBMObject performs caching for you. If you get twice the same object, the reference of the object you will get
224
-     * will be the same.
225
-     *
226
-     * For instance:
227
-     * 			$user1 = $tdbmService->getObject('users',1);
228
-     * 			$user2 = $tdbmService->getObject('users',1);
229
-     * 			$user1->name = 'John Doe';
230
-     * 			echo $user2->name;
231
-     * will return 'John Doe'.
232
-     *
233
-     * You can use filters instead of passing the primary key. For instance:
234
-     * 			$user = $tdbmService->getObject('users',new EqualFilter('users', 'login', 'jdoe'));
235
-     * This will return the user whose login is 'jdoe'.
236
-     * Please note that if 2 users have the jdoe login in database, the method will throw a TDBM_DuplicateRowException.
237
-     *
238
-     * Also, you can specify the return class for the object (provided the return class extends TDBMObject).
239
-     * For instance:
240
-     *  	$user = $tdbmService->getObject('users',1,'User');
241
-     * will return an object from the "User" class. The "User" class must extend the "TDBMObject" class.
242
-     * Please be sure not to override any method or any property unless you perfectly know what you are doing!
243
-     *
244
-     * @param string $table_name   The name of the table we retrieve an object from.
245
-     * @param mixed  $filters      If the filter is a string/integer, it will be considered as the id of the object (the value of the primary key). Otherwise, it can be a filter bag (see the filterbag parameter of the findObjects method for more details about filter bags)
246
-     * @param string $className    Optional: The name of the class to instanciate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
247
-     * @param bool   $lazy_loading If set to true, and if the primary key is passed in parameter of getObject, the object will not be queried in database. It will be queried when you first try to access a column. If at that time the object cannot be found in database, an exception will be thrown.
248
-     *
249
-     * @return TDBMObject
250
-     */
44
+	const MODE_CURSOR = 1;
45
+	const MODE_ARRAY = 2;
46
+
47
+	/**
48
+	 * The database connection.
49
+	 *
50
+	 * @var Connection
51
+	 */
52
+	private $connection;
53
+
54
+	/**
55
+	 * @var SchemaAnalyzer
56
+	 */
57
+	private $schemaAnalyzer;
58
+
59
+	/**
60
+	 * @var MagicQuery
61
+	 */
62
+	private $magicQuery;
63
+
64
+	/**
65
+	 * @var TDBMSchemaAnalyzer
66
+	 */
67
+	private $tdbmSchemaAnalyzer;
68
+
69
+	/**
70
+	 * @var string
71
+	 */
72
+	private $cachePrefix;
73
+
74
+	/**
75
+	 * Cache of table of primary keys.
76
+	 * Primary keys are stored by tables, as an array of column.
77
+	 * For instance $primary_key['my_table'][0] will return the first column of the primary key of table 'my_table'.
78
+	 *
79
+	 * @var string[]
80
+	 */
81
+	private $primaryKeysColumns;
82
+
83
+	/**
84
+	 * Service storing objects in memory.
85
+	 * Access is done by table name and then by primary key.
86
+	 * If the primary key is split on several columns, access is done by an array of columns, serialized.
87
+	 *
88
+	 * @var StandardObjectStorage|WeakrefObjectStorage
89
+	 */
90
+	private $objectStorage;
91
+
92
+	/**
93
+	 * The fetch mode of the result sets returned by `getObjects`.
94
+	 * Can be one of: TDBMObjectArray::MODE_CURSOR or TDBMObjectArray::MODE_ARRAY or TDBMObjectArray::MODE_COMPATIBLE_ARRAY.
95
+	 *
96
+	 * In 'MODE_ARRAY' mode (default), the result is an array. Use this mode by default (unless the list returned is very big).
97
+	 * In 'MODE_CURSOR' mode, the result is a Generator which is an iterable collection that can be scanned only once (only one "foreach") on it,
98
+	 * and it cannot be accessed via key. Use this mode for large datasets processed by batch.
99
+	 * In 'MODE_COMPATIBLE_ARRAY' mode, the result is an old TDBMObjectArray (used up to TDBM 3.2).
100
+	 * You can access the array by key, or using foreach, several times.
101
+	 *
102
+	 * @var int
103
+	 */
104
+	private $mode = self::MODE_ARRAY;
105
+
106
+	/**
107
+	 * Table of new objects not yet inserted in database or objects modified that must be saved.
108
+	 *
109
+	 * @var \SplObjectStorage of DbRow objects
110
+	 */
111
+	private $toSaveObjects;
112
+
113
+	/**
114
+	 * The content of the cache variable.
115
+	 *
116
+	 * @var array<string, mixed>
117
+	 */
118
+	private $cache;
119
+
120
+	/**
121
+	 * Map associating a table name to a fully qualified Bean class name.
122
+	 *
123
+	 * @var array
124
+	 */
125
+	private $tableToBeanMap = [];
126
+
127
+	/**
128
+	 * @var \ReflectionClass[]
129
+	 */
130
+	private $reflectionClassCache = array();
131
+
132
+	/**
133
+	 * @param Connection     $connection     The DBAL DB connection to use
134
+	 * @param Cache|null     $cache          A cache service to be used
135
+	 * @param SchemaAnalyzer $schemaAnalyzer The schema analyzer that will be used to find shortest paths...
136
+	 *                                       Will be automatically created if not passed.
137
+	 */
138
+	public function __construct(Connection $connection, Cache $cache = null, SchemaAnalyzer $schemaAnalyzer = null)
139
+	{
140
+		if (extension_loaded('weakref')) {
141
+			$this->objectStorage = new WeakrefObjectStorage();
142
+		} else {
143
+			$this->objectStorage = new StandardObjectStorage();
144
+		}
145
+		$this->connection = $connection;
146
+		if ($cache !== null) {
147
+			$this->cache = $cache;
148
+		} else {
149
+			$this->cache = new VoidCache();
150
+		}
151
+		if ($schemaAnalyzer) {
152
+			$this->schemaAnalyzer = $schemaAnalyzer;
153
+		} else {
154
+			$this->schemaAnalyzer = new SchemaAnalyzer($this->connection->getSchemaManager(), $this->cache, $this->getConnectionUniqueId());
155
+		}
156
+
157
+		$this->magicQuery = new MagicQuery($this->connection, $this->cache, $this->schemaAnalyzer);
158
+
159
+		$this->tdbmSchemaAnalyzer = new TDBMSchemaAnalyzer($connection, $this->cache, $this->schemaAnalyzer);
160
+		$this->cachePrefix = $this->tdbmSchemaAnalyzer->getCachePrefix();
161
+
162
+		$this->toSaveObjects = new \SplObjectStorage();
163
+	}
164
+
165
+	/**
166
+	 * Returns the object used to connect to the database.
167
+	 *
168
+	 * @return Connection
169
+	 */
170
+	public function getConnection()
171
+	{
172
+		return $this->connection;
173
+	}
174
+
175
+	/**
176
+	 * Creates a unique cache key for the current connection.
177
+	 *
178
+	 * @return string
179
+	 */
180
+	private function getConnectionUniqueId()
181
+	{
182
+		return hash('md4', $this->connection->getHost().'-'.$this->connection->getPort().'-'.$this->connection->getDatabase().'-'.$this->connection->getDriver()->getName());
183
+	}
184
+
185
+	/**
186
+	 * Sets the default fetch mode of the result sets returned by `findObjects`.
187
+	 * Can be one of: TDBMObjectArray::MODE_CURSOR or TDBMObjectArray::MODE_ARRAY.
188
+	 *
189
+	 * In 'MODE_ARRAY' mode (default), the result is a ResultIterator object that behaves like an array. Use this mode by default (unless the list returned is very big).
190
+	 * In 'MODE_CURSOR' mode, the result is a ResultIterator object. If you scan it many times (by calling several time a foreach loop), the query will be run
191
+	 * several times. In cursor mode, you cannot access the result set by key. Use this mode for large datasets processed by batch.
192
+	 *
193
+	 * @param int $mode
194
+	 *
195
+	 * @return $this
196
+	 *
197
+	 * @throws TDBMException
198
+	 */
199
+	public function setFetchMode($mode)
200
+	{
201
+		if ($mode !== self::MODE_CURSOR && $mode !== self::MODE_ARRAY) {
202
+			throw new TDBMException("Unknown fetch mode: '".$this->mode."'");
203
+		}
204
+		$this->mode = $mode;
205
+
206
+		return $this;
207
+	}
208
+
209
+	/**
210
+	 * Returns a TDBMObject associated from table "$table_name".
211
+	 * If the $filters parameter is an int/string, the object returned will be the object whose primary key = $filters.
212
+	 * $filters can also be a set of TDBM_Filters (see the findObjects method for more details).
213
+	 *
214
+	 * For instance, if there is a table 'users', with a primary key on column 'user_id' and a column 'user_name', then
215
+	 * 			$user = $tdbmService->getObject('users',1);
216
+	 * 			echo $user->name;
217
+	 * will return the name of the user whose user_id is one.
218
+	 *
219
+	 * If a table has a primary key over several columns, you should pass to $id an array containing the the value of the various columns.
220
+	 * For instance:
221
+	 * 			$group = $tdbmService->getObject('groups',array(1,2));
222
+	 *
223
+	 * Note that TDBMObject performs caching for you. If you get twice the same object, the reference of the object you will get
224
+	 * will be the same.
225
+	 *
226
+	 * For instance:
227
+	 * 			$user1 = $tdbmService->getObject('users',1);
228
+	 * 			$user2 = $tdbmService->getObject('users',1);
229
+	 * 			$user1->name = 'John Doe';
230
+	 * 			echo $user2->name;
231
+	 * will return 'John Doe'.
232
+	 *
233
+	 * You can use filters instead of passing the primary key. For instance:
234
+	 * 			$user = $tdbmService->getObject('users',new EqualFilter('users', 'login', 'jdoe'));
235
+	 * This will return the user whose login is 'jdoe'.
236
+	 * Please note that if 2 users have the jdoe login in database, the method will throw a TDBM_DuplicateRowException.
237
+	 *
238
+	 * Also, you can specify the return class for the object (provided the return class extends TDBMObject).
239
+	 * For instance:
240
+	 *  	$user = $tdbmService->getObject('users',1,'User');
241
+	 * will return an object from the "User" class. The "User" class must extend the "TDBMObject" class.
242
+	 * Please be sure not to override any method or any property unless you perfectly know what you are doing!
243
+	 *
244
+	 * @param string $table_name   The name of the table we retrieve an object from.
245
+	 * @param mixed  $filters      If the filter is a string/integer, it will be considered as the id of the object (the value of the primary key). Otherwise, it can be a filter bag (see the filterbag parameter of the findObjects method for more details about filter bags)
246
+	 * @param string $className    Optional: The name of the class to instanciate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
247
+	 * @param bool   $lazy_loading If set to true, and if the primary key is passed in parameter of getObject, the object will not be queried in database. It will be queried when you first try to access a column. If at that time the object cannot be found in database, an exception will be thrown.
248
+	 *
249
+	 * @return TDBMObject
250
+	 */
251 251
 /*	public function getObject($table_name, $filters, $className = null, $lazy_loading = false) {
252 252
 
253 253
         if (is_array($filters) || $filters instanceof FilterInterface) {
@@ -333,233 +333,233 @@  discard block
 block discarded – undo
333 333
         return $obj;
334 334
     }*/
335 335
 
336
-    /**
337
-     * Removes the given object from database.
338
-     * This cannot be called on an object that is not attached to this TDBMService
339
-     * (will throw a TDBMInvalidOperationException).
340
-     *
341
-     * @param AbstractTDBMObject $object the object to delete.
342
-     *
343
-     * @throws TDBMException
344
-     * @throws TDBMInvalidOperationException
345
-     */
346
-    public function delete(AbstractTDBMObject $object)
347
-    {
348
-        switch ($object->_getStatus()) {
349
-            case TDBMObjectStateEnum::STATE_DELETED:
350
-                // Nothing to do, object already deleted.
351
-                return;
352
-            case TDBMObjectStateEnum::STATE_DETACHED:
353
-                throw new TDBMInvalidOperationException('Cannot delete a detached object');
354
-            case TDBMObjectStateEnum::STATE_NEW:
355
-                $this->deleteManyToManyRelationships($object);
356
-                foreach ($object->_getDbRows() as $dbRow) {
357
-                    $this->removeFromToSaveObjectList($dbRow);
358
-                }
359
-                break;
360
-            case TDBMObjectStateEnum::STATE_DIRTY:
361
-                foreach ($object->_getDbRows() as $dbRow) {
362
-                    $this->removeFromToSaveObjectList($dbRow);
363
-                }
364
-                // And continue deleting...
365
-            case TDBMObjectStateEnum::STATE_NOT_LOADED:
366
-            case TDBMObjectStateEnum::STATE_LOADED:
367
-                $this->deleteManyToManyRelationships($object);
368
-                // Let's delete db rows, in reverse order.
369
-                foreach (array_reverse($object->_getDbRows()) as $dbRow) {
370
-                    $tableName = $dbRow->_getDbTableName();
371
-                    $primaryKeys = $dbRow->_getPrimaryKeys();
372
-                    $this->connection->delete($tableName, $primaryKeys);
373
-                    $this->objectStorage->remove($dbRow->_getDbTableName(), $this->getObjectHash($primaryKeys));
374
-                }
375
-                break;
376
-            // @codeCoverageIgnoreStart
377
-            default:
378
-                throw new TDBMInvalidOperationException('Unexpected status for bean');
379
-            // @codeCoverageIgnoreEnd
380
-        }
381
-
382
-        $object->_setStatus(TDBMObjectStateEnum::STATE_DELETED);
383
-    }
384
-
385
-    /**
386
-     * Removes all many to many relationships for this object.
387
-     *
388
-     * @param AbstractTDBMObject $object
389
-     */
390
-    private function deleteManyToManyRelationships(AbstractTDBMObject $object)
391
-    {
392
-        foreach ($object->_getDbRows() as $tableName => $dbRow) {
393
-            $pivotTables = $this->tdbmSchemaAnalyzer->getPivotTableLinkedToTable($tableName);
394
-            foreach ($pivotTables as $pivotTable) {
395
-                $remoteBeans = $object->_getRelationships($pivotTable);
396
-                foreach ($remoteBeans as $remoteBean) {
397
-                    $object->_removeRelationship($pivotTable, $remoteBean);
398
-                }
399
-            }
400
-        }
401
-        $this->persistManyToManyRelationships($object);
402
-    }
403
-
404
-    /**
405
-     * This function removes the given object from the database. It will also remove all objects relied to the one given
406
-     * by parameter before all.
407
-     *
408
-     * Notice: if the object has a multiple primary key, the function will not work.
409
-     *
410
-     * @param AbstractTDBMObject $objToDelete
411
-     */
412
-    public function deleteCascade(AbstractTDBMObject $objToDelete)
413
-    {
414
-        $this->deleteAllConstraintWithThisObject($objToDelete);
415
-        $this->delete($objToDelete);
416
-    }
417
-
418
-    /**
419
-     * This function is used only in TDBMService (private function)
420
-     * It will call deleteCascade function foreach object relied with a foreign key to the object given by parameter.
421
-     *
422
-     * @param AbstractTDBMObject $obj
423
-     */
424
-    private function deleteAllConstraintWithThisObject(AbstractTDBMObject $obj)
425
-    {
426
-        $dbRows = $obj->_getDbRows();
427
-        foreach ($dbRows as $dbRow) {
428
-            $tableName = $dbRow->_getDbTableName();
429
-            $pks = array_values($dbRow->_getPrimaryKeys());
430
-            if (!empty($pks)) {
431
-                $incomingFks = $this->tdbmSchemaAnalyzer->getIncomingForeignKeys($tableName);
432
-
433
-                foreach ($incomingFks as $incomingFk) {
434
-                    $filter = array_combine($incomingFk->getLocalColumns(), $pks);
435
-
436
-                    $results = $this->findObjects($incomingFk->getLocalTableName(), $filter);
437
-
438
-                    foreach ($results as $bean) {
439
-                        $this->deleteCascade($bean);
440
-                    }
441
-                }
442
-            }
443
-        }
444
-    }
445
-
446
-    /**
447
-     * This function performs a save() of all the objects that have been modified.
448
-     */
449
-    public function completeSave()
450
-    {
451
-        foreach ($this->toSaveObjects as $dbRow) {
452
-            $this->save($dbRow->getTDBMObject());
453
-        }
454
-    }
455
-
456
-    /**
457
-     * Takes in input a filter_bag (which can be about anything from a string to an array of TDBMObjects... see above from documentation),
458
-     * and gives back a proper Filter object.
459
-     *
460
-     * @param mixed $filter_bag
461
-     * @param int   $counter
462
-     *
463
-     * @return array First item: filter string, second item: parameters.
464
-     *
465
-     * @throws TDBMException
466
-     */
467
-    public function buildFilterFromFilterBag($filter_bag, $counter = 1)
468
-    {
469
-        if ($filter_bag === null) {
470
-            return ['', []];
471
-        } elseif (is_string($filter_bag)) {
472
-            return [$filter_bag, []];
473
-        } elseif (is_array($filter_bag)) {
474
-            $sqlParts = [];
475
-            $parameters = [];
476
-            foreach ($filter_bag as $column => $value) {
477
-                if (is_int($column)) {
478
-                    list($subSqlPart, $subParameters) = $this->buildFilterFromFilterBag($value, $counter);
479
-                    $sqlParts[] = $subSqlPart;
480
-                    $parameters += $subParameters;
481
-                } else {
482
-                    $paramName = 'tdbmparam'.$counter;
483
-                    if (is_array($value)) {
484
-                        $sqlParts[] = $this->connection->quoteIdentifier($column).' IN :'.$paramName;
485
-                    } else {
486
-                        $sqlParts[] = $this->connection->quoteIdentifier($column).' = :'.$paramName;
487
-                    }
488
-                    $parameters[$paramName] = $value;
489
-                    ++$counter;
490
-                }
491
-            }
492
-
493
-            return [implode(' AND ', $sqlParts), $parameters];
494
-        } elseif ($filter_bag instanceof AbstractTDBMObject) {
495
-            $sqlParts = [];
496
-            $parameters = [];
497
-            $dbRows = $filter_bag->_getDbRows();
498
-            $dbRow = reset($dbRows);
499
-            $primaryKeys = $dbRow->_getPrimaryKeys();
500
-
501
-            foreach ($primaryKeys as $column => $value) {
502
-                $paramName = 'tdbmparam'.$counter;
503
-                $sqlParts[] = $this->connection->quoteIdentifier($dbRow->_getDbTableName()).'.'.$this->connection->quoteIdentifier($column).' = :'.$paramName;
504
-                $parameters[$paramName] = $value;
505
-                ++$counter;
506
-            }
507
-
508
-            return [implode(' AND ', $sqlParts), $parameters];
509
-        } elseif ($filter_bag instanceof \Iterator) {
510
-            return $this->buildFilterFromFilterBag(iterator_to_array($filter_bag), $counter);
511
-        } else {
512
-            throw new TDBMException('Error in filter. An object has been passed that is neither a SQL string, nor an array, nor a bean, nor null.');
513
-        }
514
-    }
515
-
516
-    /**
517
-     * Takes in input an order_bag (which can be about anything from a string to an array of OrderByColumn objects... see above from documentation),
518
-     * and gives back an array of OrderByColumn / OrderBySQLString objects.
519
-     *
520
-     * @param unknown_type $orderby_bag
521
-     *
522
-     * @return array
523
-     */
524
-    public function buildOrderArrayFromOrderBag($orderby_bag)
525
-    {
526
-        // Fourth, let's apply the same steps to the orderby_bag
527
-        // 4-1 orderby_bag should be an array, if it is a singleton, let's put it in an array.
528
-
529
-        if (!is_array($orderby_bag)) {
530
-            $orderby_bag = array($orderby_bag);
531
-        }
532
-
533
-        // 4-2, let's take all the objects out of the orderby bag, and let's make objects from them
534
-        $orderby_bag2 = array();
535
-        foreach ($orderby_bag as $thing) {
536
-            if (is_a($thing, 'Mouf\\Database\\TDBM\\Filters\\OrderBySQLString')) {
537
-                $orderby_bag2[] = $thing;
538
-            } elseif (is_a($thing, 'Mouf\\Database\\TDBM\\Filters\\OrderByColumn')) {
539
-                $orderby_bag2[] = $thing;
540
-            } elseif (is_string($thing)) {
541
-                $orderby_bag2[] = new OrderBySQLString($thing);
542
-            } elseif ($thing !== null) {
543
-                throw new TDBMException('Error in orderby bag in getObjectsByFilter. An object has been passed that is neither a OrderBySQLString, nor a OrderByColumn, nor a string, nor null.');
544
-            }
545
-        }
546
-
547
-        return $orderby_bag2;
548
-    }
549
-
550
-    /**
551
-     * @param string $table
552
-     *
553
-     * @return string[]
554
-     */
555
-    public function getPrimaryKeyColumns($table)
556
-    {
557
-        if (!isset($this->primaryKeysColumns[$table])) {
558
-            $this->primaryKeysColumns[$table] = $this->tdbmSchemaAnalyzer->getSchema()->getTable($table)->getPrimaryKeyColumns();
559
-
560
-            // TODO TDBM4: See if we need to improve error reporting if table name does not exist.
561
-
562
-            /*$arr = array();
336
+	/**
337
+	 * Removes the given object from database.
338
+	 * This cannot be called on an object that is not attached to this TDBMService
339
+	 * (will throw a TDBMInvalidOperationException).
340
+	 *
341
+	 * @param AbstractTDBMObject $object the object to delete.
342
+	 *
343
+	 * @throws TDBMException
344
+	 * @throws TDBMInvalidOperationException
345
+	 */
346
+	public function delete(AbstractTDBMObject $object)
347
+	{
348
+		switch ($object->_getStatus()) {
349
+			case TDBMObjectStateEnum::STATE_DELETED:
350
+				// Nothing to do, object already deleted.
351
+				return;
352
+			case TDBMObjectStateEnum::STATE_DETACHED:
353
+				throw new TDBMInvalidOperationException('Cannot delete a detached object');
354
+			case TDBMObjectStateEnum::STATE_NEW:
355
+				$this->deleteManyToManyRelationships($object);
356
+				foreach ($object->_getDbRows() as $dbRow) {
357
+					$this->removeFromToSaveObjectList($dbRow);
358
+				}
359
+				break;
360
+			case TDBMObjectStateEnum::STATE_DIRTY:
361
+				foreach ($object->_getDbRows() as $dbRow) {
362
+					$this->removeFromToSaveObjectList($dbRow);
363
+				}
364
+				// And continue deleting...
365
+			case TDBMObjectStateEnum::STATE_NOT_LOADED:
366
+			case TDBMObjectStateEnum::STATE_LOADED:
367
+				$this->deleteManyToManyRelationships($object);
368
+				// Let's delete db rows, in reverse order.
369
+				foreach (array_reverse($object->_getDbRows()) as $dbRow) {
370
+					$tableName = $dbRow->_getDbTableName();
371
+					$primaryKeys = $dbRow->_getPrimaryKeys();
372
+					$this->connection->delete($tableName, $primaryKeys);
373
+					$this->objectStorage->remove($dbRow->_getDbTableName(), $this->getObjectHash($primaryKeys));
374
+				}
375
+				break;
376
+			// @codeCoverageIgnoreStart
377
+			default:
378
+				throw new TDBMInvalidOperationException('Unexpected status for bean');
379
+			// @codeCoverageIgnoreEnd
380
+		}
381
+
382
+		$object->_setStatus(TDBMObjectStateEnum::STATE_DELETED);
383
+	}
384
+
385
+	/**
386
+	 * Removes all many to many relationships for this object.
387
+	 *
388
+	 * @param AbstractTDBMObject $object
389
+	 */
390
+	private function deleteManyToManyRelationships(AbstractTDBMObject $object)
391
+	{
392
+		foreach ($object->_getDbRows() as $tableName => $dbRow) {
393
+			$pivotTables = $this->tdbmSchemaAnalyzer->getPivotTableLinkedToTable($tableName);
394
+			foreach ($pivotTables as $pivotTable) {
395
+				$remoteBeans = $object->_getRelationships($pivotTable);
396
+				foreach ($remoteBeans as $remoteBean) {
397
+					$object->_removeRelationship($pivotTable, $remoteBean);
398
+				}
399
+			}
400
+		}
401
+		$this->persistManyToManyRelationships($object);
402
+	}
403
+
404
+	/**
405
+	 * This function removes the given object from the database. It will also remove all objects relied to the one given
406
+	 * by parameter before all.
407
+	 *
408
+	 * Notice: if the object has a multiple primary key, the function will not work.
409
+	 *
410
+	 * @param AbstractTDBMObject $objToDelete
411
+	 */
412
+	public function deleteCascade(AbstractTDBMObject $objToDelete)
413
+	{
414
+		$this->deleteAllConstraintWithThisObject($objToDelete);
415
+		$this->delete($objToDelete);
416
+	}
417
+
418
+	/**
419
+	 * This function is used only in TDBMService (private function)
420
+	 * It will call deleteCascade function foreach object relied with a foreign key to the object given by parameter.
421
+	 *
422
+	 * @param AbstractTDBMObject $obj
423
+	 */
424
+	private function deleteAllConstraintWithThisObject(AbstractTDBMObject $obj)
425
+	{
426
+		$dbRows = $obj->_getDbRows();
427
+		foreach ($dbRows as $dbRow) {
428
+			$tableName = $dbRow->_getDbTableName();
429
+			$pks = array_values($dbRow->_getPrimaryKeys());
430
+			if (!empty($pks)) {
431
+				$incomingFks = $this->tdbmSchemaAnalyzer->getIncomingForeignKeys($tableName);
432
+
433
+				foreach ($incomingFks as $incomingFk) {
434
+					$filter = array_combine($incomingFk->getLocalColumns(), $pks);
435
+
436
+					$results = $this->findObjects($incomingFk->getLocalTableName(), $filter);
437
+
438
+					foreach ($results as $bean) {
439
+						$this->deleteCascade($bean);
440
+					}
441
+				}
442
+			}
443
+		}
444
+	}
445
+
446
+	/**
447
+	 * This function performs a save() of all the objects that have been modified.
448
+	 */
449
+	public function completeSave()
450
+	{
451
+		foreach ($this->toSaveObjects as $dbRow) {
452
+			$this->save($dbRow->getTDBMObject());
453
+		}
454
+	}
455
+
456
+	/**
457
+	 * Takes in input a filter_bag (which can be about anything from a string to an array of TDBMObjects... see above from documentation),
458
+	 * and gives back a proper Filter object.
459
+	 *
460
+	 * @param mixed $filter_bag
461
+	 * @param int   $counter
462
+	 *
463
+	 * @return array First item: filter string, second item: parameters.
464
+	 *
465
+	 * @throws TDBMException
466
+	 */
467
+	public function buildFilterFromFilterBag($filter_bag, $counter = 1)
468
+	{
469
+		if ($filter_bag === null) {
470
+			return ['', []];
471
+		} elseif (is_string($filter_bag)) {
472
+			return [$filter_bag, []];
473
+		} elseif (is_array($filter_bag)) {
474
+			$sqlParts = [];
475
+			$parameters = [];
476
+			foreach ($filter_bag as $column => $value) {
477
+				if (is_int($column)) {
478
+					list($subSqlPart, $subParameters) = $this->buildFilterFromFilterBag($value, $counter);
479
+					$sqlParts[] = $subSqlPart;
480
+					$parameters += $subParameters;
481
+				} else {
482
+					$paramName = 'tdbmparam'.$counter;
483
+					if (is_array($value)) {
484
+						$sqlParts[] = $this->connection->quoteIdentifier($column).' IN :'.$paramName;
485
+					} else {
486
+						$sqlParts[] = $this->connection->quoteIdentifier($column).' = :'.$paramName;
487
+					}
488
+					$parameters[$paramName] = $value;
489
+					++$counter;
490
+				}
491
+			}
492
+
493
+			return [implode(' AND ', $sqlParts), $parameters];
494
+		} elseif ($filter_bag instanceof AbstractTDBMObject) {
495
+			$sqlParts = [];
496
+			$parameters = [];
497
+			$dbRows = $filter_bag->_getDbRows();
498
+			$dbRow = reset($dbRows);
499
+			$primaryKeys = $dbRow->_getPrimaryKeys();
500
+
501
+			foreach ($primaryKeys as $column => $value) {
502
+				$paramName = 'tdbmparam'.$counter;
503
+				$sqlParts[] = $this->connection->quoteIdentifier($dbRow->_getDbTableName()).'.'.$this->connection->quoteIdentifier($column).' = :'.$paramName;
504
+				$parameters[$paramName] = $value;
505
+				++$counter;
506
+			}
507
+
508
+			return [implode(' AND ', $sqlParts), $parameters];
509
+		} elseif ($filter_bag instanceof \Iterator) {
510
+			return $this->buildFilterFromFilterBag(iterator_to_array($filter_bag), $counter);
511
+		} else {
512
+			throw new TDBMException('Error in filter. An object has been passed that is neither a SQL string, nor an array, nor a bean, nor null.');
513
+		}
514
+	}
515
+
516
+	/**
517
+	 * Takes in input an order_bag (which can be about anything from a string to an array of OrderByColumn objects... see above from documentation),
518
+	 * and gives back an array of OrderByColumn / OrderBySQLString objects.
519
+	 *
520
+	 * @param unknown_type $orderby_bag
521
+	 *
522
+	 * @return array
523
+	 */
524
+	public function buildOrderArrayFromOrderBag($orderby_bag)
525
+	{
526
+		// Fourth, let's apply the same steps to the orderby_bag
527
+		// 4-1 orderby_bag should be an array, if it is a singleton, let's put it in an array.
528
+
529
+		if (!is_array($orderby_bag)) {
530
+			$orderby_bag = array($orderby_bag);
531
+		}
532
+
533
+		// 4-2, let's take all the objects out of the orderby bag, and let's make objects from them
534
+		$orderby_bag2 = array();
535
+		foreach ($orderby_bag as $thing) {
536
+			if (is_a($thing, 'Mouf\\Database\\TDBM\\Filters\\OrderBySQLString')) {
537
+				$orderby_bag2[] = $thing;
538
+			} elseif (is_a($thing, 'Mouf\\Database\\TDBM\\Filters\\OrderByColumn')) {
539
+				$orderby_bag2[] = $thing;
540
+			} elseif (is_string($thing)) {
541
+				$orderby_bag2[] = new OrderBySQLString($thing);
542
+			} elseif ($thing !== null) {
543
+				throw new TDBMException('Error in orderby bag in getObjectsByFilter. An object has been passed that is neither a OrderBySQLString, nor a OrderByColumn, nor a string, nor null.');
544
+			}
545
+		}
546
+
547
+		return $orderby_bag2;
548
+	}
549
+
550
+	/**
551
+	 * @param string $table
552
+	 *
553
+	 * @return string[]
554
+	 */
555
+	public function getPrimaryKeyColumns($table)
556
+	{
557
+		if (!isset($this->primaryKeysColumns[$table])) {
558
+			$this->primaryKeysColumns[$table] = $this->tdbmSchemaAnalyzer->getSchema()->getTable($table)->getPrimaryKeyColumns();
559
+
560
+			// TODO TDBM4: See if we need to improve error reporting if table name does not exist.
561
+
562
+			/*$arr = array();
563 563
             foreach ($this->connection->getPrimaryKey($table) as $col) {
564 564
                 $arr[] = $col->name;
565 565
             }
@@ -580,132 +580,132 @@  discard block
 block discarded – undo
580 580
                     throw new TDBMException($str);
581 581
                 }
582 582
             }*/
583
-        }
584
-
585
-        return $this->primaryKeysColumns[$table];
586
-    }
587
-
588
-    /**
589
-     * This is an internal function, you should not use it in your application.
590
-     * This is used internally by TDBM to add an object to the object cache.
591
-     *
592
-     * @param DbRow $dbRow
593
-     */
594
-    public function _addToCache(DbRow $dbRow)
595
-    {
596
-        $primaryKey = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
597
-        $hash = $this->getObjectHash($primaryKey);
598
-        $this->objectStorage->set($dbRow->_getDbTableName(), $hash, $dbRow);
599
-    }
600
-
601
-    /**
602
-     * This is an internal function, you should not use it in your application.
603
-     * This is used internally by TDBM to remove the object from the list of objects that have been
604
-     * created/updated but not saved yet.
605
-     *
606
-     * @param DbRow $myObject
607
-     */
608
-    private function removeFromToSaveObjectList(DbRow $myObject)
609
-    {
610
-        unset($this->toSaveObjects[$myObject]);
611
-    }
612
-
613
-    /**
614
-     * This is an internal function, you should not use it in your application.
615
-     * This is used internally by TDBM to add an object to the list of objects that have been
616
-     * created/updated but not saved yet.
617
-     *
618
-     * @param AbstractTDBMObject $myObject
619
-     */
620
-    public function _addToToSaveObjectList(DbRow $myObject)
621
-    {
622
-        $this->toSaveObjects[$myObject] = true;
623
-    }
624
-
625
-    /**
626
-     * Generates all the daos and beans.
627
-     *
628
-     * @param string $daoFactoryClassName The classe name of the DAO factory
629
-     * @param string $daonamespace        The namespace for the DAOs, without trailing \
630
-     * @param string $beannamespace       The Namespace for the beans, without trailing \
631
-     * @param bool   $storeInUtc          If the generated daos should store the date in UTC timezone instead of user's timezone.
632
-     * @param string $composerFile        If it's set, location of custom Composer file. Relative to project root.
633
-     *
634
-     * @return \string[] the list of tables
635
-     */
636
-    public function generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc, $composerFile = null)
637
-    {
638
-        $tdbmDaoGenerator = new TDBMDaoGenerator($this->schemaAnalyzer, $this->tdbmSchemaAnalyzer->getSchema(), $this->tdbmSchemaAnalyzer);
639
-        if ($composerFile) {
640
-            $tdbmDaoGenerator->setComposerFile(__DIR__.'/../../../../../../../'.$composerFile);
641
-        }
642
-
643
-        return $tdbmDaoGenerator->generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc);
644
-    }
645
-
646
-    /**
647
-     * @param array<string, string> $tableToBeanMap
648
-     */
649
-    public function setTableToBeanMap(array $tableToBeanMap)
650
-    {
651
-        $this->tableToBeanMap = $tableToBeanMap;
652
-    }
653
-
654
-    /**
655
-     * Saves $object by INSERTing or UPDAT(E)ing it in the database.
656
-     *
657
-     * @param AbstractTDBMObject $object
658
-     *
659
-     * @throws TDBMException
660
-     */
661
-    public function save(AbstractTDBMObject $object)
662
-    {
663
-        $status = $object->_getStatus();
664
-
665
-        // Let's attach this object if it is in detached state.
666
-        if ($status === TDBMObjectStateEnum::STATE_DETACHED) {
667
-            $object->_attach($this);
668
-            $status = $object->_getStatus();
669
-        }
670
-
671
-        if ($status === TDBMObjectStateEnum::STATE_NEW) {
672
-            $dbRows = $object->_getDbRows();
673
-
674
-            $unindexedPrimaryKeys = array();
675
-
676
-            foreach ($dbRows as $dbRow) {
677
-                $tableName = $dbRow->_getDbTableName();
678
-
679
-                $schema = $this->tdbmSchemaAnalyzer->getSchema();
680
-                $tableDescriptor = $schema->getTable($tableName);
681
-
682
-                $primaryKeyColumns = $this->getPrimaryKeyColumns($tableName);
683
-
684
-                if (empty($unindexedPrimaryKeys)) {
685
-                    $primaryKeys = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
686
-                } else {
687
-                    // First insert, the children must have the same primary key as the parent.
688
-                    $primaryKeys = $this->_getPrimaryKeysFromIndexedPrimaryKeys($tableName, $unindexedPrimaryKeys);
689
-                    $dbRow->_setPrimaryKeys($primaryKeys);
690
-                }
691
-
692
-                $references = $dbRow->_getReferences();
693
-
694
-                // Let's save all references in NEW or DETACHED state (we need their primary key)
695
-                foreach ($references as $fkName => $reference) {
696
-                    $refStatus = $reference->_getStatus();
697
-                    if ($refStatus === TDBMObjectStateEnum::STATE_NEW || $refStatus === TDBMObjectStateEnum::STATE_DETACHED) {
698
-                        $this->save($reference);
699
-                    }
700
-                }
701
-
702
-                $dbRowData = $dbRow->_getDbRow();
703
-
704
-                // Let's see if the columns for primary key have been set before inserting.
705
-                // We assume that if one of the value of the PK has been set, the PK is set.
706
-                $isPkSet = !empty($primaryKeys);
707
-
708
-                /*if (!$isPkSet) {
583
+		}
584
+
585
+		return $this->primaryKeysColumns[$table];
586
+	}
587
+
588
+	/**
589
+	 * This is an internal function, you should not use it in your application.
590
+	 * This is used internally by TDBM to add an object to the object cache.
591
+	 *
592
+	 * @param DbRow $dbRow
593
+	 */
594
+	public function _addToCache(DbRow $dbRow)
595
+	{
596
+		$primaryKey = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
597
+		$hash = $this->getObjectHash($primaryKey);
598
+		$this->objectStorage->set($dbRow->_getDbTableName(), $hash, $dbRow);
599
+	}
600
+
601
+	/**
602
+	 * This is an internal function, you should not use it in your application.
603
+	 * This is used internally by TDBM to remove the object from the list of objects that have been
604
+	 * created/updated but not saved yet.
605
+	 *
606
+	 * @param DbRow $myObject
607
+	 */
608
+	private function removeFromToSaveObjectList(DbRow $myObject)
609
+	{
610
+		unset($this->toSaveObjects[$myObject]);
611
+	}
612
+
613
+	/**
614
+	 * This is an internal function, you should not use it in your application.
615
+	 * This is used internally by TDBM to add an object to the list of objects that have been
616
+	 * created/updated but not saved yet.
617
+	 *
618
+	 * @param AbstractTDBMObject $myObject
619
+	 */
620
+	public function _addToToSaveObjectList(DbRow $myObject)
621
+	{
622
+		$this->toSaveObjects[$myObject] = true;
623
+	}
624
+
625
+	/**
626
+	 * Generates all the daos and beans.
627
+	 *
628
+	 * @param string $daoFactoryClassName The classe name of the DAO factory
629
+	 * @param string $daonamespace        The namespace for the DAOs, without trailing \
630
+	 * @param string $beannamespace       The Namespace for the beans, without trailing \
631
+	 * @param bool   $storeInUtc          If the generated daos should store the date in UTC timezone instead of user's timezone.
632
+	 * @param string $composerFile        If it's set, location of custom Composer file. Relative to project root.
633
+	 *
634
+	 * @return \string[] the list of tables
635
+	 */
636
+	public function generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc, $composerFile = null)
637
+	{
638
+		$tdbmDaoGenerator = new TDBMDaoGenerator($this->schemaAnalyzer, $this->tdbmSchemaAnalyzer->getSchema(), $this->tdbmSchemaAnalyzer);
639
+		if ($composerFile) {
640
+			$tdbmDaoGenerator->setComposerFile(__DIR__.'/../../../../../../../'.$composerFile);
641
+		}
642
+
643
+		return $tdbmDaoGenerator->generateAllDaosAndBeans($daoFactoryClassName, $daonamespace, $beannamespace, $storeInUtc);
644
+	}
645
+
646
+	/**
647
+	 * @param array<string, string> $tableToBeanMap
648
+	 */
649
+	public function setTableToBeanMap(array $tableToBeanMap)
650
+	{
651
+		$this->tableToBeanMap = $tableToBeanMap;
652
+	}
653
+
654
+	/**
655
+	 * Saves $object by INSERTing or UPDAT(E)ing it in the database.
656
+	 *
657
+	 * @param AbstractTDBMObject $object
658
+	 *
659
+	 * @throws TDBMException
660
+	 */
661
+	public function save(AbstractTDBMObject $object)
662
+	{
663
+		$status = $object->_getStatus();
664
+
665
+		// Let's attach this object if it is in detached state.
666
+		if ($status === TDBMObjectStateEnum::STATE_DETACHED) {
667
+			$object->_attach($this);
668
+			$status = $object->_getStatus();
669
+		}
670
+
671
+		if ($status === TDBMObjectStateEnum::STATE_NEW) {
672
+			$dbRows = $object->_getDbRows();
673
+
674
+			$unindexedPrimaryKeys = array();
675
+
676
+			foreach ($dbRows as $dbRow) {
677
+				$tableName = $dbRow->_getDbTableName();
678
+
679
+				$schema = $this->tdbmSchemaAnalyzer->getSchema();
680
+				$tableDescriptor = $schema->getTable($tableName);
681
+
682
+				$primaryKeyColumns = $this->getPrimaryKeyColumns($tableName);
683
+
684
+				if (empty($unindexedPrimaryKeys)) {
685
+					$primaryKeys = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
686
+				} else {
687
+					// First insert, the children must have the same primary key as the parent.
688
+					$primaryKeys = $this->_getPrimaryKeysFromIndexedPrimaryKeys($tableName, $unindexedPrimaryKeys);
689
+					$dbRow->_setPrimaryKeys($primaryKeys);
690
+				}
691
+
692
+				$references = $dbRow->_getReferences();
693
+
694
+				// Let's save all references in NEW or DETACHED state (we need their primary key)
695
+				foreach ($references as $fkName => $reference) {
696
+					$refStatus = $reference->_getStatus();
697
+					if ($refStatus === TDBMObjectStateEnum::STATE_NEW || $refStatus === TDBMObjectStateEnum::STATE_DETACHED) {
698
+						$this->save($reference);
699
+					}
700
+				}
701
+
702
+				$dbRowData = $dbRow->_getDbRow();
703
+
704
+				// Let's see if the columns for primary key have been set before inserting.
705
+				// We assume that if one of the value of the PK has been set, the PK is set.
706
+				$isPkSet = !empty($primaryKeys);
707
+
708
+				/*if (!$isPkSet) {
709 709
                     // if there is no autoincrement and no pk set, let's go in error.
710 710
                     $isAutoIncrement = true;
711 711
 
@@ -723,25 +723,25 @@  discard block
 block discarded – undo
723 723
 
724 724
                 }*/
725 725
 
726
-                $types = [];
726
+				$types = [];
727 727
 
728
-                foreach ($dbRowData as $columnName => $value) {
729
-                    $columnDescriptor = $tableDescriptor->getColumn($columnName);
730
-                    $types[] = $columnDescriptor->getType();
731
-                }
728
+				foreach ($dbRowData as $columnName => $value) {
729
+					$columnDescriptor = $tableDescriptor->getColumn($columnName);
730
+					$types[] = $columnDescriptor->getType();
731
+				}
732 732
 
733
-                $this->connection->insert($tableName, $dbRowData, $types);
733
+				$this->connection->insert($tableName, $dbRowData, $types);
734 734
 
735
-                if (!$isPkSet && count($primaryKeyColumns) == 1) {
736
-                    $id = $this->connection->lastInsertId();
737
-                    $primaryKeys[$primaryKeyColumns[0]] = $id;
738
-                }
735
+				if (!$isPkSet && count($primaryKeyColumns) == 1) {
736
+					$id = $this->connection->lastInsertId();
737
+					$primaryKeys[$primaryKeyColumns[0]] = $id;
738
+				}
739 739
 
740
-                // TODO: change this to some private magic accessor in future
741
-                $dbRow->_setPrimaryKeys($primaryKeys);
742
-                $unindexedPrimaryKeys = array_values($primaryKeys);
740
+				// TODO: change this to some private magic accessor in future
741
+				$dbRow->_setPrimaryKeys($primaryKeys);
742
+				$unindexedPrimaryKeys = array_values($primaryKeys);
743 743
 
744
-                /*
744
+				/*
745 745
                  * When attached, on "save", we check if the column updated is part of a primary key
746 746
                  * If this is part of a primary key, we call the _update_id method that updates the id in the list of known objects.
747 747
                  * This method should first verify that the id is not already used (and is not auto-incremented)
@@ -751,7 +751,7 @@  discard block
 block discarded – undo
751 751
                  *
752 752
                  */
753 753
 
754
-                /*try {
754
+				/*try {
755 755
                     $this->db_connection->exec($sql);
756 756
                 } catch (TDBMException $e) {
757 757
                     $this->db_onerror = true;
@@ -770,390 +770,390 @@  discard block
 block discarded – undo
770 770
                     }
771 771
                 }*/
772 772
 
773
-                // Let's remove this object from the $new_objects static table.
774
-                $this->removeFromToSaveObjectList($dbRow);
775
-
776
-                // TODO: change this behaviour to something more sensible performance-wise
777
-                // Maybe a setting to trigger this globally?
778
-                //$this->status = TDBMObjectStateEnum::STATE_NOT_LOADED;
779
-                //$this->db_modified_state = false;
780
-                //$dbRow = array();
781
-
782
-                // Let's add this object to the list of objects in cache.
783
-                $this->_addToCache($dbRow);
784
-            }
785
-
786
-            $object->_setStatus(TDBMObjectStateEnum::STATE_LOADED);
787
-        } elseif ($status === TDBMObjectStateEnum::STATE_DIRTY) {
788
-            $dbRows = $object->_getDbRows();
789
-
790
-            foreach ($dbRows as $dbRow) {
791
-                $references = $dbRow->_getReferences();
792
-
793
-                // Let's save all references in NEW state (we need their primary key)
794
-                foreach ($references as $fkName => $reference) {
795
-                    if ($reference->_getStatus() === TDBMObjectStateEnum::STATE_NEW) {
796
-                        $this->save($reference);
797
-                    }
798
-                }
799
-
800
-                // Let's first get the primary keys
801
-                $tableName = $dbRow->_getDbTableName();
802
-                $dbRowData = $dbRow->_getDbRow();
803
-
804
-                $schema = $this->tdbmSchemaAnalyzer->getSchema();
805
-                $tableDescriptor = $schema->getTable($tableName);
806
-
807
-                $primaryKeys = $dbRow->_getPrimaryKeys();
808
-
809
-                $types = [];
810
-
811
-                foreach ($dbRowData as $columnName => $value) {
812
-                    $columnDescriptor = $tableDescriptor->getColumn($columnName);
813
-                    $types[] = $columnDescriptor->getType();
814
-                }
815
-                foreach ($primaryKeys as $columnName => $value) {
816
-                    $columnDescriptor = $tableDescriptor->getColumn($columnName);
817
-                    $types[] = $columnDescriptor->getType();
818
-                }
819
-
820
-                $this->connection->update($tableName, $dbRowData, $primaryKeys, $types);
821
-
822
-                // Let's check if the primary key has been updated...
823
-                $needsUpdatePk = false;
824
-                foreach ($primaryKeys as $column => $value) {
825
-                    if (!isset($dbRowData[$column]) || $dbRowData[$column] != $value) {
826
-                        $needsUpdatePk = true;
827
-                        break;
828
-                    }
829
-                }
830
-                if ($needsUpdatePk) {
831
-                    $this->objectStorage->remove($tableName, $this->getObjectHash($primaryKeys));
832
-                    $newPrimaryKeys = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
833
-                    $dbRow->_setPrimaryKeys($newPrimaryKeys);
834
-                    $this->objectStorage->set($tableName, $this->getObjectHash($primaryKeys), $dbRow);
835
-                }
836
-
837
-                // Let's remove this object from the list of objects to save.
838
-                $this->removeFromToSaveObjectList($dbRow);
839
-            }
840
-
841
-            $object->_setStatus(TDBMObjectStateEnum::STATE_LOADED);
842
-        } elseif ($status === TDBMObjectStateEnum::STATE_DELETED) {
843
-            throw new TDBMInvalidOperationException('This object has been deleted. It cannot be saved.');
844
-        }
845
-
846
-        // Finally, let's save all the many to many relationships to this bean.
847
-        $this->persistManyToManyRelationships($object);
848
-    }
849
-
850
-    private function persistManyToManyRelationships(AbstractTDBMObject $object)
851
-    {
852
-        foreach ($object->_getCachedRelationships() as $pivotTableName => $storage) {
853
-            $tableDescriptor = $this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName);
854
-            list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $object);
855
-
856
-            foreach ($storage as $remoteBean) {
857
-                /* @var $remoteBean AbstractTDBMObject */
858
-                $statusArr = $storage[$remoteBean];
859
-                $status = $statusArr['status'];
860
-                $reverse = $statusArr['reverse'];
861
-                if ($reverse) {
862
-                    continue;
863
-                }
864
-
865
-                if ($status === 'new') {
866
-                    $remoteBeanStatus = $remoteBean->_getStatus();
867
-                    if ($remoteBeanStatus === TDBMObjectStateEnum::STATE_NEW || $remoteBeanStatus === TDBMObjectStateEnum::STATE_DETACHED) {
868
-                        // Let's save remote bean if needed.
869
-                        $this->save($remoteBean);
870
-                    }
871
-
872
-                    $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk);
873
-
874
-                    $types = [];
875
-
876
-                    foreach ($filters as $columnName => $value) {
877
-                        $columnDescriptor = $tableDescriptor->getColumn($columnName);
878
-                        $types[] = $columnDescriptor->getType();
879
-                    }
880
-
881
-                    $this->connection->insert($pivotTableName, $filters, $types);
882
-
883
-                    // Finally, let's mark relationships as saved.
884
-                    $statusArr['status'] = 'loaded';
885
-                    $storage[$remoteBean] = $statusArr;
886
-                    $remoteStorage = $remoteBean->_getCachedRelationships()[$pivotTableName];
887
-                    $remoteStatusArr = $remoteStorage[$object];
888
-                    $remoteStatusArr['status'] = 'loaded';
889
-                    $remoteStorage[$object] = $remoteStatusArr;
890
-                } elseif ($status === 'delete') {
891
-                    $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk);
892
-
893
-                    $types = [];
894
-
895
-                    foreach ($filters as $columnName => $value) {
896
-                        $columnDescriptor = $tableDescriptor->getColumn($columnName);
897
-                        $types[] = $columnDescriptor->getType();
898
-                    }
899
-
900
-                    $this->connection->delete($pivotTableName, $filters, $types);
901
-
902
-                    // Finally, let's remove relationships completely from bean.
903
-                    $storage->detach($remoteBean);
904
-                    $remoteBean->_getCachedRelationships()[$pivotTableName]->detach($object);
905
-                }
906
-            }
907
-        }
908
-    }
909
-
910
-    private function getPivotFilters(AbstractTDBMObject $localBean, AbstractTDBMObject $remoteBean, ForeignKeyConstraint $localFk, ForeignKeyConstraint $remoteFk)
911
-    {
912
-        $localBeanPk = $this->getPrimaryKeyValues($localBean);
913
-        $remoteBeanPk = $this->getPrimaryKeyValues($remoteBean);
914
-        $localColumns = $localFk->getLocalColumns();
915
-        $remoteColumns = $remoteFk->getLocalColumns();
916
-
917
-        $localFilters = array_combine($localColumns, $localBeanPk);
918
-        $remoteFilters = array_combine($remoteColumns, $remoteBeanPk);
919
-
920
-        return array_merge($localFilters, $remoteFilters);
921
-    }
922
-
923
-    /**
924
-     * Returns the "values" of the primary key.
925
-     * This returns the primary key from the $primaryKey attribute, not the one stored in the columns.
926
-     *
927
-     * @param AbstractTDBMObject $bean
928
-     *
929
-     * @return array numerically indexed array of values.
930
-     */
931
-    private function getPrimaryKeyValues(AbstractTDBMObject $bean)
932
-    {
933
-        $dbRows = $bean->_getDbRows();
934
-        $dbRow = reset($dbRows);
935
-
936
-        return array_values($dbRow->_getPrimaryKeys());
937
-    }
938
-
939
-    /**
940
-     * Returns a unique hash used to store the object based on its primary key.
941
-     * If the array contains only one value, then the value is returned.
942
-     * Otherwise, a hash representing the array is returned.
943
-     *
944
-     * @param array $primaryKeys An array of columns => values forming the primary key
945
-     *
946
-     * @return string
947
-     */
948
-    public function getObjectHash(array $primaryKeys)
949
-    {
950
-        if (count($primaryKeys) === 1) {
951
-            return reset($primaryKeys);
952
-        } else {
953
-            ksort($primaryKeys);
954
-
955
-            return md5(json_encode($primaryKeys));
956
-        }
957
-    }
958
-
959
-    /**
960
-     * Returns an array of primary keys from the object.
961
-     * The primary keys are extracted from the object columns and not from the primary keys stored in the
962
-     * $primaryKeys variable of the object.
963
-     *
964
-     * @param DbRow $dbRow
965
-     *
966
-     * @return array Returns an array of column => value
967
-     */
968
-    public function getPrimaryKeysForObjectFromDbRow(DbRow $dbRow)
969
-    {
970
-        $table = $dbRow->_getDbTableName();
971
-        $dbRowData = $dbRow->_getDbRow();
972
-
973
-        return $this->_getPrimaryKeysFromObjectData($table, $dbRowData);
974
-    }
975
-
976
-    /**
977
-     * Returns an array of primary keys for the given row.
978
-     * The primary keys are extracted from the object columns.
979
-     *
980
-     * @param $table
981
-     * @param array $columns
982
-     *
983
-     * @return array
984
-     */
985
-    public function _getPrimaryKeysFromObjectData($table, array $columns)
986
-    {
987
-        $primaryKeyColumns = $this->getPrimaryKeyColumns($table);
988
-        $values = array();
989
-        foreach ($primaryKeyColumns as $column) {
990
-            if (isset($columns[$column])) {
991
-                $values[$column] = $columns[$column];
992
-            }
993
-        }
994
-
995
-        return $values;
996
-    }
997
-
998
-    /**
999
-     * Attaches $object to this TDBMService.
1000
-     * The $object must be in DETACHED state and will pass in NEW state.
1001
-     *
1002
-     * @param AbstractTDBMObject $object
1003
-     *
1004
-     * @throws TDBMInvalidOperationException
1005
-     */
1006
-    public function attach(AbstractTDBMObject $object)
1007
-    {
1008
-        $object->_attach($this);
1009
-    }
1010
-
1011
-    /**
1012
-     * Returns an associative array (column => value) for the primary keys from the table name and an
1013
-     * indexed array of primary key values.
1014
-     *
1015
-     * @param string $tableName
1016
-     * @param array  $indexedPrimaryKeys
1017
-     */
1018
-    public function _getPrimaryKeysFromIndexedPrimaryKeys($tableName, array $indexedPrimaryKeys)
1019
-    {
1020
-        $primaryKeyColumns = $this->tdbmSchemaAnalyzer->getSchema()->getTable($tableName)->getPrimaryKeyColumns();
1021
-
1022
-        if (count($primaryKeyColumns) !== count($indexedPrimaryKeys)) {
1023
-            throw new TDBMException(sprintf('Wrong number of columns passed for primary key. Expected %s columns for table "%s",
773
+				// Let's remove this object from the $new_objects static table.
774
+				$this->removeFromToSaveObjectList($dbRow);
775
+
776
+				// TODO: change this behaviour to something more sensible performance-wise
777
+				// Maybe a setting to trigger this globally?
778
+				//$this->status = TDBMObjectStateEnum::STATE_NOT_LOADED;
779
+				//$this->db_modified_state = false;
780
+				//$dbRow = array();
781
+
782
+				// Let's add this object to the list of objects in cache.
783
+				$this->_addToCache($dbRow);
784
+			}
785
+
786
+			$object->_setStatus(TDBMObjectStateEnum::STATE_LOADED);
787
+		} elseif ($status === TDBMObjectStateEnum::STATE_DIRTY) {
788
+			$dbRows = $object->_getDbRows();
789
+
790
+			foreach ($dbRows as $dbRow) {
791
+				$references = $dbRow->_getReferences();
792
+
793
+				// Let's save all references in NEW state (we need their primary key)
794
+				foreach ($references as $fkName => $reference) {
795
+					if ($reference->_getStatus() === TDBMObjectStateEnum::STATE_NEW) {
796
+						$this->save($reference);
797
+					}
798
+				}
799
+
800
+				// Let's first get the primary keys
801
+				$tableName = $dbRow->_getDbTableName();
802
+				$dbRowData = $dbRow->_getDbRow();
803
+
804
+				$schema = $this->tdbmSchemaAnalyzer->getSchema();
805
+				$tableDescriptor = $schema->getTable($tableName);
806
+
807
+				$primaryKeys = $dbRow->_getPrimaryKeys();
808
+
809
+				$types = [];
810
+
811
+				foreach ($dbRowData as $columnName => $value) {
812
+					$columnDescriptor = $tableDescriptor->getColumn($columnName);
813
+					$types[] = $columnDescriptor->getType();
814
+				}
815
+				foreach ($primaryKeys as $columnName => $value) {
816
+					$columnDescriptor = $tableDescriptor->getColumn($columnName);
817
+					$types[] = $columnDescriptor->getType();
818
+				}
819
+
820
+				$this->connection->update($tableName, $dbRowData, $primaryKeys, $types);
821
+
822
+				// Let's check if the primary key has been updated...
823
+				$needsUpdatePk = false;
824
+				foreach ($primaryKeys as $column => $value) {
825
+					if (!isset($dbRowData[$column]) || $dbRowData[$column] != $value) {
826
+						$needsUpdatePk = true;
827
+						break;
828
+					}
829
+				}
830
+				if ($needsUpdatePk) {
831
+					$this->objectStorage->remove($tableName, $this->getObjectHash($primaryKeys));
832
+					$newPrimaryKeys = $this->getPrimaryKeysForObjectFromDbRow($dbRow);
833
+					$dbRow->_setPrimaryKeys($newPrimaryKeys);
834
+					$this->objectStorage->set($tableName, $this->getObjectHash($primaryKeys), $dbRow);
835
+				}
836
+
837
+				// Let's remove this object from the list of objects to save.
838
+				$this->removeFromToSaveObjectList($dbRow);
839
+			}
840
+
841
+			$object->_setStatus(TDBMObjectStateEnum::STATE_LOADED);
842
+		} elseif ($status === TDBMObjectStateEnum::STATE_DELETED) {
843
+			throw new TDBMInvalidOperationException('This object has been deleted. It cannot be saved.');
844
+		}
845
+
846
+		// Finally, let's save all the many to many relationships to this bean.
847
+		$this->persistManyToManyRelationships($object);
848
+	}
849
+
850
+	private function persistManyToManyRelationships(AbstractTDBMObject $object)
851
+	{
852
+		foreach ($object->_getCachedRelationships() as $pivotTableName => $storage) {
853
+			$tableDescriptor = $this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName);
854
+			list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $object);
855
+
856
+			foreach ($storage as $remoteBean) {
857
+				/* @var $remoteBean AbstractTDBMObject */
858
+				$statusArr = $storage[$remoteBean];
859
+				$status = $statusArr['status'];
860
+				$reverse = $statusArr['reverse'];
861
+				if ($reverse) {
862
+					continue;
863
+				}
864
+
865
+				if ($status === 'new') {
866
+					$remoteBeanStatus = $remoteBean->_getStatus();
867
+					if ($remoteBeanStatus === TDBMObjectStateEnum::STATE_NEW || $remoteBeanStatus === TDBMObjectStateEnum::STATE_DETACHED) {
868
+						// Let's save remote bean if needed.
869
+						$this->save($remoteBean);
870
+					}
871
+
872
+					$filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk);
873
+
874
+					$types = [];
875
+
876
+					foreach ($filters as $columnName => $value) {
877
+						$columnDescriptor = $tableDescriptor->getColumn($columnName);
878
+						$types[] = $columnDescriptor->getType();
879
+					}
880
+
881
+					$this->connection->insert($pivotTableName, $filters, $types);
882
+
883
+					// Finally, let's mark relationships as saved.
884
+					$statusArr['status'] = 'loaded';
885
+					$storage[$remoteBean] = $statusArr;
886
+					$remoteStorage = $remoteBean->_getCachedRelationships()[$pivotTableName];
887
+					$remoteStatusArr = $remoteStorage[$object];
888
+					$remoteStatusArr['status'] = 'loaded';
889
+					$remoteStorage[$object] = $remoteStatusArr;
890
+				} elseif ($status === 'delete') {
891
+					$filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk);
892
+
893
+					$types = [];
894
+
895
+					foreach ($filters as $columnName => $value) {
896
+						$columnDescriptor = $tableDescriptor->getColumn($columnName);
897
+						$types[] = $columnDescriptor->getType();
898
+					}
899
+
900
+					$this->connection->delete($pivotTableName, $filters, $types);
901
+
902
+					// Finally, let's remove relationships completely from bean.
903
+					$storage->detach($remoteBean);
904
+					$remoteBean->_getCachedRelationships()[$pivotTableName]->detach($object);
905
+				}
906
+			}
907
+		}
908
+	}
909
+
910
+	private function getPivotFilters(AbstractTDBMObject $localBean, AbstractTDBMObject $remoteBean, ForeignKeyConstraint $localFk, ForeignKeyConstraint $remoteFk)
911
+	{
912
+		$localBeanPk = $this->getPrimaryKeyValues($localBean);
913
+		$remoteBeanPk = $this->getPrimaryKeyValues($remoteBean);
914
+		$localColumns = $localFk->getLocalColumns();
915
+		$remoteColumns = $remoteFk->getLocalColumns();
916
+
917
+		$localFilters = array_combine($localColumns, $localBeanPk);
918
+		$remoteFilters = array_combine($remoteColumns, $remoteBeanPk);
919
+
920
+		return array_merge($localFilters, $remoteFilters);
921
+	}
922
+
923
+	/**
924
+	 * Returns the "values" of the primary key.
925
+	 * This returns the primary key from the $primaryKey attribute, not the one stored in the columns.
926
+	 *
927
+	 * @param AbstractTDBMObject $bean
928
+	 *
929
+	 * @return array numerically indexed array of values.
930
+	 */
931
+	private function getPrimaryKeyValues(AbstractTDBMObject $bean)
932
+	{
933
+		$dbRows = $bean->_getDbRows();
934
+		$dbRow = reset($dbRows);
935
+
936
+		return array_values($dbRow->_getPrimaryKeys());
937
+	}
938
+
939
+	/**
940
+	 * Returns a unique hash used to store the object based on its primary key.
941
+	 * If the array contains only one value, then the value is returned.
942
+	 * Otherwise, a hash representing the array is returned.
943
+	 *
944
+	 * @param array $primaryKeys An array of columns => values forming the primary key
945
+	 *
946
+	 * @return string
947
+	 */
948
+	public function getObjectHash(array $primaryKeys)
949
+	{
950
+		if (count($primaryKeys) === 1) {
951
+			return reset($primaryKeys);
952
+		} else {
953
+			ksort($primaryKeys);
954
+
955
+			return md5(json_encode($primaryKeys));
956
+		}
957
+	}
958
+
959
+	/**
960
+	 * Returns an array of primary keys from the object.
961
+	 * The primary keys are extracted from the object columns and not from the primary keys stored in the
962
+	 * $primaryKeys variable of the object.
963
+	 *
964
+	 * @param DbRow $dbRow
965
+	 *
966
+	 * @return array Returns an array of column => value
967
+	 */
968
+	public function getPrimaryKeysForObjectFromDbRow(DbRow $dbRow)
969
+	{
970
+		$table = $dbRow->_getDbTableName();
971
+		$dbRowData = $dbRow->_getDbRow();
972
+
973
+		return $this->_getPrimaryKeysFromObjectData($table, $dbRowData);
974
+	}
975
+
976
+	/**
977
+	 * Returns an array of primary keys for the given row.
978
+	 * The primary keys are extracted from the object columns.
979
+	 *
980
+	 * @param $table
981
+	 * @param array $columns
982
+	 *
983
+	 * @return array
984
+	 */
985
+	public function _getPrimaryKeysFromObjectData($table, array $columns)
986
+	{
987
+		$primaryKeyColumns = $this->getPrimaryKeyColumns($table);
988
+		$values = array();
989
+		foreach ($primaryKeyColumns as $column) {
990
+			if (isset($columns[$column])) {
991
+				$values[$column] = $columns[$column];
992
+			}
993
+		}
994
+
995
+		return $values;
996
+	}
997
+
998
+	/**
999
+	 * Attaches $object to this TDBMService.
1000
+	 * The $object must be in DETACHED state and will pass in NEW state.
1001
+	 *
1002
+	 * @param AbstractTDBMObject $object
1003
+	 *
1004
+	 * @throws TDBMInvalidOperationException
1005
+	 */
1006
+	public function attach(AbstractTDBMObject $object)
1007
+	{
1008
+		$object->_attach($this);
1009
+	}
1010
+
1011
+	/**
1012
+	 * Returns an associative array (column => value) for the primary keys from the table name and an
1013
+	 * indexed array of primary key values.
1014
+	 *
1015
+	 * @param string $tableName
1016
+	 * @param array  $indexedPrimaryKeys
1017
+	 */
1018
+	public function _getPrimaryKeysFromIndexedPrimaryKeys($tableName, array $indexedPrimaryKeys)
1019
+	{
1020
+		$primaryKeyColumns = $this->tdbmSchemaAnalyzer->getSchema()->getTable($tableName)->getPrimaryKeyColumns();
1021
+
1022
+		if (count($primaryKeyColumns) !== count($indexedPrimaryKeys)) {
1023
+			throw new TDBMException(sprintf('Wrong number of columns passed for primary key. Expected %s columns for table "%s",
1024 1024
 			got %s instead.', count($primaryKeyColumns), $tableName, count($indexedPrimaryKeys)));
1025
-        }
1026
-
1027
-        return array_combine($primaryKeyColumns, $indexedPrimaryKeys);
1028
-    }
1029
-
1030
-    /**
1031
-     * Return the list of tables (from child to parent) joining the tables passed in parameter.
1032
-     * Tables must be in a single line of inheritance. The method will find missing tables.
1033
-     *
1034
-     * Algorithm: one of those tables is the ultimate child. From this child, by recursively getting the parent,
1035
-     * we must be able to find all other tables.
1036
-     *
1037
-     * @param string[] $tables
1038
-     *
1039
-     * @return string[]
1040
-     */
1041
-    public function _getLinkBetweenInheritedTables(array $tables)
1042
-    {
1043
-        sort($tables);
1044
-
1045
-        return $this->fromCache($this->cachePrefix.'_linkbetweeninheritedtables_'.implode('__split__', $tables),
1046
-            function () use ($tables) {
1047
-                return $this->_getLinkBetweenInheritedTablesWithoutCache($tables);
1048
-            });
1049
-    }
1050
-
1051
-    /**
1052
-     * Return the list of tables (from child to parent) joining the tables passed in parameter.
1053
-     * Tables must be in a single line of inheritance. The method will find missing tables.
1054
-     *
1055
-     * Algorithm: one of those tables is the ultimate child. From this child, by recursively getting the parent,
1056
-     * we must be able to find all other tables.
1057
-     *
1058
-     * @param string[] $tables
1059
-     *
1060
-     * @return string[]
1061
-     */
1062
-    private function _getLinkBetweenInheritedTablesWithoutCache(array $tables)
1063
-    {
1064
-        $schemaAnalyzer = $this->schemaAnalyzer;
1065
-
1066
-        foreach ($tables as $currentTable) {
1067
-            $allParents = [$currentTable];
1068
-            while ($currentFk = $schemaAnalyzer->getParentRelationship($currentTable)) {
1069
-                $currentTable = $currentFk->getForeignTableName();
1070
-                $allParents[] = $currentTable;
1071
-            };
1072
-
1073
-            // Now, does the $allParents contain all the tables we want?
1074
-            $notFoundTables = array_diff($tables, $allParents);
1075
-            if (empty($notFoundTables)) {
1076
-                // We have a winner!
1077
-                return $allParents;
1078
-            }
1079
-        }
1080
-
1081
-        throw new TDBMException(sprintf('The tables (%s) cannot be linked by an inheritance relationship.', implode(', ', $tables)));
1082
-    }
1083
-
1084
-    /**
1085
-     * Returns the list of tables related to this table (via a parent or child inheritance relationship).
1086
-     *
1087
-     * @param string $table
1088
-     *
1089
-     * @return string[]
1090
-     */
1091
-    public function _getRelatedTablesByInheritance($table)
1092
-    {
1093
-        return $this->fromCache($this->cachePrefix.'_relatedtables_'.$table, function () use ($table) {
1094
-            return $this->_getRelatedTablesByInheritanceWithoutCache($table);
1095
-        });
1096
-    }
1097
-
1098
-    /**
1099
-     * Returns the list of tables related to this table (via a parent or child inheritance relationship).
1100
-     *
1101
-     * @param string $table
1102
-     *
1103
-     * @return string[]
1104
-     */
1105
-    private function _getRelatedTablesByInheritanceWithoutCache($table)
1106
-    {
1107
-        $schemaAnalyzer = $this->schemaAnalyzer;
1108
-
1109
-        // Let's scan the parent tables
1110
-        $currentTable = $table;
1111
-
1112
-        $parentTables = [];
1113
-
1114
-        // Get parent relationship
1115
-        while ($currentFk = $schemaAnalyzer->getParentRelationship($currentTable)) {
1116
-            $currentTable = $currentFk->getForeignTableName();
1117
-            $parentTables[] = $currentTable;
1118
-        };
1119
-
1120
-        // Let's recurse in children
1121
-        $childrenTables = $this->exploreChildrenTablesRelationships($schemaAnalyzer, $table);
1122
-
1123
-        return array_merge(array_reverse($parentTables), $childrenTables);
1124
-    }
1125
-
1126
-    /**
1127
-     * Explore all the children and descendant of $table and returns ForeignKeyConstraints on those.
1128
-     *
1129
-     * @param string $table
1130
-     *
1131
-     * @return string[]
1132
-     */
1133
-    private function exploreChildrenTablesRelationships(SchemaAnalyzer $schemaAnalyzer, $table)
1134
-    {
1135
-        $tables = [$table];
1136
-        $keys = $schemaAnalyzer->getChildrenRelationships($table);
1137
-
1138
-        foreach ($keys as $key) {
1139
-            $tables = array_merge($tables, $this->exploreChildrenTablesRelationships($schemaAnalyzer, $key->getLocalTableName()));
1140
-        }
1141
-
1142
-        return $tables;
1143
-    }
1144
-
1145
-    /**
1146
-     * Casts a foreign key into SQL, assuming table name is used with no alias.
1147
-     * The returned value does contain only one table. For instance:.
1148
-     *
1149
-     * " LEFT JOIN table2 ON table1.id = table2.table1_id"
1150
-     *
1151
-     * @param ForeignKeyConstraint $fk
1152
-     * @param bool                 $leftTableIsLocal
1153
-     *
1154
-     * @return string
1155
-     */
1156
-    /*private function foreignKeyToSql(ForeignKeyConstraint $fk, $leftTableIsLocal) {
1025
+		}
1026
+
1027
+		return array_combine($primaryKeyColumns, $indexedPrimaryKeys);
1028
+	}
1029
+
1030
+	/**
1031
+	 * Return the list of tables (from child to parent) joining the tables passed in parameter.
1032
+	 * Tables must be in a single line of inheritance. The method will find missing tables.
1033
+	 *
1034
+	 * Algorithm: one of those tables is the ultimate child. From this child, by recursively getting the parent,
1035
+	 * we must be able to find all other tables.
1036
+	 *
1037
+	 * @param string[] $tables
1038
+	 *
1039
+	 * @return string[]
1040
+	 */
1041
+	public function _getLinkBetweenInheritedTables(array $tables)
1042
+	{
1043
+		sort($tables);
1044
+
1045
+		return $this->fromCache($this->cachePrefix.'_linkbetweeninheritedtables_'.implode('__split__', $tables),
1046
+			function () use ($tables) {
1047
+				return $this->_getLinkBetweenInheritedTablesWithoutCache($tables);
1048
+			});
1049
+	}
1050
+
1051
+	/**
1052
+	 * Return the list of tables (from child to parent) joining the tables passed in parameter.
1053
+	 * Tables must be in a single line of inheritance. The method will find missing tables.
1054
+	 *
1055
+	 * Algorithm: one of those tables is the ultimate child. From this child, by recursively getting the parent,
1056
+	 * we must be able to find all other tables.
1057
+	 *
1058
+	 * @param string[] $tables
1059
+	 *
1060
+	 * @return string[]
1061
+	 */
1062
+	private function _getLinkBetweenInheritedTablesWithoutCache(array $tables)
1063
+	{
1064
+		$schemaAnalyzer = $this->schemaAnalyzer;
1065
+
1066
+		foreach ($tables as $currentTable) {
1067
+			$allParents = [$currentTable];
1068
+			while ($currentFk = $schemaAnalyzer->getParentRelationship($currentTable)) {
1069
+				$currentTable = $currentFk->getForeignTableName();
1070
+				$allParents[] = $currentTable;
1071
+			};
1072
+
1073
+			// Now, does the $allParents contain all the tables we want?
1074
+			$notFoundTables = array_diff($tables, $allParents);
1075
+			if (empty($notFoundTables)) {
1076
+				// We have a winner!
1077
+				return $allParents;
1078
+			}
1079
+		}
1080
+
1081
+		throw new TDBMException(sprintf('The tables (%s) cannot be linked by an inheritance relationship.', implode(', ', $tables)));
1082
+	}
1083
+
1084
+	/**
1085
+	 * Returns the list of tables related to this table (via a parent or child inheritance relationship).
1086
+	 *
1087
+	 * @param string $table
1088
+	 *
1089
+	 * @return string[]
1090
+	 */
1091
+	public function _getRelatedTablesByInheritance($table)
1092
+	{
1093
+		return $this->fromCache($this->cachePrefix.'_relatedtables_'.$table, function () use ($table) {
1094
+			return $this->_getRelatedTablesByInheritanceWithoutCache($table);
1095
+		});
1096
+	}
1097
+
1098
+	/**
1099
+	 * Returns the list of tables related to this table (via a parent or child inheritance relationship).
1100
+	 *
1101
+	 * @param string $table
1102
+	 *
1103
+	 * @return string[]
1104
+	 */
1105
+	private function _getRelatedTablesByInheritanceWithoutCache($table)
1106
+	{
1107
+		$schemaAnalyzer = $this->schemaAnalyzer;
1108
+
1109
+		// Let's scan the parent tables
1110
+		$currentTable = $table;
1111
+
1112
+		$parentTables = [];
1113
+
1114
+		// Get parent relationship
1115
+		while ($currentFk = $schemaAnalyzer->getParentRelationship($currentTable)) {
1116
+			$currentTable = $currentFk->getForeignTableName();
1117
+			$parentTables[] = $currentTable;
1118
+		};
1119
+
1120
+		// Let's recurse in children
1121
+		$childrenTables = $this->exploreChildrenTablesRelationships($schemaAnalyzer, $table);
1122
+
1123
+		return array_merge(array_reverse($parentTables), $childrenTables);
1124
+	}
1125
+
1126
+	/**
1127
+	 * Explore all the children and descendant of $table and returns ForeignKeyConstraints on those.
1128
+	 *
1129
+	 * @param string $table
1130
+	 *
1131
+	 * @return string[]
1132
+	 */
1133
+	private function exploreChildrenTablesRelationships(SchemaAnalyzer $schemaAnalyzer, $table)
1134
+	{
1135
+		$tables = [$table];
1136
+		$keys = $schemaAnalyzer->getChildrenRelationships($table);
1137
+
1138
+		foreach ($keys as $key) {
1139
+			$tables = array_merge($tables, $this->exploreChildrenTablesRelationships($schemaAnalyzer, $key->getLocalTableName()));
1140
+		}
1141
+
1142
+		return $tables;
1143
+	}
1144
+
1145
+	/**
1146
+	 * Casts a foreign key into SQL, assuming table name is used with no alias.
1147
+	 * The returned value does contain only one table. For instance:.
1148
+	 *
1149
+	 * " LEFT JOIN table2 ON table1.id = table2.table1_id"
1150
+	 *
1151
+	 * @param ForeignKeyConstraint $fk
1152
+	 * @param bool                 $leftTableIsLocal
1153
+	 *
1154
+	 * @return string
1155
+	 */
1156
+	/*private function foreignKeyToSql(ForeignKeyConstraint $fk, $leftTableIsLocal) {
1157 1157
         $onClauses = [];
1158 1158
         $foreignTableName = $this->connection->quoteIdentifier($fk->getForeignTableName());
1159 1159
         $foreignColumns = $fk->getForeignColumns();
@@ -1179,370 +1179,370 @@  discard block
 block discarded – undo
1179 1179
         }
1180 1180
     }*/
1181 1181
 
1182
-    /**
1183
-     * Returns an identifier for the group of tables passed in parameter.
1184
-     *
1185
-     * @param string[] $relatedTables
1186
-     *
1187
-     * @return string
1188
-     */
1189
-    private function getTableGroupName(array $relatedTables)
1190
-    {
1191
-        sort($relatedTables);
1192
-
1193
-        return implode('_``_', $relatedTables);
1194
-    }
1195
-
1196
-    /**
1197
-     * Returns a `ResultIterator` object representing filtered records of "$mainTable" .
1198
-     *
1199
-     * The findObjects method should be the most used query method in TDBM if you want to query the database for objects.
1200
-     * (Note: if you want to query the database for an object by its primary key, use the findObjectByPk method).
1201
-     *
1202
-     * The findObjects method takes in parameter:
1203
-     * 	- mainTable: the kind of bean you want to retrieve. In TDBM, a bean matches a database row, so the
1204
-     * 			`$mainTable` parameter should be the name of an existing table in database.
1205
-     *  - filter: The filter is a filter bag. It is what you use to filter your request (the WHERE part in SQL).
1206
-     *          It can be a string (SQL Where clause), or even a bean or an associative array (key = column to filter, value = value to find)
1207
-     *  - parameters: The parameters used in the filter. If you pass a SQL string as a filter, be sure to avoid
1208
-     *          concatenating parameters in the string (this leads to SQL injection and also to poor caching performance).
1209
-     *          Instead, please consider passing parameters (see documentation for more details).
1210
-     *  - additionalTablesFetch: An array of SQL tables names. The beans related to those tables will be fetched along
1211
-     *          the main table. This is useful to avoid hitting the database with numerous subqueries.
1212
-     *  - mode: The fetch mode of the result. See `setFetchMode()` method for more details.
1213
-     *
1214
-     * The `findObjects` method will return a `ResultIterator`. A `ResultIterator` is an object that behaves as an array
1215
-     * (in ARRAY mode) at least. It can be iterated using a `foreach` loop.
1216
-     *
1217
-     * Finally, if filter_bag is null, the whole table is returned.
1218
-     *
1219
-     * @param string            $mainTable             The name of the table queried
1220
-     * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1221
-     * @param array             $parameters
1222
-     * @param string|null       $orderString           The ORDER BY part of the query. All columns must be prefixed by the table name (in the form: table.column)
1223
-     * @param array             $additionalTablesFetch
1224
-     * @param int               $mode
1225
-     * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1226
-     *
1227
-     * @return ResultIterator An object representing an array of results.
1228
-     *
1229
-     * @throws TDBMException
1230
-     */
1231
-    public function findObjects($mainTable, $filter = null, array $parameters = array(), $orderString = null, array $additionalTablesFetch = array(), $mode = null, $className = null)
1232
-    {
1233
-        // $mainTable is not secured in MagicJoin, let's add a bit of security to avoid SQL injection.
1234
-        if (!preg_match('/^[a-zA-Z_][a-zA-Z0-9_]*$/', $mainTable)) {
1235
-            throw new TDBMException(sprintf("Invalid table name: '%s'", $mainTable));
1236
-        }
1237
-
1238
-        list($filterString, $additionalParameters) = $this->buildFilterFromFilterBag($filter);
1239
-
1240
-        $parameters = array_merge($parameters, $additionalParameters);
1241
-
1242
-        // From the table name and the additional tables we want to fetch, let's build a list of all tables
1243
-        // that must be part of the select columns.
1244
-
1245
-        $tableGroups = [];
1246
-        $allFetchedTables = $this->_getRelatedTablesByInheritance($mainTable);
1247
-        $tableGroupName = $this->getTableGroupName($allFetchedTables);
1248
-        foreach ($allFetchedTables as $table) {
1249
-            $tableGroups[$table] = $tableGroupName;
1250
-        }
1251
-
1252
-        foreach ($additionalTablesFetch as $additionalTable) {
1253
-            $relatedTables = $this->_getRelatedTablesByInheritance($additionalTable);
1254
-            $tableGroupName = $this->getTableGroupName($relatedTables);
1255
-            foreach ($relatedTables as $table) {
1256
-                $tableGroups[$table] = $tableGroupName;
1257
-            }
1258
-            $allFetchedTables = array_merge($allFetchedTables, $relatedTables);
1259
-        }
1260
-
1261
-        // Let's remove any duplicate
1262
-        $allFetchedTables = array_flip(array_flip($allFetchedTables));
1263
-
1264
-        $columnsList = [];
1265
-        $columnDescList = [];
1266
-        $schema = $this->tdbmSchemaAnalyzer->getSchema();
1267
-
1268
-        // Now, let's build the column list
1269
-        foreach ($allFetchedTables as $table) {
1270
-            foreach ($schema->getTable($table)->getColumns() as $column) {
1271
-                $columnName = $column->getName();
1272
-                $columnDescList[] = [
1273
-                    'as' => $table.'____'.$columnName,
1274
-                    'table' => $table,
1275
-                    'column' => $columnName,
1276
-                    'type' => $column->getType(),
1277
-                    'tableGroup' => $tableGroups[$table],
1278
-                ];
1279
-                $columnsList[] = $this->connection->quoteIdentifier($table).'.'.$this->connection->quoteIdentifier($columnName).' as '.
1280
-                    $this->connection->quoteIdentifier($table.'____'.$columnName);
1281
-            }
1282
-        }
1283
-
1284
-        $sql = 'SELECT DISTINCT '.implode(', ', $columnsList).' FROM MAGICJOIN('.$mainTable.')';
1285
-        $countSql = 'SELECT COUNT(1) FROM MAGICJOIN('.$mainTable.')';
1286
-
1287
-        if (!empty($filterString)) {
1288
-            $sql .= ' WHERE '.$filterString;
1289
-            $countSql .= ' WHERE '.$filterString;
1290
-        }
1291
-
1292
-        if (!empty($orderString)) {
1293
-            $sql .= ' ORDER BY '.$orderString;
1294
-            $countSql .= ' ORDER BY '.$orderString;
1295
-        }
1296
-
1297
-        if ($mode !== null && $mode !== self::MODE_CURSOR && $mode !== self::MODE_ARRAY) {
1298
-            throw new TDBMException("Unknown fetch mode: '".$this->mode."'");
1299
-        }
1300
-
1301
-        $mode = $mode ?: $this->mode;
1302
-
1303
-        return new ResultIterator($sql, $countSql, $parameters, $columnDescList, $this->objectStorage, $className, $this, $this->magicQuery, $mode);
1304
-    }
1305
-
1306
-    /**
1307
-     * @param $table
1308
-     * @param array  $primaryKeys
1309
-     * @param array  $additionalTablesFetch
1310
-     * @param bool   $lazy                  Whether to perform lazy loading on this object or not.
1311
-     * @param string $className
1312
-     *
1313
-     * @return AbstractTDBMObject
1314
-     *
1315
-     * @throws TDBMException
1316
-     */
1317
-    public function findObjectByPk($table, array $primaryKeys, array $additionalTablesFetch = array(), $lazy = false, $className = null)
1318
-    {
1319
-        $primaryKeys = $this->_getPrimaryKeysFromObjectData($table, $primaryKeys);
1320
-        $hash = $this->getObjectHash($primaryKeys);
1321
-
1322
-        if ($this->objectStorage->has($table, $hash)) {
1323
-            $dbRow = $this->objectStorage->get($table, $hash);
1324
-            $bean = $dbRow->getTDBMObject();
1325
-            if ($className !== null && !is_a($bean, $className)) {
1326
-                throw new TDBMException("TDBM cannot create a bean of class '".$className."'. The requested object was already loaded and its class is '".get_class($bean)."'");
1327
-            }
1328
-
1329
-            return $bean;
1330
-        }
1331
-
1332
-        // Are we performing lazy fetching?
1333
-        if ($lazy === true) {
1334
-            // Can we perform lazy fetching?
1335
-            $tables = $this->_getRelatedTablesByInheritance($table);
1336
-            // Only allowed if no inheritance.
1337
-            if (count($tables) === 1) {
1338
-                if ($className === null) {
1339
-                    $className = isset($this->tableToBeanMap[$table]) ? $this->tableToBeanMap[$table] : 'Mouf\\Database\\TDBM\\TDBMObject';
1340
-                }
1341
-
1342
-                // Let's construct the bean
1343
-                if (!isset($this->reflectionClassCache[$className])) {
1344
-                    $this->reflectionClassCache[$className] = new \ReflectionClass($className);
1345
-                }
1346
-                // Let's bypass the constructor when creating the bean!
1347
-                $bean = $this->reflectionClassCache[$className]->newInstanceWithoutConstructor();
1348
-                /* @var $bean AbstractTDBMObject */
1349
-                $bean->_constructLazy($table, $primaryKeys, $this);
1350
-            }
1351
-        }
1352
-
1353
-        // Did not find the object in cache? Let's query it!
1354
-        return $this->findObjectOrFail($table, $primaryKeys, [], $additionalTablesFetch, $className);
1355
-    }
1356
-
1357
-    /**
1358
-     * Returns a unique bean (or null) according to the filters passed in parameter.
1359
-     *
1360
-     * @param string            $mainTable             The name of the table queried
1361
-     * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1362
-     * @param array             $parameters
1363
-     * @param array             $additionalTablesFetch
1364
-     * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1365
-     *
1366
-     * @return AbstractTDBMObject|null The object we want, or null if no object matches the filters.
1367
-     *
1368
-     * @throws TDBMException
1369
-     */
1370
-    public function findObject($mainTable, $filter = null, array $parameters = array(), array $additionalTablesFetch = array(), $className = null)
1371
-    {
1372
-        $objects = $this->findObjects($mainTable, $filter, $parameters, null, $additionalTablesFetch, self::MODE_ARRAY, $className);
1373
-        $page = $objects->take(0, 2);
1374
-        $count = $page->count();
1375
-        if ($count > 1) {
1376
-            throw new DuplicateRowException("Error while querying an object for table '$mainTable': More than 1 row have been returned, but we should have received at most one.");
1377
-        } elseif ($count === 0) {
1378
-            return;
1379
-        }
1380
-
1381
-        return $objects[0];
1382
-    }
1383
-
1384
-    /**
1385
-     * Returns a unique bean according to the filters passed in parameter.
1386
-     * Throws a NoBeanFoundException if no bean was found for the filter passed in parameter.
1387
-     *
1388
-     * @param string            $mainTable             The name of the table queried
1389
-     * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1390
-     * @param array             $parameters
1391
-     * @param array             $additionalTablesFetch
1392
-     * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1393
-     *
1394
-     * @return AbstractTDBMObject The object we want
1395
-     *
1396
-     * @throws TDBMException
1397
-     */
1398
-    public function findObjectOrFail($mainTable, $filter = null, array $parameters = array(), array $additionalTablesFetch = array(), $className = null)
1399
-    {
1400
-        $bean = $this->findObject($mainTable, $filter, $parameters, $additionalTablesFetch, $className);
1401
-        if ($bean === null) {
1402
-            throw new NoBeanFoundException("No result found for query on table '".$mainTable."'");
1403
-        }
1404
-
1405
-        return $bean;
1406
-    }
1407
-
1408
-    /**
1409
-     * @param array $beanData An array of data: array<table, array<column, value>>
1410
-     *
1411
-     * @return array an array with first item = class name and second item = table name
1412
-     */
1413
-    public function _getClassNameFromBeanData(array $beanData)
1414
-    {
1415
-        if (count($beanData) === 1) {
1416
-            $tableName = array_keys($beanData)[0];
1417
-        } else {
1418
-            $tables = [];
1419
-            foreach ($beanData as $table => $row) {
1420
-                $primaryKeyColumns = $this->getPrimaryKeyColumns($table);
1421
-                $pkSet = false;
1422
-                foreach ($primaryKeyColumns as $columnName) {
1423
-                    if ($row[$columnName] !== null) {
1424
-                        $pkSet = true;
1425
-                        break;
1426
-                    }
1427
-                }
1428
-                if ($pkSet) {
1429
-                    $tables[] = $table;
1430
-                }
1431
-            }
1432
-
1433
-            // $tables contains the tables for this bean. Let's view the top most part of the hierarchy
1434
-            $allTables = $this->_getLinkBetweenInheritedTables($tables);
1435
-            $tableName = $allTables[0];
1436
-        }
1437
-
1438
-        // Only one table in this bean. Life is sweat, let's look at its type:
1439
-        if (isset($this->tableToBeanMap[$tableName])) {
1440
-            return [$this->tableToBeanMap[$tableName], $tableName];
1441
-        } else {
1442
-            return ['Mouf\\Database\\TDBM\\TDBMObject', $tableName];
1443
-        }
1444
-    }
1445
-
1446
-    /**
1447
-     * Returns an item from cache or computes it using $closure and puts it in cache.
1448
-     *
1449
-     * @param string   $key
1450
-     * @param callable $closure
1451
-     *
1452
-     * @return mixed
1453
-     */
1454
-    private function fromCache($key, callable $closure)
1455
-    {
1456
-        $item = $this->cache->fetch($key);
1457
-        if ($item === false) {
1458
-            $item = $closure();
1459
-            $this->cache->save($key, $item);
1460
-        }
1461
-
1462
-        return $item;
1463
-    }
1464
-
1465
-    /**
1466
-     * Returns the foreign key object.
1467
-     *
1468
-     * @param string $table
1469
-     * @param string $fkName
1470
-     *
1471
-     * @return ForeignKeyConstraint
1472
-     */
1473
-    public function _getForeignKeyByName($table, $fkName)
1474
-    {
1475
-        return $this->tdbmSchemaAnalyzer->getSchema()->getTable($table)->getForeignKey($fkName);
1476
-    }
1477
-
1478
-    /**
1479
-     * @param $pivotTableName
1480
-     * @param AbstractTDBMObject $bean
1481
-     *
1482
-     * @return AbstractTDBMObject[]
1483
-     */
1484
-    public function _getRelatedBeans($pivotTableName, AbstractTDBMObject $bean)
1485
-    {
1486
-        list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $bean);
1487
-        /* @var $localFk ForeignKeyConstraint */
1488
-        /* @var $remoteFk ForeignKeyConstraint */
1489
-        $remoteTable = $remoteFk->getForeignTableName();
1490
-
1491
-        $primaryKeys = $this->getPrimaryKeyValues($bean);
1492
-        $columnNames = array_map(function ($name) use ($pivotTableName) { return $pivotTableName.'.'.$name; }, $localFk->getLocalColumns());
1493
-
1494
-        $filter = array_combine($columnNames, $primaryKeys);
1495
-
1496
-        return $this->findObjects($remoteTable, $filter);
1497
-    }
1498
-
1499
-    /**
1500
-     * @param $pivotTableName
1501
-     * @param AbstractTDBMObject $bean The LOCAL bean
1502
-     *
1503
-     * @return ForeignKeyConstraint[] First item: the LOCAL bean, second item: the REMOTE bean.
1504
-     *
1505
-     * @throws TDBMException
1506
-     */
1507
-    private function getPivotTableForeignKeys($pivotTableName, AbstractTDBMObject $bean)
1508
-    {
1509
-        $fks = array_values($this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName)->getForeignKeys());
1510
-        $table1 = $fks[0]->getForeignTableName();
1511
-        $table2 = $fks[1]->getForeignTableName();
1512
-
1513
-        $beanTables = array_map(function (DbRow $dbRow) { return $dbRow->_getDbTableName(); }, $bean->_getDbRows());
1514
-
1515
-        if (in_array($table1, $beanTables)) {
1516
-            return [$fks[0], $fks[1]];
1517
-        } elseif (in_array($table2, $beanTables)) {
1518
-            return [$fks[1], $fks[0]];
1519
-        } else {
1520
-            throw new TDBMException("Unexpected bean type in getPivotTableForeignKeys. Awaiting beans from table {$table1} and {$table2} for pivot table {$pivotTableName}");
1521
-        }
1522
-    }
1523
-
1524
-    /**
1525
-     * Returns a list of pivot tables linked to $bean.
1526
-     *
1527
-     * @param AbstractTDBMObject $bean
1528
-     *
1529
-     * @return string[]
1530
-     */
1531
-    public function _getPivotTablesLinkedToBean(AbstractTDBMObject $bean)
1532
-    {
1533
-        $junctionTables = [];
1534
-        $allJunctionTables = $this->schemaAnalyzer->detectJunctionTables();
1535
-        foreach ($bean->_getDbRows() as $dbRow) {
1536
-            foreach ($allJunctionTables as $table) {
1537
-                // There are exactly 2 FKs since this is a pivot table.
1538
-                $fks = array_values($table->getForeignKeys());
1539
-
1540
-                if ($fks[0]->getForeignTableName() === $dbRow->_getDbTableName() || $fks[1]->getForeignTableName() === $dbRow->_getDbTableName()) {
1541
-                    $junctionTables[] = $table->getName();
1542
-                }
1543
-            }
1544
-        }
1545
-
1546
-        return $junctionTables;
1547
-    }
1182
+	/**
1183
+	 * Returns an identifier for the group of tables passed in parameter.
1184
+	 *
1185
+	 * @param string[] $relatedTables
1186
+	 *
1187
+	 * @return string
1188
+	 */
1189
+	private function getTableGroupName(array $relatedTables)
1190
+	{
1191
+		sort($relatedTables);
1192
+
1193
+		return implode('_``_', $relatedTables);
1194
+	}
1195
+
1196
+	/**
1197
+	 * Returns a `ResultIterator` object representing filtered records of "$mainTable" .
1198
+	 *
1199
+	 * The findObjects method should be the most used query method in TDBM if you want to query the database for objects.
1200
+	 * (Note: if you want to query the database for an object by its primary key, use the findObjectByPk method).
1201
+	 *
1202
+	 * The findObjects method takes in parameter:
1203
+	 * 	- mainTable: the kind of bean you want to retrieve. In TDBM, a bean matches a database row, so the
1204
+	 * 			`$mainTable` parameter should be the name of an existing table in database.
1205
+	 *  - filter: The filter is a filter bag. It is what you use to filter your request (the WHERE part in SQL).
1206
+	 *          It can be a string (SQL Where clause), or even a bean or an associative array (key = column to filter, value = value to find)
1207
+	 *  - parameters: The parameters used in the filter. If you pass a SQL string as a filter, be sure to avoid
1208
+	 *          concatenating parameters in the string (this leads to SQL injection and also to poor caching performance).
1209
+	 *          Instead, please consider passing parameters (see documentation for more details).
1210
+	 *  - additionalTablesFetch: An array of SQL tables names. The beans related to those tables will be fetched along
1211
+	 *          the main table. This is useful to avoid hitting the database with numerous subqueries.
1212
+	 *  - mode: The fetch mode of the result. See `setFetchMode()` method for more details.
1213
+	 *
1214
+	 * The `findObjects` method will return a `ResultIterator`. A `ResultIterator` is an object that behaves as an array
1215
+	 * (in ARRAY mode) at least. It can be iterated using a `foreach` loop.
1216
+	 *
1217
+	 * Finally, if filter_bag is null, the whole table is returned.
1218
+	 *
1219
+	 * @param string            $mainTable             The name of the table queried
1220
+	 * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1221
+	 * @param array             $parameters
1222
+	 * @param string|null       $orderString           The ORDER BY part of the query. All columns must be prefixed by the table name (in the form: table.column)
1223
+	 * @param array             $additionalTablesFetch
1224
+	 * @param int               $mode
1225
+	 * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1226
+	 *
1227
+	 * @return ResultIterator An object representing an array of results.
1228
+	 *
1229
+	 * @throws TDBMException
1230
+	 */
1231
+	public function findObjects($mainTable, $filter = null, array $parameters = array(), $orderString = null, array $additionalTablesFetch = array(), $mode = null, $className = null)
1232
+	{
1233
+		// $mainTable is not secured in MagicJoin, let's add a bit of security to avoid SQL injection.
1234
+		if (!preg_match('/^[a-zA-Z_][a-zA-Z0-9_]*$/', $mainTable)) {
1235
+			throw new TDBMException(sprintf("Invalid table name: '%s'", $mainTable));
1236
+		}
1237
+
1238
+		list($filterString, $additionalParameters) = $this->buildFilterFromFilterBag($filter);
1239
+
1240
+		$parameters = array_merge($parameters, $additionalParameters);
1241
+
1242
+		// From the table name and the additional tables we want to fetch, let's build a list of all tables
1243
+		// that must be part of the select columns.
1244
+
1245
+		$tableGroups = [];
1246
+		$allFetchedTables = $this->_getRelatedTablesByInheritance($mainTable);
1247
+		$tableGroupName = $this->getTableGroupName($allFetchedTables);
1248
+		foreach ($allFetchedTables as $table) {
1249
+			$tableGroups[$table] = $tableGroupName;
1250
+		}
1251
+
1252
+		foreach ($additionalTablesFetch as $additionalTable) {
1253
+			$relatedTables = $this->_getRelatedTablesByInheritance($additionalTable);
1254
+			$tableGroupName = $this->getTableGroupName($relatedTables);
1255
+			foreach ($relatedTables as $table) {
1256
+				$tableGroups[$table] = $tableGroupName;
1257
+			}
1258
+			$allFetchedTables = array_merge($allFetchedTables, $relatedTables);
1259
+		}
1260
+
1261
+		// Let's remove any duplicate
1262
+		$allFetchedTables = array_flip(array_flip($allFetchedTables));
1263
+
1264
+		$columnsList = [];
1265
+		$columnDescList = [];
1266
+		$schema = $this->tdbmSchemaAnalyzer->getSchema();
1267
+
1268
+		// Now, let's build the column list
1269
+		foreach ($allFetchedTables as $table) {
1270
+			foreach ($schema->getTable($table)->getColumns() as $column) {
1271
+				$columnName = $column->getName();
1272
+				$columnDescList[] = [
1273
+					'as' => $table.'____'.$columnName,
1274
+					'table' => $table,
1275
+					'column' => $columnName,
1276
+					'type' => $column->getType(),
1277
+					'tableGroup' => $tableGroups[$table],
1278
+				];
1279
+				$columnsList[] = $this->connection->quoteIdentifier($table).'.'.$this->connection->quoteIdentifier($columnName).' as '.
1280
+					$this->connection->quoteIdentifier($table.'____'.$columnName);
1281
+			}
1282
+		}
1283
+
1284
+		$sql = 'SELECT DISTINCT '.implode(', ', $columnsList).' FROM MAGICJOIN('.$mainTable.')';
1285
+		$countSql = 'SELECT COUNT(1) FROM MAGICJOIN('.$mainTable.')';
1286
+
1287
+		if (!empty($filterString)) {
1288
+			$sql .= ' WHERE '.$filterString;
1289
+			$countSql .= ' WHERE '.$filterString;
1290
+		}
1291
+
1292
+		if (!empty($orderString)) {
1293
+			$sql .= ' ORDER BY '.$orderString;
1294
+			$countSql .= ' ORDER BY '.$orderString;
1295
+		}
1296
+
1297
+		if ($mode !== null && $mode !== self::MODE_CURSOR && $mode !== self::MODE_ARRAY) {
1298
+			throw new TDBMException("Unknown fetch mode: '".$this->mode."'");
1299
+		}
1300
+
1301
+		$mode = $mode ?: $this->mode;
1302
+
1303
+		return new ResultIterator($sql, $countSql, $parameters, $columnDescList, $this->objectStorage, $className, $this, $this->magicQuery, $mode);
1304
+	}
1305
+
1306
+	/**
1307
+	 * @param $table
1308
+	 * @param array  $primaryKeys
1309
+	 * @param array  $additionalTablesFetch
1310
+	 * @param bool   $lazy                  Whether to perform lazy loading on this object or not.
1311
+	 * @param string $className
1312
+	 *
1313
+	 * @return AbstractTDBMObject
1314
+	 *
1315
+	 * @throws TDBMException
1316
+	 */
1317
+	public function findObjectByPk($table, array $primaryKeys, array $additionalTablesFetch = array(), $lazy = false, $className = null)
1318
+	{
1319
+		$primaryKeys = $this->_getPrimaryKeysFromObjectData($table, $primaryKeys);
1320
+		$hash = $this->getObjectHash($primaryKeys);
1321
+
1322
+		if ($this->objectStorage->has($table, $hash)) {
1323
+			$dbRow = $this->objectStorage->get($table, $hash);
1324
+			$bean = $dbRow->getTDBMObject();
1325
+			if ($className !== null && !is_a($bean, $className)) {
1326
+				throw new TDBMException("TDBM cannot create a bean of class '".$className."'. The requested object was already loaded and its class is '".get_class($bean)."'");
1327
+			}
1328
+
1329
+			return $bean;
1330
+		}
1331
+
1332
+		// Are we performing lazy fetching?
1333
+		if ($lazy === true) {
1334
+			// Can we perform lazy fetching?
1335
+			$tables = $this->_getRelatedTablesByInheritance($table);
1336
+			// Only allowed if no inheritance.
1337
+			if (count($tables) === 1) {
1338
+				if ($className === null) {
1339
+					$className = isset($this->tableToBeanMap[$table]) ? $this->tableToBeanMap[$table] : 'Mouf\\Database\\TDBM\\TDBMObject';
1340
+				}
1341
+
1342
+				// Let's construct the bean
1343
+				if (!isset($this->reflectionClassCache[$className])) {
1344
+					$this->reflectionClassCache[$className] = new \ReflectionClass($className);
1345
+				}
1346
+				// Let's bypass the constructor when creating the bean!
1347
+				$bean = $this->reflectionClassCache[$className]->newInstanceWithoutConstructor();
1348
+				/* @var $bean AbstractTDBMObject */
1349
+				$bean->_constructLazy($table, $primaryKeys, $this);
1350
+			}
1351
+		}
1352
+
1353
+		// Did not find the object in cache? Let's query it!
1354
+		return $this->findObjectOrFail($table, $primaryKeys, [], $additionalTablesFetch, $className);
1355
+	}
1356
+
1357
+	/**
1358
+	 * Returns a unique bean (or null) according to the filters passed in parameter.
1359
+	 *
1360
+	 * @param string            $mainTable             The name of the table queried
1361
+	 * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1362
+	 * @param array             $parameters
1363
+	 * @param array             $additionalTablesFetch
1364
+	 * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1365
+	 *
1366
+	 * @return AbstractTDBMObject|null The object we want, or null if no object matches the filters.
1367
+	 *
1368
+	 * @throws TDBMException
1369
+	 */
1370
+	public function findObject($mainTable, $filter = null, array $parameters = array(), array $additionalTablesFetch = array(), $className = null)
1371
+	{
1372
+		$objects = $this->findObjects($mainTable, $filter, $parameters, null, $additionalTablesFetch, self::MODE_ARRAY, $className);
1373
+		$page = $objects->take(0, 2);
1374
+		$count = $page->count();
1375
+		if ($count > 1) {
1376
+			throw new DuplicateRowException("Error while querying an object for table '$mainTable': More than 1 row have been returned, but we should have received at most one.");
1377
+		} elseif ($count === 0) {
1378
+			return;
1379
+		}
1380
+
1381
+		return $objects[0];
1382
+	}
1383
+
1384
+	/**
1385
+	 * Returns a unique bean according to the filters passed in parameter.
1386
+	 * Throws a NoBeanFoundException if no bean was found for the filter passed in parameter.
1387
+	 *
1388
+	 * @param string            $mainTable             The name of the table queried
1389
+	 * @param string|array|null $filter                The SQL filters to apply to the query (the WHERE part). All columns must be prefixed by the table name (in the form: table.column)
1390
+	 * @param array             $parameters
1391
+	 * @param array             $additionalTablesFetch
1392
+	 * @param string            $className             Optional: The name of the class to instantiate. This class must extend the TDBMObject class. If none is specified, a TDBMObject instance will be returned.
1393
+	 *
1394
+	 * @return AbstractTDBMObject The object we want
1395
+	 *
1396
+	 * @throws TDBMException
1397
+	 */
1398
+	public function findObjectOrFail($mainTable, $filter = null, array $parameters = array(), array $additionalTablesFetch = array(), $className = null)
1399
+	{
1400
+		$bean = $this->findObject($mainTable, $filter, $parameters, $additionalTablesFetch, $className);
1401
+		if ($bean === null) {
1402
+			throw new NoBeanFoundException("No result found for query on table '".$mainTable."'");
1403
+		}
1404
+
1405
+		return $bean;
1406
+	}
1407
+
1408
+	/**
1409
+	 * @param array $beanData An array of data: array<table, array<column, value>>
1410
+	 *
1411
+	 * @return array an array with first item = class name and second item = table name
1412
+	 */
1413
+	public function _getClassNameFromBeanData(array $beanData)
1414
+	{
1415
+		if (count($beanData) === 1) {
1416
+			$tableName = array_keys($beanData)[0];
1417
+		} else {
1418
+			$tables = [];
1419
+			foreach ($beanData as $table => $row) {
1420
+				$primaryKeyColumns = $this->getPrimaryKeyColumns($table);
1421
+				$pkSet = false;
1422
+				foreach ($primaryKeyColumns as $columnName) {
1423
+					if ($row[$columnName] !== null) {
1424
+						$pkSet = true;
1425
+						break;
1426
+					}
1427
+				}
1428
+				if ($pkSet) {
1429
+					$tables[] = $table;
1430
+				}
1431
+			}
1432
+
1433
+			// $tables contains the tables for this bean. Let's view the top most part of the hierarchy
1434
+			$allTables = $this->_getLinkBetweenInheritedTables($tables);
1435
+			$tableName = $allTables[0];
1436
+		}
1437
+
1438
+		// Only one table in this bean. Life is sweat, let's look at its type:
1439
+		if (isset($this->tableToBeanMap[$tableName])) {
1440
+			return [$this->tableToBeanMap[$tableName], $tableName];
1441
+		} else {
1442
+			return ['Mouf\\Database\\TDBM\\TDBMObject', $tableName];
1443
+		}
1444
+	}
1445
+
1446
+	/**
1447
+	 * Returns an item from cache or computes it using $closure and puts it in cache.
1448
+	 *
1449
+	 * @param string   $key
1450
+	 * @param callable $closure
1451
+	 *
1452
+	 * @return mixed
1453
+	 */
1454
+	private function fromCache($key, callable $closure)
1455
+	{
1456
+		$item = $this->cache->fetch($key);
1457
+		if ($item === false) {
1458
+			$item = $closure();
1459
+			$this->cache->save($key, $item);
1460
+		}
1461
+
1462
+		return $item;
1463
+	}
1464
+
1465
+	/**
1466
+	 * Returns the foreign key object.
1467
+	 *
1468
+	 * @param string $table
1469
+	 * @param string $fkName
1470
+	 *
1471
+	 * @return ForeignKeyConstraint
1472
+	 */
1473
+	public function _getForeignKeyByName($table, $fkName)
1474
+	{
1475
+		return $this->tdbmSchemaAnalyzer->getSchema()->getTable($table)->getForeignKey($fkName);
1476
+	}
1477
+
1478
+	/**
1479
+	 * @param $pivotTableName
1480
+	 * @param AbstractTDBMObject $bean
1481
+	 *
1482
+	 * @return AbstractTDBMObject[]
1483
+	 */
1484
+	public function _getRelatedBeans($pivotTableName, AbstractTDBMObject $bean)
1485
+	{
1486
+		list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $bean);
1487
+		/* @var $localFk ForeignKeyConstraint */
1488
+		/* @var $remoteFk ForeignKeyConstraint */
1489
+		$remoteTable = $remoteFk->getForeignTableName();
1490
+
1491
+		$primaryKeys = $this->getPrimaryKeyValues($bean);
1492
+		$columnNames = array_map(function ($name) use ($pivotTableName) { return $pivotTableName.'.'.$name; }, $localFk->getLocalColumns());
1493
+
1494
+		$filter = array_combine($columnNames, $primaryKeys);
1495
+
1496
+		return $this->findObjects($remoteTable, $filter);
1497
+	}
1498
+
1499
+	/**
1500
+	 * @param $pivotTableName
1501
+	 * @param AbstractTDBMObject $bean The LOCAL bean
1502
+	 *
1503
+	 * @return ForeignKeyConstraint[] First item: the LOCAL bean, second item: the REMOTE bean.
1504
+	 *
1505
+	 * @throws TDBMException
1506
+	 */
1507
+	private function getPivotTableForeignKeys($pivotTableName, AbstractTDBMObject $bean)
1508
+	{
1509
+		$fks = array_values($this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName)->getForeignKeys());
1510
+		$table1 = $fks[0]->getForeignTableName();
1511
+		$table2 = $fks[1]->getForeignTableName();
1512
+
1513
+		$beanTables = array_map(function (DbRow $dbRow) { return $dbRow->_getDbTableName(); }, $bean->_getDbRows());
1514
+
1515
+		if (in_array($table1, $beanTables)) {
1516
+			return [$fks[0], $fks[1]];
1517
+		} elseif (in_array($table2, $beanTables)) {
1518
+			return [$fks[1], $fks[0]];
1519
+		} else {
1520
+			throw new TDBMException("Unexpected bean type in getPivotTableForeignKeys. Awaiting beans from table {$table1} and {$table2} for pivot table {$pivotTableName}");
1521
+		}
1522
+	}
1523
+
1524
+	/**
1525
+	 * Returns a list of pivot tables linked to $bean.
1526
+	 *
1527
+	 * @param AbstractTDBMObject $bean
1528
+	 *
1529
+	 * @return string[]
1530
+	 */
1531
+	public function _getPivotTablesLinkedToBean(AbstractTDBMObject $bean)
1532
+	{
1533
+		$junctionTables = [];
1534
+		$allJunctionTables = $this->schemaAnalyzer->detectJunctionTables();
1535
+		foreach ($bean->_getDbRows() as $dbRow) {
1536
+			foreach ($allJunctionTables as $table) {
1537
+				// There are exactly 2 FKs since this is a pivot table.
1538
+				$fks = array_values($table->getForeignKeys());
1539
+
1540
+				if ($fks[0]->getForeignTableName() === $dbRow->_getDbTableName() || $fks[1]->getForeignTableName() === $dbRow->_getDbTableName()) {
1541
+					$junctionTables[] = $table->getName();
1542
+				}
1543
+			}
1544
+		}
1545
+
1546
+		return $junctionTables;
1547
+	}
1548 1548
 }
Please login to merge, or discard this patch.