38 lines
2.2 KiB
PHP
38 lines
2.2 KiB
PHP
|
#!/usr/bin/env php
|
|||
|
|
<?php
|
|||
|
|
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
|||
|
|
include dirname(__FILE__, 2) . '/lib/model.class.php';
|
|||
|
|
/**
|
|||
|
|
|
|||
|
|
title=测试 executionModel->getExecutionQuery();
|
|||
|
|
timeout=0
|
|||
|
|
cid=16314
|
|||
|
|
|
|||
|
|
- 没有queryID时，获取查询执行的SQL @(( 1 ) AND ( 1 AND t1.`status` = 'doing'))
|
|||
|
|
- 有queryID时，获取查询执行的SQL @(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))
|
|||
|
|
- queryID不存在时，获取查询执行的SQL @(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))
|
|||
|
|
- queryID不存在时，获取查询执行的SQL @(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))
|
|||
|
|
- queryID不存在时，获取查询执行的SQL @(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))
|
|||
|
|
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
zenData('user')->gen(5);
|
|||
|
|
su('admin');
|
|||
|
|
|
|||
|
|
$userquery = zenData('userquery');
|
|||
|
|
$userquery->id->range(1);
|
|||
|
|
$userquery->account->range('admin');
|
|||
|
|
$userquery->module->range('execution');
|
|||
|
|
$userquery->title->range('搜索进行中的迭代');
|
|||
|
|
$userquery->sql->range("`(( 1 AND `name` LIKE '迭代' ) AND ( 1 AND `status` = 'doing' ))`");
|
|||
|
|
$userquery->form->range('``');
|
|||
|
|
$userquery->gen(1);
|
|||
|
|
|
|||
|
|
$queryIdList = array(0, 1, 2, 3, 4);
|
|||
|
|
$executionTester = new executionModelTest();
|
|||
|
|
r($executionTester->getExecutionQueryTest($queryIdList[0])) && p() && e("(( 1 ) AND ( 1 AND t1.`status` = 'doing'))"); // 没有queryID时，获取查询执行的SQL
|
|||
|
|
r($executionTester->getExecutionQueryTest($queryIdList[1])) && p() && e("(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))"); // 有queryID时，获取查询执行的SQL
|
|||
|
|
r($executionTester->getExecutionQueryTest($queryIdList[2])) && p() && e("(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))"); // queryID不存在时，获取查询执行的SQL
|
|||
|
|
r($executionTester->getExecutionQueryTest($queryIdList[3])) && p() && e("(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))"); // queryID不存在时，获取查询执行的SQL
|
|||
|
|
r($executionTester->getExecutionQueryTest($queryIdList[4])) && p() && e("(( 1 AND t1.`name` LIKE '迭代' ) AND ( 1 AND t1.`status` = 'doing' ))"); // queryID不存在时，获取查询执行的SQL
|