删除实体

Testing Is Documentation

tests/Database/Ddd/Delete/DeleteTest.php删除实体 - 图1

将实体从数据库中删除。

Uses

  1. <?php
  3. use Leevel\Database\Ddd\Entity;
  4. use Tests\Database\DatabaseTestCase as TestCase;
  5. use Tests\Database\Ddd\Entity\CompositeId;
  6. use Tests\Database\Ddd\Entity\DemoEntity;
  7. use Tests\Database\Ddd\Entity\EntityWithoutPrimaryKey;
  8. use Tests\Database\Ddd\Entity\Relation\Post;
  9. use Tests\Database\Ddd\Entity\Relation\PostContent;
  10. use Tests\Database\Ddd\Entity\SoftDeleteNotFoundDeleteAtField;

delete 删除一个实体

完整例子

  1. $entity = new DemoEntity(['id' => 5]);
  2. $entity->delete()->flush();

调用 delete 方法并没有立刻真正持久化到数据库，这一个步骤计算好了待删除的数据。

完整模型

  1. namespace Tests\Database\Ddd\Entity;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  6. class DemoEntity extends Entity
  7. {
  8.     use GetterSetter;
  10.     const TABLE = 'test';
  12.     const ID = 'id';
  14.     const AUTO = 'id';
  16.     const STRUCT = [
  17.         'id' => [
  18.             self::READONLY => true,
  19.         ],
  20.         'name' => [],
  21.     ];
  22. }
  1. public function testBaseUse(): void
  2. {
  3.     $entity = new DemoEntity(['id' => 5, 'name' => 'foo']);
  5.     $this->assertInstanceof(Entity::class, $entity);
  6.     $this->assertSame('foo', $entity->name);
  7.     $this->assertSame(['id', 'name'], $entity->changed());
  8.     $this->assertNull($entity->flushData());
  10.     $entity->delete();
  12.     $data = <<<'eot'
  13.         [
  14.             {
  15.                 "id": 5
  16.             }
  17.         ]
  18.         eot;
  20.     $this->assertSame(
  21.         $data,
  22.         $this->varJson(
  23.             $entity->flushData()
  24.         )
  25.     );
  27.     $entity->flush();
  28. }

TIP

通过 delete 方法删除一个实体，并通过 flush 将实体持久化到数据库。

softDelete 软删除一个实体

完整模型

  1. namespace Tests\Database\Ddd\Entity\Relation;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  5. use Leevel\Database\Ddd\Relation\Relation;
  7. class Post extends Entity
  8. {
  9.     use GetterSetter;
  11.     const TABLE = 'post';
  13.     const ID = 'id';
  15.     const AUTO = 'id';
  17.     const STRUCT = [
  18.         'id' => [
  19.             self::READONLY           => true,
  20.         ],
  21.         'title'     => [],
  22.         'user_id'   => [],
  23.         'summary'   => [],
  24.         'create_at' => [],
  25.         'delete_at' => [
  26.             self::CREATE_FILL => 0,
  27.         ],
  28.         'user'      => [
  29.             self::BELONGS_TO     => User::class,
  30.             self::SOURCE_KEY     => 'user_id',
  31.             self::TARGET_KEY     => 'id',
  32.         ],
  33.         'comment' => [
  34.             self::HAS_MANY          => Comment::class,
  35.             self::SOURCE_KEY        => 'id',
  36.             self::TARGET_KEY        => 'post_id',
  37.             self::RELATION_SCOPE    => 'comment',
  38.         ],
  39.         'post_content' => [
  40.             self::HAS_ONE     => PostContent::class,
  41.             self::SOURCE_KEY  => 'id',
  42.             self::TARGET_KEY  => 'post_id',
  43.         ],
  44.         'user_not_defined_source_key'      => [
  45.             self::BELONGS_TO     => User::class,
  46.             self::TARGET_KEY     => 'id',
  47.         ],
  48.         'user_not_defined_target_key'      => [
  49.             self::BELONGS_TO     => User::class,
  50.             self::SOURCE_KEY     => 'id',
  51.         ],
  52.         'comment_not_defined_source_key' => [
  53.             self::HAS_MANY          => Comment::class,
  54.             self::TARGET_KEY        => 'post_id',
  55.             self::RELATION_SCOPE    => 'comment',
  56.         ],
  57.         'comment_not_defined_target_key' => [
  58.             self::HAS_MANY          => Comment::class,
  59.             self::SOURCE_KEY        => 'id',
  60.             self::RELATION_SCOPE    => 'comment',
  61.         ],
  62.         'post_content_not_defined_source_key' => [
  63.             self::HAS_ONE     => PostContent::class,
  64.             self::TARGET_KEY  => 'post_id',
  65.         ],
  66.         'post_content_not_defined_target_key' => [
  67.             self::HAS_ONE     => PostContent::class,
  68.             self::SOURCE_KEY  => 'id',
  69.         ],
  70.     ];
  72.     const DELETE_AT = 'delete_at';
  74.     protected function relationScopeComment(Relation $relation): void
  75.     {
  76.         $relation->where('id', '>', 4);
  77.     }
  78. }
  1. public function testSoftDelete(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->softDelete()->flush();
  39.     $this->assertTrue($post->softDeleted());
  41.     $post1 = Post::withSoftDeleted()->findEntity(1);
  42.     $this->assertInstanceof(Post::class, $post1);
  43.     $this->assertSame(1, $post1->userId);
  44.     $this->assertSame('hello world', $post1->title);
  45.     $this->assertSame('post summary', $post1->summary);
  46.     $this->assertSame(date('Y-m'), date('Y-m', $post1->delete_at));
  48.     $post2 = Post::select()->findEntity(2);
  49.     $this->assertInstanceof(Post::class, $post2);
  50.     $this->assertSame(1, $post2->userId);
  51.     $this->assertSame('hello world', $post2->title);
  52.     $this->assertSame('post summary', $post2->summary);
  53.     $this->assertSame(0, $post2->delete_at);
  55.     $post1 = Post::select()->findEntity(1);
  56.     $this->assertInstanceof(Post::class, $post1);
  57.     $this->assertNull($post1->userId);
  58.     $this->assertNull($post1->title);
  59.     $this->assertNull($post1->summary);
  60.     $this->assertNull($post1->delete_at);
  61. }

softDestroy 根据主键 ID 软删除实体

  1. public function testSoftDestroy(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $this->assertSame(1, Post::softDestroy([1]));
  39.     $this->assertFalse($post->softDeleted());
  41.     $post1 = Post::withSoftDeleted()->findEntity(1);
  42.     $this->assertInstanceof(Post::class, $post1);
  43.     $this->assertSame(1, $post1->userId);
  44.     $this->assertSame('hello world', $post1->title);
  45.     $this->assertSame('post summary', $post1->summary);
  46.     $this->assertSame(date('Y-m'), date('Y-m', $post1->delete_at));
  48.     $post2 = Post::select()->findEntity(2);
  49.     $this->assertInstanceof(Post::class, $post2);
  50.     $this->assertSame(1, $post2->userId);
  51.     $this->assertSame('hello world', $post2->title);
  52.     $this->assertSame('post summary', $post2->summary);
  53.     $this->assertSame(0, $post2->delete_at);
  55.     $post1 = Post::select()->findEntity(1);
  56.     $this->assertInstanceof(Post::class, $post1);
  57.     $this->assertNull($post1->userId);
  58.     $this->assertNull($post1->title);
  59.     $this->assertNull($post1->summary);
  60.     $this->assertNull($post1->delete_at);
  61. }

destroy 根据主键 ID 删除实体

  1. public function testDestroy(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     Post::destroy([1]);
  39.     $post1 = Post::withSoftDeleted()->findEntity(1);
  40.     $this->assertInstanceof(Post::class, $post1);
  41.     $this->assertSame(1, $post1->userId);
  42.     $this->assertSame('hello world', $post1->title);
  43.     $this->assertSame('post summary', $post1->summary);
  44.     $this->assertSame(date('Y-m'), date('Y-m', $post1->delete_at));
  46.     $post2 = Post::select()->findEntity(2);
  47.     $this->assertInstanceof(Post::class, $post2);
  48.     $this->assertSame(1, $post2->userId);
  49.     $this->assertSame('hello world', $post2->title);
  50.     $this->assertSame('post summary', $post2->summary);
  51.     $this->assertSame(0, $post2->delete_at);
  53.     $post1 = Post::select()->findEntity(1);
  54.     $this->assertInstanceof(Post::class, $post1);
  55.     $this->assertNull($post1->userId);
  56.     $this->assertNull($post1->title);
  57.     $this->assertNull($post1->summary);
  58.     $this->assertNull($post1->delete_at);
  59. }

forceDestroy 根据主键 ID 强制删除实体

  1. public function testForceDestroy(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     Post::forceDestroy([1]);
  39.     $post1 = Post::withSoftDeleted()->findEntity(1);
  40.     $this->assertInstanceof(Post::class, $post1);
  41.     $this->assertNull($post1->userId);
  42.     $this->assertNull($post1->title);
  43.     $this->assertNull($post1->summary);
  44.     $this->assertNull($post1->delete_at);
  46.     $post2 = Post::select()->findEntity(2);
  47.     $this->assertInstanceof(Post::class, $post2);
  48.     $this->assertSame(1, $post2->userId);
  49.     $this->assertSame('hello world', $post2->title);
  50.     $this->assertSame('post summary', $post2->summary);
  51.     $this->assertSame(0, $post2->delete_at);
  53.     $post1 = Post::select()->findEntity(1);
  54.     $this->assertInstanceof(Post::class, $post1);
  55.     $this->assertNull($post1->userId);
  56.     $this->assertNull($post1->title);
  57.     $this->assertNull($post1->summary);
  58.     $this->assertNull($post1->delete_at);
  59. }

softRestore 恢复软删除的实体

  1. public function testSoftRestore(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->softDelete()->flush();
  39.     $this->assertTrue($post->softDeleted());
  41.     $post1 = Post::select()->findEntity(1);
  42.     $this->assertInstanceof(Post::class, $post1);
  43.     $this->assertNull($post1->userId);
  44.     $this->assertNull($post1->title);
  45.     $this->assertNull($post1->summary);
  46.     $this->assertNull($post1->delete_at);
  48.     $post1 = Post::withSoftDeleted()->findEntity(1);
  49.     $this->assertInstanceof(Post::class, $post1);
  50.     $this->assertSame(1, $post1->userId);
  51.     $this->assertSame('hello world', $post1->title);
  52.     $this->assertSame('post summary', $post1->summary);
  53.     $this->assertSame(date('Y-m'), date('Y-m', $post1->delete_at));
  55.     $post2 = Post::select()->findEntity(2);
  56.     $this->assertInstanceof(Post::class, $post2);
  57.     $this->assertSame(1, $post2->userId);
  58.     $this->assertSame('hello world', $post2->title);
  59.     $this->assertSame('post summary', $post2->summary);
  60.     $this->assertSame(0, $post2->delete_at);
  62.     $newPost = Post::withSoftDeleted()->findEntity(1);
  63.     $this->assertTrue($newPost->softDeleted());
  64.     $newPost->softRestore()->flush();
  65.     $this->assertFalse($newPost->softDeleted());
  67.     $restorePost1 = Post::select()->findEntity(1);
  68.     $this->assertSame(0, $restorePost1->delete_at);
  70.     $post1 = Post::withSoftDeleted()->findEntity(1);
  71.     $this->assertInstanceof(Post::class, $post1);
  72.     $this->assertSame(1, $post1->userId);
  73.     $this->assertSame('hello world', $post1->title);
  74.     $this->assertSame('post summary', $post1->summary);
  75.     $this->assertSame(0, $post1->delete_at);
  76. }

delete 删除实体

  1. public function testDelete(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->delete()->flush();
  39.     $sql = 'SQL: [104] UPDATE `post` SET `post`.`delete_at` = :pdonamedparameter_delete_at WHERE `post`.`id` = :post_id LIMIT 1 | Params:  2 | Key: Name: [28] :pdonamedparameter_delete_at | paramno=0 | name=[28] ":pdonamedparameter_delete_at" | is_param=1 | param_type=1 | Key: Name: [8] :post_id | paramno=1 | name=[8] ":post_id" | is_param=1 | param_type=1 (UPDATE `post` SET `post`.`delete_at` = %d WHERE `post`.`id` = 1 LIMIT 1)';
  40.     $time = time();
  41.     $this->assertTrue(in_array(Post::select()->getLastSql(), [sprintf($sql, $time), sprintf($sql, $time - 1), sprintf($sql, $time + 1)], true));
  42.     $this->assertTrue($post->softDeleted());
  44.     $post1 = Post::withSoftDeleted()->findEntity(1);
  45.     $this->assertInstanceof(Post::class, $post1);
  46.     $this->assertSame(1, $post1->userId);
  47.     $this->assertSame('hello world', $post1->title);
  48.     $this->assertSame('post summary', $post1->summary);
  49.     $this->assertSame(date('Y-m'), date('Y-m', $post1->delete_at));
  51.     $post2 = Post::select()->findEntity(2);
  52.     $this->assertInstanceof(Post::class, $post2);
  53.     $this->assertSame(1, $post2->userId);
  54.     $this->assertSame('hello world', $post2->title);
  55.     $this->assertSame('post summary', $post2->summary);
  56.     $this->assertSame(0, $post2->delete_at);
  58.     $post1 = Post::select()->findEntity(1);
  59.     $this->assertInstanceof(Post::class, $post1);
  60.     $this->assertNull($post1->userId);
  61.     $this->assertNull($post1->title);
  62.     $this->assertNull($post1->summary);
  63.     $this->assertNull($post1->delete_at);
  64. }

delete.condition 删除实体配合设置扩展查询条件

  1. public function testDeleteWithCondition(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->condition(['user_id' => 99999])->delete()->flush();
  39.     $sql = 'SQL: [141] UPDATE `post` SET `post`.`delete_at` = :pdonamedparameter_delete_at WHERE `post`.`user_id` = :post_user_id AND `post`.`id` = :post_id LIMIT 1 | Params:  3 | Key: Name: [28] :pdonamedparameter_delete_at | paramno=0 | name=[28] ":pdonamedparameter_delete_at" | is_param=1 | param_type=1 | Key: Name: [13] :post_user_id | paramno=1 | name=[13] ":post_user_id" | is_param=1 | param_type=1 | Key: Name: [8] :post_id | paramno=2 | name=[8] ":post_id" | is_param=1 | param_type=1 (UPDATE `post` SET `post`.`delete_at` = %d WHERE `post`.`user_id` = 99999 AND `post`.`id` = 1 LIMIT 1)';
  40.     $time = time();
  41.     $this->assertTrue(in_array(Post::select()->getLastSql(), [sprintf($sql, $time), sprintf($sql, $time - 1), sprintf($sql, $time + 1)], true));
  42.     $this->assertTrue($post->softDeleted());
  44.     $post1 = Post::withSoftDeleted()->findEntity(1);
  45.     $this->assertInstanceof(Post::class, $post1);
  46.     $this->assertSame(1, $post1->userId);
  47.     $this->assertSame('hello world', $post1->title);
  48.     $this->assertSame('post summary', $post1->summary);
  49.     $this->assertSame(0, $post1->delete_at);
  51.     $post2 = Post::select()->findEntity(2);
  52.     $this->assertInstanceof(Post::class, $post2);
  53.     $this->assertSame(1, $post2->userId);
  54.     $this->assertSame('hello world', $post2->title);
  55.     $this->assertSame('post summary', $post2->summary);
  56.     $this->assertSame(0, $post2->delete_at);
  58.     $post1 = Post::select()->findEntity(1);
  59.     $this->assertInstanceof(Post::class, $post1);
  60.     $this->assertSame(1, $post1->userId);
  61.     $this->assertSame('hello world', $post1->title);
  62.     $this->assertSame('post summary', $post1->summary);
  63.     $this->assertSame(0, $post1->delete_at);
  64. }

delete 复合主键删除实体

  1. public function testDeleteForCompositeId(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('composite_id')
  9.             ->insert([
  10.                 'id1'  => 1,
  11.                 'id2'  => 2,
  12.                 'name' => 'hello liu',
  13.             ])
  14.     );
  16.     $entity = CompositeId::select()->where(['id1' => 1, 'id2' => 2])->findOne();
  18.     $this->assertInstanceof(CompositeId::class, $entity);
  19.     $this->assertSame(1, $entity->id1);
  20.     $this->assertSame(2, $entity->id2);
  21.     $this->assertSame('hello liu', $entity->name);
  23.     $entity->delete()->flush();
  25.     $entity = CompositeId::select()->where(['id1' => 1, 'id2' => 2])->findOne();
  27.     $this->assertInstanceof(CompositeId::class, $entity);
  28.     $this->assertNull($entity->id1);
  29.     $this->assertNull($entity->id2);
  30.     $this->assertNull($entity->name);
  31. }

forceDelete 强制删除实体

  1. public function testForceDelete(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->forceDelete()->flush();
  39.     $this->assertSame('SQL: [55] DELETE FROM `post` WHERE `post`.`id` = :post_id LIMIT 1 | Params:  1 | Key: Name: [8] :post_id | paramno=0 | name=[8] ":post_id" | is_param=1 | param_type=1 (DELETE FROM `post` WHERE `post`.`id` = 1 LIMIT 1)', Post::select()->getLastSql());
  40.     $this->assertFalse($post->softDeleted());
  42.     $post1 = Post::withSoftDeleted()->findEntity(1);
  43.     $this->assertInstanceof(Post::class, $post1);
  44.     $this->assertNull($post1->userId);
  45.     $this->assertNull($post1->title);
  46.     $this->assertNull($post1->summary);
  47.     $this->assertNull($post1->delete_at);
  49.     $post2 = Post::select()->findEntity(2);
  50.     $this->assertInstanceof(Post::class, $post2);
  51.     $this->assertSame(1, $post2->userId);
  52.     $this->assertSame('hello world', $post2->title);
  53.     $this->assertSame('post summary', $post2->summary);
  54.     $this->assertSame(0, $post2->delete_at);
  56.     $post1 = Post::select()->findEntity(1);
  57.     $this->assertInstanceof(Post::class, $post1);
  58.     $this->assertNull($post1->userId);
  59.     $this->assertNull($post1->title);
  60.     $this->assertNull($post1->summary);
  61.     $this->assertNull($post1->delete_at);
  62. }

forceDelete.condition 强制删除实体配合设置扩展查询条件

  1. public function testForceDeleteWithCondition(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('post')
  9.             ->insert([
  10.                 'title'     => 'hello world',
  11.                 'user_id'   => 1,
  12.                 'summary'   => 'post summary',
  13.                 'delete_at' => 0,
  14.             ])
  15.     );
  17.     $this->assertSame(
  18.         2,
  19.         $connect
  20.             ->table('post')
  21.             ->insert([
  22.                 'title'     => 'hello world',
  23.                 'user_id'   => 1,
  24.                 'summary'   => 'post summary',
  25.                 'delete_at' => 0,
  26.             ])
  27.     );
  29.     $post = Post::select()->findEntity(1);
  31.     $this->assertInstanceof(Post::class, $post);
  32.     $this->assertSame(1, $post->userId);
  33.     $this->assertSame('hello world', $post->title);
  34.     $this->assertSame('post summary', $post->summary);
  35.     $this->assertSame(0, $post->delete_at);
  37.     $this->assertFalse($post->softDeleted());
  38.     $post->condition(['user_id' => 99999])->forceDelete()->flush();
  39.     $this->assertSame('SQL: [92] DELETE FROM `post` WHERE `post`.`user_id` = :post_user_id AND `post`.`id` = :post_id LIMIT 1 | Params:  2 | Key: Name: [13] :post_user_id | paramno=0 | name=[13] ":post_user_id" | is_param=1 | param_type=1 | Key: Name: [8] :post_id | paramno=1 | name=[8] ":post_id" | is_param=1 | param_type=1 (DELETE FROM `post` WHERE `post`.`user_id` = 99999 AND `post`.`id` = 1 LIMIT 1)', Post::select()->getLastSql());
  40.     $this->assertFalse($post->softDeleted());
  42.     $post1 = Post::withSoftDeleted()->findEntity(1);
  43.     $this->assertInstanceof(Post::class, $post1);
  44.     $this->assertSame(1, $post1->userId);
  45.     $this->assertSame('hello world', $post1->title);
  46.     $this->assertSame('post summary', $post1->summary);
  47.     $this->assertSame(0, $post1->delete_at);
  49.     $post2 = Post::select()->findEntity(2);
  50.     $this->assertInstanceof(Post::class, $post2);
  51.     $this->assertSame(1, $post2->userId);
  52.     $this->assertSame('hello world', $post2->title);
  53.     $this->assertSame('post summary', $post2->summary);
  54.     $this->assertSame(0, $post2->delete_at);
  56.     $post1 = Post::select()->findEntity(1);
  57.     $this->assertInstanceof(Post::class, $post1);
  58.     $this->assertSame(1, $post1->userId);
  59.     $this->assertSame('hello world', $post1->title);
  60.     $this->assertSame('post summary', $post1->summary);
  61.     $this->assertSame(0, $post1->delete_at);
  62. }