jacobemerick / web

script/cron/build-activity-stream.php

Indentation +52 added lines, -52 removed lines

@@ -11,44 +11,44 @@ 
 
 $lastBlogActivity = $activityRepository->getActivityLastUpdateByType('blog');
 if ($lastBlogActivity === false) {
-    $lastBlogActivityDateTime = new DateTime('2008-05-03');
+	$lastBlogActivityDateTime = new DateTime('2008-05-03');
 } else {
-    $lastBlogActivityDateTime = new DateTime($lastBlogActivity['updated_at']);
-    $lastBlogActivityDateTime->modify('-5 days');
+	$lastBlogActivityDateTime = new DateTime($lastBlogActivity['updated_at']);
+	$lastBlogActivityDateTime->modify('-5 days');
 }
 $newBlogActivity = $blogRepository->getBlogsUpdatedSince($lastBlogActivityDateTime);
 foreach ($newBlogActivity as $blog) {
-    $uniqueBlogCheck = $activityRepository->getActivityByTypeId('blog', $blog['id']);
-    if ($uniqueBlogCheck !== false) {
-        continue;
-    }
+	$uniqueBlogCheck = $activityRepository->getActivityByTypeId('blog', $blog['id']);
+	if ($uniqueBlogCheck !== false) {
+		continue;
+	}
 
-    $blogData = json_decode($blog['metadata'], true);
-    $message = sprintf(
-        'Blogged about %s: <a href="%s" title="Jacob Emerick\'s Blog | %s">%s</a>.',
-        str_replace('-', ' ', $blogData['category']),
-        $blogData['link'],
-        $blogData['title'],
-        $blogData['title']
-    );
-    $messageLong = sprintf(
-        "<h4><a href=\"%s\" title=\"Jacob Emerick's Blog | %s\">%s</a></h4>\n" .
-        "<p>%s [<a href=\"%s\">read more</a></a>]</p>",
-        $blogData['link'],
-        $blogData['title'],
-        $blogData['title'],
-        htmlentities($blogData['description']),
-        $blogData['link']
-    );
+	$blogData = json_decode($blog['metadata'], true);
+	$message = sprintf(
+		'Blogged about %s: <a href="%s" title="Jacob Emerick\'s Blog | %s">%s</a>.',
+		str_replace('-', ' ', $blogData['category']),
+		$blogData['link'],
+		$blogData['title'],
+		$blogData['title']
+	);
+	$messageLong = sprintf(
+		"<h4><a href=\"%s\" title=\"Jacob Emerick's Blog | %s\">%s</a></h4>\n" .
+		"<p>%s [<a href=\"%s\">read more</a></a>]</p>",
+		$blogData['link'],
+		$blogData['title'],
+		$blogData['title'],
+		htmlentities($blogData['description']),
+		$blogData['link']
+	);
 
-    $activityRepository->insertActivity(
-        $message,
-        $messageLong,
-        (new DateTime($blog['datetime'])),
-        [],
-        'blog',
-        $blog['id']
-    );
+	$activityRepository->insertActivity(
+		$message,
+		$messageLong,
+		(new DateTime($blog['datetime'])),
+		[],
+		'blog',
+		$blog['id']
+	);
 }
 
 use Jacobemerick\Web\Domain\Stream\BlogComment\MysqlBlogCommentRepository as BlogCommentRepository;
@@ -56,28 +56,28 @@ 
 $blogCommentActivity = $blogCommentRepository->getBlogComments();
 $blogCommentHolder = [];
 foreach ($blogCommentActivity as $blogComment) {
-    $blogPermalink = $blogComment['permalink'];
-    $blogPermalink = explode('#', $blogPermalink);
-    $blogPermalink = current($blogPermalink);
+	$blogPermalink = $blogComment['permalink'];
+	$blogPermalink = explode('#', $blogPermalink);
+	$blogPermalink = current($blogPermalink);
 
-    $blog = $blogRepository->getBlogByPermalink($blogPermalink);
-    if (!array_key_exists($blog['id'], $blogCommentHolder)) {
-        $blogCommentHolder[$blog['id']] = 1;
-    } else {
-        $blogCommentHolder[$blog['id']]++;
-    }
+	$blog = $blogRepository->getBlogByPermalink($blogPermalink);
+	if (!array_key_exists($blog['id'], $blogCommentHolder)) {
+		$blogCommentHolder[$blog['id']] = 1;
+	} else {
+		$blogCommentHolder[$blog['id']]++;
+	}
 }
 
 foreach ($blogCommentHolder as $blogId => $commentCount) {
-    $blogActivity = $activityRepository->getActivityByTypeId('blog', $blogId);
-    $blogActivityMetadata = json_decode($blogActivity['metadata']);
-    if (
-        !isset($blogActivityMetadata['comments']) ||
-        $blogActivityMetadata['comments'] != $commentCount
-    ) {
-        $activityRepository->updateActivityMetadata(
-            $blogActivity['id'],
-            ['comments' => $commentCount]
-        );
-    }
+	$blogActivity = $activityRepository->getActivityByTypeId('blog', $blogId);
+	$blogActivityMetadata = json_decode($blogActivity['metadata']);
+	if (
+		!isset($blogActivityMetadata['comments']) ||
+		$blogActivityMetadata['comments'] != $commentCount
+	) {
+		$activityRepository->updateActivityMetadata(
+			$blogActivity['id'],
+			['comments' => $commentCount]
+		);
+	}
 }

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);
+	}
 }