MysqlPostRepositoryTest::testFindByPath() - Code Metrics - Inspection of "Changes functionality of post fetching by path, ad..." - jacobemerick/web - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 568319...1f7489 )

by Jacob

created 2015-11-29 22:26 UTC

MysqlPostRepositoryTest::testFindByPath() A

↳ Parent: MysqlPostRepositoryTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	52
Code Lines	31

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	52
rs	9.493
cc	1
eloc	31
nc	1
nop	0

How to fix Long Method

<?php

use Aura\Sql\ConnectionLocator;
use Aura\Sql\ExtendedPdo;
use Jacobemerick\Web\Domain\Blog\MysqlPostRepository;

class MysqlPostRepositoryTest extends \PHPUnit_Framework_TestCase
namespace YourVendor;

class YourClass { }
{

    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,
              `path` varchar(60) NOT NULL,
              `category` varchar(20) NOT NULL,
              `date` date NOT NULL,
              `body` text NOT NULL,
              `display` integer NOT NULL
            )"
        );
        return $extendedPdo;
    }

    public function newMysqlPostRepository()
    {
        return new MysqlPostRepository($this->connections);
    }

    public function testFindByPath()
    {
        $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()->findByPath(
            $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()->findByPath(
            $test_inactive_post['category'],
            $test_inactive_post['path']
        );
        $this->assertFalse($inactive_post);

        $nonexistant_post = $this->newMysqlPostRepository()->findByPath(
            'test-category',
            'test-findbypath-nonexistant'
        );
        $this->assertFalse($nonexistant_post);
   }

    public function testIsInstanceOfPostRepository()
    {
        $this->assertInstanceOf(
            'Jacobemerick\Web\Domain\Blog\PostRepository',
            $this->newMysqlPostRepository()
        );
    }

    public static function tearDownAfterClass()
    {
//        $this->connections->getDefault()->disconnect();

        unlink('jpemeric_blog.db');
    }
}


1			<?php
2
3			use Aura\Sql\ConnectionLocator;
4			use Aura\Sql\ExtendedPdo;
5			use Jacobemerick\Web\Domain\Blog\MysqlPostRepository;
6
7			class MysqlPostRepositoryTest extends \PHPUnit_Framework_TestCase
			0 ignored issues – show Coding Style Compatibility introduced 2015-11-28 22:41 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
8			{
9
10			protected $connections;
11
12			public function __construct()
13			{
14			$extendedPdo = $this->newExtendedPdo();
15			$this->connections = new ConnectionLocator(function () use ($extendedPdo) {
16			return $extendedPdo;
17			});
18			}
19
20			protected function newExtendedPdo()
21			{
22			$extendedPdo = new ExtendedPdo('sqlite::memory:');
23			$extendedPdo->exec('ATTACH DATABASE `jpemeric_blog.db` AS `jpemeric_blog`');
24			$extendedPdo->exec("
25			CREATE TABLE IF NOT EXISTS `jpemeric_blog`.`post` (
26			`id` integer PRIMARY KEY AUTOINCREMENT,
27			`title` varchar(60) NOT NULL,
28			`path` varchar(60) NOT NULL,
29			`category` varchar(20) NOT NULL,
30			`date` date NOT NULL,
31			`body` text NOT NULL,
32			`display` integer NOT NULL
33			)"
34			);
35			return $extendedPdo;
36			}
37
38			public function newMysqlPostRepository()
39			{
40			return new MysqlPostRepository($this->connections);
41			}
42
43			public function testFindByPath()
44			{
45			$test_active_post = array(
46			'title' => 'test findByPath active',
47			'path' => 'test-findbypath-active',
48			'category' => 'test-category',
49			'date' => (new DateTime())->format('Y-m-d H:i:s'),
50			'body' => 'test content',
51			'display' => 1
52			);
53
54			$this->connections->getDefault()->perform("
55			INSERT INTO jpemeric_blog.post
56			(title, path, category, date, body, display)
57			VALUES
58			(:title, :path, :category, :date, :body, :display)",
59			$test_active_post);
60
61			$active_post = $this->newMysqlPostRepository()->findByPath(
62			$test_active_post['category'],
63			$test_active_post['path']
64			);
65			$this->assertSame($test_active_post['title'], $active_post['title']);
66
67			$test_inactive_post = array(
68			'title' => 'test findByPath inactive',
69			'path' => 'test-findbypath-inactive',
70			'category' => 'test-category',
71			'date' => (new DateTime())->format('Y-m-d H:i:s'),
72			'body' => 'test content',
73			'display' => 0
74			);
75
76			$this->connections->getDefault()->perform("
77			INSERT INTO jpemeric_blog.post
78			(title, path, category, date, body, display)
79			VALUES
80			(:title, :path, :category, :date, :body, :display)",
81			$test_inactive_post);
82
83			$inactive_post = $this->newMysqlPostRepository()->findByPath(
84			$test_inactive_post['category'],
85			$test_inactive_post['path']
86			);
87			$this->assertFalse($inactive_post);
88
89			$nonexistant_post = $this->newMysqlPostRepository()->findByPath(
90			'test-category',
91			'test-findbypath-nonexistant'
92			);
93			$this->assertFalse($nonexistant_post);
94			}
95
96			public function testIsInstanceOfPostRepository()
97			{
98			$this->assertInstanceOf(
99			'Jacobemerick\Web\Domain\Blog\PostRepository',
100			$this->newMysqlPostRepository()
101			);
102			}
103
104			public static function tearDownAfterClass()
105			{
106			// $this->connections->getDefault()->disconnect();
			0 ignored issues – show Unused Code Comprehensibility introduced 2015-11-28 22:31 UTC by Report Bug Copy Issue Report `70%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
107			unlink('jpemeric_blog.db');
108			}
109			}
110

jacobemerick / web

Push — master ( 568319...1f7489 )

MysqlPostRepositoryTest::testFindByPath() A

Complexity

Size

Duplication

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like