jacobemerick / web

src/Domain/Stream/BlogComment/MysqlBlogCommentRepository.php

Indentation +55 added lines, -55 removed lines

@@ -8,80 +8,80 @@
 class MysqlBlogCommentRepository implements BlogCommentRepositoryInterface
 {
 
-    /** @var  ConnectionLocator */
-    protected $connections;
+	/** @var  ConnectionLocator */
+	protected $connections;
 
-    /**
-     * @param ConnectonLocator $connections
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
+	/**
+	 * @param ConnectonLocator $connections
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
 
-    /**
-     * @param integer $limit
-     * @param integer $offset
-     *
-     * @return array|false
-     */
-    public function getBlogComments($limit = null, $offset = 0)
-    {
-        $query = "
+	/**
+	 * @param integer $limit
+	 * @param integer $offset
+	 *
+	 * @return array|false
+	 */
+	public function getBlogComments($limit = null, $offset = 0)
+	{
+		$query = "
             SELECT `id`, `permalink`, `datetime`
             FROM `jpemeric_stream`.`blog_comment`
             ORDER BY `datetime` DESC";
-        if (!is_null($limit)) {
-            $query .= "
+		if (!is_null($limit)) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
+		}
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query);
+	}
 
-    /**
-     * @param string $permalink
-     *
-     * @return array|false
-     */
-    public function getBlogCommentByPermalink($permalink)
-    {
-        $query = "
+	/**
+	 * @param string $permalink
+	 *
+	 * @return array|false
+	 */
+	public function getBlogCommentByPermalink($permalink)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`blog_comment`
             WHERE `permalink` = :permalink
             LIMIT 1";
 
-        $bindings = [
-            'permalink' => $permalink,
-        ];
+		$bindings = [
+			'permalink' => $permalink,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
 
-    public function insertBlogComment($permalink, DateTime $datetime, array $metadata)
-    {
-        $query = "
+	public function insertBlogComment($permalink, DateTime $datetime, array $metadata)
+	{
+		$query = "
             INSERT INTO `jpemeric_stream`.`blog_comment`
                 (`permalink`, `datetime`, `metadata`)
             VALUES
                 (:permalink, :datetime, :metadata)";
 
-        $bindings = [
-            'permalink' => $permalink,
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
-            'metadata' => json_encode($metadata),
-        ];
+		$bindings = [
+			'permalink' => $permalink,
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
+			'metadata' => json_encode($metadata),
+		];
 
-        return $this
-            ->connections
-            ->getWrite()
-            ->perform($query, $bindings);
-    }
+		return $this
+			->connections
+			->getWrite()
+			->perform($query, $bindings);
+	}
 }

src/Domain/Stream/Blog/BlogRepositoryInterface.php

Indentation +2 added lines, -2 removed lines

@@ -4,6 +4,6 @@
 
 interface BlogRepositoryInterface
 {
-    public function getBlogById($id);
-    public function getBlogByTitle($title);
+	public function getBlogById($id);
+	public function getBlogByTitle($title);
 }

src/Domain/Stream/Twitter/TwitterRepositoryInterface.php

Indentation +2 added lines, -2 removed lines

@@ -4,6 +4,6 @@
 
 interface TwitterRepositoryInterface
 {
-    public function getTwitterById($id);
-    public function getUnmappedTwitters();
+	public function getTwitterById($id);
+	public function getUnmappedTwitters();
 }

script/cron/fetch-blog-activity.php

Indentation +36 added lines, -36 removed lines

@@ -13,24 +13,24 @@ 
 
 $blogFeed = Feed::loadRss('http://blog.jacobemerick.com/rss.xml');
 foreach ($blogFeed->item as $item) {
-    $datetime = new DateTime($item->pubDate);
-    if ($datetime <= $mostRecentBlogDateTime) {
-        break;
-    }
-
-    $uniqueBlogCheck = $blogRepository->getBlogByPermalink((string) $item->guid);
-    if ($uniqueBlogCheck !== false) {
-        continue;
-    }
-
-    $datetime->setTimezone($container['default_timezone']);
-    $metadata = json_decode(json_encode($item), true);
-
-    $blogRepository->insertBlog(
-        (string) $item->guid,
-        $datetime,
-        $metadata
-    );
+	$datetime = new DateTime($item->pubDate);
+	if ($datetime <= $mostRecentBlogDateTime) {
+		break;
+	}
+
+	$uniqueBlogCheck = $blogRepository->getBlogByPermalink((string) $item->guid);
+	if ($uniqueBlogCheck !== false) {
+		continue;
+	}
+
+	$datetime->setTimezone($container['default_timezone']);
+	$metadata = json_decode(json_encode($item), true);
+
+	$blogRepository->insertBlog(
+		(string) $item->guid,
+		$datetime,
+		$metadata
+	);
 }
 
 $blogCommentRepository = new BlogCommentRepository($container['db_connection_locator']);
@@ -41,22 +41,22 @@ 
 
 $commentFeed = Feed::loadRss('http://blog.jacobemerick.com/rss-comments.xml');
 foreach ($commentFeed->item as $item) {
-    $datetime = new DateTime($item->pubDate);
-    if ($datetime <= $mostRecentBlogCommentDateTime) {
-        break;
-    }
-
-    $uniqueBlogCommentCheck = $blogCommentRepository->getBlogCommentByPermalink((string) $item->guid);
-    if ($uniqueBlogCommentCheck !== false) {
-        continue;
-    }
-
-    $datetime->setTimezone($container['default_timezone']);
-    $metadata = json_decode(json_encode($item), true);
-
-    $blogCommentRepository->insertBlogComment(
-        (string) $item->guid,
-        $datetime,
-        $metadata
-    );
+	$datetime = new DateTime($item->pubDate);
+	if ($datetime <= $mostRecentBlogCommentDateTime) {
+		break;
+	}
+
+	$uniqueBlogCommentCheck = $blogCommentRepository->getBlogCommentByPermalink((string) $item->guid);
+	if ($uniqueBlogCommentCheck !== false) {
+		continue;
+	}
+
+	$datetime->setTimezone($container['default_timezone']);
+	$metadata = json_decode(json_encode($item), true);
+
+	$blogCommentRepository->insertBlogComment(
+		(string) $item->guid,
+		$datetime,
+		$metadata
+	);
 }

script/cron/fetch-goodreads-activity.php

Indentation +20 added lines, -20 removed lines

@@ -6,7 +6,7 @@ 
 use Jacobemerick\Web\Domain\Stream\Goodread\MysqlGoodreadRepository as GoodreadRepository;
 
 $client = new Client([
-    'base_uri' => 'http://www.goodreads.com',
+	'base_uri' => 'http://www.goodreads.com',
 ]);
 
 $goodreadRepository = new GoodreadRepository($container['db_connection_locator']);
@@ -20,23 +20,23 @@ 
 $reviews = simplexml_load_string($reviews, 'SimpleXMLElement', LIBXML_NOCDATA);
 
 foreach ($reviews->channel->item as $review) {
-    $datetime = new DateTime((string) $review->pubDate);
-    if ($datetime <= $mostRecentReviewDateTime) {
-        break;
-    }
-
-    $uniqueReviewCheck = $goodreadRepository->getReviewByPermalink((string) $review->guid);
-    if ($uniqueReviewCheck !== false) {
-        continue;
-    }
-
-    $datetime->setTimezone($container['default_timezone']);
-    $metadata = json_decode(json_encode($review), true);
-
-    $goodreadRepository->insertReview(
-        (string) $review->guid,
-        (string) $review->book_id,
-        $datetime,
-        $metadata
-    );
+	$datetime = new DateTime((string) $review->pubDate);
+	if ($datetime <= $mostRecentReviewDateTime) {
+		break;
+	}
+
+	$uniqueReviewCheck = $goodreadRepository->getReviewByPermalink((string) $review->guid);
+	if ($uniqueReviewCheck !== false) {
+		continue;
+	}
+
+	$datetime->setTimezone($container['default_timezone']);
+	$metadata = json_decode(json_encode($review), true);
+
+	$goodreadRepository->insertReview(
+		(string) $review->guid,
+		(string) $review->book_id,
+		$datetime,
+		$metadata
+	);
 }

script/manual/historic-twitter-fetch.php

Indentation +29 added lines, -29 removed lines

@@ -4,17 +4,17 @@ 
 
 $options = getopt('f:');
 if (empty($options['f'])) {
-    exit('Must pass in a file with the f parameter.');
+	exit('Must pass in a file with the f parameter.');
 }
 
 use Abraham\TwitterOAuth\TwitterOAuth;
 use Jacobemerick\Web\Domain\Stream\Twitter\MysqlTwitterRepository as TwitterRepository;
 
 $client = new TwitterOAuth(
-    $config->twitter->consumer_key,
-    $config->twitter->consumer_secret,
-    $config->twitter->access_token,
-    $config->twitter->access_token_secret
+	$config->twitter->consumer_key,
+	$config->twitter->consumer_secret,
+	$config->twitter->access_token,
+	$config->twitter->access_token_secret
 );
 $client->setDecodeJsonAsArray(true);
 
@@ -24,29 +24,29 @@ 
 
 $handle = fopen(__DIR__ . '/' . $options['f'], 'r');
 while ($row = fgets($handle)) {
-    array_push($idList, trim($row));
-    if (count($idList) == 100) {
-        $tweetLookup = $client->get('statuses/lookup', [
-            'id' => implode(',', $idList),
-            'trim_user' => true,
-        ]);
-
-        foreach ($tweetLookup as $tweet) {
-            $uniqueTweetCheck = $twitterRepository->getTwitterByTweetId($tweet['id_str']);
-            if ($uniqueTweetCheck !== false) {
-                if ($uniqueTweetCheck['metadata'] != json_encode($tweet)) {
-                    $twitterRepository->updateTweetMetadata($tweet['id_str'], $tweet);
-                }
-                continue;
-            }
-
-            $twitterRepository->insertTweet(
-                $tweet['id_str'],
-                (new DateTime($tweet['created_at']))->setTimezone($container['default_timezone']),
-                $tweet
-            );
-        }
-        $idList = [];
-    }
+	array_push($idList, trim($row));
+	if (count($idList) == 100) {
+		$tweetLookup = $client->get('statuses/lookup', [
+			'id' => implode(',', $idList),
+			'trim_user' => true,
+		]);
+
+		foreach ($tweetLookup as $tweet) {
+			$uniqueTweetCheck = $twitterRepository->getTwitterByTweetId($tweet['id_str']);
+			if ($uniqueTweetCheck !== false) {
+				if ($uniqueTweetCheck['metadata'] != json_encode($tweet)) {
+					$twitterRepository->updateTweetMetadata($tweet['id_str'], $tweet);
+				}
+				continue;
+			}
+
+			$twitterRepository->insertTweet(
+				$tweet['id_str'],
+				(new DateTime($tweet['created_at']))->setTimezone($container['default_timezone']),
+				$tweet
+			);
+		}
+		$idList = [];
+	}
 }
 fclose($handle);

src/Domain/Stream/Activity/ActivityRepositoryInterface.php

Indentation +5 added lines, -5 removed lines

@@ -4,9 +4,9 @@
 
 interface ActivityRepositoryInterface
 {
-    public function getActivityById($id);
-    public function getActivities($limit = null, $offset = 0);
-    public function getActivitiesCount();
-    public function getActivitiesByType($type, $limit = null, $offset = 0);
-    public function getActivitiesByTypeCount($type);
+	public function getActivityById($id);
+	public function getActivities($limit = null, $offset = 0);
+	public function getActivitiesCount();
+	public function getActivitiesByType($type, $limit = null, $offset = 0);
+	public function getActivitiesByTypeCount($type);
 }

src/Domain/Stream/Activity/MysqlActivityRepository.php

Indentation +146 added lines, -146 removed lines

@@ -8,192 +8,192 @@
 class MysqlActivityRepository implements ActivityRepositoryInterface
 {
 
-    /** @var  ConnectionLocator */
-    protected $connections;
-
-    /**
-     * @param ConnectonLocator $connections
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
-
-    /**
-     * @param integer $id
-     *
-     * @return array|false
-     */
-    public function getActivityById($id)
-    {
-        $query = "
+	/** @var  ConnectionLocator */
+	protected $connections;
+
+	/**
+	 * @param ConnectonLocator $connections
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
+
+	/**
+	 * @param integer $id
+	 *
+	 * @return array|false
+	 */
+	public function getActivityById($id)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`activity`
             WHERE `id` = :id
             LIMIT 1";
-        $bindings = [
-            'id' => $id,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    public function getActivityByTypeId($type, $typeId)
-    {
-        $query = "
+		$bindings = [
+			'id' => $id,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	public function getActivityByTypeId($type, $typeId)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`activity`
             WHERE `type` = :type && `type_id` = :type_id
             LIMIT 1";
-        $bindings = [
-            'type'    => $type,
-            'type_id' => $typeId,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    public function getActivityLastUpdateByType($type)
-    {
-        $query = "
+		$bindings = [
+			'type'    => $type,
+			'type_id' => $typeId,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	public function getActivityLastUpdateByType($type)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`activity`
             WHERE `type` = :type
             ORDER BY `updated_at` DESC
             LIMIT 1";
 
-        $bindings = [
-            'type' => $type,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    /**
-     * @param integer $limit
-     * @param integer $offset
-     *
-     * @return array|false
-     */
-    public function getActivities($limit = null, $offset = 0)
-    {
-        $query = "
+		$bindings = [
+			'type' => $type,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	/**
+	 * @param integer $limit
+	 * @param integer $offset
+	 *
+	 * @return array|false
+	 */
+	public function getActivities($limit = null, $offset = 0)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`activity`
             ORDER BY `datetime` DESC";
-        if (!is_null($limit)) {
-            $query .= "
+		if (!is_null($limit)) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
+		}
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query);
+	}
 
-    public function getActivitiesCount()
-    {
-        $query = "
+	public function getActivitiesCount()
+	{
+		$query = "
             SELECT COUNT(1) AS `count`
             FROM `jpemeric_stream`.`activity`";
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchValue($query);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchValue($query);
+	}
 
-    public function getActivitiesByType($type, $limit = null, $offset = 0)
-    {
-        $query = "
+	public function getActivitiesByType($type, $limit = null, $offset = 0)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`activity`
             WHERE `type` = :type
             ORDER BY `datetime` DESC";
-        if (!is_null($limit)) {
-            $query .= "
+		if (!is_null($limit)) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
-        $bindings = [
-            'type' => $type,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
-
-    public function getActivitiesByTypeCount($type)
-    {
-        $query = "
+		}
+		$bindings = [
+			'type' => $type,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
+
+	public function getActivitiesByTypeCount($type)
+	{
+		$query = "
             SELECT COUNT(1) AS `count`
             FROM `jpemeric_stream`.`activity`
             WHERE `type` = :type";
-        $bindings = [
-            'type' => $type,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchValue($query, $bindings);
-    }
-
-    public function insertActivity(
-        $message,
-        $messageLong,
-        DateTime $datetime,
-        array $metadata,
-        $type,
-        $typeId
-    ) {
-        $query = "
+		$bindings = [
+			'type' => $type,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchValue($query, $bindings);
+	}
+
+	public function insertActivity(
+		$message,
+		$messageLong,
+		DateTime $datetime,
+		array $metadata,
+		$type,
+		$typeId
+	) {
+		$query = "
             INSERT INTO `jpemeric_stream`.`activity`
                 (`message`, `message_long`, `datetime`, `metadata`, `type`, `type_id`)
             VALUES
                 (:message, :message_long, :datetime, :metadata, :type, :type_id)";
 
-        $bindings = [
-            'message' => $message,
-            'message_long' => $messageLong,
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
-            'metadata' => json_encode($metadata),
-            'type' => $type,
-            'type_id' => $typeId,
-        ];
-
-        return $this
-            ->connections
-            ->getWrite()
-            ->perform($query, $bindings);
-    }
-
-    public function updateActivityMetadata($activityId, array $metadata)
-    {
-        $query = "
+		$bindings = [
+			'message' => $message,
+			'message_long' => $messageLong,
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
+			'metadata' => json_encode($metadata),
+			'type' => $type,
+			'type_id' => $typeId,
+		];
+
+		return $this
+			->connections
+			->getWrite()
+			->perform($query, $bindings);
+	}
+
+	public function updateActivityMetadata($activityId, array $metadata)
+	{
+		$query = "
             UPDATE `jpemeric_stream`.`activity`
             SET `metadata` = :metadata
             WHERE `id` = :id";
 
-        $bindings = [
-            'metadata' => json_encode($metadata),
-            'id' => $activityId,
-        ];
+		$bindings = [
+			'metadata' => json_encode($metadata),
+			'id' => $activityId,
+		];
 
-        return $this
-            ->connections
-            ->getWrite()
-            ->perform($query, $bindings);
-    }
+		return $this
+			->connections
+			->getWrite()
+			->perform($query, $bindings);
+	}
 }

src/Domain/Stream/Blog/MysqlBlogRepository.php

Indentation +96 added lines, -96 removed lines

@@ -8,129 +8,129 @@
 class MysqlBlogRepository implements BlogRepositoryInterface
 {
 
-    /** @var  ConnectionLocator */
-    protected $connections;
-
-    /**
-     * @param ConnectonLocator $connections
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
-
-    /**
-     * @param integer $id
-     *
-     * @return array|false
-     */
-    public function getBlogById($id)
-    {
-        $query = "
+	/** @var  ConnectionLocator */
+	protected $connections;
+
+	/**
+	 * @param ConnectonLocator $connections
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
+
+	/**
+	 * @param integer $id
+	 *
+	 * @return array|false
+	 */
+	public function getBlogById($id)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`blog`
             WHERE `id` = :id
             LIMIT 1";
-        $bindings = [
-            'id' => $id,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    public function getBlogByPermalink($permalink)
-    {
-        $query = "
+		$bindings = [
+			'id' => $id,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	public function getBlogByPermalink($permalink)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`blog2`
             WHERE `permalink` = :permalink
             LIMIT 1";
-        $bindings = [
-            'permalink' => $permalink,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    /**
-     * @param string $title
-     *
-     * @return array|false
-     */
-    public function getBlogByTitle($title)
-    {
-        $query = "
+		$bindings = [
+			'permalink' => $permalink,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	/**
+	 * @param string $title
+	 *
+	 * @return array|false
+	 */
+	public function getBlogByTitle($title)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`blog`
             WHERE `title` = :title
             LIMIT 1";
-        $bindings = [
-            'title' => $title,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    public function getBlogs($limit = null, $offset = 0)
-    {
-        $query = "
+		$bindings = [
+			'title' => $title,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	public function getBlogs($limit = null, $offset = 0)
+	{
+		$query = "
             SELECT `id`, `permalink`, `datetime`
             FROM `jpemeric_stream`.`blog2`
             ORDER BY `datetime` DESC";
-        if (!is_null($limit)) {
-            $query .= "
+		if (!is_null($limit)) {
+			$query .= "
             LIMIT {$limit}, {$offset}";
-        }
+		}
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query);
+	}
 
-    public function getBlogsUpdatedSince(DateTime $datetime)
-    {
-        $query = "
+	public function getBlogsUpdatedSince(DateTime $datetime)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_stream`.`blog2`
             WHERE `updated_at` >= :last_update";
 
-        $bindings = [
-            'last_update' => $datetime->format('Y-m-d H:i:s'),
-        ];
+		$bindings = [
+			'last_update' => $datetime->format('Y-m-d H:i:s'),
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 
-    public function insertBlog($permalink, DateTime $datetime, array $metadata)
-    {
-        $query = "
+	public function insertBlog($permalink, DateTime $datetime, array $metadata)
+	{
+		$query = "
             INSERT INTO `jpemeric_stream`.`blog2`
                 (`permalink`, `datetime`, `metadata`)
             VALUES
                 (:permalink, :datetime, :metadata)";
 
-        $bindings = [
-            'permalink' => $permalink,
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
-            'metadata' => json_encode($metadata),
-        ];
-
-        return $this
-            ->connections
-            ->getWrite()
-            ->perform($query, $bindings);
-    }
+		$bindings = [
+			'permalink' => $permalink,
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
+			'metadata' => json_encode($metadata),
+		];
+
+		return $this
+			->connections
+			->getWrite()
+			->perform($query, $bindings);
+	}
 }