查询语言.flow

Testing Is Documentation

tests/Database/Query/FlowTest.php查询语言.flow - 图1

QueryPHP 数据构造器支持条件运算符，可以根据不同条件做不同的事情，支持所有的构造器函数，即返回 $this。

Uses

  1. <?php
  3. use Tests\Database\DatabaseTestCase as TestCase;

limit 限制条数

  1. public function testBaseUse(): void
  2. {
  3.     $connect = $this->createDatabaseConnectMock();
  5.     $sql = <<<'eot'
  6.         [
  7.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id ORDER BY `test_query`.`name` DESC LIMIT 1",
  8.             {
  9.                 "test_query_id": [
  10.                     2
  11.                 ]
  12.             },
  13.             false
  14.         ]
  15.         eot;
  17.     $id = 2;
  19.     $this->assertSame(
  20.         $sql,
  21.         $this->varJson(
  22.             $connect
  23.                 ->table('test_query')
  24.                 ->if(1 === $id)
  25.                 ->where('id', 1)
  26.                 ->elif(2 === $id)
  27.                 ->where('id', 2)
  28.                 ->orderBy('name DESC')
  29.                 ->elif(3 === $id)
  30.                 ->where('id', 3)
  31.                 ->where('id', 1111)
  32.                 ->elif(4 === $id)
  33.                 ->where('id', 4)
  34.                 ->fi()
  35.                 ->findOne(true)
  36.         )
  37.     );
  39.     $sql = <<<'eot'
  40.         [
  41.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
  42.             {
  43.                 "test_query_id": [
  44.                     1
  45.                 ]
  46.             },
  47.             false
  48.         ]
  49.         eot;
  51.     $id = 1;
  53.     $this->assertSame(
  54.         $sql,
  55.         $this->varJson(
  56.             $connect
  57.                 ->table('test_query')
  58.                 ->if(1 === $id)
  59.                 ->where('id', 1)
  60.                 ->elif(2 === $id)
  61.                 ->where('id', 2)
  62.                 ->orderBy('name DESC')
  63.                 ->elif(3 === $id)
  64.                 ->where('id', 3)
  65.                 ->where('id', 1111)
  66.                 ->elif(4 === $id)
  67.                 ->where('id', 4)
  68.                 ->fi()
  69.                 ->findOne(true),
  70.             1
  71.         )
  72.     );
  74.     $sql = <<<'eot'
  75.         [
  76.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id AND `test_query`.`id` = :test_query_id_1 LIMIT 1",
  77.             {
  78.                 "test_query_id": [
  79.                     3
  80.                 ],
  81.                 "test_query_id_1": [
  82.                     1111
  83.                 ]
  84.             },
  85.             false
  86.         ]
  87.         eot;
  89.     $id = 3;
  91.     $this->assertSame(
  92.         $sql,
  93.         $this->varJson(
  94.             $connect
  95.                 ->table('test_query')
  96.                 ->if(1 === $id)
  97.                 ->where('id', 1)
  98.                 ->elif(2 === $id)
  99.                 ->where('id', 2)
  100.                 ->orderBy('name DESC')
  101.                 ->elif(3 === $id)
  102.                 ->where('id', 3)
  103.                 ->where('id', 1111)
  104.                 ->elif(4 === $id)
  105.                 ->where('id', 4)
  106.                 ->fi()
  107.                 ->findOne(true),
  108.             2
  109.         )
  110.     );
  112.     $sql = <<<'eot'
  113.         [
  114.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
  115.             {
  116.                 "test_query_id": [
  117.                     4
  118.                 ]
  119.             },
  120.             false
  121.         ]
  122.         eot;
  124.     $id = 4;
  126.     $this->assertSame(
  127.         $sql,
  128.         $this->varJson(
  129.             $connect
  130.                 ->table('test_query')
  131.                 ->if(1 === $id)
  132.                 ->where('id', 1)
  133.                 ->elif(2 === $id)
  134.                 ->where('id', 2)
  135.                 ->orderBy('name DESC')
  136.                 ->elif(3 === $id)
  137.                 ->where('id', 3)
  138.                 ->where('id', 1111)
  139.                 ->elif(4 === $id)
  140.                 ->where('id', 4)
  141.                 ->fi()
  142.                 ->findOne(true),
  143.             3
  144.         )
  145.     );
  146. }

else 浅记忆

else 仅仅能记忆上一次 if,elif 的结果，上一次的反向结果就是 else 的条件值，我们建议不要在 SQL 链式中使用过度的条件判断。

  1. public function testElse(): void
  2. {
  3.     $connect = $this->createDatabaseConnectMock();
  5.     $sql = <<<'eot'
  6.         [
  7.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id AND `test_query`.`id` = :test_query_id_1 ORDER BY `test_query`.`name` DESC LIMIT 1",
  8.             {
  9.                 "test_query_id": [
  10.                     2
  11.                 ],
  12.                 "test_query_id_1": [
  13.                     4
  14.                 ]
  15.             },
  16.             false
  17.         ]
  18.         eot;
  20.     $id = 2;
  22.     $this->assertSame(
  23.         $sql,
  24.         $this->varJson(
  25.             $connect
  26.                 ->table('test_query')
  27.                 ->if(1 === $id)
  28.                 ->where('id', 1)
  29.                 ->elif(2 === $id)
  30.                 ->where('id', 2)
  31.                 ->orderBy('name DESC')
  32.                 ->elif(3 === $id)
  33.                 ->where('id', 3)
  34.                 ->where('id', 1111)
  35.                 ->else() // else 仅仅能记忆上一次 if,elif 的结果，上一次的反向结果就是 else 的条件值,其等价于 elif($id != 3)
  36.                 ->where('id', 4)
  37.                 ->fi()
  38.                 ->findOne(true)
  39.         )
  40.     );
  42.     $sql = <<<'eot'
  43.         [
  44.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id AND `test_query`.`id` = :test_query_id_1 LIMIT 1",
  45.             {
  46.                 "test_query_id": [
  47.                     3
  48.                 ],
  49.                 "test_query_id_1": [
  50.                     1111
  51.                 ]
  52.             },
  53.             false
  54.         ]
  55.         eot;
  57.     $id = 3;
  59.     $this->assertSame(
  60.         $sql,
  61.         $this->varJson(
  62.             $connect
  63.                 ->table('test_query')
  64.                 ->if(1 === $id)
  65.                 ->where('id', 1)
  66.                 ->elif(2 === $id)
  67.                 ->where('id', 2)
  68.                 ->orderBy('name DESC')
  69.                 ->elif(3 === $id)
  70.                 ->where('id', 3)
  71.                 ->where('id', 1111)
  72.                 ->else() // else 仅仅能记忆上一次 if,elif 的结果，上一次的反向结果就是 else 的条件值,其等价于 elif($id != 3)
  73.                 ->where('id', 4)
  74.                 ->fi()
  75.                 ->findOne(true),
  76.             1
  77.         )
  78.     );
  80.     $sql = <<<'eot'
  81.         [
  82.             "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
  83.             {
  84.                 "test_query_id": [
  85.                     4
  86.                 ]
  87.             },
  88.             false
  89.         ]
  90.         eot;
  92.     $id = 5;
  94.     $this->assertSame(
  95.         $sql,
  96.         $this->varJson(
  97.             $connect
  98.                 ->table('test_query')
  99.                 ->if(1 === $id)
  100.                 ->where('id', 1)
  101.                 ->elif(2 === $id)
  102.                 ->where('id', 2)
  103.                 ->orderBy('name DESC')
  104.                 ->elif(3 === $id)
  105.                 ->where('id', 3)
  106.                 ->where('id', 1111)
  107.                 ->else() // else 仅仅能记忆上一次 if,elif 的结果，上一次的反向结果就是 else 的条件值,其等价于 elif($id != 3)
  108.                 ->where('id', 4)
  109.                 ->fi()
  110.                 ->findOne(true),
  111.             2
  112.         )
  113.     );
  114. }

TIP

命令遵循 shell 命令风格，即 if,elif,else,fi。