jacobemerick / web

controller/portfolio/AboutController.class.inc.php

Indentation +20 added lines, -20 removed lines

@@ -5,26 +5,26 @@
 class AboutController extends DefaultPageController
 {
 
-    protected function set_head_data()
-    {
-        $this->set_title("Jacob Emerick's Portfolio");
-        $this->set_description("Jacob Emerick's Portfolio - collection of programming projects and resume");
-        $this->set_keywords([
-            'portfolio',
-            'Jacob Emerick',
-            'web development',
-            'web programming',
-            'software development',
-            'agile',
-            'freelance',
-        ]);
-    }
+	protected function set_head_data()
+	{
+		$this->set_title("Jacob Emerick's Portfolio");
+		$this->set_description("Jacob Emerick's Portfolio - collection of programming projects and resume");
+		$this->set_keywords([
+			'portfolio',
+			'Jacob Emerick',
+			'web development',
+			'web programming',
+			'software development',
+			'agile',
+			'freelance',
+		]);
+	}
 
-    protected function set_body_data()
-    {
-        $this->set_body('body_view', 'About');
-        $this->set_body('body_data', []);
+	protected function set_body_data()
+	{
+		$this->set_body('body_view', 'About');
+		$this->set_body('body_data', []);
 
-        parent::set_body_data();
-    }
+		parent::set_body_data();
+	}
 }

controller/portfolio/ResumeController.class.inc.php

Indentation +23 added lines, -23 removed lines

@@ -5,31 +5,31 @@
 class ResumeController extends DefaultPageController
 {
 
-    protected $resume = 'resume-20160318.json';
+	protected $resume = 'resume-20160318.json';
 
-    protected function set_head_data()
-    {
-        $this->set_title("Resume | Jacob Emerick's Portfolio");
-        $this->set_description("Resume for Jacob Emerick, a software engineer extraordinaire");
-        $this->set_keywords([
-            'resume',
-            'programming resume',
-            'Jacob Emerick',
-            'software engineer',
-            'portfolio',
-            'shutterstock',
-        ]);
-    }
+	protected function set_head_data()
+	{
+		$this->set_title("Resume | Jacob Emerick's Portfolio");
+		$this->set_description("Resume for Jacob Emerick, a software engineer extraordinaire");
+		$this->set_keywords([
+			'resume',
+			'programming resume',
+			'Jacob Emerick',
+			'software engineer',
+			'portfolio',
+			'shutterstock',
+		]);
+	}
 
-    protected function set_body_data()
-    {
-        $this->set_body('body_view', 'Resume');
+	protected function set_body_data()
+	{
+		$this->set_body('body_view', 'Resume');
 
-        $resumePath = Loader::getRootURL('portfolio') . "/jsonresume/{$this->resume}";
-        $resume = file_get_contents($resumePath);
-        $resume = json_decode($resume, true);
-        $this->set_body('body_data', $resume);
+		$resumePath = Loader::getRootURL('portfolio') . "/jsonresume/{$this->resume}";
+		$resume = file_get_contents($resumePath);
+		$resume = json_decode($resume, true);
+		$this->set_body('body_data', $resume);
 
-        parent::set_body_data();
-    }
+		parent::set_body_data();
+	}
 }

controller/portfolio/ProjectsController.class.inc.php

Indentation +19 added lines, -19 removed lines

@@ -5,25 +5,25 @@
 class ProjectsController extends DefaultPageController
 {
 
-    protected function set_head_data()
-    {
-        $this->set_title("Projects Page | Jacob Emerick's Portfolio");
-        $this->set_description("Collection of key open-source projects that Jacob has developed and maintained over the years.");
-        $this->set_keywords([
-            'projects',
-            'open source',
-            'example work',
-            'portfolio',
-            'Jacob Emerick',
-            'software development',
-        ]);
-    }
+	protected function set_head_data()
+	{
+		$this->set_title("Projects Page | Jacob Emerick's Portfolio");
+		$this->set_description("Collection of key open-source projects that Jacob has developed and maintained over the years.");
+		$this->set_keywords([
+			'projects',
+			'open source',
+			'example work',
+			'portfolio',
+			'Jacob Emerick',
+			'software development',
+		]);
+	}
 
-    protected function set_body_data()
-    {
-        $this->set_body('body_view', 'Projects');
-        $this->set_body('body_data', []);
+	protected function set_body_data()
+	{
+		$this->set_body('body_view', 'Projects');
+		$this->set_body('body_data', []);
 
-        parent::set_body_data();
-    }
+		parent::set_body_data();
+	}
 }

tests/unit/Domain/Blog/Post/MysqlPostRepositoryTest.php

Indentation +1235 added lines, -1235 removed lines

@@ -10,14 +10,14 @@ 
 class MysqlPostRepositoryTest extends PHPUnit_Framework_TestCase
 {
 
-    protected static $connection;
+	protected static $connection;
 
-    public static function setUpBeforeClass()
-    {
-        $extendedPdo = new ExtendedPdo('sqlite::memory:');
-        $extendedPdo->exec('ATTACH DATABASE `jpemeric_blog.db` AS `jpemeric_blog`');
+	public static function setUpBeforeClass()
+	{
+		$extendedPdo = new ExtendedPdo('sqlite::memory:');
+		$extendedPdo->exec('ATTACH DATABASE `jpemeric_blog.db` AS `jpemeric_blog`');
 
-        $extendedPdo->exec("
+		$extendedPdo->exec("
             CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`post` (
                 `id` integer PRIMARY KEY AUTOINCREMENT,
                 `title` varchar(60) NOT NULL,
@@ -27,1282 +27,1282 @@ 
                 `body` text,
                 `display` integer(1) NOT NULL
             )"
-        );
-        $extendedPdo->exec("
+		);
+		$extendedPdo->exec("
             CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`ptlink` (
                 `post_id` integer NOT NULL,
                 `tag_id` integer NOT NULL
             )"
-        );
-        $extendedPdo->exec("
+		);
+		$extendedPdo->exec("
             CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`series_post` (
                 `series` integer NOT NULL,
                 `post` integer NOT NULL,
                 `order` integer(1) NOT NULL
             )"
-        );
-        $extendedPdo->exec("
+		);
+		$extendedPdo->exec("
             CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`tag` (
                 `id` integer PRIMARY KEY AUTOINCREMENT,
                 `tag` varchar(25) NOT NULL
             )"
-        );
-
-        self::$connection = new ConnectionLocator(function () use ($extendedPdo) {
-            return $extendedPdo;
-        });
-    }
-
-    public function testIsInstanceOfPostRepository()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-
-        $this->assertInstanceOf(
-            'Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository',
-            $repository
-        );
-    }
-
-    public function testImplementsPostInterface()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-
-        $this->assertInstanceOf(
-            'Jacobemerick\Web\Domain\Blog\Post\PostRepositoryInterface',
-            $repository
-        );
-    }
-
-    public function testConstructSetsConnections()
-    {
-        $respository = new MysqlPostRepository(self::$connection);
-
-        $this->assertAttributeSame(
-            self::$connection,
-            'connections',
-            $respository
-        );
-    }
-
-    public function testFindPostByPath()
-    {
-        $testData = [
-            'id'       => rand(1, 100),
-            'title'    => 'test title',
-            'path'     => 'test-path',
-            'category' => 'test category',
-            'date'     => (new DateTime())->format('Y-m-d H:i:s'),
-            'body'     => 'test body',
-            'display'  => 1
-        ];
-
-        $this->insertPostData($testData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->findPostByPath($testData['path']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-        $this->assertArrayHasKey('id', $data);
-        $this->assertEquals($testData['id'], $data['id']);
-        $this->assertArrayHasKey('title', $data);
-        $this->assertEquals($testData['title'], $data['title']);
-        $this->assertArrayHasKey('path', $data);
-        $this->assertEquals($testData['path'], $data['path']);
-        $this->assertArrayHasKey('date', $data);
-        $this->assertEquals($testData['date'], $data['date']);
-        $this->assertArrayHasKey('body', $data);
-        $this->assertEquals($testData['body'], $data['body']);
-        $this->assertArrayHasKey('category', $data);
-        $this->assertEquals($testData['category'], $data['category']);
-    }
-
-    public function testFindPostByPathInactive()
-    {
-        $testData = [
-            'id'       => rand(1, 100),
-            'path'     => 'test-path',
-            'display'  => 0
-        ];
-
-        $this->insertPostData($testData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->findPostByPath($testData['path']);
-
-        $this->assertFalse($data);
-    }
-
-    public function testFindPostByPathFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->findPostByPath('');
-
-        $this->assertFalse($data);
-    }
-
-    public function testGetActivePosts()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'title'    => 'title one',
-                'path'     => 'path-one',
-                'category' => 'test category',
-                'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'title'    => 'title two',
-                'path'     => 'path-two',
-                'category' => 'test category',
-                'date'     => (new DateTime())->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePosts();
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-        $this->assertCount(count($testData), $data);
-
-        usort($testData, function ($rowA, $rowB) {
-            return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
-        });
-
-        foreach ($testData as $key => $testRow) {
-            $this->assertArrayHasKey('id', $data[$key]);
-            $this->assertEquals($testRow['id'], $data[$key]['id']);
-            $this->assertArrayHasKey('title', $data[$key]);
-            $this->assertEquals($testRow['title'], $data[$key]['title']);
-            $this->assertArrayHasKey('path', $data[$key]);
-            $this->assertEquals($testRow['path'], $data[$key]['path']);
-            $this->assertArrayHasKey('date', $data[$key]);
-            $this->assertEquals($testRow['date'], $data[$key]['date']);
-            $this->assertArrayHasKey('body', $data[$key]);
-            $this->assertEquals($testRow['body'], $data[$key]['body']);
-            $this->assertArrayHasKey('category', $data[$key]);
-            $this->assertEquals($testRow['category'], $data[$key]['category']);
-        }
-    }
+		);
+
+		self::$connection = new ConnectionLocator(function () use ($extendedPdo) {
+			return $extendedPdo;
+		});
+	}
+
+	public function testIsInstanceOfPostRepository()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+
+		$this->assertInstanceOf(
+			'Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository',
+			$repository
+		);
+	}
+
+	public function testImplementsPostInterface()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+
+		$this->assertInstanceOf(
+			'Jacobemerick\Web\Domain\Blog\Post\PostRepositoryInterface',
+			$repository
+		);
+	}
+
+	public function testConstructSetsConnections()
+	{
+		$respository = new MysqlPostRepository(self::$connection);
+
+		$this->assertAttributeSame(
+			self::$connection,
+			'connections',
+			$respository
+		);
+	}
+
+	public function testFindPostByPath()
+	{
+		$testData = [
+			'id'       => rand(1, 100),
+			'title'    => 'test title',
+			'path'     => 'test-path',
+			'category' => 'test category',
+			'date'     => (new DateTime())->format('Y-m-d H:i:s'),
+			'body'     => 'test body',
+			'display'  => 1
+		];
+
+		$this->insertPostData($testData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->findPostByPath($testData['path']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+		$this->assertArrayHasKey('id', $data);
+		$this->assertEquals($testData['id'], $data['id']);
+		$this->assertArrayHasKey('title', $data);
+		$this->assertEquals($testData['title'], $data['title']);
+		$this->assertArrayHasKey('path', $data);
+		$this->assertEquals($testData['path'], $data['path']);
+		$this->assertArrayHasKey('date', $data);
+		$this->assertEquals($testData['date'], $data['date']);
+		$this->assertArrayHasKey('body', $data);
+		$this->assertEquals($testData['body'], $data['body']);
+		$this->assertArrayHasKey('category', $data);
+		$this->assertEquals($testData['category'], $data['category']);
+	}
+
+	public function testFindPostByPathInactive()
+	{
+		$testData = [
+			'id'       => rand(1, 100),
+			'path'     => 'test-path',
+			'display'  => 0
+		];
+
+		$this->insertPostData($testData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->findPostByPath($testData['path']);
+
+		$this->assertFalse($data);
+	}
+
+	public function testFindPostByPathFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->findPostByPath('');
+
+		$this->assertFalse($data);
+	}
+
+	public function testGetActivePosts()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'title'    => 'title one',
+				'path'     => 'path-one',
+				'category' => 'test category',
+				'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'title'    => 'title two',
+				'path'     => 'path-two',
+				'category' => 'test category',
+				'date'     => (new DateTime())->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePosts();
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+		$this->assertCount(count($testData), $data);
+
+		usort($testData, function ($rowA, $rowB) {
+			return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
+		});
+
+		foreach ($testData as $key => $testRow) {
+			$this->assertArrayHasKey('id', $data[$key]);
+			$this->assertEquals($testRow['id'], $data[$key]['id']);
+			$this->assertArrayHasKey('title', $data[$key]);
+			$this->assertEquals($testRow['title'], $data[$key]['title']);
+			$this->assertArrayHasKey('path', $data[$key]);
+			$this->assertEquals($testRow['path'], $data[$key]['path']);
+			$this->assertArrayHasKey('date', $data[$key]);
+			$this->assertEquals($testRow['date'], $data[$key]['date']);
+			$this->assertArrayHasKey('body', $data[$key]);
+			$this->assertEquals($testRow['body'], $data[$key]['body']);
+			$this->assertArrayHasKey('category', $data[$key]);
+			$this->assertEquals($testRow['category'], $data[$key]['category']);
+		}
+	}
  
-    public function testGetActivePostsInactive()
-    {
-        $testData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 0,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePosts();
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testData = array_filter($testData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertCount(count($testData), $data);
-
-        $testIds = array_column($testData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
+	public function testGetActivePostsInactive()
+	{
+		$testData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 0,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePosts();
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testData = array_filter($testData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertCount(count($testData), $data);
+
+		$testIds = array_column($testData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
  
-    public function testGetActivePostsFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePosts();
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsRange()
-    {
-        $testData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePosts(2, 1);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-        $this->assertCount(2, $data);
-
-        $testData = array_slice($testData, 2, 1);
-
-        $testIds = array_column($testData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
-
-    public function testGetActivePostsRangeFailure()
-    {
-        $testData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePosts(1, 3);
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsCount()
-    {
-        $testData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCount();
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals(count($testData), $data);
-    }
-
-    public function testGetActivePostsCountInactive()
-    {
-        $testData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 0,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCount();
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-
-        $testData = array_filter($testData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertEquals(count($testData), $data);
-    }
-
-    public function testGetActivePostsCountFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCount();
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals('0', $data);
-    }
-
-    public function testGetActivePostsByTag()
-    {
-        $testPostData = [
-            [
-                'id'       => rand(1, 100),
-                'title'    => 'title one',
-                'path'     => 'path-one',
-                'category' => 'test category',
-                'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'title'    => 'title two',
-                'path'     => 'path-two',
-                'category' => 'test category',
-                'date'     => (new DateTime())->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByTag($testTagData['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-        $this->assertCount(count($testPostData), $data);
-
-        usort($testPostData, function ($rowA, $rowB) {
-            return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
-        });
-
-        foreach ($testPostData as $key => $testPostRow) {
-            $this->assertArrayHasKey('id', $data[$key]);
-            $this->assertEquals($testPostRow['id'], $data[$key]['id']);
-            $this->assertArrayHasKey('title', $data[$key]);
-            $this->assertEquals($testPostRow['title'], $data[$key]['title']);
-            $this->assertArrayHasKey('path', $data[$key]);
-            $this->assertEquals($testPostRow['path'], $data[$key]['path']);
-            $this->assertArrayHasKey('date', $data[$key]);
-            $this->assertEquals($testPostRow['date'], $data[$key]['date']);
-            $this->assertArrayHasKey('body', $data[$key]);
-            $this->assertEquals($testPostRow['body'], $data[$key]['body']);
-            $this->assertArrayHasKey('category', $data[$key]);
-            $this->assertEquals($testPostRow['category'], $data[$key]['category']);
-        }
-    }
-
-    public function testGetActivePostsByTagInactive()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 0,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByTag($testTagData['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testPostData = array_filter($testPostData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertCount(count($testPostData), $data);
-
-        $testIds = array_column($testPostData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
+	public function testGetActivePostsFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePosts();
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsRange()
+	{
+		$testData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePosts(2, 1);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+		$this->assertCount(2, $data);
+
+		$testData = array_slice($testData, 2, 1);
+
+		$testIds = array_column($testData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
+
+	public function testGetActivePostsRangeFailure()
+	{
+		$testData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePosts(1, 3);
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsCount()
+	{
+		$testData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCount();
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals(count($testData), $data);
+	}
+
+	public function testGetActivePostsCountInactive()
+	{
+		$testData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 0,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCount();
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+
+		$testData = array_filter($testData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertEquals(count($testData), $data);
+	}
+
+	public function testGetActivePostsCountFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCount();
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals('0', $data);
+	}
+
+	public function testGetActivePostsByTag()
+	{
+		$testPostData = [
+			[
+				'id'       => rand(1, 100),
+				'title'    => 'title one',
+				'path'     => 'path-one',
+				'category' => 'test category',
+				'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'title'    => 'title two',
+				'path'     => 'path-two',
+				'category' => 'test category',
+				'date'     => (new DateTime())->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByTag($testTagData['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+		$this->assertCount(count($testPostData), $data);
+
+		usort($testPostData, function ($rowA, $rowB) {
+			return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
+		});
+
+		foreach ($testPostData as $key => $testPostRow) {
+			$this->assertArrayHasKey('id', $data[$key]);
+			$this->assertEquals($testPostRow['id'], $data[$key]['id']);
+			$this->assertArrayHasKey('title', $data[$key]);
+			$this->assertEquals($testPostRow['title'], $data[$key]['title']);
+			$this->assertArrayHasKey('path', $data[$key]);
+			$this->assertEquals($testPostRow['path'], $data[$key]['path']);
+			$this->assertArrayHasKey('date', $data[$key]);
+			$this->assertEquals($testPostRow['date'], $data[$key]['date']);
+			$this->assertArrayHasKey('body', $data[$key]);
+			$this->assertEquals($testPostRow['body'], $data[$key]['body']);
+			$this->assertArrayHasKey('category', $data[$key]);
+			$this->assertEquals($testPostRow['category'], $data[$key]['category']);
+		}
+	}
+
+	public function testGetActivePostsByTagInactive()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 0,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByTag($testTagData['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testPostData = array_filter($testPostData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertCount(count($testPostData), $data);
+
+		$testIds = array_column($testPostData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
  
-    public function testGetActivePostsByTagFailure()
-    {
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByTag($testTagData['id']);
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsByTagRange()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByTag($testTagData['id'], 2, 1);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testPostData = array_slice($testPostData, 1, 2);
-
-        $this->assertCount(count($testPostData), $data);
-
-        $testIds = array_column($testPostData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
-
-    public function testGetActivePostsByTagRangeFailure()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByTag($testTagData['id'], 1, 3);
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsCountByTag()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByTag($testTagData['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals(count($testPostData), $data);
-    }
-
-    public function testGetActivePostsCountByTagInactive()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 0,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByTag($testTagData['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-
-        $testPostData = array_filter($testPostData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertEquals(count($testPostData), $data);
-    }
+	public function testGetActivePostsByTagFailure()
+	{
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByTag($testTagData['id']);
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsByTagRange()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByTag($testTagData['id'], 2, 1);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testPostData = array_slice($testPostData, 1, 2);
+
+		$this->assertCount(count($testPostData), $data);
+
+		$testIds = array_column($testPostData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
+
+	public function testGetActivePostsByTagRangeFailure()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByTag($testTagData['id'], 1, 3);
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsCountByTag()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByTag($testTagData['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals(count($testPostData), $data);
+	}
+
+	public function testGetActivePostsCountByTagInactive()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 0,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByTag($testTagData['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+
+		$testPostData = array_filter($testPostData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertEquals(count($testPostData), $data);
+	}
  
-    public function testGetActivePostsCountByTagFailure()
-    {
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
+	public function testGetActivePostsCountByTagFailure()
+	{
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
 
-        $this->insertTagData($testTagData);
+		$this->insertTagData($testTagData);
 
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByTag($testTagData['id']);
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByTag($testTagData['id']);
 
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals('0', $data);
-    }
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals('0', $data);
+	}
  
-    public function testGetActivePostsByCategory()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'title'    => 'title one',
-                'path'     => 'path-one',
-                'category' => 'test category',
-                'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'title'    => 'title two',
-                'path'     => 'path-two',
-                'category' => 'test category',
-                'date'     => (new DateTime())->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByCategory(reset($testData)['category']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-        $this->assertCount(count($testData), $data);
-
-        usort($testData, function ($rowA, $rowB) {
-            return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
-        });
-
-        foreach ($testData as $key => $testDataRow) {
-            $this->assertArrayHasKey('id', $data[$key]);
-            $this->assertEquals($testDataRow['id'], $data[$key]['id']);
-            $this->assertArrayHasKey('title', $data[$key]);
-            $this->assertEquals($testDataRow['title'], $data[$key]['title']);
-            $this->assertArrayHasKey('path', $data[$key]);
-            $this->assertEquals($testDataRow['path'], $data[$key]['path']);
-            $this->assertArrayHasKey('date', $data[$key]);
-            $this->assertEquals($testDataRow['date'], $data[$key]['date']);
-            $this->assertArrayHasKey('body', $data[$key]);
-            $this->assertEquals($testDataRow['body'], $data[$key]['body']);
-            $this->assertArrayHasKey('category', $data[$key]);
-            $this->assertEquals($testDataRow['category'], $data[$key]['category']);
-        }
-    }
-
-    public function testGetActivePostsByCategoryInactive()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'category' => 'test category',
-                'display'  => 0,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByCategory(reset($testData)['category']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testData = array_filter($testData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertCount(count($testData), $data);
-
-        $testIds = array_column($testData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
+	public function testGetActivePostsByCategory()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'title'    => 'title one',
+				'path'     => 'path-one',
+				'category' => 'test category',
+				'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'title'    => 'title two',
+				'path'     => 'path-two',
+				'category' => 'test category',
+				'date'     => (new DateTime())->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByCategory(reset($testData)['category']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+		$this->assertCount(count($testData), $data);
+
+		usort($testData, function ($rowA, $rowB) {
+			return ((new DateTime($rowA['date'])) < (new DateTime($rowB['date'])));
+		});
+
+		foreach ($testData as $key => $testDataRow) {
+			$this->assertArrayHasKey('id', $data[$key]);
+			$this->assertEquals($testDataRow['id'], $data[$key]['id']);
+			$this->assertArrayHasKey('title', $data[$key]);
+			$this->assertEquals($testDataRow['title'], $data[$key]['title']);
+			$this->assertArrayHasKey('path', $data[$key]);
+			$this->assertEquals($testDataRow['path'], $data[$key]['path']);
+			$this->assertArrayHasKey('date', $data[$key]);
+			$this->assertEquals($testDataRow['date'], $data[$key]['date']);
+			$this->assertArrayHasKey('body', $data[$key]);
+			$this->assertEquals($testDataRow['body'], $data[$key]['body']);
+			$this->assertArrayHasKey('category', $data[$key]);
+			$this->assertEquals($testDataRow['category'], $data[$key]['category']);
+		}
+	}
+
+	public function testGetActivePostsByCategoryInactive()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'category' => 'test category',
+				'display'  => 0,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByCategory(reset($testData)['category']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testData = array_filter($testData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertCount(count($testData), $data);
+
+		$testIds = array_column($testData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
  
-    public function testGetActivePostsByCategoryFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByCategory('');
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsByCategoryRange()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByCategory(reset($testData)['category'], 2, 1);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testData = array_slice($testData, 1, 2);
-
-        $this->assertCount(count($testData), $data);
-
-        $testIds = array_column($testData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
-
-    public function testGetActivePostsByCategoryRangeFailure()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByCategory(reset($testData)['category'], 1, 3);
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    public function testGetActivePostsCountByCategory()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByCategory(reset($testData)['category']);
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals(count($testData), $data);
-    }
-
-    public function testGetActivePostsCountByCategoryInactive()
-    {
-        $testData = [
-            [
-                'id'       => rand(1, 100),
-                'category' => 'test category',
-                'display'  => 0,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'category' => 'test category',
-                'display'  => 1,
-            ],
-        ];
-
-        array_walk($testData, [$this, 'insertPostData']);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByCategory(reset($testData)['category']);
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-
-        $testData = array_filter($testData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertEquals(count($testData), $data);
-    }
-
-    public function testGetActivePostsCountByCategoryFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsCountByCategory('');
-
-        $this->assertNotFalse($data);
-        $this->assertStringMatchesFormat('%d', $data);
-        $this->assertEquals('0', $data);
-    }
-
-    public function testGetActivePostsByRelatedTags()
-    {
-        $testPostData = [
-            [
-                'id'       => rand(1, 100),
-                'title'    => 'title one',
-                'path'     => 'path-one',
-                'category' => 'test category',
-                'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
-                'body'     => 'body one',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(101, 200),
-                'title'    => 'title two',
-                'path'     => 'path-two',
-                'category' => 'test category',
-                'date'     => (new DateTime('-2 days'))->format('Y-m-d H:i:s'),
-                'body'     => 'body two',
-                'display'  => 1,
-            ],
-            [
-                'id'       => rand(201, 300),
-                'title'    => 'title three',
-                'path'     => 'path-three',
-                'category' => 'test category',
-                'date'     => (new DateTime('-3 days'))->format('Y-m-d H:i:s'),
-                'body'     => 'body three',
-                'display'  => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        array_shift($testPostData);
-
-        $this->assertCount(count($testPostData), $data);
-        foreach ($testPostData as $key => $testPostRow) {
-            $this->assertArrayHasKey('id', $data[$key]);
-            $this->assertEquals($testPostRow['id'], $data[$key]['id']);
-            $this->assertArrayHasKey('title', $data[$key]);
-            $this->assertEquals($testPostRow['title'], $data[$key]['title']);
-            $this->assertArrayHasKey('path', $data[$key]);
-            $this->assertEquals($testPostRow['path'], $data[$key]['path']);
-            $this->assertArrayHasKey('date', $data[$key]);
-            $this->assertEquals($testPostRow['date'], $data[$key]['date']);
-            $this->assertArrayHasKey('body', $data[$key]);
-            $this->assertEquals($testPostRow['body'], $data[$key]['body']);
-            $this->assertArrayHasKey('category', $data[$key]);
-            $this->assertEquals($testPostRow['category'], $data[$key]['category']);
-            $this->assertArrayHasKey('count', $data[$key]);
-            $this->assertEquals(count($testTagData), $data[$key]['count']);
-        }
-    }
-
-    public function testGetActivePostsByRelatedTagsLimit()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id'], 1);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        $testPostData = array_slice($testPostData, 1, 1);
-
-        $this->assertCount(count($testPostData), $data);
-
-        $testIds = array_column($testPostData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
+	public function testGetActivePostsByCategoryFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByCategory('');
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsByCategoryRange()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByCategory(reset($testData)['category'], 2, 1);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testData = array_slice($testData, 1, 2);
+
+		$this->assertCount(count($testData), $data);
+
+		$testIds = array_column($testData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
+
+	public function testGetActivePostsByCategoryRangeFailure()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByCategory(reset($testData)['category'], 1, 3);
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	public function testGetActivePostsCountByCategory()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByCategory(reset($testData)['category']);
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals(count($testData), $data);
+	}
+
+	public function testGetActivePostsCountByCategoryInactive()
+	{
+		$testData = [
+			[
+				'id'       => rand(1, 100),
+				'category' => 'test category',
+				'display'  => 0,
+			],
+			[
+				'id'       => rand(101, 200),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'category' => 'test category',
+				'display'  => 1,
+			],
+		];
+
+		array_walk($testData, [$this, 'insertPostData']);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByCategory(reset($testData)['category']);
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+
+		$testData = array_filter($testData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertEquals(count($testData), $data);
+	}
+
+	public function testGetActivePostsCountByCategoryFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsCountByCategory('');
+
+		$this->assertNotFalse($data);
+		$this->assertStringMatchesFormat('%d', $data);
+		$this->assertEquals('0', $data);
+	}
+
+	public function testGetActivePostsByRelatedTags()
+	{
+		$testPostData = [
+			[
+				'id'       => rand(1, 100),
+				'title'    => 'title one',
+				'path'     => 'path-one',
+				'category' => 'test category',
+				'date'     => (new DateTime('-1 day'))->format('Y-m-d H:i:s'),
+				'body'     => 'body one',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(101, 200),
+				'title'    => 'title two',
+				'path'     => 'path-two',
+				'category' => 'test category',
+				'date'     => (new DateTime('-2 days'))->format('Y-m-d H:i:s'),
+				'body'     => 'body two',
+				'display'  => 1,
+			],
+			[
+				'id'       => rand(201, 300),
+				'title'    => 'title three',
+				'path'     => 'path-three',
+				'category' => 'test category',
+				'date'     => (new DateTime('-3 days'))->format('Y-m-d H:i:s'),
+				'body'     => 'body three',
+				'display'  => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		array_shift($testPostData);
+
+		$this->assertCount(count($testPostData), $data);
+		foreach ($testPostData as $key => $testPostRow) {
+			$this->assertArrayHasKey('id', $data[$key]);
+			$this->assertEquals($testPostRow['id'], $data[$key]['id']);
+			$this->assertArrayHasKey('title', $data[$key]);
+			$this->assertEquals($testPostRow['title'], $data[$key]['title']);
+			$this->assertArrayHasKey('path', $data[$key]);
+			$this->assertEquals($testPostRow['path'], $data[$key]['path']);
+			$this->assertArrayHasKey('date', $data[$key]);
+			$this->assertEquals($testPostRow['date'], $data[$key]['date']);
+			$this->assertArrayHasKey('body', $data[$key]);
+			$this->assertEquals($testPostRow['body'], $data[$key]['body']);
+			$this->assertArrayHasKey('category', $data[$key]);
+			$this->assertEquals($testPostRow['category'], $data[$key]['category']);
+			$this->assertArrayHasKey('count', $data[$key]);
+			$this->assertEquals(count($testTagData), $data[$key]['count']);
+		}
+	}
+
+	public function testGetActivePostsByRelatedTagsLimit()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id'], 1);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		$testPostData = array_slice($testPostData, 1, 1);
+
+		$this->assertCount(count($testPostData), $data);
+
+		$testIds = array_column($testPostData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
  
-    public function testGetActivePostsByRelatedTagsInactive()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 0,
-            ],
-            [
-                'id'      => rand(301, 400),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        array_shift($testPostData);
-        $testPostData = array_filter($testPostData, function ($row) {
-            return ($row['display'] == 1);
-        });
-
-        $this->assertCount(count($testPostData), $data);
-
-        $testIds = array_column($testPostData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
+	public function testGetActivePostsByRelatedTagsInactive()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 0,
+			],
+			[
+				'id'      => rand(301, 400),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		array_shift($testPostData);
+		$testPostData = array_filter($testPostData, function ($row) {
+			return ($row['display'] == 1);
+		});
+
+		$this->assertCount(count($testPostData), $data);
+
+		$testIds = array_column($testPostData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
  
-    public function testGetActivePostsByRelatedTagsExcludeSeries()
-    {
-        $testPostData = [
-            [
-                'id'      => rand(1, 100),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(101, 200),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(201, 300),
-                'display' => 1,
-            ],
-            [
-                'id'      => rand(301, 400),
-                'display' => 1,
-            ],
-        ];
-
-        $testTagData = [
-            'id' => rand(1, 100),
-        ];
-
-        $testPTLinkData = [];
-        foreach ($testPostData as $testPostRow) {
-            array_push($testPTLinkData, [
-                'post_id' => $testPostRow['id'],
-                'tag_id' => $testTagData['id'],
-            ]);
-        }
-
-        $seriesPostKey = rand(1, 3);
-        $testSeriesPostData = [
-            [
-                'series' => 1,
-                'post' => reset($testPostData)['id'],
-            ],
-            [
-                'series' => 1,
-                'post' => $testPostData[$seriesPostKey]['id'],
-            ],
-        ];
-
-        array_walk($testPostData, [$this, 'insertPostData']);
-        array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
-        array_walk($testSeriesPostData, [$this, 'insertSeriesPostData']);
-        $this->insertTagData($testTagData);
-
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
-
-        $this->assertNotFalse($data);
-        $this->assertInternalType('array', $data);
-
-        array_shift($testPostData);
-        $testPostData = array_filter($testPostData, function ($row) use ($testSeriesPostData) {
-            return (!in_array($row['id'], array_column($testSeriesPostData, 'post')));
-        });
-
-        $this->assertCount(count($testPostData), $data);
-
-        $testIds = array_column($testPostData, 'ids');
-        $dataIds = array_column($data, 'ids');
-
-        $this->assertEmpty(array_merge(
-            array_diff($testIds, $dataIds),
-            array_diff($dataIds, $testIds)
-        ));
-    }
-
-    public function testGetActivePostsByRelatedTagsFailure()
-    {
-        $repository = new MysqlPostRepository(self::$connection);
-        $data = $repository->getActivePostsByRelatedTags('');
-
-        $this->assertEmpty($data);
-        $this->assertInternalType('array', $data);
-    }
-
-    protected function insertPostData(array $data)
-    {
-        $defaultData = [
-            'id' => null,
-            'title' => '',
-            'path' => '',
-            'category' => '',
-            'date' => '',
-            'body' => '',
-            'display' => 0,
-        ];
-
-        $data = array_merge($defaultData, $data);
-
-        return self::$connection->getDefault()->perform("
+	public function testGetActivePostsByRelatedTagsExcludeSeries()
+	{
+		$testPostData = [
+			[
+				'id'      => rand(1, 100),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(101, 200),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(201, 300),
+				'display' => 1,
+			],
+			[
+				'id'      => rand(301, 400),
+				'display' => 1,
+			],
+		];
+
+		$testTagData = [
+			'id' => rand(1, 100),
+		];
+
+		$testPTLinkData = [];
+		foreach ($testPostData as $testPostRow) {
+			array_push($testPTLinkData, [
+				'post_id' => $testPostRow['id'],
+				'tag_id' => $testTagData['id'],
+			]);
+		}
+
+		$seriesPostKey = rand(1, 3);
+		$testSeriesPostData = [
+			[
+				'series' => 1,
+				'post' => reset($testPostData)['id'],
+			],
+			[
+				'series' => 1,
+				'post' => $testPostData[$seriesPostKey]['id'],
+			],
+		];
+
+		array_walk($testPostData, [$this, 'insertPostData']);
+		array_walk($testPTLinkData, [$this, 'insertPTLinkData']);
+		array_walk($testSeriesPostData, [$this, 'insertSeriesPostData']);
+		$this->insertTagData($testTagData);
+
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByRelatedTags(reset($testPostData)['id']);
+
+		$this->assertNotFalse($data);
+		$this->assertInternalType('array', $data);
+
+		array_shift($testPostData);
+		$testPostData = array_filter($testPostData, function ($row) use ($testSeriesPostData) {
+			return (!in_array($row['id'], array_column($testSeriesPostData, 'post')));
+		});
+
+		$this->assertCount(count($testPostData), $data);
+
+		$testIds = array_column($testPostData, 'ids');
+		$dataIds = array_column($data, 'ids');
+
+		$this->assertEmpty(array_merge(
+			array_diff($testIds, $dataIds),
+			array_diff($dataIds, $testIds)
+		));
+	}
+
+	public function testGetActivePostsByRelatedTagsFailure()
+	{
+		$repository = new MysqlPostRepository(self::$connection);
+		$data = $repository->getActivePostsByRelatedTags('');
+
+		$this->assertEmpty($data);
+		$this->assertInternalType('array', $data);
+	}
+
+	protected function insertPostData(array $data)
+	{
+		$defaultData = [
+			'id' => null,
+			'title' => '',
+			'path' => '',
+			'category' => '',
+			'date' => '',
+			'body' => '',
+			'display' => 0,
+		];
+
+		$data = array_merge($defaultData, $data);
+
+		return self::$connection->getDefault()->perform("
             INSERT INTO `jpemeric_blog`.`post`
                 (id, title, path, category, date, body, display)
             VALUES
                 (:id, :title, :path, :category, :date, :body, :display)",
-            $data
-        );
-    }
+			$data
+		);
+	}
 
-    protected function insertPTLinkData(array $data)
-    {
-        $defaultData = [
-            'post' => null,
-            'tag' => null,
-        ];
+	protected function insertPTLinkData(array $data)
+	{
+		$defaultData = [
+			'post' => null,
+			'tag' => null,
+		];
 
-        $data = array_merge($defaultData, $data);
+		$data = array_merge($defaultData, $data);
 
-        return self::$connection->getDefault()->perform("
+		return self::$connection->getDefault()->perform("
             INSERT INTO `jpemeric_blog`.`ptlink`
                 (post_id, tag_id)
             VALUES
                 (:post_id, :tag_id)",
-            $data
-        );
-    }
+			$data
+		);
+	}
 
-    protected function insertSeriesPostData(array $data)
-    {
-        $defaultData = [
-            'series' => '',
-            'post' => '',
-            'order' => 0,
-        ];
+	protected function insertSeriesPostData(array $data)
+	{
+		$defaultData = [
+			'series' => '',
+			'post' => '',
+			'order' => 0,
+		];
 
-        $data = array_merge($defaultData, $data);
+		$data = array_merge($defaultData, $data);
 
-        return self::$connection->getDefault()->perform("
+		return self::$connection->getDefault()->perform("
             INSERT INTO `jpemeric_blog`.`series_post`
                 (series, post, `order`)
             VALUES
                 (:series, :post, :order)",
-            $data
-        );
-    }
+			$data
+		);
+	}
 
-    protected function insertTagData(array $data)
-    {
-        $defaultData = [
-            'id' => null,
-            'tag' => '',
-        ];
+	protected function insertTagData(array $data)
+	{
+		$defaultData = [
+			'id' => null,
+			'tag' => '',
+		];
 
-        $data = array_merge($defaultData, $data);
+		$data = array_merge($defaultData, $data);
 
-        return self::$connection->getDefault()->perform("
+		return self::$connection->getDefault()->perform("
             INSERT INTO `jpemeric_blog`.`tag`
                 (id, tag)
             VALUES
                 (:id, :tag)",
-            $data
-        );
-    }
-
-    protected function tearDown()
-    {
-        self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`post`");
-        self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`ptlink`");
-        self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`series_post`");
-        self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`tag`");
-    }
-
-    public static function tearDownAfterClass()
-    {
-        self::$connection->getDefault()->disconnect();
-        unlink('jpemeric_blog.db');
-    }
+			$data
+		);
+	}
+
+	protected function tearDown()
+	{
+		self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`post`");
+		self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`ptlink`");
+		self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`series_post`");
+		self::$connection->getDefault()->perform("DELETE FROM `jpemeric_blog`.`tag`");
+	}
+
+	public static function tearDownAfterClass()
+	{
+		self::$connection->getDefault()->disconnect();
+		unlink('jpemeric_blog.db');
+	}
 }

controller/portfolio/DefaultPageController.class.inc.php

Indentation +52 added lines, -52 removed lines

@@ -5,56 +5,56 @@
 abstract class DefaultPageController extends PageController
 {
 
-    public function __construct()
-    {
-        parent::__construct();
-
-        $this->add_css('reset');
-        $this->add_css('portfolio', 4);
-    }
-
-    protected function set_body_data()
-    {
-        $this->set_body('header_data', [
-            'menu' => $this->get_menu(),
-            'home_link' => Loader::getRootURL(),
-        ]);
-        $this->set_body('activity_array', $this->get_recent_activity());
-
-        $this->set_body_view('Page');
-    }
-
-    protected function get_menu()
-    {
-        $menu = [
-            [
-                'name' => 'About',
-                'link' => Loader::getRootURL(),
-            ],
-            [
-                'name' => 'Projects',
-                'link' => Loader::getRootURL() . 'projects/',
-            ],
-            [
-                'name' => 'Résumé',
-                'link' => Loader::getRootURL() . 'resume/',
-            ],
-            [
-                'name' => 'Contact',
-                'link' => Loader::getRootURL() . 'contact/',
-            ],
-        ];
-
-        if (!URLDecode::getPiece(1)) {
-            $active_page = 'About';
-        } else {
-            $active_page = ucfirst(URLDecode::getPiece(1));
-        }
-
-        return array_map(function ($row) use ($active_page) {
-            $row = (object) $row;
-            $row->active = ($row->name == $active_page);
-            return $row;
-        }, $menu);
-    }
+	public function __construct()
+	{
+		parent::__construct();
+
+		$this->add_css('reset');
+		$this->add_css('portfolio', 4);
+	}
+
+	protected function set_body_data()
+	{
+		$this->set_body('header_data', [
+			'menu' => $this->get_menu(),
+			'home_link' => Loader::getRootURL(),
+		]);
+		$this->set_body('activity_array', $this->get_recent_activity());
+
+		$this->set_body_view('Page');
+	}
+
+	protected function get_menu()
+	{
+		$menu = [
+			[
+				'name' => 'About',
+				'link' => Loader::getRootURL(),
+			],
+			[
+				'name' => 'Projects',
+				'link' => Loader::getRootURL() . 'projects/',
+			],
+			[
+				'name' => 'Résumé',
+				'link' => Loader::getRootURL() . 'resume/',
+			],
+			[
+				'name' => 'Contact',
+				'link' => Loader::getRootURL() . 'contact/',
+			],
+		];
+
+		if (!URLDecode::getPiece(1)) {
+			$active_page = 'About';
+		} else {
+			$active_page = ucfirst(URLDecode::getPiece(1));
+		}
+
+		return array_map(function ($row) use ($active_page) {
+			$row = (object) $row;
+			$row->active = ($row->name == $active_page);
+			return $row;
+		}, $menu);
+	}
 }

controller/blog/PostController.class.inc.php

Indentation +31 added lines, -31 removed lines

@@ -23,9 +23,9 @@ 
 	{
 		parent::__construct();
 		
-        global $container;
-        $repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']);
-        $this->post = $repository->findPostByPath(URLDecode::getPiece(2));
+		global $container;
+		$repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']);
+		$this->post = $repository->findPostByPath(URLDecode::getPiece(2));
 
 		if($this->post == null)
 			$this->eject();
@@ -36,9 +36,9 @@ 
 			Loader::getRootUrl('blog') . $this->post['category'] . '/' . $this->post['path'] . '/',
 			$this->post['title']);
 
-        global $container;
-        $repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
-        $this->tags = $repository->getTagsForPost($this->post['id']);
+		global $container;
+		$repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
+		$this->tags = $repository->getTagsForPost($this->post['id']);
 	}
 
 	protected function set_head_data()
@@ -50,9 +50,9 @@ 
 		$this->set_keywords($this->get_post_keywords());
 		$this->set_author(self::$AUTHOR);
 
-    $photo = Content::instance('FetchFirstPhoto', $this->post['body'])->activate(true);
-    $photo = preg_match('/^<img src="([a-z-:\.\/]+)" [^>]+>$/', $photo, $matches);
-    $this->set_head('thumbnail', $matches[1]);
+	$photo = Content::instance('FetchFirstPhoto', $this->post['body'])->activate(true);
+	$photo = preg_match('/^<img src="([a-z-:\.\/]+)" [^>]+>$/', $photo, $matches);
+	$this->set_head('thumbnail', $matches[1]);
 
 		if (array_key_exists($this->post['id'], self::$DEPRECATED_BLOGS)) {
 			$log_id = self::$DEPRECATED_BLOGS[$this->post['id']];
@@ -126,18 +126,18 @@ 
 			
 			$post = new stdclass();
 
-      if (
-        strpos($post_row['title'], 'Rainy Supe Loop') === 0 ||
-        strpos($post_row['title'], 'Malapais Loop') === 0 ||
-        strpos($post_row['title'], 'Mazatzal Peak Loop') === 0 ||
-        strpos($post_row['title'], 'Dripping Springs Loop') === 0
-      ) {
-        $title = $post_row['title'];
-        $title = explode(':', $title);
-        $title = array_pop($title);
-        $title = trim($title);
-        $post->title = $title;
-      } else if (strpos($post_row['title'], 'Isle Royale') === 0) {
+	  if (
+		strpos($post_row['title'], 'Rainy Supe Loop') === 0 ||
+		strpos($post_row['title'], 'Malapais Loop') === 0 ||
+		strpos($post_row['title'], 'Mazatzal Peak Loop') === 0 ||
+		strpos($post_row['title'], 'Dripping Springs Loop') === 0
+	  ) {
+		$title = $post_row['title'];
+		$title = explode(':', $title);
+		$title = array_pop($title);
+		$title = trim($title);
+		$post->title = $title;
+	  } else if (strpos($post_row['title'], 'Isle Royale') === 0) {
 				$title = $post_row['title'];
 				$title = explode(',', $title);
 				$title = array_pop($title);
@@ -168,12 +168,12 @@ 
 	private $series_posts;
 	private function fetch_series_posts()
 	{
-      if(!isset($this->series_posts)) {
-          global $container;
-          $repository = new Jacobemerick\Web\Domain\Blog\Series\MysqlSeriesRepository($container['db_connection_locator']);
-          $this->series_posts = $repository->getSeriesForPost($this->post['id']);
-      }
-      return $this->series_posts;
+	  if(!isset($this->series_posts)) {
+		  global $container;
+		  $repository = new Jacobemerick\Web\Domain\Blog\Series\MysqlSeriesRepository($container['db_connection_locator']);
+		  $this->series_posts = $repository->getSeriesForPost($this->post['id']);
+	  }
+	  return $this->series_posts;
 	}
 
 	private function get_related_posts()
@@ -191,11 +191,11 @@ 
 			$exclude_post_array[] = $series_post['post'];
 		}
 
-        global $container;
-        $repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']);
-        $post_result = $repository->getActivePostsByRelatedTags($this->post['id']);
+		global $container;
+		$repository = new Jacobemerick\Web\Domain\Blog\Post\MysqlPostRepository($container['db_connection_locator']);
+		$post_result = $repository->getActivePostsByRelatedTags($this->post['id']);
 
-        $post_array = array();
+		$post_array = array();
 		
 		foreach($post_result as $post_row)
 		{

module/form/CommentSubmitModule.class.inc.php

Indentation +53 added lines, -53 removed lines

@@ -42,7 +42,7 @@ 
 		$comment_id = $this->save_comment();
 		
 		$comment_meta_id = $this->save_comment_meta($commenter_id, $comment_id, $page_id);
-    $comment_service_id = $this->save_to_comment_service(Request::getPost());
+	$comment_service_id = $this->save_to_comment_service(Request::getPost());
 		
 		$this->send_notifications($page_id);
 		$this->redirect_to_comment($comment_meta_id);
@@ -168,26 +168,26 @@ 
 			}
 		}
         
-        $site = URLDecode::getSite();
+		$site = URLDecode::getSite();
         
-        if ($site == 'blog') {
-            $subject = "New Comment on Jacob Emerick's Blog";
-            $message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to jacob@jacobemerick.com if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!";
-        } else if ($site == 'waterfalls') {
-            $subject = "New Comment on Waterfalls of the Keweenaw";
-            $message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to jacob@jacobemerick.com if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!";
-        }
+		if ($site == 'blog') {
+			$subject = "New Comment on Jacob Emerick's Blog";
+			$message = "Hello!\nThere has been a new comment on the post '{$this->page_title}' at Jacob Emerick's Blog. You have chosen to be notified of it - please reply to jacob@jacobemerick.com if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!";
+		} else if ($site == 'waterfalls') {
+			$subject = "New Comment on Waterfalls of the Keweenaw";
+			$message = "Hello!\nThere has been a new comment on the page '{$this->page_title}' at Waterfalls of the Keweenaw. You have chosen to be notified of it - please reply to jacob@jacobemerick.com if you would like to be removed from these notifications.\n\nOn " . date('F j, Y g:i a') . ", " . Request::getPost('name') . " commented...\n" . Request::getPost('comment') . "\n\nVisit {$this->full_path}#comments to see and reply to all the comments on this post.\nThank you!";
+		}
 
-    global $container;
+	global $container;
 
 		foreach($email_recipient_array as $email_recipient)
 		{
-      $sent = $container['mail']
-        ->addTo($email_recipient['email'], $email_recipient['name'])
-        ->addBCC($container['config']->admin_email)
-        ->setSubject($subject)
-        ->setPlainMessage($message)
-        ->send();		
+	  $sent = $container['mail']
+		->addTo($email_recipient['email'], $email_recipient['name'])
+		->addBCC($container['config']->admin_email)
+		->setSubject($subject)
+		->setPlainMessage($message)
+		->send();		
 		}
 	}
 
@@ -201,41 +201,41 @@ 
 		exit;
 	}
 
-    private function save_to_comment_service(array $data)
-    {
-        $path = $_SERVER['REQUEST_URI'];
-        $path = explode('/', $path);
-        $path = array_filter($path);
-        $path = array_slice($path, 0, 2);
-        $path = implode('/', $path);
-
-        $body = [
-            'commenter' => [
-                'name' => $data['name'],
-                'email' => $data['email'],
-                'website' => $data['website'],
-            ],
-            'body' => $data['comment'],
-            'should_notify' => (isset($data['notify']) && $data['notify'] == 'check'),
-            'domain' => (URLDecode::getSite() == 'blog' ? 'blog.jacobemerick.com' : 'waterfallsofthekeweenaw.com'),
-            'path' => $path,
-            'url' => $this->full_path,
-            'thread' => 'comments',
-            'ip_address' => $_SERVER['REMOTE_ADDR'],
-            'user_agent' => $_SERVER['HTTP_USER_AGENT'],
-            'referrer' => $_SERVER['HTTP_REFERER'],
-        ];
-
-        global $config;
-        $configuration = new Jacobemerick\CommentService\Configuration();
-        $configuration->setUsername($config->comments->user);
-        $configuration->setPassword($config->comments->password);
-        $configuration->addDefaultHeader('Content-Type', 'application/json');
-        $configuration->setHost($config->comments->host);
-        $configuration->setCurlTimeout($config->comments->timeout);
-
-        $client = new Jacobemerick\CommentService\ApiClient($configuration);
-        $api = new Jacobemerick\CommentService\Api\DefaultApi($client);
-        $response = $api->createComment($body);
-    }
+	private function save_to_comment_service(array $data)
+	{
+		$path = $_SERVER['REQUEST_URI'];
+		$path = explode('/', $path);
+		$path = array_filter($path);
+		$path = array_slice($path, 0, 2);
+		$path = implode('/', $path);
+
+		$body = [
+			'commenter' => [
+				'name' => $data['name'],
+				'email' => $data['email'],
+				'website' => $data['website'],
+			],
+			'body' => $data['comment'],
+			'should_notify' => (isset($data['notify']) && $data['notify'] == 'check'),
+			'domain' => (URLDecode::getSite() == 'blog' ? 'blog.jacobemerick.com' : 'waterfallsofthekeweenaw.com'),
+			'path' => $path,
+			'url' => $this->full_path,
+			'thread' => 'comments',
+			'ip_address' => $_SERVER['REMOTE_ADDR'],
+			'user_agent' => $_SERVER['HTTP_USER_AGENT'],
+			'referrer' => $_SERVER['HTTP_REFERER'],
+		];
+
+		global $config;
+		$configuration = new Jacobemerick\CommentService\Configuration();
+		$configuration->setUsername($config->comments->user);
+		$configuration->setPassword($config->comments->password);
+		$configuration->addDefaultHeader('Content-Type', 'application/json');
+		$configuration->setHost($config->comments->host);
+		$configuration->setCurlTimeout($config->comments->timeout);
+
+		$client = new Jacobemerick\CommentService\ApiClient($configuration);
+		$api = new Jacobemerick\CommentService\Api\DefaultApi($client);
+		$response = $api->createComment($body);
+	}
 }

bootstrap.php

Indentation +61 added lines, -61 removed lines

@@ -15,7 +15,7 @@ 
 
 $handle = @fopen($config_path, 'r');
 if ($handle === false) {
-    throw new RuntimeException("Could not load config");
+	throw new RuntimeException("Could not load config");
 }
 $config = fread($handle, filesize($config_path));
 fclose($handle);
@@ -23,71 +23,71 @@ 
 $config = json_decode($config);
 $last_json_error = json_last_error();
 if ($last_json_error !== JSON_ERROR_NONE) {
-    throw new RuntimeException("Could not parse config - JSON error detected");
+	throw new RuntimeException("Could not parse config - JSON error detected");
 }
 $container['config'] = $config;
 
 // timezones are fun
 date_default_timezone_set('America/Phoenix'); // todo - belongs in configuration
 $container['default_timezone'] = function ($c) {
-    return new DateTimeZone('America/Phoenix');
+	return new DateTimeZone('America/Phoenix');
 };
 
 
 // configure the db connections holder
 $db_connections = new Aura\Sql\ConnectionLocator();
 $db_connections->setDefault(function () use ($config) {
-    $connection = $config->database->slave;
-    return new Aura\Sql\ExtendedPdo(
-        "mysql:host={$connection->host}",
-        $connection->user,
-        $connection->password
-    );
+	$connection = $config->database->slave;
+	return new Aura\Sql\ExtendedPdo(
+		"mysql:host={$connection->host}",
+		$connection->user,
+		$connection->password
+	);
 });
 $db_connections->setWrite('master', function () use ($config) {
-    $connection = $config->database->master;
-    return new Aura\Sql\ExtendedPdo(
-        "mysql:host={$connection->host}",
-        $connection->user,
-        $connection->password
-    );
+	$connection = $config->database->master;
+	return new Aura\Sql\ExtendedPdo(
+		"mysql:host={$connection->host}",
+		$connection->user,
+		$connection->password
+	);
 });
 $db_connections->setRead('slave', function () use ($config) {
-    $connection = $config->database->slave;
-    $pdo = new Aura\Sql\ExtendedPdo(
-        "mysql:host={$connection->host}",
-        $connection->user,
-        $connection->password
-    );
-
-    $profiler = new Aura\Sql\Profiler();
-    $profiler->setActive(true);
-    $pdo->setProfiler($profiler);
-
-    return $pdo;
+	$connection = $config->database->slave;
+	$pdo = new Aura\Sql\ExtendedPdo(
+		"mysql:host={$connection->host}",
+		$connection->user,
+		$connection->password
+	);
+
+	$profiler = new Aura\Sql\Profiler();
+	$profiler->setActive(true);
+	$pdo->setProfiler($profiler);
+
+	return $pdo;
 });
 $container['db_connection_locator'] = $db_connections;
 
 
 // setup mail handler
 $container['mail'] = $container->factory(function ($c) {
-    return (new Jacobemerick\Archangel\Archangel())->setLogger($c['logger']);
+	return (new Jacobemerick\Archangel\Archangel())->setLogger($c['logger']);
 });
 
 
 // setup the logger
 $container['setup_logger'] = $container->protect(function ($name) use ($container) {
-    $logger = new Monolog\Logger($name);
+	$logger = new Monolog\Logger($name);
 
-    $logPath = __DIR__ . "/logs/{$name}.log";
-    $streamHandler = new Monolog\Handler\StreamHandler($logPath, Monolog\Logger::INFO);
-    $streamHandler->setFormatter(
-        new Monolog\Formatter\LineFormatter("[%datetime%] %channel%.%level_name%: %message%\n")
-    );
-    $logger->pushHandler($streamHandler);
+	$logPath = __DIR__ . "/logs/{$name}.log";
+	$streamHandler = new Monolog\Handler\StreamHandler($logPath, Monolog\Logger::INFO);
+	$streamHandler->setFormatter(
+		new Monolog\Formatter\LineFormatter("[%datetime%] %channel%.%level_name%: %message%\n")
+	);
+	$logger->pushHandler($streamHandler);
 
-    Monolog\ErrorHandler::register($logger);
-    $container['logger'] = $logger;
+	Monolog\ErrorHandler::register($logger);
+	$container['logger'] = $logger;
 });
 
 
@@ -108,30 +108,30 @@ 
 
 // sets up shutdown function to display profiler
 register_shutdown_function(function () use ($container) {
-    if (
-        !isset($_COOKIE['debugger']) ||
-        $_COOKIE['debugger'] != 'display'
-    ) {
-        return;
-    }
-
-    $dbProfiles = $container['db_connection_locator']
-        ->getRead()
-        ->getProfiler()
-        ->getProfiles();
-    $dbProfiles = array_filter($dbProfiles, function ($profile) {
-        return $profile['function'] == 'perform';
-    });
-    $dbProfiles = array_map(function ($profile) {
-        return [
-            'sql' => trim(preg_replace('/\s+/', ' ', $profile['statement'])),
-            'parameters' => $profile['bind_values'],
-            'time' => $profile['duration'],
-        ];
-    }, $dbProfiles);
-    $container['profiler']->setProfiledQueries($dbProfiles);
-    $container['profiler']->setDisplay(new Particletree\Pqp\Display());
-    $container['profiler']->display($container['db_connection_locator']->getRead());
+	if (
+		!isset($_COOKIE['debugger']) ||
+		$_COOKIE['debugger'] != 'display'
+	) {
+		return;
+	}
+
+	$dbProfiles = $container['db_connection_locator']
+		->getRead()
+		->getProfiler()
+		->getProfiles();
+	$dbProfiles = array_filter($dbProfiles, function ($profile) {
+		return $profile['function'] == 'perform';
+	});
+	$dbProfiles = array_map(function ($profile) {
+		return [
+			'sql' => trim(preg_replace('/\s+/', ' ', $profile['statement'])),
+			'parameters' => $profile['bind_values'],
+			'time' => $profile['duration'],
+		];
+	}, $dbProfiles);
+	$container['profiler']->setProfiledQueries($dbProfiles);
+	$container['profiler']->setDisplay(new Particletree\Pqp\Display());
+	$container['profiler']->display($container['db_connection_locator']->getRead());
 });
 
 $container['console']->logMemory(null, 'PHP - Post-boostrap memory');

controller/blog/DefaultPageController.class.inc.php

Indentation +87 added lines, -87 removed lines

@@ -18,14 +18,14 @@ 
 
 	protected function set_head_data()
 	{
-    $this->set_head('rss_link', [
-      'title' => 'Jacob Emerick Blog Feed',
-      'url' => '/rss.xml'
-    ]);
-    $this->set_head('rss_comment_link', [
-      'title' => 'Jacob Emerick Blog Comment Feed',
-      'url' => '/rss-comments.xml'
-    ]);
+	$this->set_head('rss_link', [
+	  'title' => 'Jacob Emerick Blog Feed',
+	  'url' => '/rss.xml'
+	]);
+	$this->set_head('rss_comment_link', [
+	  'title' => 'Jacob Emerick Blog Comment Feed',
+	  'url' => '/rss-comments.xml'
+	]);
 		
 		$this->add_css('normalize');
 		$this->add_css('blog');
@@ -83,45 +83,45 @@ 
 	final private function get_comments_for_post($post)
 	{
 		$count = CommentCollector::getCommentCountForURL(self::$BLOG_SITE_ID, $post['path']);
-    $count_from_service = $this->get_comments_for_post_from_service($post);
-
-    if ($count != $count_from_service) {
-        global $container;
-        $container['console']->log('Mismatch between comment service and legacy db');
-        $container['console']->log("{$count}, {$count_from_service} in service");
-    }
-    return $count;
-	}
-
-    final private function get_comments_for_post_from_service($post)
-    {
-        global $config;
-        $configuration = new Jacobemerick\CommentService\Configuration();
-        $configuration->setUsername($config->comments->user);
-        $configuration->setPassword($config->comments->password);
-        $configuration->addDefaultHeader('Content-Type', 'application/json');
-        $configuration->setHost($config->comments->host);
-        $configuration->setCurlTimeout($config->comments->timeout);
-
-        $client = new Jacobemerick\CommentService\ApiClient($configuration);
-        $api = new Jacobemerick\CommentService\Api\DefaultApi($client);
-
-        $start = microtime(true);
-        $comment_response = $api->getComments(null, null, null, 'blog.jacobemerick.com', "{$post['category']}/{$post['path']}");
-        $elapsed = microtime(true) - $start;
-        global $container;
-        $container['logger']->info("CommentService | Comment Count | {$elapsed}");
-
-        return count($comment_response);
-    }
+	$count_from_service = $this->get_comments_for_post_from_service($post);
+
+	if ($count != $count_from_service) {
+		global $container;
+		$container['console']->log('Mismatch between comment service and legacy db');
+		$container['console']->log("{$count}, {$count_from_service} in service");
+	}
+	return $count;
+	}
+
+	final private function get_comments_for_post_from_service($post)
+	{
+		global $config;
+		$configuration = new Jacobemerick\CommentService\Configuration();
+		$configuration->setUsername($config->comments->user);
+		$configuration->setPassword($config->comments->password);
+		$configuration->addDefaultHeader('Content-Type', 'application/json');
+		$configuration->setHost($config->comments->host);
+		$configuration->setCurlTimeout($config->comments->timeout);
+
+		$client = new Jacobemerick\CommentService\ApiClient($configuration);
+		$api = new Jacobemerick\CommentService\Api\DefaultApi($client);
+
+		$start = microtime(true);
+		$comment_response = $api->getComments(null, null, null, 'blog.jacobemerick.com', "{$post['category']}/{$post['path']}");
+		$elapsed = microtime(true) - $start;
+		global $container;
+		$container['logger']->info("CommentService | Comment Count | {$elapsed}");
+
+		return count($comment_response);
+	}
 
 	final private function get_tags_for_post($post)
 	{
-        global $container;
-        $repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
-        $tag_result = $repository->getTagsForPost($post['id']);
+		global $container;
+		$repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
+		$tag_result = $repository->getTagsForPost($post['id']);
 
-        $tag_array = array();
+		$tag_array = array();
 		foreach($tag_result as $tag)
 		{
 			$tag_object = new stdclass();
@@ -155,9 +155,9 @@ 
 
 	final private function get_tag_cloud()
 	{
-        global $container;
-        $repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
-        $tag_result = $repository->getTagCloud();
+		global $container;
+		$repository = new Jacobemerick\Web\Domain\Blog\Tag\MysqlTagRepository($container['db_connection_locator']);
+		$tag_result = $repository->getTagCloud();
 		
 		$maximum_tag_count = $this->get_maximum_tag_count($tag_result);
 		
@@ -206,49 +206,49 @@ 
 			$array[] = $comment_obj;
 		}
 
-    $comment_service_array = $this->get_comments_from_service();
-    if ($comment_service_array !== $array) {
-      global $container;
-      $container['console']->log('Mismatch between comment service and legacy db');
-      $container['console']->log($comment_service_array[0]);
-      $container['console']->log($array[0]);
-    }
+	$comment_service_array = $this->get_comments_from_service();
+	if ($comment_service_array !== $array) {
+	  global $container;
+	  $container['console']->log('Mismatch between comment service and legacy db');
+	  $container['console']->log($comment_service_array[0]);
+	  $container['console']->log($array[0]);
+	}
 		return $array;
 	}
 
-    final private function get_comments_from_service()
-    {
-        global $config;
-        $configuration = new Jacobemerick\CommentService\Configuration();
-        $configuration->setUsername($config->comments->user);
-        $configuration->setPassword($config->comments->password);
-        $configuration->addDefaultHeader('Content-Type', 'application/json');
-        $configuration->setHost($config->comments->host);
-        $configuration->setCurlTimeout($config->comments->timeout);
-
-        $client = new Jacobemerick\CommentService\ApiClient($configuration);
-        $api = new Jacobemerick\CommentService\Api\DefaultApi($client);
-
-        $start = microtime(true);
-        $comment_response = $api->getComments(1, self::$RECENT_COMMENT_COUNT, '-date', 'blog.jacobemerick.com');
-        $elapsed = microtime(true) - $start;
-        global $container;
-        $container['logger']->info("CommentService | Sidebar | {$elapsed}");
-
-        $array = array();
-        foreach($comment_response as $comment)
-        {
-            $body = $comment->getBody();
-            $body = Content::instance('CleanComment', $body)->activate();
-            $body = strip_tags($body);
-
-            $comment_obj = new stdclass();
-            $comment_obj->description = Content::instance('SmartTrim', $body)->activate(30);
-            $comment_obj->commenter = $comment->getCommenter()->getName();
-            $comment_obj->link = "{$comment->getUrl()}/#comment-{$comment->getId()}";
-            $array[] = $comment_obj;
-        }
-        return $array;
-    }
+	final private function get_comments_from_service()
+	{
+		global $config;
+		$configuration = new Jacobemerick\CommentService\Configuration();
+		$configuration->setUsername($config->comments->user);
+		$configuration->setPassword($config->comments->password);
+		$configuration->addDefaultHeader('Content-Type', 'application/json');
+		$configuration->setHost($config->comments->host);
+		$configuration->setCurlTimeout($config->comments->timeout);
+
+		$client = new Jacobemerick\CommentService\ApiClient($configuration);
+		$api = new Jacobemerick\CommentService\Api\DefaultApi($client);
+
+		$start = microtime(true);
+		$comment_response = $api->getComments(1, self::$RECENT_COMMENT_COUNT, '-date', 'blog.jacobemerick.com');
+		$elapsed = microtime(true) - $start;
+		global $container;
+		$container['logger']->info("CommentService | Sidebar | {$elapsed}");
+
+		$array = array();
+		foreach($comment_response as $comment)
+		{
+			$body = $comment->getBody();
+			$body = Content::instance('CleanComment', $body)->activate();
+			$body = strip_tags($body);
+
+			$comment_obj = new stdclass();
+			$comment_obj->description = Content::instance('SmartTrim', $body)->activate(30);
+			$comment_obj->commenter = $comment->getCommenter()->getName();
+			$comment_obj->link = "{$comment->getUrl()}/#comment-{$comment->getId()}";
+			$array[] = $comment_obj;
+		}
+		return $array;
+	}
 
 }