47 lines
4.1 KiB
PHP
Executable file
47 lines
4.1 KiB
PHP
Executable file
#!/usr/bin/env php
|
||
<?php
|
||
|
||
/**
|
||
|
||
title=测试 searchModel::buildIndexQuery();
|
||
timeout=0
|
||
cid=18293
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'program' @SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'program' AND t1.deleted = '0'
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'story' @SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'story' AND t1.version=t2.version
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'doc' @SELECT DISTINCT t1.*, t2.content, t2.digest FROM `zt_doc` AS t1 LEFT JOIN `zt_doccontent` AS t2 ON t1.id=t2.doc WHERE t1.deleted = '0' AND t1.version=t2.version
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'project' @SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'project' AND t1.deleted = '0'
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'execution' @SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` IN ('stage','sprint','kanban') AND t1.deleted = '0'
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'requirement' @SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'requirement' AND t1.version=t2.version
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'epic' @SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'epic' AND t1.version=t2.version
|
||
|
||
- 执行searchTest模块的buildIndexQueryTest方法，参数是'project', false @SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'project'
|
||
|
||
*/
|
||
|
||
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
||
include dirname(__FILE__, 2) . '/lib/model.class.php';
|
||
|
||
// 准备测试数据
|
||
zenData('project')->gen(5);
|
||
zenData('story')->gen(5);
|
||
zenData('doc')->gen(5);
|
||
|
||
// 用户登录
|
||
su('admin');
|
||
|
||
// 创建测试实例
|
||
$searchTest = new searchModelTest();
|
||
|
||
r($searchTest->buildIndexQueryTest('program')) && p() && e("SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'program' AND t1.deleted = '0'");
|
||
r($searchTest->buildIndexQueryTest('story')) && p() && e("SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'story' AND t1.version=t2.version");
|
||
r($searchTest->buildIndexQueryTest('doc')) && p() && e("SELECT DISTINCT t1.*, t2.content, t2.digest FROM `zt_doc` AS t1 LEFT JOIN `zt_doccontent` AS t2 ON t1.id=t2.doc WHERE t1.deleted = '0' AND t1.version=t2.version");
|
||
r($searchTest->buildIndexQueryTest('project')) && p() && e("SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'project' AND t1.deleted = '0'");
|
||
r($searchTest->buildIndexQueryTest('execution')) && p() && e("SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` IN ('stage','sprint','kanban') AND t1.deleted = '0'");
|
||
r($searchTest->buildIndexQueryTest('requirement')) && p() && e("SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'requirement' AND t1.version=t2.version");
|
||
r($searchTest->buildIndexQueryTest('epic')) && p() && e("SELECT DISTINCT t1.*, t2.spec, t2.verify FROM `zt_story` AS t1 LEFT JOIN `zt_storyspec` AS t2 ON t1.id=t2.story WHERE t1.deleted = '0' AND `type` = 'epic' AND t1.version=t2.version");
|
||
r($searchTest->buildIndexQueryTest('project', false)) && p() && e("SELECT t1.* FROM `zt_project` AS t1 WHERE (t1.`isTpl` = '0' OR t1.`isTpl` IS NULL) AND 1=1 AND `type` = 'project'"); |