From a86bdc6b5bab78b4026f44161413f4e482df42e4 Mon Sep 17 00:00:00 2001 From: Thomas Lange Date: Fri, 25 Jun 2021 22:13:59 +0200 Subject: Reorganize namespaces --- core/namespace/Repository.php | 323 ------------------------------------------ 1 file changed, 323 deletions(-) delete mode 100644 core/namespace/Repository.php (limited to 'core/namespace/Repository.php') diff --git a/core/namespace/Repository.php b/core/namespace/Repository.php deleted file mode 100644 index e2b42a7..0000000 --- a/core/namespace/Repository.php +++ /dev/null @@ -1,323 +0,0 @@ -Database = $Database; - } - - #=============================================================================== - # Adds an entity to the runtime cache - #=============================================================================== - protected function storeInstance(int $identifier, EntityInterface $Entity) { - return $this->entities[$identifier] = $Entity; - } - - #=============================================================================== - # Adds an array of entities to the runtime cache - #=============================================================================== - protected function storeMultipleInstances(array $entities) { - foreach($entities as $Entity) { - $this->storeInstance($Entity->getID(), $Entity); - } - - return $entities; - } - - #=============================================================================== - # Gets an entity from the runtime cache - #=============================================================================== - protected function fetchInstance(int $identifier) { - return $this->entities[$identifier] ?? FALSE; - } - - #=============================================================================== - # Removes an entity from the runtime cache - #=============================================================================== - protected function removeInstance(int $identifier) { - if(isset($this->cache[$identifier])) { - unset($this->cache[$identifier]); - } - } - - #=========================================================================== - # Insert entity - #=========================================================================== - public function insert(EntityInterface $Entity): bool { - $attributes = $Entity->getFilteredAttributes(); - - foreach($attributes as $field => $value) { - $fields[] = $field; - $values[] = '?'; - } - - $fields = implode(', ', $fields ?? []); - $values = implode(', ', $values ?? []); - - $query = 'INSERT INTO %s (%s) VALUES(%s)'; - $query = sprintf($query, static::getTableName(), $fields, $values); - - $Statement = $this->Database->prepare($query); - return $Statement->execute(array_values($attributes)); - } - - #=========================================================================== - # Update entity - #=========================================================================== - public function update(EntityInterface $Entity): bool { - $attributes = $Entity->getFilteredAttributes(); - - foreach($attributes as $field => $value) { - $params[] = "$field = ?"; - } - - $params = implode(', ', $params ?? []); - - $query = 'UPDATE %s SET %s WHERE id = '.intval($Entity->getID()); - $query = sprintf($query, static::getTableName(), $params); - - $Statement = $this->Database->prepare($query); - return $Statement->execute(array_values($attributes)); - } - - #=========================================================================== - # Delete entity - #=========================================================================== - public function delete(EntityInterface $Entity): bool { - $query = 'DELETE FROM %s WHERE id = ?'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->prepare($query); - return $Statement->execute([$Entity->getID()]); - } - - #=========================================================================== - # Find entity based on primary key - #=========================================================================== - public function find(int $id): ?EntityInterface { - if($Entity = $this->fetchInstance($id)) { - return $Entity; - } - - return $this->findBy('id', $id); - } - - #=============================================================================== - # Find entity based on specific field comparison - #=============================================================================== - public function findBy(string $field, $value): ?EntityInterface { - $query = 'SELECT * FROM %s WHERE %s = ?'; - $query = sprintf($query, static::getTableName(), $field); - - $Statement = $this->Database->prepare($query); - $Statement->execute([$value]); - - if($Entity = $Statement->fetchObject(static::getClassName())) { - $this->storeInstance($Entity->getID(), $Entity); - return $Entity; - } - - return NULL; - } - - #=============================================================================== - # Find previous entity - #=============================================================================== - public function findPrev(EntityInterface $Entity): ?EntityInterface { - $query = 'SELECT * FROM %s WHERE time_insert < ? ORDER BY time_insert DESC LIMIT 1'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->prepare($query); - $Statement->execute([$Entity->get('time_insert')]); - - if($Entity = $Statement->fetchObject(static::getClassName())) { - $this->storeInstance($Entity->getID(), $Entity); - return $Entity; - } - - return NULL; - } - - #=============================================================================== - # Find next entity - #=============================================================================== - public function findNext(EntityInterface $Entity): ?EntityInterface { - $query = 'SELECT * FROM %s WHERE time_insert > ? ORDER BY time_insert ASC LIMIT 1'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->prepare($query); - $Statement->execute([$Entity->get('time_insert')]); - - if($Entity = $Statement->fetchObject(static::getClassName())) { - $this->storeInstance($Entity->getID(), $Entity); - return $Entity; - } - - return NULL; - } - - #=========================================================================== - # Find last (which means the newest) entity - #=========================================================================== - public function getLast(): ?EntityInterface { - $query = 'SELECT * FROM %s ORDER BY time_insert DESC LIMIT 1'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($Entity = $Statement->fetchObject(static::getClassName())) { - $this->storeInstance($Entity->getID(), $Entity); - return $Entity; - } - - return NULL; - } - - #=========================================================================== - # Get entity count - #=========================================================================== - public function getCount(): int { - $query = 'SELECT COUNT(id) FROM %s'; - $query = sprintf($query, static::getTableName()); - - return $this->Database->query($query)->fetchColumn(); - } - - #=========================================================================== - # Get paginated entity list - #=========================================================================== - public function getPaginated(string $order, int $limit, int $offset = 0): array { - return $this->getAll([], $order, "$offset,$limit"); - } - - #=========================================================================== - # Get all entities - #=========================================================================== - public function getAll(array $filter = [], string $order = null, string $limit = null): array { - $select = 'SELECT * FROM '.static::getTableName(); - $wheres = []; - $params = []; - - if(!empty($filter)) { - foreach($filter as $column => $value) { - $wheres[] = "$column = ?"; - $params[] = $value; - } - - $where = 'WHERE '.implode(' AND ', $wheres); - } - - if($order) { - $order = "ORDER BY $order"; - } - - if($limit) { - $limit = "LIMIT $limit"; - } - - $query = "$select %s %s %s"; - $query = sprintf($query, $where ?? '', $order ?? '', $limit ?? ''); - - $Statement = $this->Database->prepare($query); - $Statement->execute($params); - - if($entities = $Statement->fetchAll($this->Database::FETCH_CLASS, static::getClassName())) { - $this->storeMultipleInstances($entities); - return $entities; - } - - return []; - } - - #=============================================================================== - # Get entities based on search query - #=============================================================================== - public function search(string $search, array $filter = []): array { - if($search === '*') { - return $this->getAll([], NULL, 20); - } - - if(strlen($filter['year'] ?? '') !== 0) { - $extend[] = 'YEAR(time_insert) = ? AND'; - $params[] = $filter['year']; - } - - if(strlen($filter['month'] ?? '') !== 0) { - $extend[] = 'MONTH(time_insert) = ? AND'; - $params[] = $filter['month']; - } - - if(strlen($filter['day'] ?? '') !== 0) { - $extend[] = 'DAY(time_insert) = ? AND'; - $params[] = $filter['day']; - } - - $dateparts = implode(' ', $extend ?? []); - - $query = 'SELECT * FROM %s WHERE %s MATCH(name, body) - AGAINST(? IN BOOLEAN MODE) LIMIT 20'; - $query = sprintf($query, static::getTableName(), $dateparts); - - $Statement = $this->Database->prepare($query); - $Statement->execute(array_merge($params ?? [], [$search])); - - if($entities = $Statement->fetchAll($this->Database::FETCH_CLASS, static::getClassName())) { - $this->storeMultipleInstances($entities); - return $entities; - } - - return []; - } - - #=============================================================================== - # Get a list of distinct days - #=============================================================================== - public function getDistinctDays(): array { - $query = 'SELECT DISTINCT DAY(time_insert) AS d FROM %s ORDER BY d'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } - - #=============================================================================== - # Get a list of distinct months - #=============================================================================== - public function getDistinctMonths(): array { - $query = 'SELECT DISTINCT MONTH(time_insert) AS m FROM %s ORDER BY m'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } - - #=============================================================================== - # Get a list of distinct years - #=============================================================================== - public function getDistinctYears(): array { - $query = 'SELECT DISTINCT YEAR(time_insert) AS y FROM %s ORDER BY y'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } -} -- cgit v1.2.3