--- /dev/null
+<?php
+
+namespace Drupal\aggregator;
+
+use Drupal\Core\Entity\Query\QueryInterface;
+use Drupal\Core\Entity\Sql\SqlContentEntityStorage;
+
+/**
+ * Controller class for aggregators items.
+ *
+ * This extends the Drupal\Core\Entity\Sql\SqlContentEntityStorage class, adding
+ * required special handling for feed item entities.
+ */
+class ItemStorage extends SqlContentEntityStorage implements ItemStorageInterface {
+
+ /**
+ * {@inheritdoc}
+ */
+ public function getItemCount(FeedInterface $feed) {
+ $query = \Drupal::entityQuery('aggregator_item')
+ ->condition('fid', $feed->id())
+ ->count();
+
+ return $query->execute();
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function loadAll($limit = NULL) {
+ $query = \Drupal::entityQuery('aggregator_item');
+ return $this->executeFeedItemQuery($query, $limit);
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function loadByFeed($fid, $limit = NULL) {
+ $query = \Drupal::entityQuery('aggregator_item')
+ ->condition('fid', $fid);
+ return $this->executeFeedItemQuery($query, $limit);
+ }
+
+ /**
+ * Helper method to execute an item query.
+ *
+ * @param \Drupal\Core\Entity\Query\QueryInterface $query
+ * The query to execute.
+ * @param int $limit
+ * (optional) The number of items to return.
+ *
+ * @return \Drupal\aggregator\ItemInterface[]
+ * An array of the feed items.
+ */
+ protected function executeFeedItemQuery(QueryInterface $query, $limit) {
+ $query->sort('timestamp', 'DESC')
+ ->sort('iid', 'DESC');
+ if (!empty($limit)) {
+ $query->pager($limit);
+ }
+
+ return $this->loadMultiple($query->execute());
+ }
+
+}