sunnysideup /
silverstripe-version-pruner
| 1 | <?php |
||
| 2 | |||
| 3 | namespace Sunnysideup\VersionPruner; |
||
| 4 | |||
| 5 | use SilverStripe\ORM\DataObject; |
||
| 6 | use SilverStripe\ORM\Queries\SQLSelect; |
||
| 7 | |||
| 8 | abstract class PruningTemplatesTemplate |
||
| 9 | { |
||
| 10 | /** |
||
| 11 | * @var int |
||
| 12 | */ |
||
| 13 | private const DEFAULT_ALWAYS_KEEP = 12; |
||
| 14 | |||
| 15 | /** |
||
| 16 | * @var int |
||
| 17 | */ |
||
| 18 | private const DEFAULT_MAX_DELETE_IN_ONE_GO = 1000; |
||
| 19 | |||
| 20 | /** |
||
| 21 | * @var string[] |
||
| 22 | */ |
||
| 23 | private const BASE_FIELDS = [ |
||
| 24 | 'ID', |
||
| 25 | 'Version', |
||
| 26 | 'LastEdited', |
||
| 27 | ]; |
||
| 28 | |||
| 29 | /** |
||
| 30 | * Versioned DataObject. |
||
| 31 | * |
||
| 32 | * @var DataObject |
||
| 33 | */ |
||
| 34 | protected $object; |
||
| 35 | |||
| 36 | /** |
||
| 37 | * the table that contains the fields like Version and ClassName |
||
| 38 | * does not include the _Version bit. |
||
| 39 | * |
||
| 40 | * @var string |
||
| 41 | */ |
||
| 42 | protected $baseTable = ''; |
||
| 43 | |||
| 44 | /** |
||
| 45 | * array of items to delete. |
||
| 46 | * |
||
| 47 | * @var array |
||
| 48 | */ |
||
| 49 | protected $toDelete = []; |
||
| 50 | |||
| 51 | /** |
||
| 52 | * @param mixed $object |
||
| 53 | */ |
||
| 54 | public function __construct($object, array $toDelete) |
||
| 55 | { |
||
| 56 | $this->object = $object; |
||
| 57 | $this->toDelete[$this->getUniqueKey()] = $toDelete; |
||
| 58 | $this->baseTable = $this->object->baseTable(); |
||
| 59 | } |
||
| 60 | |||
| 61 | /** |
||
| 62 | * adds / removes records to be deleted. |
||
| 63 | */ |
||
| 64 | abstract public function run(?bool $verbose = false); |
||
| 65 | |||
| 66 | abstract public function getTitle(): string; |
||
| 67 | |||
| 68 | abstract public function getDescription(): string; |
||
| 69 | |||
| 70 | public function getToDelete(): array |
||
| 71 | { |
||
| 72 | return $this->toDelete[$this->getUniqueKey()]; |
||
| 73 | } |
||
| 74 | |||
| 75 | public function setBaseTable(): self |
||
| 76 | { |
||
| 77 | $this->baseTable = $this->object->baseTable(); |
||
| 78 | |||
| 79 | return $this; |
||
| 80 | } |
||
| 81 | |||
| 82 | public function setToDelete(array $toDelete): self |
||
| 83 | { |
||
| 84 | $this->toDelete[$this->getUniqueKey()] = $toDelete; |
||
| 85 | |||
| 86 | return $this; |
||
| 87 | } |
||
| 88 | |||
| 89 | /** |
||
| 90 | * we use this unique key to accidentally mix up records. |
||
| 91 | */ |
||
| 92 | protected function getUniqueKey(): string |
||
| 93 | { |
||
| 94 | return $this->object->ClassName . '_' . $this->object->ID; |
||
| 95 | } |
||
| 96 | |||
| 97 | /** |
||
| 98 | * we keep adding to array ... |
||
| 99 | * |
||
| 100 | * @param mixed $records |
||
| 101 | */ |
||
| 102 | protected function addVersionNumberToArray(array $array, $records, ?string $field = 'Version'): array |
||
| 103 | { |
||
| 104 | $myArray = []; |
||
| 105 | foreach ($records as $record) { |
||
| 106 | $myArray[$record[$field]] = $record[$field]; |
||
| 107 | } |
||
| 108 | |||
| 109 | return $array + $myArray; |
||
| 110 | } |
||
| 111 | |||
| 112 | protected function getBaseQuery(?array $additionalFieldsToSelect = []): SQLSelect |
||
| 113 | { |
||
| 114 | return (new SQLSelect()) |
||
| 115 | ->setFrom($this->baseTable . '_Versions') // important, of course! |
||
| 116 | ->setSelect(array_merge(self::BASE_FIELDS, $additionalFieldsToSelect)) // not sure if we need this. |
||
| 117 | ->setOrderBy('"ID" DESC') // important - we always work backwards |
||
| 118 | ; |
||
| 119 | } |
||
| 120 | |||
| 121 | protected function normaliseWhere(array $array): array |
||
| 122 | { |
||
| 123 | return $array + [ |
||
| 124 | '"RecordID" = ?' => $this->object->ID, |
||
| 125 | ]; |
||
| 126 | } |
||
| 127 | |||
| 128 | protected function normaliseLimit(?int $int = self::DEFAULT_MAX_DELETE_IN_ONE_GO): int |
||
| 129 | { |
||
| 130 | if ($int > self::DEFAULT_MAX_DELETE_IN_ONE_GO) { |
||
| 131 | $int = self::DEFAULT_MAX_DELETE_IN_ONE_GO; |
||
| 132 | } |
||
| 133 | |||
| 134 | return $int; |
||
|
0 ignored issues
–
show
Bug
Best Practice
introduced
by
Loading history...
|
|||
| 135 | } |
||
| 136 | |||
| 137 | protected function normaliseOffset(?int $int = self::DEFAULT_ALWAYS_KEEP): int |
||
| 138 | { |
||
| 139 | if ($int < self::DEFAULT_ALWAYS_KEEP) { |
||
| 140 | $int = self::DEFAULT_ALWAYS_KEEP; |
||
| 141 | } |
||
| 142 | |||
| 143 | return $int; |
||
|
0 ignored issues
–
show
|
|||
| 144 | } |
||
| 145 | } |
||
| 146 |