1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- <?php
- declare(strict_types = 1);
- namespace App\Test\Core\DB;
- use App\Core\ActorLocalRoles;
- use App\Core\DB;
- use App\Entity\Actor;
- use App\Entity\LocalUser;
- use App\Util\Exception\DuplicateFoundException;
- use App\Util\Exception\NotFoundException;
- use App\Util\GNUsocialTestCase;
- use Jchook\AssertThrows\AssertThrows;
- class DBTest extends GNUsocialTestCase
- {
- use AssertThrows;
- public function testDql()
- {
- static::bootKernel();
- $actor = DB::dql('select a from actor a where a.nickname = :nickname', ['nickname' => 'taken_user']);
- static::assertIsArray($actor);
- static::assertTrue($actor[0] instanceof Actor);
- }
- public function testSql()
- {
- static::bootKernel();
- $actor = DB::sql('select {select} from actor a where a.nickname = :nickname', ['nickname' => 'taken_user']);
- static::assertIsArray($actor);
- static::assertTrue($actor[0] instanceof Actor);
- }
- public function testFindBy()
- {
- static::bootKernel();
- $actor = DB::findBy('actor', ['nickname' => 'taken_user']);
- static::assertIsArray($actor);
- static::assertTrue($actor[0] instanceof Actor);
- $actor = DB::findBy('actor', ['and' => ['is_null' => 'bio', 'or' => ['nickname' => 'user does not exist', 'gte' => ['id' => 0]]]]);
- static::assertIsArray($actor);
- static::assertTrue($actor[0] instanceof Actor);
- }
- public function testFindOneBy()
- {
- static::bootKernel();
- $actor = DB::findOneBy('actor', ['nickname' => 'taken_user']);
- static::assertInstanceOf(Actor::class, $actor);
- static::assertThrows(DuplicateFoundException::class, fn () => DB::findOneBy('actor', ['is_null' => 'bio']));
- static::assertThrows(NotFoundException::class, fn () => DB::findOneBy('actor', ['nickname' => 'nickname_not_in_use']));
- }
- public function testCount()
- {
- static::bootKernel();
- static::assertTrue(DB::count('actor', ['nickname' => 'taken_user']) == 1);
- static::assertTrue(DB::count('actor', []) != 1);
- }
- public function testPersistWithSameId()
- {
- $actor = Actor::create(['nickname' => 'test', 'bio' => 'some very interesting bio', 'is_local' => false, 'roles' => ActorLocalRoles::NONE, 'type' => Actor::PERSON]);
- $user = LocalUser::create(['nickname' => 'test']);
- $id = DB::persistWithSameId($actor, $user, fn ($id) => $id);
- static::assertTrue($id != 0);
- static::assertTrue($actor->getId() == $id);
- static::assertTrue($user->getId() == $id);
- }
- }
|