实体查询

Testing Is Documentation

tests/Database/Ddd/SelectTest.php实体查询 - 图1

在设计实体的时候，我们是这样想的，查询不属于实体的一部分而应该是独立的，所以实体查询被抽象出来了。

Uses

  1. <?php
  3. use Exception;
  4. use Leevel\Collection\Collection;
  5. use Leevel\Database\Ddd\Entity;
  6. use Leevel\Database\Ddd\Select;
  7. use Leevel\Database\Page;
  8. use Tests\Database\DatabaseTestCase as TestCase;
  9. use Tests\Database\Ddd\Entity\CompositeId;
  10. use Tests\Database\Ddd\Entity\Relation\Post;

基本使用方法

  1. public function testBase(): 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.     $select = new Select(new Post());
  18.     $post = $select->findEntity(1);
  19.     $entity = $select->entity();
  21.     $this->assertInstanceof(Post::class, $post);
  22.     $this->assertSame(1, $post->id);
  23.     $this->assertSame(1, $post->userId);
  24.     $this->assertSame('hello world', $post->title);
  25.     $this->assertSame('post summary', $post->summary);
  26.     $this->assertInstanceof(Entity::class, $entity);
  27. }

findEntity 通过主键查找实体

  1. public function testFindEntity(): 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.     $select = new Select(new Post());
  18.     $post = $select->findEntity(1);
  20.     $this->assertInstanceof(Post::class, $post);
  21.     $this->assertSame(1, $post->id);
  22.     $this->assertSame(1, $post->userId);
  23.     $this->assertSame('hello world', $post->title);
  24.     $this->assertSame('post summary', $post->summary);
  25. }

复合主键请使用 where 条件查询

  1. public function testFindEntityForCompositeId(): 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.     $select = new Select(new CompositeId());
  17.     $entity = $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);
  22. }

findOrFail 通过主键查找实体，未找到则抛出异常

  1. public function testFindOrFail(): 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.     $select = new Select(new Post());
  18.     $post = $select->findOrFail(1);
  20.     $this->assertInstanceof(Post::class, $post);
  21.     $this->assertSame(1, $post->id);
  22.     $this->assertSame(1, $post->userId);
  23.     $this->assertSame('hello world', $post->title);
  24.     $this->assertSame('post summary', $post->summary);
  25. }

findOrFail 通过主键查找实体，未找到则抛出异常例子

  1. public function testFindOrFailThrowsException(): void
  2. {
  3.     $this->expectException(\Leevel\Database\Ddd\EntityNotFoundException::class);
  4.     $this->expectExceptionMessage(
  5.         'Entity `Tests\\Database\\Ddd\\Entity\\Relation\\Post` was not found.'
  6.     );
  8.     $select = new Select(new Post());
  9.     $post = $select->findOrFail(1);
  10. }

findMany 通过主键查找多个实体

  1. public function testFindMany(): 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.     $select = new Select(new Post());
  30.     $posts = $select->findMany([1, 2]);
  32.     $this->assertInstanceof(Collection::class, $posts);
  33.     $this->assertCount(2, $posts);
  35.     $post1 = $posts[0];
  36.     $this->assertInstanceof(Post::class, $post1);
  37.     $this->assertSame(1, $post1->userId);
  38.     $this->assertSame('hello world', $post1->title);
  39.     $this->assertSame('post summary', $post1->summary);
  41.     $post2 = $posts[1];
  42.     $this->assertInstanceof(Post::class, $post2);
  43.     $this->assertSame(1, $post2->userId);
  44.     $this->assertSame('hello world', $post2->title);
  45.     $this->assertSame('post summary', $post2->summary);
  46. }

findMany 通过主键查找多个实体未找到数据返回空集合

  1. public function testFindManyWithoutResults(): void
  2. {
  3.     $select = new Select(new Post());
  4.     $posts = $select->findMany([1, 2]);
  6.     $this->assertInstanceof(Collection::class, $posts);
  7.     $this->assertCount(0, $posts);
  8. }

实体查询默认不带软删除数据

  1. public function testEntityDefaultWithoutSoftDeleted(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $posts = $select->findAll();
  31.     $sql = <<<'eot'
  32.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  33.         eot;
  34.     $this->assertSame(
  35.         $sql,
  36.         $select->getLastSql(),
  37.     );
  39.     $this->assertInstanceof(Collection::class, $posts);
  40.     $this->assertCount(2, $posts);
  42.     $this->assertFalse($post->softDeleted());
  43.     $this->assertSame(1, Post::softDestroy([1]));
  44.     $this->assertFalse($post->softDeleted());
  46.     $posts = $select->findAll();
  47.     $sql = <<<'eot'
  48.         SQL: [72] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at_1 | Params:  1 | Key: Name: [17] :post_delete_at_1 | paramno=0 | name=[17] ":post_delete_at_1" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  49.         eot;
  50.     $this->assertSame(
  51.         $sql,
  52.         $select->getLastSql(),
  53.     );
  55.     $this->assertInstanceof(Collection::class, $posts);
  56.     $this->assertCount(1, $posts);
  58.     $posts = Post::select()->findAll();
  59.     $sql = <<<'eot'
  60.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  61.         eot;
  62.     $this->assertSame(
  63.         $sql,
  64.         $select->getLastSql(),
  65.     );
  67.     $this->assertInstanceof(Collection::class, $posts);
  68.     $this->assertCount(1, $posts);
  69. }

withSoftDeleted 包含软删除数据的实体查询对象（实体发起）

  1. public function testEntityWithSoftDeleted(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $posts = $select->findAll();
  31.     $sql = <<<'eot'
  32.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  33.         eot;
  34.     $this->assertSame(
  35.         $sql,
  36.         $select->getLastSql(),
  37.     );
  39.     $this->assertInstanceof(Collection::class, $posts);
  40.     $this->assertCount(2, $posts);
  42.     $this->assertFalse($post->softDeleted());
  43.     $this->assertSame(1, Post::softDestroy([1]));
  44.     $this->assertFalse($post->softDeleted());
  46.     $posts = $select->findAll();
  47.     $sql = <<<'eot'
  48.         SQL: [72] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at_1 | Params:  1 | Key: Name: [17] :post_delete_at_1 | paramno=0 | name=[17] ":post_delete_at_1" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  49.         eot;
  50.     $this->assertSame(
  51.         $sql,
  52.         $select->getLastSql(),
  53.     );
  55.     $this->assertInstanceof(Collection::class, $posts);
  56.     $this->assertCount(1, $posts);
  58.     $posts = Post::withSoftDeleted()->findAll();
  59.     $sql = <<<'eot'
  60.         SQL: [27] SELECT `post`.* FROM `post` | Params:  0 (SELECT `post`.* FROM `post`)
  61.         eot;
  62.     $this->assertSame(
  63.         $sql,
  64.         $select->getLastSql(),
  65.     );
  67.     $this->assertInstanceof(Collection::class, $posts);
  68.     $this->assertCount(2, $posts);
  69. }

onlySoftDeleted 仅仅包含软删除数据的实体查询对象（实体发起）

  1. public function testEntityOnlySoftDeleted(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $posts = $select->findAll();
  31.     $sql = <<<'eot'
  32.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  33.         eot;
  34.     $this->assertSame(
  35.         $sql,
  36.         $select->getLastSql(),
  37.     );
  39.     $this->assertInstanceof(Collection::class, $posts);
  40.     $this->assertCount(2, $posts);
  42.     $this->assertFalse($post->softDeleted());
  43.     $this->assertSame(1, Post::softDestroy([1]));
  44.     $this->assertFalse($post->softDeleted());
  46.     $posts = $select->findAll();
  47.     $sql = <<<'eot'
  48.         SQL: [72] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at_1 | Params:  1 | Key: Name: [17] :post_delete_at_1 | paramno=0 | name=[17] ":post_delete_at_1" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  49.         eot;
  50.     $this->assertSame(
  51.         $sql,
  52.         $select->getLastSql(),
  53.     );
  55.     $this->assertInstanceof(Collection::class, $posts);
  56.     $this->assertCount(1, $posts);
  58.     $posts = Post::onlySoftDeleted()->findAll();
  59.     $sql = <<<'eot'
  60.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` > :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` > 0)
  61.         eot;
  62.     $this->assertSame(
  63.         $sql,
  64.         $select->getLastSql(),
  65.     );
  67.     $this->assertInstanceof(Collection::class, $posts);
  68.     $this->assertCount(1, $posts);
  69. }

onlySoftDeleted 包含软删除数据的实体查询对象（实体查询发起）

  1. public function testWithSoftDeleted(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $posts = $select->findAll();
  31.     $sql = <<<'eot'
  32.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  33.         eot;
  34.     $this->assertSame(
  35.         $sql,
  36.         $select->getLastSql(),
  37.     );
  39.     $this->assertInstanceof(Collection::class, $posts);
  40.     $this->assertCount(2, $posts);
  42.     $this->assertFalse($post->softDeleted());
  43.     $this->assertSame(1, Post::softDestroy([1]));
  44.     $this->assertFalse($post->softDeleted());
  46.     $posts = $select->findAll();
  47.     $sql = <<<'eot'
  48.         SQL: [72] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at_1 | Params:  1 | Key: Name: [17] :post_delete_at_1 | paramno=0 | name=[17] ":post_delete_at_1" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  49.         eot;
  50.     $this->assertSame(
  51.         $sql,
  52.         $select->getLastSql(),
  53.     );
  55.     $this->assertInstanceof(Collection::class, $posts);
  56.     $this->assertCount(1, $posts);
  58.     $posts = $select->withSoftDeleted()->findAll();
  59.     $sql = <<<'eot'
  60.         SQL: [27] SELECT `post`.* FROM `post` | Params:  0 (SELECT `post`.* FROM `post`)
  61.         eot;
  62.     $this->assertSame(
  63.         $sql,
  64.         $select->getLastSql(),
  65.     );
  67.     $this->assertInstanceof(Collection::class, $posts);
  68.     $this->assertCount(2, $posts);
  69. }

onlySoftDeleted 仅仅包含软删除数据的实体查询对象（实体查询发起）

  1. public function testOnlySoftDeleted(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $posts = $select->findAll();
  31.     $sql = <<<'eot'
  32.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  33.         eot;
  34.     $this->assertSame(
  35.         $sql,
  36.         $select->getLastSql(),
  37.     );
  39.     $this->assertInstanceof(Collection::class, $posts);
  40.     $this->assertCount(2, $posts);
  42.     $this->assertFalse($post->softDeleted());
  43.     $this->assertSame(1, Post::softDestroy([1]));
  44.     $this->assertFalse($post->softDeleted());
  46.     $posts = $select->findAll();
  47.     $sql = <<<'eot'
  48.         SQL: [72] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at_1 | Params:  1 | Key: Name: [17] :post_delete_at_1 | paramno=0 | name=[17] ":post_delete_at_1" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0)
  49.         eot;
  50.     $this->assertSame(
  51.         $sql,
  52.         $select->getLastSql(),
  53.     );
  55.     $this->assertInstanceof(Collection::class, $posts);
  56.     $this->assertCount(1, $posts);
  58.     $posts = $select->onlySoftDeleted()->findAll();
  59.     $sql = <<<'eot'
  60.         SQL: [70] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` > :post_delete_at | Params:  1 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_delete_at" | is_param=1 | param_type=1 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` > 0)
  61.         eot;
  62.     $this->assertSame(
  63.         $sql,
  64.         $select->getLastSql(),
  65.     );
  67.     $this->assertInstanceof(Collection::class, $posts);
  68.     $this->assertCount(1, $posts);
  69. }

getLastSql 获取最近一次查询的 SQL 语句

  1. public function testLastSql(): 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.     $select = new Select(new Post());
  18.     $post = $select->findEntity(1);
  20.     $this->assertInstanceof(Post::class, $post);
  21.     $this->assertSame(1, $post->id);
  22.     $this->assertSame(1, $post->userId);
  23.     $this->assertSame('hello world', $post->title);
  24.     $this->assertSame('post summary', $post->summary);
  26.     $sql = <<<'eot'
  27.         SQL: [105] SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = :post_delete_at AND `post`.`id` = :post_id LIMIT 1 | Params:  2 | Key: Name: [15] :post_delete_at | paramno=0 | name=[15] ":post_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 (SELECT `post`.* FROM `post` WHERE `post`.`delete_at` = 0 AND `post`.`id` = 1 LIMIT 1)
  28.         eot;
  30.     $this->assertSame(
  31.         $sql,
  32.         $select->databaseConnect()->getLastSql(),
  33.     );
  34. }

withoutPreLoadsResult 获取不执行预载入的查询结果

  1. public function testWithoutPreLoadsResult(): 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.     $select = new Select(new Post());
  18.     $post = Select::withoutPreLoadsResult(function () use ($select) {
  19.         return $select->findEntity(1);
  20.     });
  22.     $this->assertInstanceof(Post::class, $post);
  23.     $this->assertSame(1, $post->id);
  24.     $this->assertSame(1, $post->userId);
  25.     $this->assertSame('hello world', $post->title);
  26.     $this->assertSame('post summary', $post->summary);
  27. }

eager 添加预载入关联查询

  1. public function testPreLoadPage(): 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.     $select = new Select($post = Post::select()->findEntity(1));
  30.     $select->eager(['user']);
  31.     $page = $select->page(1, 10);
  32.     $sql = <<<'eot'
  33.         SQL: [63] SELECT `user`.* FROM `user` WHERE `user`.`id` IN (:user_id_in0) | Params:  1 | Key: Name: [12] :user_id_in0 | paramno=0 | name=[12] ":user_id_in0" | is_param=1 | param_type=1 (SELECT `user`.* FROM `user` WHERE `user`.`id` IN (1))
  34.         eot;
  35.     $this->assertSame(
  36.         $sql,
  37.         $select->getLastSql(),
  38.     );
  40.     $this->assertInstanceof(Page::class, $page);
  41.     $data = $page->getData();
  42.     $this->assertCount(2, $data);
  43.     $this->assertInstanceof(Collection::class, $data);
  44.     $pageData = $page->toArray();
  45.     $this->assertCount(2, $pageData['data']);
  46.     $this->assertInstanceof(Collection::class, $pageData['data']);
  48.     $data = <<<'eot'
  49.         {
  50.             "per_page": 10,
  51.             "current_page": 1,
  52.             "total_page": 1,
  53.             "total_record": 2,
  54.             "total_macro": false,
  55.             "from": 0,
  56.             "to": 2
  57.         }
  58.         eot;
  60.     $this->assertSame(
  61.         $data,
  62.         $this->varJson(
  63.             $pageData['page']
  64.         )
  65.     );
  66. }