Fwk\Db\BasicCrudTest

Complexity

Total Complexity

8

Size/Duplication

Total Lines	189
Duplicated Lines	0 %

Coupling/Cohesion

Dependencies

5

Importance

Changes	1
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	9	1
A	tearDown()	0	4	1
A	testNonSpecialSelectFetchAssoc()	0	16	1
A	testNonSpecialSelectFetchClass()	0	17	1
A	testSelectWithJoin()	0	63	1
A	testInsert()	0	16	1
A	testUpdate()	0	22	1
A	testDelete()	0	20	1

<?php

namespace Fwk\Db;

/**
 * Test class for Accessor.
 * Generated by PHPUnit on 2012-05-27 at 17:46:42.
 */
class BasicCrudTest extends \PHPUnit_Framework_TestCase
{
    protected $connection;

    /**
     * Sets up the fixture, for example, opens a network connection.
     * This method is called before a test is executed.
     */
    protected function setUp()
    {
        $this->connection = new Connection(array(
            'memory'    => true,
            'driver'    => 'pdo_sqlite'
        ));

        \FwkDbTestUtil::createTestDb($this->connection);
    }

    protected function tearDown()
    {
        \FwkDbTestUtil::dropTestDb($this->connection);
    }

    public function testNonSpecialSelectFetchAssoc()
    {
        $query = Query::factory()
            ->insert('fwkdb_test_users')
            ->set('username', 'joeBar');

        $this->connection->execute($query);
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));

        $query = Query::factory()->select()->from('fwkdb_test_users')->setFetchMode(\PDO::FETCH_ASSOC);
        $res = $this->connection->execute($query);

        $this->assertTrue(is_array($res));
        $this->assertEquals(1, count($res));
        $this->assertTrue(is_array($res[0]));
    }

    public function testNonSpecialSelectFetchClass()
    {
        $query = Query::factory()
            ->insert('fwkdb_test_users')
            ->set('username', 'joeBar');

        $this->connection->execute($query);
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));

        $query = Query::factory()->select()->from('fwkdb_test_users')->setFetchMode(\PDO::FETCH_CLASS);
        $res = $this->connection->execute($query);

        $this->assertTrue(is_array($res));
        $this->assertEquals(1, count($res));
        $this->assertTrue(is_object($res[0]));
        $this->assertInstanceOf('\stdClass', $res[0]);
    }

    public function testSelectWithJoin()
    {
        $query = Query::factory()
            ->insert('fwkdb_test_users')
            ->set('username', 'joeBar');

        $this->connection->execute($query);

        $query = Query::factory()
            ->insert('fwkdb_test_emails')
            ->values(array(
                'email' => 'test@nitronet.org',
                'verified' => true
            ));

        $this->connection->execute($query);

        $query = Query::factory()
            ->insert('fwkdb_test_emails')
            ->values(array(
                'email' => 'test2@nitronet.dev',
                'verified' => false
            ));

        $this->connection->execute($query);

        $query = Query::factory()
            ->insert('fwkdb_test_users_emails')
            ->values(array(
                'user_id' => 1,
                'email_id' => 1
            ));

        $this->connection->execute($query);

        $query = Query::factory()
            ->insert('fwkdb_test_users_emails')
            ->values(array(
                'user_id' => 1,
                'email_id' => 2
            ));

        $this->connection->execute($query);

        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(2, count($this->connection->table('fwkdb_test_emails')->finder()->all()));
        $this->assertEquals(2, count($this->connection->table('fwkdb_test_users_emails')->finder()->all()));

        $query = Query::factory()
            ->select()
            ->from('fwkdb_test_users u')
            ->join('fwkdb_test_users_emails ue', 'u.id', 'ue.user_id', Query::JOIN_LEFT, array('skipped' => true))
            ->join('fwkdb_test_emails e', 'e.id', 'ue.email_id', Query::JOIN_LEFT, array('column' => 'emails'));

        $res = $this->connection->execute($query);

        $this->assertTrue(is_array($res));
        $this->assertEquals(1, count($res));
        $entity = $res[0];

        $this->assertTrue(is_object($entity));
        $this->assertEquals(2, count($entity->emails));
    }

    /**
     */
    public function testInsert()
    {
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $query = Query::factory()
                    ->insert('fwkdb_test_users')
                    ->set('username', 'joeBar');

        $this->connection->execute($query);
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));

        $query = Query::factory()
                    ->insert('fwkdb_test_users')
                    ->set('username', 'joeBar2');
        $this->connection->execute($query);
        $this->assertEquals(2, count($this->connection->table('fwkdb_test_users')->finder()->all()));
    }

    /**
     */
    public function testUpdate()
    {
        $query = Query::factory()
                    ->insert('fwkdb_test_users')
                    ->set('username', 'joeBar');

        $this->connection->execute($query);

        $one = $this->connection->table('fwkdb_test_users')->finder()->one(1);
        $this->assertNotNull($one);

        $query = Query::factory()
                ->update('fwkdb_test_users')
                ->set('username', '?')
                ->where('id = ?');

        $this->connection->execute($query, array('joeBarUPDATED', 1));

        $one = $this->connection->table('fwkdb_test_users')->finder()->one(1);
        $this->assertNotNull($one);
        $this->assertEquals("joeBarUPDATED", $one->username);
    }

    /**
     */
    public function testDelete()
    {
        $query = Query::factory()
                    ->insert('fwkdb_test_users')
                    ->set('username', 'joeBar');

        $this->connection->execute($query);

        $one = $this->connection->table('fwkdb_test_users')->finder()->one(1);
        $this->assertNotNull($one);

        $query = Query::factory()
                ->delete('fwkdb_test_users')
                ->where('id = ?');

        $this->connection->execute($query, array(1));

        $one = $this->connection->table('fwkdb_test_users')->finder()->one(1);
        $this->assertNull($one);
    }
}