Completed
Push — master ( 3bc018...c23a2d )
by Jacob
03:34
created
src/Domain/Comment/Comment/MysqlCommentRepository.php 2 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -11,7 +11,7 @@
 block discarded – undo
11 11
     protected $connections;
12 12
 
13 13
     /**
14
-     * @param Aura\Sql\ConnectionLocator $connections
14
+     * @param ConnectionLocator $connections
15 15
      */
16 16
     public function __construct(ConnectionLocator $connections)
17 17
     {
Please login to merge, or discard this patch.
Indentation   +36 added lines, -36 removed lines patch added patch discarded remove patch
@@ -7,26 +7,26 @@  discard block
 block discarded – undo
7 7
 class MysqlCommentRepository implements CommentRepositoryInterface
8 8
 {
9 9
 
10
-    /** @var  Aura\Sql\ConnectionLocator */
11
-    protected $connections;
12
-
13
-    /**
14
-     * @param Aura\Sql\ConnectionLocator $connections
15
-     */
16
-    public function __construct(ConnectionLocator $connections)
17
-    {
18
-        $this->connections = $connections;
19
-    }
20
-
21
-    public function getActiveCommentsBySite($site, $limit = null, $offset = 0)
22
-    {
23
-        if ($site == 'blog') {
24
-            $site_id = 2;
25
-        } else {
26
-            throw new Exception('Unrecognized site id in comment repository');
27
-        }
28
-
29
-        $query = "
10
+	/** @var  Aura\Sql\ConnectionLocator */
11
+	protected $connections;
12
+
13
+	/**
14
+	 * @param Aura\Sql\ConnectionLocator $connections
15
+	 */
16
+	public function __construct(ConnectionLocator $connections)
17
+	{
18
+		$this->connections = $connections;
19
+	}
20
+
21
+	public function getActiveCommentsBySite($site, $limit = null, $offset = 0)
22
+	{
23
+		if ($site == 'blog') {
24
+			$site_id = 2;
25
+		} else {
26
+			throw new Exception('Unrecognized site id in comment repository');
27
+		}
28
+
29
+		$query = "
30 30
             SELECT `comment_meta`.`id`, `comment_meta`.`date`, `comment`.`body`, `commenter`.`name`,
31 31
                    `post`.`title`, `post`.`category`, `post`.`path`
32 32
             FROM `jpemeric_comment`.`comment_meta`
@@ -39,21 +39,21 @@  discard block
 block discarded – undo
39 39
                                                  `post`.`display` = :display_post
40 40
             WHERE `comment_meta`.`display` = :active_comment
41 41
             ORDER BY `comment_meta`.`date` DESC";
42
-        if ($limit != null) {
43
-            $query .= "
42
+		if ($limit != null) {
43
+			$query .= "
44 44
             LIMIT {$offset}, {$limit}";
45
-        }
46
-
47
-        $bindings = [
48
-            'trusted_commenter' => 1,
49
-            'comment_site' => $site_id,
50
-            'display_post' => 1,
51
-            'active_comment' => 1,
52
-        ];
53
-
54
-        return $this
55
-            ->connections
56
-            ->getRead()
57
-            ->fetchAll($query, $bindings);
58
-    }
45
+		}
46
+
47
+		$bindings = [
48
+			'trusted_commenter' => 1,
49
+			'comment_site' => $site_id,
50
+			'display_post' => 1,
51
+			'active_comment' => 1,
52
+		];
53
+
54
+		return $this
55
+			->connections
56
+			->getRead()
57
+			->fetchAll($query, $bindings);
58
+	}
59 59
 }
Please login to merge, or discard this patch.
src/Domain/Comment/Comment/CommentRepositoryInterface.php 2 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -4,5 +4,5 @@
 block discarded – undo
4 4
 
5 5
 interface CommentRepositoryInterface
6 6
 {
7
-    public function getActiveCommentsBySite($site, $limit = null, $offset= 0);
7
+	public function getActiveCommentsBySite($site, $limit = null, $offset= 0);
8 8
 }
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -4,5 +4,5 @@
 block discarded – undo
4 4
 
5 5
 interface CommentRepositoryInterface
6 6
 {
7
-    public function getActiveCommentsBySite($site, $limit = null, $offset= 0);
7
+    public function getActiveCommentsBySite($site, $limit = null, $offset = 0);
8 8
 }
Please login to merge, or discard this patch.
script/cron/generate-rss-feeds.php 3 patches
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -16,7 +16,7 @@
 block discarded – undo
16 16
  * @param string $folder
17 17
  * @return boolean
18 18
  */
19
-$buildFeed = function (Feed $feed, $folder, $name = 'rss') {
19
+$buildFeed = function(Feed $feed, $folder, $name = 'rss') {
20 20
     $tempFeed = __DIR__ . "/../../public/{$folder}/{$name}-new.xml";
21 21
     $finalFeed = __DIR__ . "/../../public/{$folder}/{$name}.xml";
22 22
 
Please login to merge, or discard this patch.
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -3,7 +3,6 @@
 block discarded – undo
3 3
 require_once __DIR__ . '/../index.php';
4 4
 
5 5
 use Github\Client;
6
-
7 6
 use Jacobemerick\Web\Domain\Stream\Changelog\MysqlChangelogRepository as ChangelogRepository;
8 7
 
9 8
 $client = new Client();
Please login to merge, or discard this patch.
Indentation   +83 added lines, -83 removed lines patch added patch discarded remove patch
@@ -21,14 +21,14 @@  discard block
 block discarded – undo
21 21
  * @return boolean
22 22
  */
23 23
 $buildFeed = function (Feed $feed, $folder, $name = 'rss') {
24
-    $tempFeed = __DIR__ . "/../../public/{$folder}/{$name}-new.xml";
25
-    $finalFeed = __DIR__ . "/../../public/{$folder}/{$name}.xml";
24
+	$tempFeed = __DIR__ . "/../../public/{$folder}/{$name}-new.xml";
25
+	$finalFeed = __DIR__ . "/../../public/{$folder}/{$name}.xml";
26 26
 
27
-    $feedHandle = fopen($tempFeed, 'w');
28
-    fwrite($feedHandle, $feed->render());
29
-    fclose($feedHandle);
27
+	$feedHandle = fopen($tempFeed, 'w');
28
+	fwrite($feedHandle, $feed->render());
29
+	fclose($feedHandle);
30 30
 
31
-    rename($tempFeed, $finalFeed);
31
+	rename($tempFeed, $finalFeed);
32 32
 };
33 33
 
34 34
 
@@ -47,56 +47,56 @@  discard block
 block discarded – undo
47 47
 $activeBlogPosts = $blogPostRepository->getActivePosts();
48 48
 
49 49
 foreach ($activeBlogPosts as $blogPost) {
50
-    $blogPostItem = new Item();
51
-
52
-    $blogPostItem->title($blogPost['title']);
53
-
54
-    $url = "http://blog.jacobemerick.com/{$blogPost['category']}/{$blogPost['path']}/";
55
-    $blogPostItem->url($url);
56
-    $blogPostItem->guid($url, true);
57
-
58
-    $description = $blogPost['body'];
59
-    $description = strip_tags($description);
60
-    $description = strtok($description, "\n");
61
-    if (strlen($description) > 250) {
62
-        $description = wordwrap($description, 250);
63
-        $description = strtok($description, "\n");
64
-        if (substr($description, -1) != '.') {
65
-            $description .= '…';
66
-        }
67
-    }
68
-    $description = html_entity_decode($description);
69
-    $blogPostItem->description($description);
70
-
71
-    $categoryUrl = "http://blog.jacobemerick.com/{$blogPost['category']}/";
72
-    $blogPostItem->category($blogPost['category'], $categoryUrl);
73
-
74
-    $pubDate = new DateTime($blogPost['date']);
75
-    $blogPostItem->pubDate($pubDate->getTimestamp());
76
-
77
-    $firstPhoto = Content::instance('FetchFirstPhoto', $blogPost['body'])->activate(true, 'large');
78
-    if (!empty($firstPhoto)) {
79
-        $firstPhotoPieces = sscanf($firstPhoto, '<img src="%s" height="%d" width="%d" alt="%s" />');
80
-        $firstPhotoPath = current($firstPhotoPieces);
81
-        $firstPhotoPath = trim($firstPhotoPath, '"');
82
-
83
-        $firstPhotoInternalPath = __DIR__ . '/../../public' . $firstPhotoPath;
84
-
85
-        $firstPhotoSize = filesize($firstPhotoInternalPath);
86
-
87
-        /**
88
-         * ugh, remote host does not have pecl fileinfo
89
-         *
90
-         * $fInfo = new finfo(FILEINFO_MIME_TYPE);
91
-         * $firstPhotoType = $fInfo->file($firstPhotoInternalPath);
92
-         * unset($fInfo);
93
-         **/
94
-        $firstPhotoType = 'image/jpeg';
95
-
96
-        $blogPostItem->enclosure("http://blog.jacobemerick.com{$firstPhotoPath}", $firstPhotoSize, $firstPhotoType);
97
-    }
98
-
99
-    $blogPostItem->appendTo($blogPostChannel);
50
+	$blogPostItem = new Item();
51
+
52
+	$blogPostItem->title($blogPost['title']);
53
+
54
+	$url = "http://blog.jacobemerick.com/{$blogPost['category']}/{$blogPost['path']}/";
55
+	$blogPostItem->url($url);
56
+	$blogPostItem->guid($url, true);
57
+
58
+	$description = $blogPost['body'];
59
+	$description = strip_tags($description);
60
+	$description = strtok($description, "\n");
61
+	if (strlen($description) > 250) {
62
+		$description = wordwrap($description, 250);
63
+		$description = strtok($description, "\n");
64
+		if (substr($description, -1) != '.') {
65
+			$description .= '&hellip;';
66
+		}
67
+	}
68
+	$description = html_entity_decode($description);
69
+	$blogPostItem->description($description);
70
+
71
+	$categoryUrl = "http://blog.jacobemerick.com/{$blogPost['category']}/";
72
+	$blogPostItem->category($blogPost['category'], $categoryUrl);
73
+
74
+	$pubDate = new DateTime($blogPost['date']);
75
+	$blogPostItem->pubDate($pubDate->getTimestamp());
76
+
77
+	$firstPhoto = Content::instance('FetchFirstPhoto', $blogPost['body'])->activate(true, 'large');
78
+	if (!empty($firstPhoto)) {
79
+		$firstPhotoPieces = sscanf($firstPhoto, '<img src="%s" height="%d" width="%d" alt="%s" />');
80
+		$firstPhotoPath = current($firstPhotoPieces);
81
+		$firstPhotoPath = trim($firstPhotoPath, '"');
82
+
83
+		$firstPhotoInternalPath = __DIR__ . '/../../public' . $firstPhotoPath;
84
+
85
+		$firstPhotoSize = filesize($firstPhotoInternalPath);
86
+
87
+		/**
88
+		 * ugh, remote host does not have pecl fileinfo
89
+		 *
90
+		 * $fInfo = new finfo(FILEINFO_MIME_TYPE);
91
+		 * $firstPhotoType = $fInfo->file($firstPhotoInternalPath);
92
+		 * unset($fInfo);
93
+		 **/
94
+		$firstPhotoType = 'image/jpeg';
95
+
96
+		$blogPostItem->enclosure("http://blog.jacobemerick.com{$firstPhotoPath}", $firstPhotoSize, $firstPhotoType);
97
+	}
98
+
99
+	$blogPostItem->appendTo($blogPostChannel);
100 100
 }
101 101
 
102 102
 $buildFeed($blogPostFeed, 'blog');
@@ -114,33 +114,33 @@  discard block
 block discarded – undo
114 114
 $activeBlogComments = $commentRepository->getActiveCommentsBySite('blog');
115 115
 
116 116
 foreach ($activeBlogComments as $blogComment) {
117
-    $blogCommentItem = new Item();
118
-
119
-    $blogCommentItem->title("Comment on '{$blogComment['title']}' from {$blogComment['name']}");
120
-
121
-    $url = "http://blog.jacobemerick.com/{$blogComment['category']}/{$blogComment['path']}/";
122
-    $url .= "#comment-{$blogComment['id']}";
123
-    $blogCommentItem->url($url);
124
-    $blogCommentItem->guid($url, true);
125
-
126
-    $description = $blogComment['body'];
127
-    $description = strip_tags($description);
128
-    $description = strtok($description, "\n");
129
-    if (strlen($description) > 250) {
130
-        $description = wordwrap($description, 250);
131
-        $description = strtok($description, "\n");
132
-        if (substr($description, -1) != '.') {
133
-            $description .= '&hellip;';
134
-        }
135
-    }
136
-    $description = html_entity_decode($description);
137
-    $description = trim($description);
138
-    $blogCommentItem->description($description);
139
-
140
-    $pubDate = new DateTime($blogComment['date']);
141
-    $blogCommentItem->pubDate($pubDate->getTimestamp());
142
-
143
-    $blogCommentItem->appendTo($blogCommentChannel);
117
+	$blogCommentItem = new Item();
118
+
119
+	$blogCommentItem->title("Comment on '{$blogComment['title']}' from {$blogComment['name']}");
120
+
121
+	$url = "http://blog.jacobemerick.com/{$blogComment['category']}/{$blogComment['path']}/";
122
+	$url .= "#comment-{$blogComment['id']}";
123
+	$blogCommentItem->url($url);
124
+	$blogCommentItem->guid($url, true);
125
+
126
+	$description = $blogComment['body'];
127
+	$description = strip_tags($description);
128
+	$description = strtok($description, "\n");
129
+	if (strlen($description) > 250) {
130
+		$description = wordwrap($description, 250);
131
+		$description = strtok($description, "\n");
132
+		if (substr($description, -1) != '.') {
133
+			$description .= '&hellip;';
134
+		}
135
+	}
136
+	$description = html_entity_decode($description);
137
+	$description = trim($description);
138
+	$blogCommentItem->description($description);
139
+
140
+	$pubDate = new DateTime($blogComment['date']);
141
+	$blogCommentItem->pubDate($pubDate->getTimestamp());
142
+
143
+	$blogCommentItem->appendTo($blogCommentChannel);
144 144
 }
145 145
 
146 146
 $buildFeed($blogCommentFeed, 'blog', 'rss-comments');
Please login to merge, or discard this patch.
src/Domain/Stream/BlogComment/MysqlBlogCommentRepository.php 1 patch
Indentation   +55 added lines, -55 removed lines patch added patch discarded remove patch
@@ -8,80 +8,80 @@
 block discarded – undo
8 8
 class MysqlBlogCommentRepository implements BlogCommentRepositoryInterface
9 9
 {
10 10
 
11
-    /** @var  ConnectionLocator */
12
-    protected $connections;
11
+	/** @var  ConnectionLocator */
12
+	protected $connections;
13 13
 
14
-    /**
15
-     * @param ConnectonLocator $connections
16
-     */
17
-    public function __construct(ConnectionLocator $connections)
18
-    {
19
-        $this->connections = $connections;
20
-    }
14
+	/**
15
+	 * @param ConnectonLocator $connections
16
+	 */
17
+	public function __construct(ConnectionLocator $connections)
18
+	{
19
+		$this->connections = $connections;
20
+	}
21 21
 
22
-    /**
23
-     * @param integer $limit
24
-     * @param integer $offset
25
-     *
26
-     * @return array|false
27
-     */
28
-    public function getBlogComments($limit = null, $offset = 0)
29
-    {
30
-        $query = "
22
+	/**
23
+	 * @param integer $limit
24
+	 * @param integer $offset
25
+	 *
26
+	 * @return array|false
27
+	 */
28
+	public function getBlogComments($limit = null, $offset = 0)
29
+	{
30
+		$query = "
31 31
             SELECT `id`, `permalink`, `datetime`
32 32
             FROM `jpemeric_stream`.`blog_comment`
33 33
             ORDER BY `datetime` DESC";
34
-        if (!is_null($limit)) {
35
-            $query .= "
34
+		if (!is_null($limit)) {
35
+			$query .= "
36 36
             LIMIT {$offset}, {$limit}";
37
-        }
37
+		}
38 38
 
39
-        return $this
40
-            ->connections
41
-            ->getRead()
42
-            ->fetchAll($query);
43
-    }
39
+		return $this
40
+			->connections
41
+			->getRead()
42
+			->fetchAll($query);
43
+	}
44 44
 
45
-    /**
46
-     * @param string $permalink
47
-     *
48
-     * @return array|false
49
-     */
50
-    public function getBlogCommentByPermalink($permalink)
51
-    {
52
-        $query = "
45
+	/**
46
+	 * @param string $permalink
47
+	 *
48
+	 * @return array|false
49
+	 */
50
+	public function getBlogCommentByPermalink($permalink)
51
+	{
52
+		$query = "
53 53
             SELECT *
54 54
             FROM `jpemeric_stream`.`blog_comment`
55 55
             WHERE `permalink` = :permalink
56 56
             LIMIT 1";
57 57
 
58
-        $bindings = [
59
-            'permalink' => $permalink,
60
-        ];
58
+		$bindings = [
59
+			'permalink' => $permalink,
60
+		];
61 61
 
62
-        return $this
63
-            ->connections
64
-            ->getRead()
65
-            ->fetchOne($query, $bindings);
66
-    }
62
+		return $this
63
+			->connections
64
+			->getRead()
65
+			->fetchOne($query, $bindings);
66
+	}
67 67
 
68
-    public function insertBlogComment($permalink, DateTime $datetime, array $metadata)
69
-    {
70
-        $query = "
68
+	public function insertBlogComment($permalink, DateTime $datetime, array $metadata)
69
+	{
70
+		$query = "
71 71
             INSERT INTO `jpemeric_stream`.`blog_comment`
72 72
                 (`permalink`, `datetime`, `metadata`)
73 73
             VALUES
74 74
                 (:permalink, :datetime, :metadata)";
75 75
 
76
-        $bindings = [
77
-            'permalink' => $permalink,
78
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
79
-            'metadata' => json_encode($metadata),
80
-        ];
76
+		$bindings = [
77
+			'permalink' => $permalink,
78
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
79
+			'metadata' => json_encode($metadata),
80
+		];
81 81
 
82
-        return $this
83
-            ->connections
84
-            ->getWrite()
85
-            ->perform($query, $bindings);
86
-    }
82
+		return $this
83
+			->connections
84
+			->getWrite()
85
+			->perform($query, $bindings);
86
+	}
87 87
 }
Please login to merge, or discard this patch.
script/cron/fetch-goodreads-activity.php 1 patch
Indentation   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -6,7 +6,7 @@  discard block
 block discarded – undo
6 6
 use Jacobemerick\Web\Domain\Stream\Goodread\MysqlGoodreadRepository as GoodreadRepository;
7 7
 
8 8
 $client = new Client([
9
-    'base_uri' => 'http://www.goodreads.com',
9
+	'base_uri' => 'http://www.goodreads.com',
10 10
 ]);
11 11
 
12 12
 $goodreadRepository = new GoodreadRepository($container['db_connection_locator']);
@@ -20,23 +20,23 @@  discard block
 block discarded – undo
20 20
 $reviews = simplexml_load_string($reviews, 'SimpleXMLElement', LIBXML_NOCDATA);
21 21
 
22 22
 foreach ($reviews->channel->item as $review) {
23
-    $datetime = new DateTime((string) $review->pubDate);
24
-    if ($datetime <= $mostRecentReviewDateTime) {
25
-        break;
26
-    }
27
-
28
-    $uniqueReviewCheck = $goodreadRepository->getReviewByPermalink((string) $review->guid);
29
-    if ($uniqueReviewCheck !== false) {
30
-        continue;
31
-    }
32
-
33
-    $datetime->setTimezone($container['default_timezone']);
34
-    $metadata = json_decode(json_encode($review), true);
35
-
36
-    $goodreadRepository->insertReview(
37
-        (string) $review->guid,
38
-        (string) $review->book_id,
39
-        $datetime,
40
-        $metadata
41
-    );
23
+	$datetime = new DateTime((string) $review->pubDate);
24
+	if ($datetime <= $mostRecentReviewDateTime) {
25
+		break;
26
+	}
27
+
28
+	$uniqueReviewCheck = $goodreadRepository->getReviewByPermalink((string) $review->guid);
29
+	if ($uniqueReviewCheck !== false) {
30
+		continue;
31
+	}
32
+
33
+	$datetime->setTimezone($container['default_timezone']);
34
+	$metadata = json_decode(json_encode($review), true);
35
+
36
+	$goodreadRepository->insertReview(
37
+		(string) $review->guid,
38
+		(string) $review->book_id,
39
+		$datetime,
40
+		$metadata
41
+	);
42 42
 }
Please login to merge, or discard this patch.
script/manual/historic-twitter-fetch.php 1 patch
Indentation   +29 added lines, -29 removed lines patch added patch discarded remove patch
@@ -4,17 +4,17 @@  discard block
 block discarded – undo
4 4
 
5 5
 $options = getopt('f:');
6 6
 if (empty($options['f'])) {
7
-    exit('Must pass in a file with the f parameter.');
7
+	exit('Must pass in a file with the f parameter.');
8 8
 }
9 9
 
10 10
 use Abraham\TwitterOAuth\TwitterOAuth;
11 11
 use Jacobemerick\Web\Domain\Stream\Twitter\MysqlTwitterRepository as TwitterRepository;
12 12
 
13 13
 $client = new TwitterOAuth(
14
-    $config->twitter->consumer_key,
15
-    $config->twitter->consumer_secret,
16
-    $config->twitter->access_token,
17
-    $config->twitter->access_token_secret
14
+	$config->twitter->consumer_key,
15
+	$config->twitter->consumer_secret,
16
+	$config->twitter->access_token,
17
+	$config->twitter->access_token_secret
18 18
 );
19 19
 $client->setDecodeJsonAsArray(true);
20 20
 
@@ -24,29 +24,29 @@  discard block
 block discarded – undo
24 24
 
25 25
 $handle = fopen(__DIR__ . '/' . $options['f'], 'r');
26 26
 while ($row = fgets($handle)) {
27
-    array_push($idList, trim($row));
28
-    if (count($idList) == 100) {
29
-        $tweetLookup = $client->get('statuses/lookup', [
30
-            'id' => implode(',', $idList),
31
-            'trim_user' => true,
32
-        ]);
33
-
34
-        foreach ($tweetLookup as $tweet) {
35
-            $uniqueTweetCheck = $twitterRepository->getTwitterByTweetId($tweet['id_str']);
36
-            if ($uniqueTweetCheck !== false) {
37
-                if ($uniqueTweetCheck['metadata'] != json_encode($tweet)) {
38
-                    $twitterRepository->updateTweetMetadata($tweet['id_str'], $tweet);
39
-                }
40
-                continue;
41
-            }
42
-
43
-            $twitterRepository->insertTweet(
44
-                $tweet['id_str'],
45
-                (new DateTime($tweet['created_at']))->setTimezone($container['default_timezone']),
46
-                $tweet
47
-            );
48
-        }
49
-        $idList = [];
50
-    }
27
+	array_push($idList, trim($row));
28
+	if (count($idList) == 100) {
29
+		$tweetLookup = $client->get('statuses/lookup', [
30
+			'id' => implode(',', $idList),
31
+			'trim_user' => true,
32
+		]);
33
+
34
+		foreach ($tweetLookup as $tweet) {
35
+			$uniqueTweetCheck = $twitterRepository->getTwitterByTweetId($tweet['id_str']);
36
+			if ($uniqueTweetCheck !== false) {
37
+				if ($uniqueTweetCheck['metadata'] != json_encode($tweet)) {
38
+					$twitterRepository->updateTweetMetadata($tweet['id_str'], $tweet);
39
+				}
40
+				continue;
41
+			}
42
+
43
+			$twitterRepository->insertTweet(
44
+				$tweet['id_str'],
45
+				(new DateTime($tweet['created_at']))->setTimezone($container['default_timezone']),
46
+				$tweet
47
+			);
48
+		}
49
+		$idList = [];
50
+	}
51 51
 }
52 52
 fclose($handle);
Please login to merge, or discard this patch.
src/Domain/Stream/Activity/ActivityRepositoryInterface.php 1 patch
Indentation   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -4,9 +4,9 @@
 block discarded – undo
4 4
 
5 5
 interface ActivityRepositoryInterface
6 6
 {
7
-    public function getActivityById($id);
8
-    public function getActivities($limit = null, $offset = 0);
9
-    public function getActivitiesCount();
10
-    public function getActivitiesByType($type, $limit = null, $offset = 0);
11
-    public function getActivitiesByTypeCount($type);
7
+	public function getActivityById($id);
8
+	public function getActivities($limit = null, $offset = 0);
9
+	public function getActivitiesCount();
10
+	public function getActivitiesByType($type, $limit = null, $offset = 0);
11
+	public function getActivitiesByTypeCount($type);
12 12
 }
Please login to merge, or discard this patch.
src/Domain/Stream/Activity/MysqlActivityRepository.php 1 patch
Indentation   +146 added lines, -146 removed lines patch added patch discarded remove patch
@@ -8,192 +8,192 @@
 block discarded – undo
8 8
 class MysqlActivityRepository implements ActivityRepositoryInterface
9 9
 {
10 10
 
11
-    /** @var  ConnectionLocator */
12
-    protected $connections;
13
-
14
-    /**
15
-     * @param ConnectonLocator $connections
16
-     */
17
-    public function __construct(ConnectionLocator $connections)
18
-    {
19
-        $this->connections = $connections;
20
-    }
21
-
22
-    /**
23
-     * @param integer $id
24
-     *
25
-     * @return array|false
26
-     */
27
-    public function getActivityById($id)
28
-    {
29
-        $query = "
11
+	/** @var  ConnectionLocator */
12
+	protected $connections;
13
+
14
+	/**
15
+	 * @param ConnectonLocator $connections
16
+	 */
17
+	public function __construct(ConnectionLocator $connections)
18
+	{
19
+		$this->connections = $connections;
20
+	}
21
+
22
+	/**
23
+	 * @param integer $id
24
+	 *
25
+	 * @return array|false
26
+	 */
27
+	public function getActivityById($id)
28
+	{
29
+		$query = "
30 30
             SELECT *
31 31
             FROM `jpemeric_stream`.`activity`
32 32
             WHERE `id` = :id
33 33
             LIMIT 1";
34
-        $bindings = [
35
-            'id' => $id,
36
-        ];
37
-
38
-        return $this
39
-            ->connections
40
-            ->getRead()
41
-            ->fetchOne($query, $bindings);
42
-    }
43
-
44
-    public function getActivityByTypeId($type, $typeId)
45
-    {
46
-        $query = "
34
+		$bindings = [
35
+			'id' => $id,
36
+		];
37
+
38
+		return $this
39
+			->connections
40
+			->getRead()
41
+			->fetchOne($query, $bindings);
42
+	}
43
+
44
+	public function getActivityByTypeId($type, $typeId)
45
+	{
46
+		$query = "
47 47
             SELECT *
48 48
             FROM `jpemeric_stream`.`activity`
49 49
             WHERE `type` = :type && `type_id` = :type_id
50 50
             LIMIT 1";
51
-        $bindings = [
52
-            'type'    => $type,
53
-            'type_id' => $typeId,
54
-        ];
55
-
56
-        return $this
57
-            ->connections
58
-            ->getRead()
59
-            ->fetchOne($query, $bindings);
60
-    }
61
-
62
-    public function getActivityLastUpdateByType($type)
63
-    {
64
-        $query = "
51
+		$bindings = [
52
+			'type'    => $type,
53
+			'type_id' => $typeId,
54
+		];
55
+
56
+		return $this
57
+			->connections
58
+			->getRead()
59
+			->fetchOne($query, $bindings);
60
+	}
61
+
62
+	public function getActivityLastUpdateByType($type)
63
+	{
64
+		$query = "
65 65
             SELECT *
66 66
             FROM `jpemeric_stream`.`activity`
67 67
             WHERE `type` = :type
68 68
             ORDER BY `updated_at` DESC
69 69
             LIMIT 1";
70 70
 
71
-        $bindings = [
72
-            'type' => $type,
73
-        ];
74
-
75
-        return $this
76
-            ->connections
77
-            ->getRead()
78
-            ->fetchOne($query, $bindings);
79
-    }
80
-
81
-    /**
82
-     * @param integer $limit
83
-     * @param integer $offset
84
-     *
85
-     * @return array|false
86
-     */
87
-    public function getActivities($limit = null, $offset = 0)
88
-    {
89
-        $query = "
71
+		$bindings = [
72
+			'type' => $type,
73
+		];
74
+
75
+		return $this
76
+			->connections
77
+			->getRead()
78
+			->fetchOne($query, $bindings);
79
+	}
80
+
81
+	/**
82
+	 * @param integer $limit
83
+	 * @param integer $offset
84
+	 *
85
+	 * @return array|false
86
+	 */
87
+	public function getActivities($limit = null, $offset = 0)
88
+	{
89
+		$query = "
90 90
             SELECT *
91 91
             FROM `jpemeric_stream`.`activity`
92 92
             ORDER BY `datetime` DESC";
93
-        if (!is_null($limit)) {
94
-            $query .= "
93
+		if (!is_null($limit)) {
94
+			$query .= "
95 95
             LIMIT {$offset}, {$limit}";
96
-        }
96
+		}
97 97
 
98
-        return $this
99
-            ->connections
100
-            ->getRead()
101
-            ->fetchAll($query);
102
-    }
98
+		return $this
99
+			->connections
100
+			->getRead()
101
+			->fetchAll($query);
102
+	}
103 103
 
104
-    public function getActivitiesCount()
105
-    {
106
-        $query = "
104
+	public function getActivitiesCount()
105
+	{
106
+		$query = "
107 107
             SELECT COUNT(1) AS `count`
108 108
             FROM `jpemeric_stream`.`activity`";
109 109
 
110
-        return $this
111
-            ->connections
112
-            ->getRead()
113
-            ->fetchValue($query);
114
-    }
110
+		return $this
111
+			->connections
112
+			->getRead()
113
+			->fetchValue($query);
114
+	}
115 115
 
116
-    public function getActivitiesByType($type, $limit = null, $offset = 0)
117
-    {
118
-        $query = "
116
+	public function getActivitiesByType($type, $limit = null, $offset = 0)
117
+	{
118
+		$query = "
119 119
             SELECT *
120 120
             FROM `jpemeric_stream`.`activity`
121 121
             WHERE `type` = :type
122 122
             ORDER BY `datetime` DESC";
123
-        if (!is_null($limit)) {
124
-            $query .= "
123
+		if (!is_null($limit)) {
124
+			$query .= "
125 125
             LIMIT {$offset}, {$limit}";
126
-        }
127
-        $bindings = [
128
-            'type' => $type,
129
-        ];
130
-
131
-        return $this
132
-            ->connections
133
-            ->getRead()
134
-            ->fetchAll($query, $bindings);
135
-    }
136
-
137
-    public function getActivitiesByTypeCount($type)
138
-    {
139
-        $query = "
126
+		}
127
+		$bindings = [
128
+			'type' => $type,
129
+		];
130
+
131
+		return $this
132
+			->connections
133
+			->getRead()
134
+			->fetchAll($query, $bindings);
135
+	}
136
+
137
+	public function getActivitiesByTypeCount($type)
138
+	{
139
+		$query = "
140 140
             SELECT COUNT(1) AS `count`
141 141
             FROM `jpemeric_stream`.`activity`
142 142
             WHERE `type` = :type";
143
-        $bindings = [
144
-            'type' => $type,
145
-        ];
146
-
147
-        return $this
148
-            ->connections
149
-            ->getRead()
150
-            ->fetchValue($query, $bindings);
151
-    }
152
-
153
-    public function insertActivity(
154
-        $message,
155
-        $messageLong,
156
-        DateTime $datetime,
157
-        array $metadata,
158
-        $type,
159
-        $typeId
160
-    ) {
161
-        $query = "
143
+		$bindings = [
144
+			'type' => $type,
145
+		];
146
+
147
+		return $this
148
+			->connections
149
+			->getRead()
150
+			->fetchValue($query, $bindings);
151
+	}
152
+
153
+	public function insertActivity(
154
+		$message,
155
+		$messageLong,
156
+		DateTime $datetime,
157
+		array $metadata,
158
+		$type,
159
+		$typeId
160
+	) {
161
+		$query = "
162 162
             INSERT INTO `jpemeric_stream`.`activity`
163 163
                 (`message`, `message_long`, `datetime`, `metadata`, `type`, `type_id`)
164 164
             VALUES
165 165
                 (:message, :message_long, :datetime, :metadata, :type, :type_id)";
166 166
 
167
-        $bindings = [
168
-            'message' => $message,
169
-            'message_long' => $messageLong,
170
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
171
-            'metadata' => json_encode($metadata),
172
-            'type' => $type,
173
-            'type_id' => $typeId,
174
-        ];
175
-
176
-        return $this
177
-            ->connections
178
-            ->getWrite()
179
-            ->perform($query, $bindings);
180
-    }
181
-
182
-    public function updateActivityMetadata($activityId, array $metadata)
183
-    {
184
-        $query = "
167
+		$bindings = [
168
+			'message' => $message,
169
+			'message_long' => $messageLong,
170
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
171
+			'metadata' => json_encode($metadata),
172
+			'type' => $type,
173
+			'type_id' => $typeId,
174
+		];
175
+
176
+		return $this
177
+			->connections
178
+			->getWrite()
179
+			->perform($query, $bindings);
180
+	}
181
+
182
+	public function updateActivityMetadata($activityId, array $metadata)
183
+	{
184
+		$query = "
185 185
             UPDATE `jpemeric_stream`.`activity`
186 186
             SET `metadata` = :metadata
187 187
             WHERE `id` = :id";
188 188
 
189
-        $bindings = [
190
-            'metadata' => json_encode($metadata),
191
-            'id' => $activityId,
192
-        ];
189
+		$bindings = [
190
+			'metadata' => json_encode($metadata),
191
+			'id' => $activityId,
192
+		];
193 193
 
194
-        return $this
195
-            ->connections
196
-            ->getWrite()
197
-            ->perform($query, $bindings);
198
-    }
194
+		return $this
195
+			->connections
196
+			->getWrite()
197
+			->perform($query, $bindings);
198
+	}
199 199
 }
Please login to merge, or discard this patch.
src/Domain/Stream/DailyMile/MysqlDailyMileRepository.php 1 patch
Indentation   +82 added lines, -82 removed lines patch added patch discarded remove patch
@@ -8,106 +8,106 @@
 block discarded – undo
8 8
 class MysqlDailyMileRepository implements DailyMileRepositoryInterface
9 9
 {
10 10
 
11
-    /** @var  ConnectionLocator */
12
-    protected $connections;
13
-
14
-    /**
15
-     * @param ConnectonLocator $connections
16
-     */
17
-    public function __construct(ConnectionLocator $connections)
18
-    {
19
-        $this->connections = $connections;
20
-    }
21
-
22
-    /**
23
-     * @param integer $limit
24
-     * @param integer $offset
25
-     *
26
-     * @return array|false
27
-     */
28
-    public function getEntries($limit = null, $offset = 0)
29
-    {
30
-        $query = "
11
+	/** @var  ConnectionLocator */
12
+	protected $connections;
13
+
14
+	/**
15
+	 * @param ConnectonLocator $connections
16
+	 */
17
+	public function __construct(ConnectionLocator $connections)
18
+	{
19
+		$this->connections = $connections;
20
+	}
21
+
22
+	/**
23
+	 * @param integer $limit
24
+	 * @param integer $offset
25
+	 *
26
+	 * @return array|false
27
+	 */
28
+	public function getEntries($limit = null, $offset = 0)
29
+	{
30
+		$query = "
31 31
             SELECT `id`, `entry_id`, `datetime`
32 32
             FROM `jpemeric_stream`.`dailymile`
33 33
             ORDER BY `datetime` DESC";
34
-        if (!is_null($limit)) {
35
-          $query .= "
34
+		if (!is_null($limit)) {
35
+		  $query .= "
36 36
           LIMIT {$offset}, {$limit}";
37
-        }
38
-
39
-        return $this
40
-            ->connections
41
-            ->getRead()
42
-            ->fetchAll($query);
43
-    }
44
-
45
-    /**
46
-     * @param integer $entryId
47
-     *
48
-     * @return array|false
49
-     */
50
-    public function getEntryByEntryId($entryId)
51
-    {
52
-        $query = "
37
+		}
38
+
39
+		return $this
40
+			->connections
41
+			->getRead()
42
+			->fetchAll($query);
43
+	}
44
+
45
+	/**
46
+	 * @param integer $entryId
47
+	 *
48
+	 * @return array|false
49
+	 */
50
+	public function getEntryByEntryId($entryId)
51
+	{
52
+		$query = "
53 53
             SELECT *
54 54
             FROM `jpemeric_stream`.`dailymile`
55 55
             WHERE `entry_id` = :entry_id
56 56
             LIMIT 1";
57 57
 
58
-        $bindings = [
59
-            'entry_id' => $entryId,
60
-        ];
58
+		$bindings = [
59
+			'entry_id' => $entryId,
60
+		];
61 61
 
62
-        return $this
63
-            ->connections
64
-            ->getRead()
65
-            ->fetchOne($query, $bindings);
66
-    }
62
+		return $this
63
+			->connections
64
+			->getRead()
65
+			->fetchOne($query, $bindings);
66
+	}
67 67
 
68
-    public function getDailyMilesUpdatedSince(DateTime $datetime)
69
-    {
70
-        $query = "
68
+	public function getDailyMilesUpdatedSince(DateTime $datetime)
69
+	{
70
+		$query = "
71 71
             SELECT *
72 72
             FROM `jpemeric_stream`.`dailymile`
73 73
             WHERE `updated_at` >= :last_update";
74 74
 
75
-        $bindings = [
76
-            'last_update' => $datetime->format('Y-m-d H:i:s'),
77
-        ];
78
-
79
-        return $this
80
-            ->connections
81
-            ->getRead()
82
-            ->fetchAll($query, $bindings);
83
-    }
84
-
85
-    /**
86
-     * @param integer  $entryId
87
-     * @param string   $entryType
88
-     * @param DateTime $datetime
89
-     * @param array    $metadata
90
-     *
91
-     * @return
92
-     */
93
-    public function insertEntry($entryId, $entryType, DateTime $datetime, array $metadata)
94
-    {
95
-        $query = "
75
+		$bindings = [
76
+			'last_update' => $datetime->format('Y-m-d H:i:s'),
77
+		];
78
+
79
+		return $this
80
+			->connections
81
+			->getRead()
82
+			->fetchAll($query, $bindings);
83
+	}
84
+
85
+	/**
86
+	 * @param integer  $entryId
87
+	 * @param string   $entryType
88
+	 * @param DateTime $datetime
89
+	 * @param array    $metadata
90
+	 *
91
+	 * @return
92
+	 */
93
+	public function insertEntry($entryId, $entryType, DateTime $datetime, array $metadata)
94
+	{
95
+		$query = "
96 96
             INSERT INTO `jpemeric_stream`.`dailymile`
97 97
                 (`entry_id`, `type`, `datetime`, `metadata`)
98 98
             VALUES
99 99
                 (:entry_id, :entry_type, :datetime, :metadata)";
100 100
 
101
-        $bindings = [
102
-            'entry_id' => $entryId,
103
-            'entry_type' => $entryType,
104
-            'datetime' => $datetime->format('Y-m-d H:i:s'),
105
-            'metadata' => json_encode($metadata),
106
-        ];
107
-
108
-        return $this
109
-            ->connections
110
-            ->getWrite()
111
-            ->perform($query, $bindings);
112
-    }
101
+		$bindings = [
102
+			'entry_id' => $entryId,
103
+			'entry_type' => $entryType,
104
+			'datetime' => $datetime->format('Y-m-d H:i:s'),
105
+			'metadata' => json_encode($metadata),
106
+		];
107
+
108
+		return $this
109
+			->connections
110
+			->getWrite()
111
+			->perform($query, $bindings);
112
+	}
113 113
 }
Please login to merge, or discard this patch.