jacobemerick / web

src/Domain/Blog/Post/MysqlPostRepository.php

Indentation +136 added lines, -136 removed lines

@@ -7,165 +7,165 @@ 
 class MysqlPostRepository implements PostRepository
 {
 
-    /** @var  Aura\Sql\ConnectionLocator */
-    protected $connections;
-
-    /**
-     * @param Aura\Sql\ConnectionLocator $connections
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
-
-    /**
-     * @param string $category
-     * @param string $path
-     *
-     * @return array|false
-     */
-    public function findPostByPath($category, $path)
-    {
-        $query = "
+	/** @var  Aura\Sql\ConnectionLocator */
+	protected $connections;
+
+	/**
+	 * @param Aura\Sql\ConnectionLocator $connections
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
+
+	/**
+	 * @param string $category
+	 * @param string $path
+	 *
+	 * @return array|false
+	 */
+	public function findPostByPath($category, $path)
+	{
+		$query = "
             SELECT `id`, `title`, `path`, `date`, `body`, `category`
             FROM `jpemeric_blog`.`post`
             WHERE `path` = :path AND `category` = :category AND `display` = :is_active
             LIMIT 1";
-        $bindings = [
-            'path'      => $path,
-            'category'  => $category,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
-
-    public function getActivePosts($limit = null, $offset = 0)
-    {
-        $query = "
+		$bindings = [
+			'path'      => $path,
+			'category'  => $category,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
+
+	public function getActivePosts($limit = null, $offset = 0)
+	{
+		$query = "
             SELECT `id`, `title`, `path`, `date`, `body`, `category`
             FROM `jpemeric_blog`.`post`
             WHERE `display` = :is_active
             ORDER BY `date` DESC";
-        if ($limit != null) {
-            $query .= "
+		if ($limit != null) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
+		}
 
-        $bindings = [
-            'is_active' => 1,
-        ];
+		$bindings = [
+			'is_active' => 1,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 
-    public function getActivePostsCount()
-    {
-        $query = "
+	public function getActivePostsCount()
+	{
+		$query = "
             SELECT COUNT(1) AS `count`
             FROM `jpemeric_blog`.`post`
             WHERE `display` = :is_active";
-        $bindings = [
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchValue($query, $bindings);
-    }
-
-    public function getActivePostsByTag($tag, $limit = null, $offset = 0)
-    {
-        $query = "
+		$bindings = [
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchValue($query, $bindings);
+	}
+
+	public function getActivePostsByTag($tag, $limit = null, $offset = 0)
+	{
+		$query = "
             SELECT `id`, `title`, `path`, `date`, `body`, `category`
             FROM `jpemeric_blog`.`post`
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`post_id` = `post`.`id` AND
                                                    `ptlink`.`tag_id` = :tag_id
             WHERE `display` = :is_active";
-        if ($limit != null) {
-            $query .= "
+		if ($limit != null) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
-
-        $bindings = [
-            'tag_id'    => $tag,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
-
-    public function getActivePostsCountByTag($tag)
-    {
-        $query = "
+		}
+
+		$bindings = [
+			'tag_id'    => $tag,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
+
+	public function getActivePostsCountByTag($tag)
+	{
+		$query = "
             SELECT COUNT(1) AS `count`
             FROM `jpemeric_blog`.`post`
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`post_id` = `post`.`id` AND
                                                    `ptlink`.`tag_id` = :tag_id
             WHERE `display` = :is_active";
-        $bindings = [
-            'tag_id'    => $tag,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchValue($query, $bindings);
-    }
-
-    public function getActivePostsByCategory($category, $limit = null, $offset = 0)
-    {
-        $query = "
+		$bindings = [
+			'tag_id'    => $tag,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchValue($query, $bindings);
+	}
+
+	public function getActivePostsByCategory($category, $limit = null, $offset = 0)
+	{
+		$query = "
             SELECT `id`, `title`, `path`, `date`, `body`, `category`
             FROM `jpemeric_blog`.`post`
             WHERE `category` = :category AND `display` = :is_active";
-        if ($limit != null) {
-            $query .= "
+		if ($limit != null) {
+			$query .= "
             LIMIT {$offset}, {$limit}";
-        }
-
-        $bindings = [
-            'category'  => $category,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
-
-    public function getActivePostsCountByCategory($category)
-    {
-        $query = "
+		}
+
+		$bindings = [
+			'category'  => $category,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
+
+	public function getActivePostsCountByCategory($category)
+	{
+		$query = "
             SELECT COUNT(1) AS `count`
             FROM `jpemeric_blog`.`post`
             WHERE `category` = :category AND `display` = :is_active";
-        $bindings = [
-            'category'  => $category,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchValue($query, $bindings);
-    }
-
-    public function getActivePostsByRelatedTags($post, $limit = 4)
-    {
-        $query = "
+		$bindings = [
+			'category'  => $category,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchValue($query, $bindings);
+	}
+
+	public function getActivePostsByRelatedTags($post, $limit = 4)
+	{
+		$query = "
             SELECT `id`, `title`, `path`, `date`, `body`, `category`, COUNT(1) AS `count`
             FROM `jpemeric_blog`.`post`
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`post_id` = `post`.`id` AND
@@ -185,14 +185,14 @@ 
             GROUP BY `id`
             ORDER BY `count` DESC
             LIMIT {$limit}";
-        $bindings = [
-            'post'      => $post,
-            'is_active' => 1,
-        ];
-
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		$bindings = [
+			'post'      => $post,
+			'is_active' => 1,
+		];
+
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 }

src/Domain/Blog/Post/PostRepositoryInterface.php

Indentation +8 added lines, -8 removed lines

@@ -4,12 +4,12 @@
 
 interface PostRepository
 {
-    public function findPostByPath($category, $path);
-    public function getActivePosts($limit = null, $offset= 0);
-    public function getActivePostsCount();
-    public function getActivePostsByTag($tag, $limit = null, $offset = 0);
-    public function getActivePostsCountByTag($tag);
-    public function getActivePostsByCategory($category, $limit = null, $offset = 0);
-    public function getActivePostsCountByCategory($category);
-    public function getActivePostsByRelatedTags($post, $limit = 4);
+	public function findPostByPath($category, $path);
+	public function getActivePosts($limit = null, $offset= 0);
+	public function getActivePostsCount();
+	public function getActivePostsByTag($tag, $limit = null, $offset = 0);
+	public function getActivePostsCountByTag($tag);
+	public function getActivePostsByCategory($category, $limit = null, $offset = 0);
+	public function getActivePostsCountByCategory($category);
+	public function getActivePostsByRelatedTags($post, $limit = 4);
 }

src/Domain/Blog/Series/MysqlSeriesRepository.php

Indentation +26 added lines, -26 removed lines

@@ -7,25 +7,25 @@ 
 class MysqlSeriesRepository implements SeriesRepository
 {
 
-    /** @var  Aura\Sql\ConnectionLocator */
-    protected $connections;
+	/** @var  Aura\Sql\ConnectionLocator */
+	protected $connections;
 
-    /**
-     * @param Aura\Sql\ConnectionLocator
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
+	/**
+	 * @param Aura\Sql\ConnectionLocator
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
 
-    /**
-     * @param integer $post
-     *
-     * @return array|false
-     */
-    public function getSeriesForPost($post)
-    {
-        $query = "
+	/**
+	 * @param integer $post
+	 *
+	 * @return array|false
+	 */
+	public function getSeriesForPost($post)
+	{
+		$query = "
             SELECT `series`.`title` AS `series_title`, `series`.`description` AS `series_descriptions`,
                    `post.id` AS `post`, `post`.`title`, `post`.`category`, `post`.`path`
             FROM `jpemeric_blog`.`series`
@@ -38,14 +38,14 @@ 
                 WHERE `post` = :lookup_post
                 LIMIT 1)
             ORDER BY `series_post`.`order`";
-        $bindings = [
-            'is_active'   => 1,
-            'lookup_post' => $post,
-        ];
+		$bindings = [
+			'is_active'   => 1,
+			'lookup_post' => $post,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 }

src/Domain/Blog/Series/SeriesRepositoryInterface.php

Indentation +1 added lines, -1 removed lines

@@ -4,5 +4,5 @@
 
 interface SeriesRepository
 {
-    public function getSeriesForPost($post);
+	public function getSeriesForPost($post);
 }

src/Domain/Blog/Tag/MysqlTagRepository.php

Indentation +55 added lines, -55 removed lines

@@ -7,85 +7,85 @@
 class MysqlTagRepository implements TagRepository
 {
 
-    /** @var  Aura\Sql\ConnectionLocator */
-    protected $connections;
+	/** @var  Aura\Sql\ConnectionLocator */
+	protected $connections;
 
-    /**
-     * @param Aura\Sql\ConnectionLocator
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
+	/**
+	 * @param Aura\Sql\ConnectionLocator
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
 
-    /**
-     * @param string $title
-     *
-     * @return array|false
-     */
-    public function findTagByTitle($title)
-    {
-        $query = "
+	/**
+	 * @param string $title
+	 *
+	 * @return array|false
+	 */
+	public function findTagByTitle($title)
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_blog`.`tag`
             WHERE `tag` = :title
             LIMIT 1";
-        $bindings = [
-            'title' => $title,
-        ];
+		$bindings = [
+			'title' => $title,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
 
-    public function getAllTags()
-    {
-        $query = "
+	public function getAllTags()
+	{
+		$query = "
             SELECT *
             FROM `jpemeric_blog`.`tag`
             ORDER BY `tag`";
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query);
+	}
 
-    public function getTagCloud()
-    {
-        $query = "
+	public function getTagCloud()
+	{
+		$query = "
             SELECT COUNT(1) AS `count`, `tag`
             FROM `jpemeric_blog`.`tag`
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`tag_id` = `tag`.`id`
             INNER JOIN `jpemeric_blog`.`post` ON `post`.`id` = `ptlink`.`post_id` AND
                                                  `post`.`display` = :is_active
             GROUP BY `tag`";
-        $bindings = [
-            'is_active' => 1,
-        ];
+		$bindings = [
+			'is_active' => 1,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 
-    public function getTagsForPost($post)
-    {
-        $query = "
+	public function getTagsForPost($post)
+	{
+		$query = "
             SELECT `tag`.*
             FROM `jpemeric_blog`.`tag`
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`tag_id` AND `post_id` = :post
             ORDER BY `tag`";
-        $bindings = [
-            'post' => $post,
-        ];
+		$bindings = [
+			'post' => $post,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchAll($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchAll($query, $bindings);
+	}
 }

src/Domain/Blog/Tag/TagRepositoryInterface.php

Indentation +4 added lines, -4 removed lines

@@ -4,8 +4,8 @@
 
 interface TagRepository
 {
-    public function findTagByTitle($title);
-    public function getAllTags();
-    public function getTagCloud();
-    public function getTagsForPost($post);
+	public function findTagByTitle($title);
+	public function getAllTags();
+	public function getTagCloud();
+	public function getTagsForPost($post);
 }

src/Domain/Blog/Introduction/IntroductionRepositoryInterface.php

Indentation +1 added lines, -1 removed lines

@@ -4,5 +4,5 @@
 
 interface IntroductionRepository
 {
-    public function findByType($type, $value = '');
+	public function findByType($type, $value = '');
 }

src/Domain/Blog/Introduction/MysqlIntroductionRepository.php

Indentation +27 added lines, -27 removed lines

@@ -7,38 +7,38 @@
 class MysqlIntroductionRepository implements IntroductionRepository
 {
 
-    /** @var  Aura\Sql\ConnectionLocator */
-    protected $connections;
+	/** @var  Aura\Sql\ConnectionLocator */
+	protected $connections;
 
-    /**
-     * @param Aura\Sql\ConnectionLocator
-     */
-    public function __construct(ConnectionLocator $connections)
-    {
-        $this->connections = $connections;
-    }
+	/**
+	 * @param Aura\Sql\ConnectionLocator
+	 */
+	public function __construct(ConnectionLocator $connections)
+	{
+		$this->connections = $connections;
+	}
 
-    /**
-     * @param string $type
-     * @param string $value
-     *
-     * @return array|false
-     */
-    public function findByType($type, $value = '')
-    {
-        $query = "
+	/**
+	 * @param string $type
+	 * @param string $value
+	 *
+	 * @return array|false
+	 */
+	public function findByType($type, $value = '')
+	{
+		$query = "
             SELECT `title`, `content`, `image`
             FROM `jpemeric_blog`.`introduction`
             WHERE `type` = :type AND `value` = :value
             LIMIT 1";
-        $bindings = [
-            'type'  => $type,
-            'value' => $value,
-        ];
+		$bindings = [
+			'type'  => $type,
+			'value' => $value,
+		];
 
-        return $this
-            ->connections
-            ->getRead()
-            ->fetchOne($query, $bindings);
-    }
+		return $this
+			->connections
+			->getRead()
+			->fetchOne($query, $bindings);
+	}
 }

tests/unit/domain/blog/MysqlPostRepositoryTest.php

Indentation +87 added lines, -87 removed lines

@@ -7,21 +7,21 @@ 
 class MysqlPostRepositoryTest extends PHPUnit_Framework_TestCase
 {
 
-    protected $connections;
-
-    public function __construct()
-    {
-        $extendedPdo = $this->newExtendedPdo();
-        $this->connections = new ConnectionLocator(function () use ($extendedPdo) {
-            return $extendedPdo;
-        });
-    }
-
-    protected function newExtendedPdo()
-    {
-        $extendedPdo = new ExtendedPdo('sqlite::memory:');
-        $extendedPdo->exec('ATTACH DATABASE `jpemeric_blog.db` AS `jpemeric_blog`');
-        $extendedPdo->exec("
+	protected $connections;
+
+	public function __construct()
+	{
+		$extendedPdo = $this->newExtendedPdo();
+		$this->connections = new ConnectionLocator(function () use ($extendedPdo) {
+			return $extendedPdo;
+		});
+	}
+
+	protected function newExtendedPdo()
+	{
+		$extendedPdo = new ExtendedPdo('sqlite::memory:');
+		$extendedPdo->exec('ATTACH DATABASE `jpemeric_blog.db` AS `jpemeric_blog`');
+		$extendedPdo->exec("
             CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`post` (
               `id` integer PRIMARY KEY AUTOINCREMENT,
               `title` varchar(60) NOT NULL,
@@ -31,88 +31,88 @@ 
               `body` text NOT NULL,
               `display` integer NOT NULL
             )"
-        );
-        return $extendedPdo;
-    }
-
-    public function newMysqlPostRepository()
-    {
-        return new MysqlPostRepository($this->connections);
-    }
-
-    public function testConstructSetsConnections()
-    {
-        $this->assertAttributeEquals(
-            $this->connections,
-            'connections',
-            $this->newMysqlPostRepository()
-        );
-    }
-
-    public function testFindPostByPath()
-    {
-        $test_active_post = array(
-            'title'     => 'test findByPath active',
-            'path'      => 'test-findbypath-active',
-            'category'  => 'test-category',
-            'date'      => (new DateTime())->format('Y-m-d H:i:s'),
-            'body'      => 'test content',
-            'display'   => 1
-        );
-
-        $this->connections->getDefault()->perform("
+		);
+		return $extendedPdo;
+	}
+
+	public function newMysqlPostRepository()
+	{
+		return new MysqlPostRepository($this->connections);
+	}
+
+	public function testConstructSetsConnections()
+	{
+		$this->assertAttributeEquals(
+			$this->connections,
+			'connections',
+			$this->newMysqlPostRepository()
+		);
+	}
+
+	public function testFindPostByPath()
+	{
+		$test_active_post = array(
+			'title'     => 'test findByPath active',
+			'path'      => 'test-findbypath-active',
+			'category'  => 'test-category',
+			'date'      => (new DateTime())->format('Y-m-d H:i:s'),
+			'body'      => 'test content',
+			'display'   => 1
+		);
+
+		$this->connections->getDefault()->perform("
             INSERT INTO jpemeric_blog.post
                 (title, path, category, date, body, display)
             VALUES
                 (:title, :path, :category, :date, :body, :display)",
-            $test_active_post);
-
-        $active_post = $this->newMysqlPostRepository()->findPostByPath(
-            $test_active_post['category'],
-            $test_active_post['path']
-        );
-        $this->assertSame($test_active_post['title'], $active_post['title']);
-
-        $test_inactive_post = array(
-            'title'     => 'test findByPath inactive',
-            'path'      => 'test-findbypath-inactive',
-            'category'  => 'test-category',
-            'date'      => (new DateTime())->format('Y-m-d H:i:s'),
-            'body'      => 'test content',
-            'display'   => 0
-        );
-
-        $this->connections->getDefault()->perform("
+			$test_active_post);
+
+		$active_post = $this->newMysqlPostRepository()->findPostByPath(
+			$test_active_post['category'],
+			$test_active_post['path']
+		);
+		$this->assertSame($test_active_post['title'], $active_post['title']);
+
+		$test_inactive_post = array(
+			'title'     => 'test findByPath inactive',
+			'path'      => 'test-findbypath-inactive',
+			'category'  => 'test-category',
+			'date'      => (new DateTime())->format('Y-m-d H:i:s'),
+			'body'      => 'test content',
+			'display'   => 0
+		);
+
+		$this->connections->getDefault()->perform("
             INSERT INTO jpemeric_blog.post
                 (title, path, category, date, body, display)
             VALUES
                 (:title, :path, :category, :date, :body, :display)",
-            $test_inactive_post);
-
-        $inactive_post = $this->newMysqlPostRepository()->findPostByPath(
-            $test_inactive_post['category'],
-            $test_inactive_post['path']
-        );
-        $this->assertFalse($inactive_post);
-
-        $nonexistant_post = $this->newMysqlPostRepository()->findPostByPath(
-            'test-category',
-            'test-findbypath-nonexistant'
-        );
-        $this->assertFalse($nonexistant_post);
+			$test_inactive_post);
+
+		$inactive_post = $this->newMysqlPostRepository()->findPostByPath(
+			$test_inactive_post['category'],
+			$test_inactive_post['path']
+		);
+		$this->assertFalse($inactive_post);
+
+		$nonexistant_post = $this->newMysqlPostRepository()->findPostByPath(
+			'test-category',
+			'test-findbypath-nonexistant'
+		);
+		$this->assertFalse($nonexistant_post);
    }
 
-    public function testIsInstanceOfPostRepository()
-    {
-        $this->assertInstanceOf(
-            'Jacobemerick\Web\Domain\Blog\Post\PostRepositoryInterface',
-            $this->newMysqlPostRepository()
-        );
-    }
+	public function testIsInstanceOfPostRepository()
+	{
+		$this->assertInstanceOf(
+			'Jacobemerick\Web\Domain\Blog\Post\PostRepositoryInterface',
+			$this->newMysqlPostRepository()
+		);
+	}
 
-    public static function tearDownAfterClass()
-    {
+	public static function tearDownAfterClass()
+	{
 //        $this->connections->getDefault()->disconnect();
-        unlink('jpemeric_blog.db');
-    }
+		unlink('jpemeric_blog.db');
+	}
 }