ClasslessHasOneCyclicTest.php

<?php
/**
 * Cycle DataMapper ORM
 *
 * @license   MIT
 * @author    Anton Titov (Wolfy-J)
 */
declare(strict_types=1);

namespace Cycle\ORM\Tests\Classless;

use Cycle\ORM\Heap\Heap;
use Cycle\ORM\Mapper\StdMapper;
use Cycle\ORM\Relation;
use Cycle\ORM\Schema;
use Cycle\ORM\Select;
use Cycle\ORM\Tests\BaseTest;
use Cycle\ORM\Tests\Traits\TableTrait;
use Cycle\ORM\Transaction;

abstract class ClasslessHasOneCyclicTest extends BaseTest
{
    use TableTrait;

    public function setUp()
    {
        parent::setUp();

        $this->makeTable('cyclic', [
            'id'        => 'primary',
            'name'      => 'string',
            'parent_id' => 'integer,nullable'
        ]);

        $this->getDatabase()->table('cyclic')->insertMultiple(
            ['parent_id', 'name'],
            [
                [null, 'first'],
                [1, 'second'],
                [3, 'self-reference'],
            ]
        );

        $this->orm = $this->withSchema(new Schema([
            'cyclic' => [
                Schema::MAPPER       => StdMapper::class,
                Schema::DATABASE     => 'default',
                Schema::TABLE        => 'cyclic',
                Schema::PRIMARY_KEY  => 'id',
                Schema::FIND_BY_KEYS => ['parent_id'],
                Schema::COLUMNS      => ['id', 'parent_id', 'name'],
                Schema::SCHEMA       => [],
                Schema::RELATIONS    => [
                    'cyclic' => [
                        Relation::TYPE   => Relation::HAS_ONE,
                        Relation::TARGET => 'cyclic',
                        Relation::SCHEMA => [
                            Relation::CASCADE   => true,
                            Relation::NULLABLE  => true,
                            Relation::INNER_KEY => 'id',
                            Relation::OUTER_KEY => 'parent_id',
                        ],
                    ]
                ]
            ],
        ]));
    }

    public function testFetchCyclic()
    {
        $selector = new Select($this->orm, 'cyclic');
        $selector->load('cyclic')->orderBy('cyclic.id');

        $this->assertEquals([
            [
                'id'        => '1',
                'parent_id' => null,
                'name'      => 'first',
                'cyclic'    => [
                    'id'        => '2',
                    'parent_id' => '1',
                    'name'      => 'second',
                ],
            ],
            [
                'id'        => '2',
                'parent_id' => '1',
                'name'      => 'second',
                'cyclic'    => null,
            ],
            [
                'id'        => '3',
                'parent_id' => '3',
                'name'      => 'self-reference',
                'cyclic'    => [
                    'id'        => '3',
                    'parent_id' => '3',
                    'name'      => 'self-reference',
                ],
            ],
        ], $selector->fetchData());
    }

    public function testFetchCyclicRelation()
    {
        $selector = new Select($this->orm, 'cyclic');
        list($a, $b, $c) = $selector->load('cyclic')->orderBy('cyclic.id')->fetchAll();

        $this->assertSame($b, $a->cyclic);
        $this->assertSame(null, $b->cyclic);
        $this->assertSame($c, $c->cyclic);
    }

    public function testUpdateCyclic()
    {
        $selector = new Select($this->orm, 'cyclic');
        $c = $selector->load('cyclic')->wherePK(3)->fetchOne();
        $this->assertEquals('self-reference', $c->name);

        $c->name = 'updated';

        $tr = new Transaction($this->orm);
        $tr->persist($c);
        $tr->run();

        $selector = new Select($this->orm->withHeap(new Heap()), 'cyclic');
        $c = $selector->load('cyclic')->wherePK(3)->fetchOne();

        $this->assertEquals('updated', $c->name);
        $this->assertSame($c, $c->cyclic);
    }

    public function testCyclicWithoutLoad()
    {
        $selector = new Select($this->orm, 'cyclic');
        $c = $selector->wherePK(3)->fetchOne();
        $this->assertEquals('self-reference', $c->name);
        $this->assertSame($c, $c->cyclic);
    }

    public function testCreateCyclic()
    {
        $c = $this->orm->make('cyclic');
        $c->name = "new";
        $c->cyclic = $c;

        $this->captureWriteQueries();
        $tr = new Transaction($this->orm);
        $tr->persist($c);
        $tr->run();
        $this->assertNumWrites(2);

        $selector = new Select($this->orm->withHeap(new Heap()), 'cyclic');
        $c = $selector->load('cyclic')->wherePK(4)->fetchOne();
        $this->assertEquals('new', $c->name);
        $this->assertSame($c, $c->cyclic);
    }
}