123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- <?php
- namespace Illuminate\Tests\Database;
- use Illuminate\Database\Eloquent\Builder;
- use Illuminate\Database\Eloquent\Model;
- use Illuminate\Database\Eloquent\Relations\MorphToMany;
- use Mockery as m;
- use PHPUnit\Framework\TestCase;
- use stdClass;
- class DatabaseEloquentMorphToManyTest extends TestCase
- {
- protected function tearDown(): void
- {
- m::close();
- }
- public function testEagerConstraintsAreProperlyAdded()
- {
- $relation = $this->getRelation();
- $relation->getParent()->shouldReceive('getKeyName')->andReturn('id');
- $relation->getParent()->shouldReceive('getKeyType')->once()->andReturn('int');
- $relation->getQuery()->shouldReceive('whereIntegerInRaw')->once()->with('taggables.taggable_id', [1, 2]);
- $relation->getQuery()->shouldReceive('where')->once()->with('taggables.taggable_type', get_class($relation->getParent()));
- $model1 = new EloquentMorphToManyModelStub;
- $model1->id = 1;
- $model2 = new EloquentMorphToManyModelStub;
- $model2->id = 2;
- $relation->addEagerConstraints([$model1, $model2]);
- }
- public function testAttachInsertsPivotTableRecord()
- {
- $relation = $this->getMockBuilder(MorphToMany::class)->onlyMethods(['touchIfTouching'])->setConstructorArgs($this->getRelationArguments())->getMock();
- $query = m::mock(stdClass::class);
- $query->shouldReceive('from')->once()->with('taggables')->andReturn($query);
- $query->shouldReceive('insert')->once()->with([['taggable_id' => 1, 'taggable_type' => get_class($relation->getParent()), 'tag_id' => 2, 'foo' => 'bar']])->andReturn(true);
- $relation->getQuery()->shouldReceive('getQuery')->andReturn($mockQueryBuilder = m::mock(stdClass::class));
- $mockQueryBuilder->shouldReceive('newQuery')->once()->andReturn($query);
- $relation->expects($this->once())->method('touchIfTouching');
- $relation->attach(2, ['foo' => 'bar']);
- }
- public function testDetachRemovesPivotTableRecord()
- {
- $relation = $this->getMockBuilder(MorphToMany::class)->onlyMethods(['touchIfTouching'])->setConstructorArgs($this->getRelationArguments())->getMock();
- $query = m::mock(stdClass::class);
- $query->shouldReceive('from')->once()->with('taggables')->andReturn($query);
- $query->shouldReceive('where')->once()->with('taggables.taggable_id', 1)->andReturn($query);
- $query->shouldReceive('where')->once()->with('taggable_type', get_class($relation->getParent()))->andReturn($query);
- $query->shouldReceive('whereIn')->once()->with('taggables.tag_id', [1, 2, 3]);
- $query->shouldReceive('delete')->once()->andReturn(true);
- $relation->getQuery()->shouldReceive('getQuery')->andReturn($mockQueryBuilder = m::mock(stdClass::class));
- $mockQueryBuilder->shouldReceive('newQuery')->once()->andReturn($query);
- $relation->expects($this->once())->method('touchIfTouching');
- $this->assertTrue($relation->detach([1, 2, 3]));
- }
- public function testDetachMethodClearsAllPivotRecordsWhenNoIDsAreGiven()
- {
- $relation = $this->getMockBuilder(MorphToMany::class)->onlyMethods(['touchIfTouching'])->setConstructorArgs($this->getRelationArguments())->getMock();
- $query = m::mock(stdClass::class);
- $query->shouldReceive('from')->once()->with('taggables')->andReturn($query);
- $query->shouldReceive('where')->once()->with('taggables.taggable_id', 1)->andReturn($query);
- $query->shouldReceive('where')->once()->with('taggable_type', get_class($relation->getParent()))->andReturn($query);
- $query->shouldReceive('whereIn')->never();
- $query->shouldReceive('delete')->once()->andReturn(true);
- $relation->getQuery()->shouldReceive('getQuery')->andReturn($mockQueryBuilder = m::mock(stdClass::class));
- $mockQueryBuilder->shouldReceive('newQuery')->once()->andReturn($query);
- $relation->expects($this->once())->method('touchIfTouching');
- $this->assertTrue($relation->detach());
- }
- public function getRelation()
- {
- [$builder, $parent] = $this->getRelationArguments();
- return new MorphToMany($builder, $parent, 'taggable', 'taggables', 'taggable_id', 'tag_id', 'id', 'id');
- }
- public function getRelationArguments()
- {
- $parent = m::mock(Model::class);
- $parent->shouldReceive('getMorphClass')->andReturn(get_class($parent));
- $parent->shouldReceive('getKey')->andReturn(1);
- $parent->shouldReceive('getCreatedAtColumn')->andReturn('created_at');
- $parent->shouldReceive('getUpdatedAtColumn')->andReturn('updated_at');
- $parent->shouldReceive('getMorphClass')->andReturn(get_class($parent));
- $parent->shouldReceive('getAttribute')->with('id')->andReturn(1);
- $builder = m::mock(Builder::class);
- $related = m::mock(Model::class);
- $builder->shouldReceive('getModel')->andReturn($related);
- $related->shouldReceive('getTable')->andReturn('tags');
- $related->shouldReceive('getKeyName')->andReturn('id');
- $related->shouldReceive('qualifyColumn')->with('id')->andReturn('tags.id');
- $related->shouldReceive('getMorphClass')->andReturn(get_class($related));
- $builder->shouldReceive('join')->once()->with('taggables', 'tags.id', '=', 'taggables.tag_id');
- $builder->shouldReceive('where')->once()->with('taggables.taggable_id', '=', 1);
- $builder->shouldReceive('where')->once()->with('taggables.taggable_type', get_class($parent));
- return [$builder, $parent, 'taggable', 'taggables', 'taggable_id', 'tag_id', 'id', 'id', 'relation_name', false];
- }
- }
- class EloquentMorphToManyModelStub extends Model
- {
- protected $guarded = [];
- }
|