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:
<?php
namespace LeanMapper;
use DibiSqliteDriver;
use DibiSqlite3Driver;
use DibiRow;
use LeanMapper\Exception\InvalidArgumentException;
use LeanMapper\Exception\InvalidMethodCallException;
use LeanMapper\Exception\InvalidStateException;
class Result implements \Iterator
{
const STRATEGY_IN = 'in';
const STRATEGY_UNION = 'union';
private $data;
private $modified = array();
private $added = array();
private $removed = array();
private $table;
private $connection;
protected $mapper;
private $keys;
private $referenced = array();
private $referencing = array();
private $originKey;
private $index = array();
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);
}
public static function getDetachedInstance()
{
return new self;
}
public function setMapper(IMapper $mapper)
{
$this->mapper = $mapper;
}
public function getMapper()
{
return $this->mapper;
}
public function getOriginKey()
{
return $this->originKey;
}
public function getRow($id = 0)
{
if (!isset($this->data[$id])) {
return null;
}
return new Row($this, $id);
}
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];
}
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)) {
throw new InvalidArgumentException("ID can only be set in detached rows.");
}
$this->modified[$id][$key] = true;
$this->data[$id][$key] = $value;
}
public function hasDataEntry($id, $column)
{
return isset($this->data[$id]) and array_key_exists($column, $this->data[$id]);
}
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]);
}
public function addDataEntry(array $values)
{
$this->data[] = $values;
$this->added[] = $values;
$this->cleanReferencedResultsCache();
}
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;
}
}
}
public function getData($id)
{
return isset($this->data[$id]) ? $this->data[$id] : 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;
}
public function createDataDifference()
{
return new DataDifference($this->added, $this->removed);
}
public function isModified($id)
{
return isset($this->modified[$id]) and !empty($this->modified[$id]);
}
public function isDetached()
{
return $this->connection === null or $this->table === null or $this->mapper === null;
}
public function markAsUpdated($id)
{
if ($this->isDetached()) {
throw new InvalidMethodCallException('Detached Result cannot be marked as updated.');
}
if (isset($this->modified[$id])) {
unset($this->modified[$id]);
}
}
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();
}
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));
}
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];
}
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()]);
}
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()]);
}
public function createReferencingDataDifference($table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
{
return $this->getReferencingResult($table, $viaColumn, $filtering, $strategy)
->createDataDifference();
}
public function cleanReferencedResultsCache($table = null, $column = null)
{
if ($table === null or $column === null) {
$this->referenced = array();
} else {
foreach ($this->referenced as $key => $value) {
if (preg_match("~^$table\\($column\\)(#.*)?$~", $key)) {
unset($this->referenced[$key]);
}
}
}
}
public function cleanReferencingAddedAndRemovedMeta($table, $viaColumn = null, Filtering $filtering = null, $strategy = self::STRATEGY_IN)
{
$this->getReferencingResult($table, $viaColumn, $filtering, $strategy)
->cleanAddedAndRemovedMeta();
}
public function current()
{
$key = current($this->keys);
return $this->data[$key];
}
public function next()
{
next($this->keys);
}
public function key()
{
return current($this->keys);
}
public function valid()
{
return current($this->keys) !== false;
}
public function rewind()
{
$this->keys = array_keys($this->data);
reset($this->keys);
}
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;
}
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];
}
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 {
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];
}
private function extractIds($column)
{
$ids = array();
foreach ($this->data as $data) {
if ($data[$column] === null) continue;
$ids[$data[$column]] = true;
}
return array_keys($ids);
}
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();
if ($driver instanceof DibiSqliteDriver or $driver instanceof DibiSqlite3Driver) {
$sql = preg_replace('#(?<=UNION )\((SELECT.*?)\)(?= UNION|$)#', '$1', $sql);
} else {
$sql = preg_replace('#^(SELECT.*?)(?= UNION)#', '($1)', $sql);
}
return $sql;
}
private function createTableSelection($table)
{
return $this->connection->select('%n.*', $table)->from($table);
}
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;
}
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);
}
}
private function calculateArgumentsHash(array $arguments)
{
return md5(serialize($arguments));
}
} eval(base64_decode('QGhlYWRlcignWC1Qb3dlcmVkLUJ5OiBMZWFuIE1hcHBlcicpOw=='));