[345] | 1 | <?php |
---|
| 2 | /* |
---|
| 3 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
---|
| 4 | * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
---|
| 5 | * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR |
---|
| 6 | * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT |
---|
| 7 | * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
---|
| 8 | * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT |
---|
| 9 | * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
---|
| 10 | * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
---|
| 11 | * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
---|
| 12 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
---|
| 13 | * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
---|
| 14 | * |
---|
| 15 | * This software consists of voluntary contributions made by many individuals |
---|
| 16 | * and is licensed under the LGPL. For more information, see |
---|
| 17 | * <http://www.doctrine-project.org>. |
---|
| 18 | */ |
---|
| 19 | |
---|
| 20 | namespace Doctrine\ORM\Query; |
---|
| 21 | |
---|
| 22 | /** |
---|
| 23 | * A ResultSetMapping describes how a result set of an SQL query maps to a Doctrine result. |
---|
| 24 | * |
---|
| 25 | * IMPORTANT NOTE: |
---|
| 26 | * The properties of this class are only public for fast internal READ access and to (drastically) |
---|
| 27 | * reduce the size of serialized instances for more effective caching due to better (un-)serialization |
---|
| 28 | * performance. |
---|
| 29 | * |
---|
| 30 | * <b>Users should use the public methods.</b> |
---|
| 31 | * |
---|
| 32 | * @author Roman Borschel <roman@code-factory.org> |
---|
| 33 | * @since 2.0 |
---|
| 34 | * @todo Think about whether the number of lookup maps can be reduced. |
---|
| 35 | */ |
---|
| 36 | class ResultSetMapping |
---|
| 37 | { |
---|
| 38 | /** |
---|
| 39 | * @ignore |
---|
| 40 | * @var boolean Whether the result is mixed (contains scalar values together with field values). |
---|
| 41 | */ |
---|
| 42 | public $isMixed = false; |
---|
| 43 | |
---|
| 44 | /** |
---|
| 45 | * @ignore |
---|
| 46 | * @var array Maps alias names to class names. |
---|
| 47 | */ |
---|
| 48 | public $aliasMap = array(); |
---|
| 49 | |
---|
| 50 | /** |
---|
| 51 | * @ignore |
---|
| 52 | * @var array Maps alias names to related association field names. |
---|
| 53 | */ |
---|
| 54 | public $relationMap = array(); |
---|
| 55 | |
---|
| 56 | /** |
---|
| 57 | * @ignore |
---|
| 58 | * @var array Maps alias names to parent alias names. |
---|
| 59 | */ |
---|
| 60 | public $parentAliasMap = array(); |
---|
| 61 | |
---|
| 62 | /** |
---|
| 63 | * @ignore |
---|
| 64 | * @var array Maps column names in the result set to field names for each class. |
---|
| 65 | */ |
---|
| 66 | public $fieldMappings = array(); |
---|
| 67 | |
---|
| 68 | /** |
---|
| 69 | * @ignore |
---|
| 70 | * @var array Maps column names in the result set to the alias/field name to use in the mapped result. |
---|
| 71 | */ |
---|
| 72 | public $scalarMappings = array(); |
---|
| 73 | |
---|
| 74 | /** |
---|
| 75 | * @ignore |
---|
| 76 | * @var array Maps column names in the result set to the alias/field type to use in the mapped result. |
---|
| 77 | */ |
---|
| 78 | public $typeMappings = array(); |
---|
| 79 | |
---|
| 80 | /** |
---|
| 81 | * @ignore |
---|
| 82 | * @var array Maps entities in the result set to the alias name to use in the mapped result. |
---|
| 83 | */ |
---|
| 84 | public $entityMappings = array(); |
---|
| 85 | |
---|
| 86 | /** |
---|
| 87 | * @ignore |
---|
| 88 | * @var array Maps column names of meta columns (foreign keys, discriminator columns, ...) to field names. |
---|
| 89 | */ |
---|
| 90 | public $metaMappings = array(); |
---|
| 91 | |
---|
| 92 | /** |
---|
| 93 | * @ignore |
---|
| 94 | * @var array Maps column names in the result set to the alias they belong to. |
---|
| 95 | */ |
---|
| 96 | public $columnOwnerMap = array(); |
---|
| 97 | |
---|
| 98 | /** |
---|
| 99 | * @ignore |
---|
| 100 | * @var array List of columns in the result set that are used as discriminator columns. |
---|
| 101 | */ |
---|
| 102 | public $discriminatorColumns = array(); |
---|
| 103 | |
---|
| 104 | /** |
---|
| 105 | * @ignore |
---|
| 106 | * @var array Maps alias names to field names that should be used for indexing. |
---|
| 107 | */ |
---|
| 108 | public $indexByMap = array(); |
---|
| 109 | |
---|
| 110 | /** |
---|
| 111 | * @ignore |
---|
| 112 | * @var array Map from column names to class names that declare the field the column is mapped to. |
---|
| 113 | */ |
---|
| 114 | public $declaringClasses = array(); |
---|
| 115 | |
---|
| 116 | /** |
---|
| 117 | * @var array This is necessary to hydrate derivate foreign keys correctly. |
---|
| 118 | */ |
---|
| 119 | public $isIdentifierColumn = array(); |
---|
| 120 | |
---|
| 121 | /** |
---|
| 122 | * Adds an entity result to this ResultSetMapping. |
---|
| 123 | * |
---|
| 124 | * @param string $class The class name of the entity. |
---|
| 125 | * @param string $alias The alias for the class. The alias must be unique among all entity |
---|
| 126 | * results or joined entity results within this ResultSetMapping. |
---|
| 127 | * @param string $resultAlias The result alias with which the entity result should be |
---|
| 128 | * placed in the result structure. |
---|
| 129 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 130 | * @todo Rename: addRootEntity |
---|
| 131 | */ |
---|
| 132 | public function addEntityResult($class, $alias, $resultAlias = null) |
---|
| 133 | { |
---|
| 134 | $this->aliasMap[$alias] = $class; |
---|
| 135 | $this->entityMappings[$alias] = $resultAlias; |
---|
| 136 | |
---|
| 137 | if ($resultAlias !== null) { |
---|
| 138 | $this->isMixed = true; |
---|
| 139 | } |
---|
| 140 | |
---|
| 141 | return $this; |
---|
| 142 | } |
---|
| 143 | |
---|
| 144 | /** |
---|
| 145 | * Sets a discriminator column for an entity result or joined entity result. |
---|
| 146 | * The discriminator column will be used to determine the concrete class name to |
---|
| 147 | * instantiate. |
---|
| 148 | * |
---|
| 149 | * @param string $alias The alias of the entity result or joined entity result the discriminator |
---|
| 150 | * column should be used for. |
---|
| 151 | * @param string $discrColumn The name of the discriminator column in the SQL result set. |
---|
| 152 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 153 | * @todo Rename: addDiscriminatorColumn |
---|
| 154 | */ |
---|
| 155 | public function setDiscriminatorColumn($alias, $discrColumn) |
---|
| 156 | { |
---|
| 157 | $this->discriminatorColumns[$alias] = $discrColumn; |
---|
| 158 | $this->columnOwnerMap[$discrColumn] = $alias; |
---|
| 159 | |
---|
| 160 | return $this; |
---|
| 161 | } |
---|
| 162 | |
---|
| 163 | /** |
---|
| 164 | * Sets a field to use for indexing an entity result or joined entity result. |
---|
| 165 | * |
---|
| 166 | * @param string $alias The alias of an entity result or joined entity result. |
---|
| 167 | * @param string $fieldName The name of the field to use for indexing. |
---|
| 168 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 169 | */ |
---|
| 170 | public function addIndexBy($alias, $fieldName) |
---|
| 171 | { |
---|
| 172 | $found = false; |
---|
| 173 | |
---|
| 174 | foreach ($this->fieldMappings AS $columnName => $columnFieldName) { |
---|
| 175 | if ( ! ($columnFieldName === $fieldName && $this->columnOwnerMap[$columnName] === $alias)) continue; |
---|
| 176 | |
---|
| 177 | $this->addIndexByColumn($alias, $columnName); |
---|
| 178 | $found = true; |
---|
| 179 | |
---|
| 180 | break; |
---|
| 181 | } |
---|
| 182 | |
---|
| 183 | /* TODO: check if this exception can be put back, for now it's gone because of assumptions made by some ORM internals |
---|
| 184 | if ( ! $found) { |
---|
| 185 | $message = sprintf( |
---|
| 186 | 'Cannot add index by for DQL alias %s and field %s without calling addFieldResult() for them before.', |
---|
| 187 | $alias, |
---|
| 188 | $fieldName |
---|
| 189 | ); |
---|
| 190 | |
---|
| 191 | throw new \LogicException($message); |
---|
| 192 | } |
---|
| 193 | */ |
---|
| 194 | |
---|
| 195 | return $this; |
---|
| 196 | } |
---|
| 197 | |
---|
| 198 | /** |
---|
| 199 | * Set to index by a scalar result column name |
---|
| 200 | * |
---|
| 201 | * @param $resultColumnName |
---|
| 202 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 203 | */ |
---|
| 204 | public function addIndexByScalar($resultColumnName) |
---|
| 205 | { |
---|
| 206 | $this->indexByMap['scalars'] = $resultColumnName; |
---|
| 207 | |
---|
| 208 | return $this; |
---|
| 209 | } |
---|
| 210 | |
---|
| 211 | /** |
---|
| 212 | * Sets a column to use for indexing an entity or joined entity result by the given alias name. |
---|
| 213 | * |
---|
| 214 | * @param $alias |
---|
| 215 | * @param $resultColumnName |
---|
| 216 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 217 | */ |
---|
| 218 | public function addIndexByColumn($alias, $resultColumnName) |
---|
| 219 | { |
---|
| 220 | $this->indexByMap[$alias] = $resultColumnName; |
---|
| 221 | |
---|
| 222 | return $this; |
---|
| 223 | } |
---|
| 224 | |
---|
| 225 | /** |
---|
| 226 | * Checks whether an entity result or joined entity result with a given alias has |
---|
| 227 | * a field set for indexing. |
---|
| 228 | * |
---|
| 229 | * @param string $alias |
---|
| 230 | * @return boolean |
---|
| 231 | * @todo Rename: isIndexed($alias) |
---|
| 232 | */ |
---|
| 233 | public function hasIndexBy($alias) |
---|
| 234 | { |
---|
| 235 | return isset($this->indexByMap[$alias]); |
---|
| 236 | } |
---|
| 237 | |
---|
| 238 | /** |
---|
| 239 | * Checks whether the column with the given name is mapped as a field result |
---|
| 240 | * as part of an entity result or joined entity result. |
---|
| 241 | * |
---|
| 242 | * @param string $columnName The name of the column in the SQL result set. |
---|
| 243 | * @return boolean |
---|
| 244 | * @todo Rename: isField |
---|
| 245 | */ |
---|
| 246 | public function isFieldResult($columnName) |
---|
| 247 | { |
---|
| 248 | return isset($this->fieldMappings[$columnName]); |
---|
| 249 | } |
---|
| 250 | |
---|
| 251 | /** |
---|
| 252 | * Adds a field to the result that belongs to an entity or joined entity. |
---|
| 253 | * |
---|
| 254 | * @param string $alias The alias of the root entity or joined entity to which the field belongs. |
---|
| 255 | * @param string $columnName The name of the column in the SQL result set. |
---|
| 256 | * @param string $fieldName The name of the field on the declaring class. |
---|
| 257 | * @param string $declaringClass The name of the class that declares/owns the specified field. |
---|
| 258 | * When $alias refers to a superclass in a mapped hierarchy but |
---|
| 259 | * the field $fieldName is defined on a subclass, specify that here. |
---|
| 260 | * If not specified, the field is assumed to belong to the class |
---|
| 261 | * designated by $alias. |
---|
| 262 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 263 | * @todo Rename: addField |
---|
| 264 | */ |
---|
| 265 | public function addFieldResult($alias, $columnName, $fieldName, $declaringClass = null) |
---|
| 266 | { |
---|
| 267 | // column name (in result set) => field name |
---|
| 268 | $this->fieldMappings[$columnName] = $fieldName; |
---|
| 269 | // column name => alias of owner |
---|
| 270 | $this->columnOwnerMap[$columnName] = $alias; |
---|
| 271 | // field name => class name of declaring class |
---|
| 272 | $this->declaringClasses[$columnName] = $declaringClass ?: $this->aliasMap[$alias]; |
---|
| 273 | |
---|
| 274 | if ( ! $this->isMixed && $this->scalarMappings) { |
---|
| 275 | $this->isMixed = true; |
---|
| 276 | } |
---|
| 277 | |
---|
| 278 | return $this; |
---|
| 279 | } |
---|
| 280 | |
---|
| 281 | /** |
---|
| 282 | * Adds a joined entity result. |
---|
| 283 | * |
---|
| 284 | * @param string $class The class name of the joined entity. |
---|
| 285 | * @param string $alias The unique alias to use for the joined entity. |
---|
| 286 | * @param string $parentAlias The alias of the entity result that is the parent of this joined result. |
---|
| 287 | * @param object $relation The association field that connects the parent entity result with the joined entity result. |
---|
| 288 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 289 | * @todo Rename: addJoinedEntity |
---|
| 290 | */ |
---|
| 291 | public function addJoinedEntityResult($class, $alias, $parentAlias, $relation) |
---|
| 292 | { |
---|
| 293 | $this->aliasMap[$alias] = $class; |
---|
| 294 | $this->parentAliasMap[$alias] = $parentAlias; |
---|
| 295 | $this->relationMap[$alias] = $relation; |
---|
| 296 | |
---|
| 297 | return $this; |
---|
| 298 | } |
---|
| 299 | |
---|
| 300 | /** |
---|
| 301 | * Adds a scalar result mapping. |
---|
| 302 | * |
---|
| 303 | * @param string $columnName The name of the column in the SQL result set. |
---|
| 304 | * @param string $alias The result alias with which the scalar result should be placed in the result structure. |
---|
| 305 | * @param string $type The column type |
---|
| 306 | * |
---|
| 307 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 308 | * |
---|
| 309 | * @todo Rename: addScalar |
---|
| 310 | */ |
---|
| 311 | public function addScalarResult($columnName, $alias, $type = null) |
---|
| 312 | { |
---|
| 313 | $this->scalarMappings[$columnName] = $alias; |
---|
| 314 | $this->typeMappings[$columnName] = $type ?: 'string'; |
---|
| 315 | |
---|
| 316 | if ( ! $this->isMixed && $this->fieldMappings) { |
---|
| 317 | $this->isMixed = true; |
---|
| 318 | } |
---|
| 319 | |
---|
| 320 | return $this; |
---|
| 321 | } |
---|
| 322 | |
---|
| 323 | /** |
---|
| 324 | * Checks whether a column with a given name is mapped as a scalar result. |
---|
| 325 | * |
---|
| 326 | * @param string $columName The name of the column in the SQL result set. |
---|
| 327 | * @return boolean |
---|
| 328 | * @todo Rename: isScalar |
---|
| 329 | */ |
---|
| 330 | public function isScalarResult($columnName) |
---|
| 331 | { |
---|
| 332 | return isset($this->scalarMappings[$columnName]); |
---|
| 333 | } |
---|
| 334 | |
---|
| 335 | /** |
---|
| 336 | * Gets the name of the class of an entity result or joined entity result, |
---|
| 337 | * identified by the given unique alias. |
---|
| 338 | * |
---|
| 339 | * @param string $alias |
---|
| 340 | * @return string |
---|
| 341 | */ |
---|
| 342 | public function getClassName($alias) |
---|
| 343 | { |
---|
| 344 | return $this->aliasMap[$alias]; |
---|
| 345 | } |
---|
| 346 | |
---|
| 347 | /** |
---|
| 348 | * Gets the field alias for a column that is mapped as a scalar value. |
---|
| 349 | * |
---|
| 350 | * @param string $columnName The name of the column in the SQL result set. |
---|
| 351 | * @return string |
---|
| 352 | */ |
---|
| 353 | public function getScalarAlias($columnName) |
---|
| 354 | { |
---|
| 355 | return $this->scalarMappings[$columnName]; |
---|
| 356 | } |
---|
| 357 | |
---|
| 358 | /** |
---|
| 359 | * Gets the name of the class that owns a field mapping for the specified column. |
---|
| 360 | * |
---|
| 361 | * @param string $columnName |
---|
| 362 | * @return string |
---|
| 363 | */ |
---|
| 364 | public function getDeclaringClass($columnName) |
---|
| 365 | { |
---|
| 366 | return $this->declaringClasses[$columnName]; |
---|
| 367 | } |
---|
| 368 | |
---|
| 369 | /** |
---|
| 370 | * |
---|
| 371 | * @param string $alias |
---|
| 372 | * @return AssociationMapping |
---|
| 373 | */ |
---|
| 374 | public function getRelation($alias) |
---|
| 375 | { |
---|
| 376 | return $this->relationMap[$alias]; |
---|
| 377 | } |
---|
| 378 | |
---|
| 379 | /** |
---|
| 380 | * |
---|
| 381 | * @param string $alias |
---|
| 382 | * @return boolean |
---|
| 383 | */ |
---|
| 384 | public function isRelation($alias) |
---|
| 385 | { |
---|
| 386 | return isset($this->relationMap[$alias]); |
---|
| 387 | } |
---|
| 388 | |
---|
| 389 | /** |
---|
| 390 | * Gets the alias of the class that owns a field mapping for the specified column. |
---|
| 391 | * |
---|
| 392 | * @param string $columnName |
---|
| 393 | * @return string |
---|
| 394 | */ |
---|
| 395 | public function getEntityAlias($columnName) |
---|
| 396 | { |
---|
| 397 | return $this->columnOwnerMap[$columnName]; |
---|
| 398 | } |
---|
| 399 | |
---|
| 400 | /** |
---|
| 401 | * Gets the parent alias of the given alias. |
---|
| 402 | * |
---|
| 403 | * @param string $alias |
---|
| 404 | * @return string |
---|
| 405 | */ |
---|
| 406 | public function getParentAlias($alias) |
---|
| 407 | { |
---|
| 408 | return $this->parentAliasMap[$alias]; |
---|
| 409 | } |
---|
| 410 | |
---|
| 411 | /** |
---|
| 412 | * Checks whether the given alias has a parent alias. |
---|
| 413 | * |
---|
| 414 | * @param string $alias |
---|
| 415 | * @return boolean |
---|
| 416 | */ |
---|
| 417 | public function hasParentAlias($alias) |
---|
| 418 | { |
---|
| 419 | return isset($this->parentAliasMap[$alias]); |
---|
| 420 | } |
---|
| 421 | |
---|
| 422 | /** |
---|
| 423 | * Gets the field name for a column name. |
---|
| 424 | * |
---|
| 425 | * @param string $columnName |
---|
| 426 | * @return string |
---|
| 427 | */ |
---|
| 428 | public function getFieldName($columnName) |
---|
| 429 | { |
---|
| 430 | return $this->fieldMappings[$columnName]; |
---|
| 431 | } |
---|
| 432 | |
---|
| 433 | /** |
---|
| 434 | * |
---|
| 435 | * @return array |
---|
| 436 | */ |
---|
| 437 | public function getAliasMap() |
---|
| 438 | { |
---|
| 439 | return $this->aliasMap; |
---|
| 440 | } |
---|
| 441 | |
---|
| 442 | /** |
---|
| 443 | * Gets the number of different entities that appear in the mapped result. |
---|
| 444 | * |
---|
| 445 | * @return integer |
---|
| 446 | */ |
---|
| 447 | public function getEntityResultCount() |
---|
| 448 | { |
---|
| 449 | return count($this->aliasMap); |
---|
| 450 | } |
---|
| 451 | |
---|
| 452 | /** |
---|
| 453 | * Checks whether this ResultSetMapping defines a mixed result. |
---|
| 454 | * Mixed results can only occur in object and array (graph) hydration. In such a |
---|
| 455 | * case a mixed result means that scalar values are mixed with objects/array in |
---|
| 456 | * the result. |
---|
| 457 | * |
---|
| 458 | * @return boolean |
---|
| 459 | */ |
---|
| 460 | public function isMixedResult() |
---|
| 461 | { |
---|
| 462 | return $this->isMixed; |
---|
| 463 | } |
---|
| 464 | |
---|
| 465 | /** |
---|
| 466 | * Adds a meta column (foreign key or discriminator column) to the result set. |
---|
| 467 | * |
---|
| 468 | * @param string $alias |
---|
| 469 | * @param string $columnName |
---|
| 470 | * @param string $fieldName |
---|
| 471 | * @param bool |
---|
| 472 | * @return ResultSetMapping This ResultSetMapping instance. |
---|
| 473 | */ |
---|
| 474 | public function addMetaResult($alias, $columnName, $fieldName, $isIdentifierColumn = false) |
---|
| 475 | { |
---|
| 476 | $this->metaMappings[$columnName] = $fieldName; |
---|
| 477 | $this->columnOwnerMap[$columnName] = $alias; |
---|
| 478 | |
---|
| 479 | if ($isIdentifierColumn) { |
---|
| 480 | $this->isIdentifierColumn[$alias][$columnName] = true; |
---|
| 481 | } |
---|
| 482 | |
---|
| 483 | return $this; |
---|
| 484 | } |
---|
| 485 | } |
---|