更新实体

Testing Is Documentation

tests/Database/Ddd/Update/UpdateTest.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\DemoDatabaseEntity;
  7. use Tests\Database\Ddd\Entity\DemoEntity;
  8. use Tests\Database\Ddd\Entity\DemoReadonlyUpdateEntity;
  9. use Tests\Database\Ddd\Entity\DemoUpdateAutoFillEntity;
  10. use Tests\Database\Ddd\Entity\DemoUpdatePropWhiteEntity;

save 更新一个实体

存在主键数据，则可以通过 save 方法更新一个实体。

完整例子

  1. $entity = new DemoEntity(['id' => 1], true);
  2. $entity->name = 'foo';
  3. $entity->save()->flush();

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

完整模型

  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' => 1], true);
  4.     $entity->name = 'foo';
  6.     $this->assertInstanceof(Entity::class, $entity);
  7.     $this->assertSame(1, $entity->id);
  8.     $this->assertSame('foo', $entity->name);
  9.     $this->assertSame(['name'], $entity->changed());
  10.     $this->assertNull($entity->flushData());
  11.     $entity->save();
  13.     $data = <<<'eot'
  14.         [
  15.             {
  16.                 "id": 1
  17.             },
  18.             {
  19.                 "name": "foo"
  20.             }
  21.         ]
  22.         eot;
  24.     $this->assertSame(
  25.         $data,
  26.         $this->varJson(
  27.             $entity->flushData()
  28.         )
  29.     );
  30. }

TIP

通过 save 方法更新一个实体，并通过 flush 将实体持久化到数据库。

update 更新一个实体

  1. public function testUpdateBaseUse(): void
  2. {
  3.     $entity = new DemoEntity(['id' => 1], true);
  4.     $entity->name = 'foo';
  6.     $this->assertInstanceof(Entity::class, $entity);
  7.     $this->assertSame(1, $entity->id);
  8.     $this->assertSame('foo', $entity->name);
  9.     $this->assertSame(['name'], $entity->changed());
  10.     $this->assertNull($entity->flushData());
  11.     $entity->update();
  13.     $data = <<<'eot'
  14.         [
  15.             {
  16.                 "id": 1
  17.             },
  18.             {
  19.                 "name": "foo"
  20.             }
  21.         ]
  22.         eot;
  24.     $this->assertSame(
  25.         $data,
  26.         $this->varJson(
  27.             $entity->flushData()
  28.         )
  29.     );
  30. }

TIP

通过 update 方法保存一个实体，并通过 flush 将实体持久化到数据库。

更新一个实体支持更新属性白名单

完整模型

  1. namespace Tests\Database\Ddd\Entity;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  6. class DemoUpdatePropWhiteEntity 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::UPDATE_PROP_WHITE => true,
  19.             self::READONLY          => true,
  20.         ],
  21.         'name' => [
  22.             self::UPDATE_PROP_WHITE => true,
  23.         ],
  24.         'description' => [],
  25.     ];
  26. }

调用 \Leevel\Database\Ddd\Entity::UPDATE_PROP_WHITE => true 来设置字段白名单，一旦设置了更新属性白名单只有通过了白名单的字段才能够更新模型属性。

  1. public function testUpdatePropBlackAndWhite(): void
  2. {
  3.     $entity = new DemoUpdatePropWhiteEntity(['id' => 5], true);
  4.     $entity->name = 'foo';
  5.     $entity->description = 'hello description';
  6.     $entity->update();
  8.     $data = <<<'eot'
  9.         [
  10.             {
  11.                 "id": 5
  12.             },
  13.             {
  14.                 "name": "foo"
  15.             }
  16.         ]
  17.         eot;
  19.     $this->assertSame(
  20.         $data,
  21.         $this->varJson(
  22.             $entity->flushData()
  23.         )
  24.     );
  25. }

fill 设置允许自动填充字段

完整模型

  1. namespace Tests\Database\Ddd\Entity;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  6. class DemoUpdateAutoFillEntity 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.             self::UPDATE_FILL       => 'name for '.self::UPDATE_FILL,
  22.         ],
  23.         'description' => [
  24.             self::UPDATE_FILL    => null,
  25.         ],
  26.         'address' => [
  27.             self::UPDATE_FILL    => null,
  28.         ],
  29.         'foo_bar' => [
  30.             self::UPDATE_FILL    => null,
  31.         ],
  32.         'hello' => [
  33.             self::UPDATE_FILL      => null,
  34.         ],
  35.     ];
  37.     protected function fillDescription($old): string
  38.     {
  39.         return 'set description.';
  40.     }
  42.     protected function fillAddress($old): string
  43.     {
  44.         return 'address is set now.';
  45.     }
  47.     protected function fillFooBar($old): string
  48.     {
  49.         return 'foo bar.';
  50.     }
  52.     protected function fillHello($old): string
  53.     {
  54.         return 'hello field.';
  55.     }
  56. }
  1. public function testUpdateAutoFillWithCustomField(): void
  2. {
  3.     $entity = new DemoUpdateAutoFillEntity(['id' => 5], true);
  4.     $entity
  5.         ->fill(['address', 'hello'])
  6.         ->update();
  8.     $data = <<<'eot'
  9.         [
  10.             {
  11.                 "id": 5
  12.             },
  13.             {
  14.                 "address": "address is set now.",
  15.                 "hello": "hello field."
  16.             }
  17.         ]
  18.         eot;
  20.     $this->assertSame(
  21.         $data,
  22.         $this->varJson(
  23.             $entity->flushData()
  24.         )
  25.     );
  26. }

TIP

默认情况下，不会自动填充，除非指定允许填充字段。

fillAll 设置允许自动填充字段为所有字段

  1. public function testUpdateAutoFillWithAll(): void
  2. {
  3.     $entity = new DemoUpdateAutoFillEntity(['id' => 5], true);
  4.     $entity
  5.         ->fillAll()
  6.         ->update();
  8.     $data = <<<'eot'
  9.         [
  10.             {
  11.                 "id": 5
  12.             },
  13.             {
  14.                 "name": "name for update_fill",
  15.                 "description": "set description.",
  16.                 "address": "address is set now.",
  17.                 "foo_bar": "foo bar.",
  18.                 "hello": "hello field."
  19.             }
  20.         ]
  21.         eot;
  23.     $this->assertSame(
  24.         $data,
  25.         $this->varJson(
  26.             $entity->flushData()
  27.         )
  28.     );
  29. }

save 自动判断操作快捷方式支持添加数据

完整模型

  1. namespace Tests\Database\Ddd\Entity;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  6. class DemoDatabaseEntity 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.         'create_at' => [],
  22.     ];
  23. }
  1. public function testSaveWithProp(): void
  2. {
  3.     $entity = new DemoDatabaseEntity(['id' => 1], true);
  4.     $entity->save(['name' => 'hello']);
  6.     $data = <<<'eot'
  7.         [
  8.             {
  9.                 "id": 1
  10.             },
  11.             {
  12.                 "name": "hello"
  13.             }
  14.         ]
  15.         eot;
  17.     $this->assertSame(
  18.         $data,
  19.         $this->varJson(
  20.             $entity->flushData()
  21.         )
  22.     );
  23. }

update 更新快捷方式支持添加数据

  1. public function testUpdateWithProp(): void
  2. {
  3.     $entity = new DemoDatabaseEntity(['id' => 1]);
  4.     $entity->update(['name' => 'hello']);
  6.     $data = <<<'eot'
  7.         [
  8.             {
  9.                 "id": 1
  10.             },
  11.             {
  12.                 "name": "hello"
  13.             }
  14.         ]
  15.         eot;
  17.     $this->assertSame(
  18.         $data,
  19.         $this->varJson(
  20.             $entity->flushData()
  21.         )
  22.     );
  23. }

update 更新快捷方式存在更新数据才能够保存

  1. public function testUpdateWithNoDataAndDoNothing(): void
  2. {
  3.     $entity = new DemoDatabaseEntity(['id' => 1]);
  4.     $this->assertInstanceof(DemoDatabaseEntity::class, $entity->update());
  5.     $this->assertNull($entity->flushData());
  6. }

update 更新快捷方式存在主键数据才能够保存

  1. public function testUpdateWithPrimaryKeyData(): void
  2. {
  3.     $this->expectException(\InvalidArgumentException::class);
  4.     $this->expectExceptionMessage('Entity Tests\\Database\\Ddd\\Entity\\DemoDatabaseEntity has no primary key data.');
  6.     $entity = new DemoDatabaseEntity();
  7.     $entity->update();
  8. }

save 自动判断操作快捷方式复合主键例子

完整模型

  1. namespace Tests\Database\Ddd\Entity;
  3. use Leevel\Database\Ddd\Entity;
  4. use Leevel\Database\Ddd\GetterSetter;
  6. class CompositeId extends Entity
  7. {
  8.     use GetterSetter;
  10.     const TABLE = 'composite_id';
  12.     const ID = ['id1', 'id2'];
  14.     const AUTO = null;
  16.     const STRUCT = [
  17.         'id1'      => [],
  18.         'id2'      => [],
  19.         'name'     => [],
  20.     ];
  21. }
  1. public function testSaveWithCompositeId(): void
  2. {
  3.     $connect = $this->createDatabaseConnect();
  5.     $this->assertSame(
  6.         1,
  7.         $connect
  8.             ->table('composite_id')
  9.             ->insert([
  10.                 'id1'     => 2,
  11.                 'id2'     => 3,
  12.             ])
  13.     );
  15.     $entity = new CompositeId();
  16.     $entity->save(['id1' => 2, 'id2' => 3, 'name' => 'hello']);
  18.     $data = <<<'eot'
  19.         [
  20.             {
  21.                 "id1": 2,
  22.                 "id2": 3,
  23.                 "name": "hello"
  24.             }
  25.         ]
  26.         eot;
  28.     $this->assertSame(
  29.         $data,
  30.         $this->varJson(
  31.             $entity->flushData()
  32.         )
  33.     );
  35.     $entity->flush();
  37.     $sql = 'SQL: [173] UPDATE `composite_id` SET `composite_id`.`name` = :pdonamedparameter_name WHERE `composite_id`.`id1` = :composite_id_id1 AND `composite_id`.`id2` = :composite_id_id2 LIMIT 1 | Params:  3 | Key: Name: [23] :pdonamedparameter_name | paramno=0 | name=[23] ":pdonamedparameter_name" | is_param=1 | param_type=2 | Key: Name: [17] :composite_id_id1 | paramno=1 | name=[17] ":composite_id_id1" | is_param=1 | param_type=1 | Key: Name: [17] :composite_id_id2 | paramno=2 | name=[17] ":composite_id_id2" | is_param=1 | param_type=1 (UPDATE `composite_id` SET `composite_id`.`name` = \'hello\' WHERE `composite_id`.`id1` = 2 AND `composite_id`.`id2` = 3 LIMIT 1)';
  38.     $this->assertSame($sql, $entity->select()->getLastSql());
  39. }