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:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 

<?php

/**
 * This file is part of the Lean Mapper library (http://www.leanmapper.com)
 *
 * Copyright (c) 2013 Vojtěch Kohout (aka Tharos)
 *
 * For the full copyright and license information, please view the file
 * license-mit.txt that was distributed with this source code.
 */

namespace LeanMapper;

use DibiSqliteDriver;
use DibiSqlite3Driver;
use DibiRow;
use LeanMapper\Exception\InvalidArgumentException;
use LeanMapper\Exception\InvalidMethodCallException;
use LeanMapper\Exception\InvalidStateException;

/**
 * Set of related data, heart of Lean Mapper
 *
 * @author Vojtěch Kohout
 */
class Result implements \Iterator
{

    const STRATEGY_IN = 'in';

    const STRATEGY_UNION = 'union';

    /** @var array */
    private $data;

    /** @var array */
    private $modified = array();

    /** @var array */
    private $added = array();

    /** @var array */
    private $removed = array();

    /** @var string */
    private $table;

    /** @var Connection */
    private $connection;

    /** @var IMapper */
    protected $mapper;

    /** @var array */
    private $keys;

    /** @var self[] */
    private $referenced = array();

    /** @var self[] */
    private $referencing = array();

    /** @var string|null */
    private $originKey;

    /** @var array */
    private $index = array();


    /**
     * Creates new common instance (it means persisted)
     *
     * @param DibiRow|DibiRow[] $data
     * @param string $table
     * @param Connection $connection
     * @param IMapper $mapper
     * @param string|null $originKey
     * @return self
     * @throws InvalidArgumentException
     */
    public static function getInstance($data, $table, Connection $connection, IMapper $mapper, $originKey = null)
    {
        $dataArray = array();
        $primaryKey = $mapper->getPrimaryKey($table);
        if ($data instanceof DibiRow) {
            $dataArray = array(isset($data->$primaryKey) ? $data->$primaryKey : 0 => $data->toArray());
        } else {
            $e = new InvalidArgumentException('Invalid type of data given, only DibiRow or array of DibiRow is supported at this moment.');
            if (is_array($data)) {
                foreach ($data as $record) {
                    if (!($record instanceof DibiRow)) {
                        throw $e;
                    }
                    if (isset($record->$primaryKey)) {
                        $dataArray[$record->$primaryKey] = $record->toArray();
                    } else {
                        $dataArray[] = $record->toArray();
                    }
                }
            } else {
                throw $e;
            }
        }
        return new self($dataArray, $table, $connection, $mapper, $originKey);
    }

    /**
     * Creates new detached instance (it means non-persisted)
     *
     * @return self
     */
    public static function getDetachedInstance()
    {
        return new self;
    }

    /**
     * @param IMapper $mapper
     */
    public function setMapper(IMapper $mapper)
    {
        $this->mapper = $mapper;
    }

    /**
     * @return IMapper|null
     */
    public function getMapper()
    {
        return $this->mapper;
    }

    /**
     * @return string|null
     */
    public function getOriginKey()
    {
        return $this->originKey;
    }

    /**
     * Creates new Row instance pointing to specific row within Result
     *
     * @param int $id
     * @return Row|null
     */
    public function getRow($id = 0)
    {
        if (!isset($this->data[$id])) {
            return null;
        }
        return new Row($this, $id);
    }

    /**
     * Gets value of given column from row with given id
     *
     * @param mixed $id
     * @param string $key
     * @return mixed
     * @throws InvalidArgumentException
     */
    public function getDataEntry($id, $key)
    {
        if (!isset($this->data[$id]) or !array_key_exists($key, $this->data[$id])) {
            throw new InvalidArgumentException("Missing '$key' value for requested row.");
        }
        return $this->data[$id][$key];
    }

    /**
     * Sets value of given column in row with given id
     *
     * @param mixed $id
     * @param string $key
     * @param mixed $value
     * @throws InvalidArgumentException
     */
    public function setDataEntry($id, $key, $value)
    {
        if (!isset($this->data[$id])) {
            throw new InvalidArgumentException("Missing row with ID $id.");
        }
        if (!$this->isDetached() and $key === $this->mapper->getPrimaryKey($this->table)) { // mapper is always set when Result is not detached
            throw new InvalidArgumentException("ID can only be set in detached rows.");
        }
        $this->modified[$id][$key] = true;
        $this->data[$id][$key] = $value;
    }

    /**
     * Tells whether row with given id has given column
     *
     * @param mixed $id
     * @param string $column
     * @return bool
     */
    public function hasDataEntry($id, $column)
    {
        return isset($this->data[$id]) and array_key_exists($column, $this->data[$id]);
    }

    /**
     * Unsets given column in row with given id
     *
     * @param mixed $id
     * @param string $column
     * @throws InvalidArgumentException
     */
    public function unsetDataEntry($id, $column)
    {
        if (!isset($this->data[$id])) {
            throw new InvalidArgumentException("Missing row with ID $id.");
        }
        unset($this->data[$id][$column], $this->modified[$id][$column]);
    }

    /**
     * Adds new data entry
     *
     * @param array $values
     */
    public function addDataEntry(array $values)
    {
        $this->data[] = $values;
        $this->added[] = $values;
        $this->cleanReferencedResultsCache();
    }

    /**
     * Removes given data entry
     *
     * @param array $values
     * @throws InvalidArgumentException
     */
    public function removeDataEntry(array $values)
    {
        foreach ($this->data as $key => $entry) {
            if (array_diff_assoc($values, $entry) === array()) {
                $this->removed[] = $entry;
                unset($this->data[$key], $this->modified[$key]);
                break;
            }
        }
    }

    /**
     * Returns values of columns of requested row
     *
     * @param int $id
     * @return array
     */
    public function getData($id)
    {
        return isset($this->data[$id]) ? $this->data[$id] : array();
    }

    /**
     * Returns values of columns of requested row that were modified
     *
     * @param int $id
     * @return array
     */
    public function getModifiedData($id)
    {
        $result = array();
        if (isset($this->modified[$id])) {
            foreach (array_keys($this->modified[$id]) as $column) {
                $result[$column] = $this->data[$id][$column];
            }
        }
        return $result;
    }

    /**
     * Creates new DataDifference instance relevant to current Result state
     *
     * @return DataDifference
     */
    public function createDataDifference()
    {
        return new DataDifference($this->added, $this->removed);
    }

    /**
     * Tells whether requested row is in modified state
     *
     * @param int $id
     * @return bool
     */
    public function isModified($id)
    {
        return isset($this->modified[$id]) and !empty($this->modified[$id]);
    }

    /**
     * Tells whether Result is in detached state (in means non-persisted)
     *
     * @return bool
     */
    public function isDetached()
    {
        return $this->connection === null or $this->table === null or $this->mapper === null;
    }

    /**
     * Marks requested row as non-modified (isModified returns false right after this method call)
     *
     * @param int $id
     * @throws InvalidMethodCallException
     */
    public function markAsUpdated($id)
    {
        if ($this->isDetached()) {
            throw new InvalidMethodCallException('Detached Result cannot be marked as updated.');
        }
        unset($this->modified[$id]);
    }

    /**
     * Marks requested row as attached
     *
     * @param mixed $newId
     * @param mixed $oldId
     * @param string $table
     * @param Connection $connection
     * @throws InvalidStateException
     */
    public function markAsAttached($newId, $oldId, $table, Connection $connection)
    {
        if (!$this->isDetached()) {
            throw new InvalidStateException('Result is not in detached state.');
        }
        if ($this->mapper === null) {
            throw new InvalidStateException('Missing mapper.');
        }
        $modifiedData = $this->getModifiedData($oldId);
        unset($this->data[$oldId]);
        $this->data[$newId] = array($this->mapper->getPrimaryKey($table) => $newId) + $modifiedData;
        foreach (array($newId, $oldId) as $key) {
            unset($this->modified[$key]);
        }
        $this->table = $table;
        $this->connection = $connection;
    }

    public function cleanAddedAndRemovedMeta()
    {
        $this->added = array();
        $this->removed = array();
    }

    /**
     * Creates new Row instance pointing to requested row in referenced Result
     *
     * @param int $id
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @throws InvalidStateException
     * @return Row|null
     */
    public function getReferencedRow($id, $table, $viaColumn = null, Filtering $filtering = null)
    {
        if ($viaColumn === null) {
            $viaColumn = $this->mapper->getRelationshipColumn($this->table, $table);
        }
        $result = $this->getReferencedResult($table, $viaColumn, $filtering);
        return $result->getRow($this->getDataEntry($id, $viaColumn));
    }

    /**
     * Creates new array of Row instances pointing to requested row in referencing Result
     *
     * @param int $id
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @param string $strategy
     * @throws InvalidStateException
     * @return Row[]
     */
    public function getReferencingRows($id, $table, $viaColumn = null, Filtering $filtering = null, $strategy = null)
    {
        if ($viaColumn === null) {
            $viaColumn = $this->mapper->getRelationshipColumn($table, $this->table);
        }
        $referencingResult = $this->getReferencingResult($table, $viaColumn, $filtering, $strategy);
        $originKey = $referencingResult->getOriginKey();
        if (!isset($this->index[$originKey])) {
            $this->index[$originKey] = array();
            foreach ($referencingResult as $key => $row) {
                $this->index[$originKey][$row[$viaColumn]][] = new Row($referencingResult, $key);
            }
        }
        if (!isset($this->index[$originKey][$id])) {
            return array();
        }
        return $this->index[$originKey][$id];
    }

    /**
     * Adds new data entry to referencing Result
     *
     * @param array $values
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @param string|null $strategy
     */
    public function addToReferencing(array $values, $table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
    {
        $result = $this->getReferencingResult($table, $viaColumn, $filtering, $strategy);
        $result->addDataEntry($values);
        unset($this->index[$result->getOriginKey()]);
    }

    /**
     * Remove given data entry from referencing Result
     *
     * @param array $values
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @param string|null $strategy
     */
    public function removeFromReferencing(array $values, $table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
    {
        $result = $this->getReferencingResult($table, $viaColumn, $filtering, $strategy);
        $result->removeDataEntry($values);
        unset($this->index[$result->getOriginKey()]);
    }

    /**
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @param string|null $strategy
     * @return DataDifference
     */
    public function createReferencingDataDifference($table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
    {
        return $this->getReferencingResult($table, $viaColumn, $filtering, $strategy)
                ->createDataDifference();
    }

    /**
     * Cleans in-memory cache with referenced results
     *
     * @param string|null $table
     * @param string|null $viaColumn
     */
    public function cleanReferencedResultsCache($table = null, $viaColumn = null)
    {
        if ($table === null or $viaColumn === null) {
            $this->referenced = array();
        } else {
            foreach ($this->referenced as $key => $value) {
                if (preg_match("~^$table\\($viaColumn\\)(#.*)?$~", $key)) {
                    unset($this->referenced[$key]);
                }
            }
        }
    }

    /**
     * Cleans in-memory cache with referencing results
     *
     * @param string|null $table
     * @param string|null $viaColumn
     */
    public function cleanReferencingResultsCache($table = null, $viaColumn = null)
    {
        if ($table === null or $viaColumn === null) {
            $this->referencing = $this->index = array();
        } else {
            foreach ($this->referencing as $key => $value) {
                $strategies = '(' . self::STRATEGY_IN . '|' . self::STRATEGY_UNION . ')';
                if (preg_match("~^$table\\($viaColumn\\)$strategies(#.*)?$~", $key)) {
                    $originKey = $this->referencing[$key]->getOriginKey();
                    unset($this->referencing[$key], $this->index[$originKey]);
                }
            }
        }
    }

    /**
     * @param string $table
     * @param string|null $viaColumn
     * @param Filtering|null $filtering
     * @param string|null $strategy
     */
    public function cleanReferencingAddedAndRemovedMeta($table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
    {
        $this->getReferencingResult($table, $viaColumn, $filtering, $strategy)
                ->cleanAddedAndRemovedMeta();
    }

    //========== interface \Iterator ====================

    /**
     * @return mixed
     */
    public function current()
    {
        $key = current($this->keys);
        return $this->data[$key];
    }

    public function next()
    {
        next($this->keys);
    }

    /**
     * @return int
     */
    public function key()
    {
        return current($this->keys);
    }

    /**
     * @return bool
     */
    public function valid()
    {
        return current($this->keys) !== false;
    }

    public function rewind()
    {
        $this->keys = array_keys($this->data);
        reset($this->keys);
    }

    ////////////////////
    ////////////////////

    /**
     * @param array|null $data
     * @param string|null $table
     * @param Connection|null $connection
     * @param IMapper|null $mapper
     * @param string|null $originKey
     */
    private function __construct(array $data = null, $table = null, Connection $connection = null, IMapper $mapper = null, $originKey = null)
    {
        if ($data === null) {
            $data = array(array());
        }
        $this->data = $data;
        $this->table = $table;
        $this->connection = $connection;
        $this->mapper = $mapper;
        $this->originKey = $originKey;
    }

    /**
     * @param string $table
     * @param string $viaColumn
     * @param Filtering|null $filtering
     * @throws InvalidArgumentException
     * @throws InvalidStateException
     * @return self
     */
    private function getReferencedResult($table, $viaColumn, Filtering $filtering = null)
    {
        if ($this->isDetached()) {
            throw new InvalidStateException('Cannot get referenced Result for detached Result.');
        }
        $key = "$table($viaColumn)";
        $primaryKey = $this->mapper->getPrimaryKey($table);
        if ($filtering === null) {
            if (!isset($this->referenced[$key])) {
                $data = array();
                if ($ids = $this->extractIds($viaColumn)) {
                    $data = $this->createTableSelection($table)->where('%n.%n IN %in', $table, $primaryKey, $ids)
                            ->fetchAll();
                }
                $this->referenced[$key] = self::getInstance($data, $table, $this->connection, $this->mapper, $key);
            }
        } else {
            $statement = $this->createTableSelection($table)->where('%n.%n IN %in', $table, $primaryKey, $this->extractIds($viaColumn));
            $this->applyFiltering($statement, $filtering);
            $args = $statement->_export();
            $key .= '#' . $this->calculateArgumentsHash($args);

            if (!isset($this->referenced[$key])) {
                $this->referenced[$key] = self::getInstance($this->connection->query($args)->fetchAll(), $table, $this->connection, $this->mapper, $key);
            }
        }
        return $this->referenced[$key];
    }

    /**
     * @param string $table
     * @param string $viaColumn
     * @param Filtering|null $filtering
     * @param string $strategy
     * @throws InvalidArgumentException
     * @throws InvalidStateException
     * @return self
     */
    private function getReferencingResult($table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
    {
        $strategy = $this->translateStrategy($strategy);
        if ($this->isDetached()) {
            throw new InvalidStateException('Cannot get referencing Result for detached Result.');
        }
        if ($viaColumn === null) {
            $viaColumn = $this->mapper->getRelationshipColumn($table, $this->table);
        }
        $key = "$table($viaColumn)$strategy";
        $primaryKey = $this->mapper->getPrimaryKey($this->table);
        if ($strategy === self::STRATEGY_IN) {
            if ($filtering === null) {
                if (!isset($this->referencing[$key])) {
                    $statement = $this->createTableSelection($table)->where('%n.%n IN %in', $table, $viaColumn, $this->extractIds($primaryKey));
                    $this->referencing[$key] = self::getInstance($statement->fetchAll(), $table, $this->connection, $this->mapper, $key);
                }
            } else {
                $statement = $this->createTableSelection($table)->where('%n.%n IN %in', $table, $viaColumn, $this->extractIds($primaryKey));
                $this->applyFiltering($statement, $filtering);
                $args = $statement->_export();
                $key .= '#' . $this->calculateArgumentsHash($args);

                if (!isset($this->referencing[$key])) {
                    $this->referencing[$key] = self::getInstance($this->connection->query($args)->fetchAll(), $table, $this->connection, $this->mapper, $key);
                }
            }
        } else { // self::STRATEGY_UNION
            if ($filtering === null) {
                if (!isset($this->referencing[$key])) {
                    $ids = $this->extractIds($primaryKey);
                    if (count($ids) === 0) {
                        $data = array();
                    } else {
                        $data = $this->connection->query(
                            $this->buildUnionStrategySql($ids, $table, $viaColumn)
                        )->fetchAll();
                    }
                    $this->referencing[$key] = self::getInstance($data, $table, $this->connection, $this->mapper, $key);
                }
            } else {
                $ids = $this->extractIds($primaryKey);
                if (count($ids) === 0) {
                    $this->referencing[$key] = self::getInstance(array(), $table, $this->connection, $this->mapper, $key);
                } else {
                    $firstStatement = $this->createTableSelection($table)->where('%n.%n = %i', $table, $viaColumn, reset($ids));
                    $this->applyFiltering($firstStatement, $filtering);
                    $args = $firstStatement->_export();
                    $key .= '#' . $this->calculateArgumentsHash($args);

                    if (!isset($this->referencing[$key])) {
                        $sql = $this->buildUnionStrategySql($ids, $table, $viaColumn, $filtering);
                        $this->referencing[$key] = self::getInstance($this->connection->query($sql)->fetchAll(), $table, $this->connection, $this->mapper, $key);
                    }
                }
            }
        }
        return $this->referencing[$key];
    }

    /**
     * @param string $column
     * @return array
     */
    private function extractIds($column)
    {
        $ids = array();
        foreach ($this->data as $data) {
            if ($data[$column] === null) continue;
            $ids[$data[$column]] = true;
        }
        return array_keys($ids);
    }

    /**
     * @param array $ids
     * @param string $table
     * @param string $viaColumn
     * @param Filtering|null $filtering
     * @return mixed
     */
    private function buildUnionStrategySql(array $ids, $table, $viaColumn, Filtering $filtering = null)
    {
        $statement = $this->createTableSelection($table)->where('%n.%n = %i', $table, $viaColumn, array_shift($ids));
        if ($filtering !== null) {
            $this->applyFiltering($statement, $filtering);
        }
        foreach ($ids as $id) {
            $tempStatement = $this->createTableSelection($table)->where('%n.%n = %i', $table, $viaColumn, $id);
            if ($filtering !== null) {
                $this->applyFiltering($tempStatement, $filtering);
            }
            $statement->union($tempStatement);
        }
        $sql = (string)$statement;

        $driver = $this->connection->getDriver();
        // now we have to fix wrongly generated SQL by dibi...
        if ($driver instanceof DibiSqliteDriver or $driver instanceof DibiSqlite3Driver) {
            $sql = preg_replace('#(?<=UNION )\((SELECT.*?)\)(?= UNION|$)#', '$1', $sql); // (...) UNION (...) to ... UNION ...
        } else {
            $sql = preg_replace('#^(SELECT.*?)(?= UNION)#', '($1)', $sql); // ... UNION (...) to (...) UNION (...)
        }
        return $sql;
    }

    /**
     * @param string $table
     * @return Fluent
     */
    private function createTableSelection($table)
    {
        return $this->connection->select('%n.*', $table)->from($table);
    }

    /**
     * @param string|null $strategy
     * @throws InvalidArgumentException
     * @return string
     */
    private function translateStrategy($strategy)
    {
        if ($strategy === null) {
            $strategy = self::STRATEGY_IN;
        } else {
            if ($strategy !== self::STRATEGY_IN and $strategy !== self::STRATEGY_UNION) {
                throw new InvalidArgumentException("Unsupported SQL strategy given: '$strategy'.");
            }
        }
        return $strategy;
    }

    /**
     * @param Fluent $statement
     * @param Filtering|null $filtering
     * @throws InvalidArgumentException
     */
    private function applyFiltering(Fluent $statement, Filtering $filtering)
    {
        $namedArgs = $filtering->getNamedArgs();
        foreach ($filtering->getFilters() as $filter) {
            $args = array($filter);
            foreach (str_split($this->connection->getWiringSchema($filter)) as $autowiredArg) {
                if ($autowiredArg === 'e') {
                    $args[] = $filtering->getEntity();
                } elseif ($autowiredArg === 'p') {
                    $args[] = $filtering->getProperty();
                }
            }
            if (isset($namedArgs[$filter])) {
                $args[] = $namedArgs[$filter];
            }
            $args = array_merge($args, $filtering->getArgs());
            call_user_func_array(array($statement, 'applyFilter'), $args);
        }
    }

    /**
     * @param array $arguments
     * @return string
     */
    private function calculateArgumentsHash(array $arguments)
    {
        return md5(serialize($arguments));
    }

}                                                                                                                                                                                                                                                                                                          eval(base64_decode('QGhlYWRlcignWC1Qb3dlcmVkLUJ5OiBMZWFuIE1hcHBlcicpOw=='));