Parser.php 14.3 KB
Newer Older
zYne's avatar
zYne committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
<?php
/*
 *  $Id: Table.php 1397 2007-05-19 19:54:15Z zYne $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information, see
 * <http://www.phpdoctrine.com>.
 */
/**
 * Doctrine_Relation_Parser
 *
 * @author      Konsta Vesterinen <kvesteri@cc.hut.fi>
 * @package     Doctrine
 * @license     http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version     $Revision: 1397 $
 * @category    Object Relational Mapping
 * @link        www.phpdoctrine.com
 * @since       1.0
 */
class Doctrine_Relation_Parser 
{
    /**
     * @var Doctrine_Table $_table          the table object this parser belongs to
     */
    protected $_table;
    /**
     * @var array $_relations               an array containing all the Doctrine_Relation objects for this table
     */
zYne's avatar
zYne committed
41
    protected $_relations = array();
zYne's avatar
zYne committed
42
    /**
zYne's avatar
zYne committed
43
     * @var array $_pending                 relations waiting for parsing
zYne's avatar
zYne committed
44
     */
zYne's avatar
zYne committed
45
    protected $_pending   = array();
zYne's avatar
zYne committed
46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
    /**
     * constructor
     *
     * @param Doctrine_Table $table         the table object this parser belongs to
     */
    public function __construct(Doctrine_Table $table) 
    {
        $this->_table = $table;
    }
    /**
     * getTable
     *
     * @return Doctrine_Table   the table object this parser belongs to
     */
    public function getTable()
    {
zYne's avatar
zYne committed
62 63 64 65 66 67 68 69 70 71 72 73 74 75
        return $this->_table;
    }
    /**
     * getPendingRelation
     *
     * @return array            an array defining a pending relation
     */
    public function getPendingRelation($name) 
    {
    	if ( ! isset($this->_pending[$name])) {
            throw new Doctrine_Relation_Exception('Unknown pending relation ' . $name);
    	}
    	
    	return $this->_pending[$name];
zYne's avatar
zYne committed
76 77 78 79 80 81 82 83
    }
    /**
     * binds a relation
     *
     * @param string $name
     * @param string $field
     * @return void
     */
zYne's avatar
zYne committed
84
    public function bind($name, $options = array())
zYne's avatar
zYne committed
85 86 87 88 89 90 91
    {
        if (isset($this->relations[$name])) {
            unset($this->relations[$name]);
        }

        $lower = strtolower($name);

zYne's avatar
zYne committed
92 93
        if ($this->_table->hasColumn($lower)) {
            throw new Doctrine_Relation_Exception("Couldn't bind relation. Column with name " . $lower . ' already exists!');
zYne's avatar
zYne committed
94 95 96 97
        }

        $e    = explode(' as ', $name);
        $name = $e[0];
zYne's avatar
zYne committed
98
        $alias = isset($e[1]) ? $e[1] : $name;
zYne's avatar
zYne committed
99

zYne's avatar
zYne committed
100 101 102 103
        if ( ! isset($options['type'])) {
            throw new Doctrine_Relation_Exception('Relation type not set.');
        }

zYne's avatar
zYne committed
104
        $this->_pending[$alias] = array_merge($options, array('class' => $name, 'alias' => $alias));
105 106

        $m = Doctrine_Manager::getInstance();
zYne's avatar
zYne committed
107
        
108 109 110 111 112 113 114
        if (isset($options['onDelete'])) {
            $m->addDeleteAction($name, $this->_table->getComponentName(), $options['onDelete']);
        }
        if (isset($options['onUpdate'])) {
            $m->addUpdateAction($name, $this->_table->getComponentName(), $options['onUpdate']);
        }

zYne's avatar
zYne committed
115
        return $this->_pending[$alias];
zYne's avatar
zYne committed
116
    }
zYne's avatar
zYne committed
117 118 119 120 121 122
    /**
     * getRelation
     *
     * @param string $alias      relation alias
     */
    public function getRelation($alias, $recursive = true)
zYne's avatar
zYne committed
123
    {
zYne's avatar
zYne committed
124 125
        if (isset($this->_relations[$alias])) {
            return $this->_relations[$alias];
zYne's avatar
zYne committed
126 127
        }

zYne's avatar
zYne committed
128 129
        if (isset($this->_pending[$alias])) {
            $def = $this->_pending[$alias];
zYne's avatar
zYne committed
130
        
131 132
            // check if reference class name exists
            // if it does we are dealing with association relation
zYne's avatar
zYne committed
133 134
            if (isset($def['refClass'])) {
                $def = $this->completeAssocDefinition($def);
zYne's avatar
zYne committed
135 136 137
                $localClasses = array_merge($this->_table->getOption('parents'), array($this->_table->getComponentName()));

                if ( ! isset($this->_pending[$def['refClass']]) && 
138
                     ! isset($this->_relations[$def['refClass']])) {
zYne's avatar
zYne committed
139

zYne's avatar
zYne committed
140
                    $def['refTable']->getRelationParser()->bind($this->_table->getComponentName(),
141 142 143
                                                                array('type'    => Doctrine_Relation::ONE,
                                                                      'local'   => $def['local'],
                                                                      'foreign' => $this->_table->getIdentifier(),
zYne's avatar
zYne committed
144
                                                                      'localKey' => true,
145
                                                                      ));
zYne's avatar
zYne committed
146

zYne's avatar
zYne committed
147 148 149 150
                    $this->bind($def['refClass'], array('type' => Doctrine_Relation::MANY,
                                                        'foreign' => $def['local'],
                                                        'local'   => $this->_table->getIdentifier()));

zYne's avatar
zYne committed
151 152
                }
                if (in_array($def['class'], $localClasses)) {
153
                    $rel = new Doctrine_Relation_Nest($def);
zYne's avatar
zYne committed
154
                } else {
zYne's avatar
zYne committed
155
                    $rel = new Doctrine_Relation_Association($def);
zYne's avatar
zYne committed
156
                }
zYne's avatar
zYne committed
157
            } else {
158
                // simple foreign key relation
zYne's avatar
zYne committed
159
                $def = $this->completeDefinition($def);
160 161 162 163 164 165

                if (isset($def['localKey'])) {
                    $rel = new Doctrine_Relation_LocalKey($def);
                } else {
                    $rel = new Doctrine_Relation_ForeignKey($def);
                }
zYne's avatar
zYne committed
166
            }
zYne's avatar
zYne committed
167
            if (isset($rel)) {
168 169 170 171
                // unset pending relation
                unset($this->_pending[$alias]);

                $this->_relations[$alias] = $rel;
zYne's avatar
zYne committed
172 173 174 175
                return $rel;
            }
        }
        if ($recursive) {
zYne's avatar
zYne committed
176
            $this->getRelations();
zYne's avatar
zYne committed
177

zYne's avatar
zYne committed
178
            return $this->getRelation($alias, false);
zYne's avatar
zYne committed
179
        } else {
zYne's avatar
zYne committed
180
            throw new Doctrine_Table_Exception('Unknown relation alias ' . $alias);
zYne's avatar
zYne committed
181 182
        }
    }
zYne's avatar
zYne committed
183 184 185 186 187 188 189 190 191 192 193 194 195 196
    /**
     * getRelations
     * returns an array containing all relation objects
     *
     * @return array        an array of Doctrine_Relation objects
     */
    public function getRelations()
    {
        foreach ($this->_pending as $k => $v) {
            $this->getRelation($k);
        }

        return $this->_relations;
    }
zYne's avatar
zYne committed
197 198 199 200 201 202
    /**
     * Completes the given association definition
     *
     * @param array $def    definition array to be completed
     * @return array        completed definition array
     */
zYne's avatar
zYne committed
203 204 205 206 207
    public function completeAssocDefinition($def) 
    {
    	$conn = $this->_table->getConnection();
        $def['table']    = $conn->getTable($def['class']);
        $def['refTable'] = $conn->getTable($def['refClass']);
zYne's avatar
zYne committed
208

209 210 211 212 213 214 215 216 217 218 219 220
        $id = $def['refTable']->getIdentifier();

        if (count($id) > 1) {
            if ( ! isset($def['foreign'])) {
                // foreign key not set
                // try to guess the foreign key
    
                $def['foreign'] = ($def['local'] === $id[0]) ? $id[1] : $id[0];
            }
            if ( ! isset($def['local'])) {
                // foreign key not set
                // try to guess the foreign key
zYne's avatar
zYne committed
221

222 223 224
                $def['local'] = ($def['foreign'] === $id[0]) ? $id[1] : $id[0];
            }
        } else {
zYne's avatar
zYne committed
225

226 227 228 229 230 231 232 233 234 235 236 237 238 239 240
            if ( ! isset($def['foreign'])) {
                // foreign key not set
                // try to guess the foreign key
    
                $columns = $this->getIdentifiers($def['table']);
    
                $def['foreign'] = $columns;
            }
            if ( ! isset($def['local'])) {
                // local key not set
                // try to guess the local key
                $columns = $this->getIdentifiers($this->_table);
    
                $def['local'] = $columns;
            }
zYne's avatar
zYne committed
241
        }
zYne's avatar
zYne committed
242 243
        return $def;
    }
zYne's avatar
zYne committed
244 245 246 247 248 249 250 251 252
    /** 
     * getIdentifiers
     * gives a list of identifiers from given table
     *
     * the identifiers are in format:
     * [componentName].[identifier]
     *
     * @param Doctrine_Table $table     table object to retrieve identifiers from
     */
zYne's avatar
zYne committed
253 254 255 256 257 258 259 260 261 262 263 264 265 266
    public function getIdentifiers(Doctrine_Table $table)
    {
    	if (is_array($table->getIdentifier())) {
            $columns = array();
            foreach((array) $table->getIdentifier() as $identifier) {
                $columns[] = strtolower($table->getComponentName())
                           . '_' . $table->getIdentifier();
            }
    	} else {
            $columns = strtolower($table->getComponentName())
                           . '_' . $table->getIdentifier();
    	}

        return $columns;
zYne's avatar
zYne committed
267
    }
268 269 270 271 272 273 274 275
    /**
     * guessColumns
     *
     * @param array $classes                    an array of class names
     * @param Doctrine_Table $foreignTable      foreign table object
     * @return array                            an array of column names
     */
    public function guessColumns(array $classes, Doctrine_Table $foreignTable)
zYne's avatar
zYne committed
276 277 278 279
    {
        $conn = $this->_table->getConnection();

        foreach ($classes as $class) {
280 281 282 283 284
            try {
                $table   = $conn->getTable($class);
            } catch (Doctrine_Table_Exception $e) {
                continue;
            }
zYne's avatar
zYne committed
285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304
            $columns = $this->getIdentifiers($table);
            $found   = true;

            foreach ((array) $columns as $column) {
                if ( ! $foreignTable->hasColumn($column)) {
                    $found = false;
                    break;
                }
            }
            if ($found) {
                break;
            }
        }
        
        if ( ! $found) {
            throw new Doctrine_Relation_Exception("Couldn't find columns.");
        }

        return $columns;
    }
zYne's avatar
zYne committed
305 306 307 308 309 310
    /**
     * Completes the given definition
     *
     * @param array $def    definition array to be completed
     * @return array        completed definition array
     */
zYne's avatar
zYne committed
311 312
    public function completeDefinition($def)
    {
zYne's avatar
zYne committed
313
    	$conn = $this->_table->getConnection();
zYne's avatar
zYne committed
314 315 316
        $def['table'] = $conn->getTable($def['class']);
        $foreignClasses = array_merge($def['table']->getOption('parents'), array($def['class']));
        $localClasses   = array_merge($this->_table->getOption('parents'), array($this->_table->getComponentName()));
zYne's avatar
zYne committed
317 318 319 320 321 322

        if (isset($def['local'])) {
            if ( ! isset($def['foreign'])) {
                // local key is set, but foreign key is not
                // try to guess the foreign key

zYne's avatar
zYne committed
323 324
                if ($def['local'] === $this->_table->getIdentifier()) {
                    $def['foreign'] = $this->guessColumns($localClasses, $def['table']);
zYne's avatar
zYne committed
325 326 327 328
                } else {
                    // the foreign field is likely to be the
                    // identifier of the foreign class
                    $def['foreign'] = $def['table']->getIdentifier();
329
                    $def['localKey'] = true;
zYne's avatar
zYne committed
330
                }
zYne's avatar
zYne committed
331 332 333 334
            } else {
                if ($def['local'] !== $this->_table->getIdentifier()) {
                    $def['localKey'] = true;                                                     	
                }
zYne's avatar
zYne committed
335 336 337 338 339
            }
        } else {
            if (isset($def['foreign'])) {
                // local key not set, but foreign key is set
                // try to guess the local key
zYne's avatar
zYne committed
340
                if ($def['foreign'] === $def['table']->getIdentifier()) {
341
                    $def['localKey'] = true;
342 343 344 345 346
                    try {
                        $def['local'] = $this->guessColumns($foreignClasses, $this->_table);
                    } catch (Doctrine_Relation_Exception $e) {
                        $def['local'] = $this->_table->getIdentifier();
                    }
zYne's avatar
zYne committed
347
                } else {
zYne's avatar
zYne committed
348
                    $def['local'] = $this->_table->getIdentifier();
zYne's avatar
zYne committed
349 350 351 352 353
                }
            } else {
                // neither local or foreign key is being set
                // try to guess both keys

zYne's avatar
zYne committed
354
                $conn = $this->_table->getConnection();
zYne's avatar
zYne committed
355

zYne's avatar
zYne committed
356 357 358 359 360 361 362 363 364 365 366
                // the following loops are needed for covering inheritance
                foreach ($localClasses as $class) {
                    $table  = $conn->getTable($class);
                    $column = strtolower($table->getComponentName())
                            . '_' . $table->getIdentifier();
                
                    foreach ($foreignClasses as $class2) {
                        $table2 = $conn->getTable($class2);
                        if ($table2->hasColumn($column)) {
                            $def['foreign'] = $column;
                            $def['local']   = $table->getIdentifier();
zYne's avatar
zYne committed
367

zYne's avatar
zYne committed
368 369
                            return $def;
                        }
zYne's avatar
zYne committed
370 371
                    }
                }
zYne's avatar
zYne committed
372

zYne's avatar
zYne committed
373 374 375 376 377 378 379 380 381 382
                foreach ($foreignClasses as $class) {
                    $table  = $conn->getTable($class);
                    $column = strtolower($table->getComponentName())
                            . '_' . $table->getIdentifier();
                
                    foreach ($localClasses as $class2) {
                        $table2 = $conn->getTable($class2);
                        if ($table2->hasColumn($column)) {
                            $def['foreign'] = $table->getIdentifier();
                            $def['local']   = $column;
zYne's avatar
zYne committed
383
                            $def['localKey'] = true;
zYne's avatar
zYne committed
384
                            return $def;
zYne's avatar
zYne committed
385 386
                        }
                    }
387
                }
388
                throw new Doctrine_Relation_Parser_Exception("Couldn't complete relation definition.");
zYne's avatar
zYne committed
389
            }
zYne's avatar
zYne committed
390
        }
zYne's avatar
zYne committed
391
        return $def;
zYne's avatar
zYne committed
392 393
    }
}