64 lines
2.3 KiB
PHP
Executable file
64 lines
2.3 KiB
PHP
Executable file
#!/usr/bin/env php
|
||
<?php
|
||
|
||
/**
|
||
|
||
title=测试 convertTao::getJiraUser();
|
||
timeout=0
|
||
cid=15854
|
||
|
||
- 步骤1：正常情况，返回1条记录 @1
|
||
- 步骤5：验证返回结果中AID为aabbccdd的记录的键值属性aabbccdd @user1
|
||
- 步骤5：验证返回结果中AID为eeffgghh的记录的键值属性eeffgghh @user2
|
||
- 步骤5：验证返回结果中AID为ddd的记录的键值属性ddd @~~
|
||
- 步骤5：验证返回结果中AID为fff的记录的键值属性fff @~~
|
||
|
||
*/
|
||
|
||
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
||
include dirname(__FILE__, 2) . '/lib/tao.class.php';
|
||
|
||
// 2. 创建临时表
|
||
global $tester;
|
||
$sql = <<<EOT
|
||
CREATE TABLE IF NOT EXISTS `jiratmprelation`(
|
||
`id` int(8) NOT NULL AUTO_INCREMENT,
|
||
`AType` char(30) NOT NULL,
|
||
`AID` char(100) NOT NULL,
|
||
`BType` char(30) NOT NULL,
|
||
`BID` char(100) NOT NULL,
|
||
`extra` char(100) NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `relation` (`AType`,`BType`,`AID`,`BID`)
|
||
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
EOT;
|
||
|
||
try {
|
||
$tester->dbh->exec($sql);
|
||
} catch (Exception $e) {
|
||
// 表可能已存在，忽略错误
|
||
}
|
||
|
||
su('admin');
|
||
$convertTest = new convertTaoTest();
|
||
|
||
try {
|
||
$tester->dbh->exec("DELETE FROM jiratmprelation");
|
||
$tester->dbh->exec("INSERT INTO jiratmprelation(AID, AType, BID, BType, extra) VALUES ('aabbccdd', 'juser', 'user1', 'zuser', ''), ('10001', 'jissue', '1', 'zbug', '')");
|
||
} catch (Exception $e) {
|
||
// 忽略可能的数据库错误
|
||
}
|
||
|
||
r(count($convertTest->getJiraUserTest())) && p() && e('1'); // 步骤1：正常情况，返回1条记录
|
||
|
||
try {
|
||
$tester->dbh->exec("DELETE FROM jiratmprelation");
|
||
$tester->dbh->exec("INSERT INTO jiratmprelation(AID, AType, BID, BType, extra) VALUES ('aabbccdd', 'juser', 'user1', 'zuser', ''), ('eeffgghh', 'juser', 'user2', 'zuser', '')");
|
||
} catch (Exception $e) {
|
||
// 忽略可能的数据库错误
|
||
}
|
||
r($convertTest->getJiraUserTest()) && p('aabbccdd') && e('user1'); // 步骤5：验证返回结果中AID为aabbccdd的记录的键值
|
||
r($convertTest->getJiraUserTest()) && p('eeffgghh') && e('user2'); // 步骤5：验证返回结果中AID为eeffgghh的记录的键值
|
||
r($convertTest->getJiraUserTest()) && p('ddd') && e('~~'); // 步骤5：验证返回结果中AID为ddd的记录的键值
|
||
r($convertTest->getJiraUserTest()) && p('fff') && e('~~'); // 步骤5：验证返回结果中AID为fff的记录的键值
|