32 lines
2 KiB
PHP
Executable file
32 lines
2 KiB
PHP
Executable file
#!/usr/bin/env php
|
||
<?php
|
||
|
||
/**
|
||
|
||
title=测试 biModel::getOptionsFromSql();
|
||
timeout=0
|
||
cid=15177
|
||
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'account' 属性1 @admin
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'account' 属性2 @user1
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT id, realname FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'realname' 属性1 @admin
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'nonexistent', 'account' @0
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'nonexistent' @0
|
||
- 执行biTest模块的getOptionsFromSqlTest方法，参数是'SELECT count 属性10 @total
|
||
|
||
*/
|
||
|
||
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
||
include dirname(__FILE__, 2) . '/lib/model.class.php';
|
||
|
||
zenData('user')->gen(10);
|
||
su('admin');
|
||
|
||
$biTest = new biModelTest();
|
||
|
||
r($biTest->getOptionsFromSqlTest('SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'account')) && p('1') && e('admin');
|
||
r($biTest->getOptionsFromSqlTest('SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'account')) && p('2') && e('user1');
|
||
r($biTest->getOptionsFromSqlTest('SELECT id, realname FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'realname')) && p('1') && e('admin');
|
||
r(count($biTest->getOptionsFromSqlTest('SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'nonexistent', 'account'))) && p() && e(0);
|
||
r(count($biTest->getOptionsFromSqlTest('SELECT id, account FROM zt_user WHERE deleted = "0"', 'mysql', 'id', 'nonexistent'))) && p() && e(0);
|
||
r($biTest->getOptionsFromSqlTest('SELECT count(*) as cnt, "total" as label FROM zt_user', 'mysql', 'cnt', 'label')) && p('10') && e('total'); |