fwk / Db

tests/BasicEntityEagerRelationsTest.php

<?php

namespace Fwk\Db;

class User7 extends \stdClass
{
    public $emails;

    public $metas;

    public $phone;

    public function __construct()
    {
        $this->emails = new Relations\Many2Many(
                'id',
                'user_id',
                'fwkdb_test_emails',
                'fwkdb_test_users_emails',
                'id',
                'email_id',
                'Fwk\Db\Email7'
        );
        $this->emails->setFetchMode(RelationInterface::FETCH_EAGER);
        $this->emails->setOrderBy('email');

        $this->metas = new Relations\One2Many(
                'id',
                'user_id',
                'fwkdb_test_users_metas'
        );
        $this->metas->setReference('name');
        $this->metas->setFetchMode(RelationInterface::FETCH_EAGER);

        $this->phone = new Relations\One2One('phone_id', 'id', 'fwkdb_test_phones');
        $this->phone->setFetchMode(RelationInterface::FETCH_EAGER);
    }
}

class Email7 extends \stdClass

PSR1 recommends that each class should be in its own file to aid autoloaders.

{
}

/**
 * Test class for Accessor.
 * Generated by PHPUnit on 2012-05-27 at 17:46:42.
 */
class BasicEntityEagerRelationsTest extends \PHPUnit_Framework_TestCase

PSR1 recommends that each class should be in its own file to aid autoloaders.

{
    /**
     *
     * @var \Fwk\Db\Connection
     */
    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 testM2MSave()
    {
        $u = new User7;
        $u->username = "joebar";

        $e = new Email7();
        $e->email = "joe@bar.com";
        $e->verified = 1;

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

        $u->emails[] = $e;
        $this->connection->table('fwkdb_test_users')->save($u);

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

    public function testM2MRemoveChild()
    {
        $u = new User7;
        $u->username = "joebar";

        $e = new Email7();
        $e->email = "joe@bar.com";
        $e->verified = 1;

        $u->emails[] = $e;
        $this->connection->table('fwkdb_test_users')->save($u);

        $user = $this->connection->table('fwkdb_test_users')->finder('Fwk\Db\User')->one(1);
        $this->assertNotNull($user);
        $this->assertInstanceOf('\Fwk\Db\Email', $user->emails[0]);

        unset($user->emails[0]);
        $this->connection->table('fwkdb_test_users')->save($user);

        $this->assertNull($user->emails[0]);
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_emails')->finder()->all()));
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users_emails')->finder()->all()));
    }

    public function testO2MSave()
    {
        $u = new User7;
        $u->username = "joebar";

        $m = new \stdClass;
        $m->name = "param";
        $m->value = "value";

        $u->metas[] = $m;

        $this->assertEquals($m, $u->metas['param']); // test the reference
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users_metas')->finder()->all()));

        $this->connection->table('fwkdb_test_users')->save($u);

        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users_metas')->finder()->all()));
        $this->assertEquals($u->id, $u->metas['param']->user_id);
    }

    public function testO2MRemoveChild()
    {
        $u = new User7;
        $u->username = "joebar";

        $m = new \stdClass;
        $m->name = "param";
        $m->value = "value";

        $u->metas[] = $m;
        $this->connection->table('fwkdb_test_users')->save($u);

        $user = $this->connection->table('fwkdb_test_users')->finder('Fwk\Db\User')->one(1);
        $this->assertNotNull($user);
        $this->assertInstanceOf('\stdClass', $user->metas['param']);

        unset($user->metas['param']);
        $this->connection->table('fwkdb_test_users')->save($user);

        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users_metas')->finder()->all()));
        $this->assertNull($user->metas['param']);
    }

    public function testO2OSave()
    {
        $u = new User7;
        $u->username = "joebar";

        $m = new \stdClass;
        $m->number = "0467010506";

        $u->phone->set($m);

        $this->assertEquals(0, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(0, count($this->connection->table('fwkdb_test_phones')->finder()->all()));

        $this->connection->table('fwkdb_test_users')->save($u);

        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_phones')->finder()->all()));
        $this->assertEquals($m->id, $u->phone_id);
    }

    public function testO2ORemoveChild()
    {
        $u = new User7;
        $u->username = "joebar";

        $m = new \stdClass;
        $m->number = "0467010506";

        $u->phone->set($m);

        $this->connection->table('fwkdb_test_users')->save($u);

        $user = $this->connection->table('fwkdb_test_users')->finder('Fwk\Db\User')->one(1);
        $this->assertNotNull($user);
        $this->assertInstanceOf('\stdClass', $user->phone->get());

        $user->phone->set();
        $this->connection->table('fwkdb_test_users')->save($user);

        $this->assertEquals(1, count($this->connection->table('fwkdb_test_users')->finder()->all()));
        $this->assertEquals(1, count($this->connection->table('fwkdb_test_phones')->finder()->all()));
        $this->assertNull($user->phone_id);
    }

    protected function insertBulk(Connection $db)
    {
        $users = array();
        for($x = 0; $x < 10; $x++) {
            $u = new User7;
            $u->username = "test". $x;

            $m = new \stdClass;
            $m->number = "046701050". $x;
            $u->phone->set($m);

            for ($y = 0; $y < 5; $y++) {
                $me = new \stdClass;
                $me->name = "param". $y;
                $me->value = "value". $x;
                $u->metas[] = $me;
            }

            $users[] = $u;
        }

        $db->table('fwkdb_test_users')->save($users);
    }

    /**
     * @medium
     */
    public function testSelectEager()
    {
        $this->insertBulk($this->connection);
        $this->assertEquals(10, count($this->connection->table('fwkdb_test_users')->finder()->all()));

        $user1 = $this->connection->table('fwkdb_test_users')->finder('Fwk\Db\User7')->one(1);
        $this->assertTrue(is_object($user1));
        $this->assertEquals(5, count($user1->metas));
        $this->assertEquals(1, count($user1->phone));
    }
}