28 lines
1.5 KiB
PHP
28 lines
1.5 KiB
PHP
|
#!/usr/bin/env php
|
|||
|
|
<?php
|
|||
|
|
|
|||
|
|
/**
|
|||
|
|
|
|||
|
|
title=测试 pivotModel::initSql();
|
|||
|
|
timeout=0
|
|||
|
|
cid=17409
|
|||
|
|
|
|||
|
|
- 执行pivot模块的initSqlTest方法，参数是'select id, name from zt_user;;;;', array @select id,name from zt_user
|
|||
|
|
|
|||
|
|
- 执行pivot模块的initSqlTest方法，参数是'select * from zt_user where name = $username', array @select * from zt_user where name = ''
|
|||
|
|
- 执行pivot模块的initSqlTest方法，参数是'select id from zt_user', array 属性1 @~~
|
|||
|
|
- 执行pivot模块的initSqlTest方法，参数是'select * from zt_task', array 属性1 @ where tt.`status` like %wait%
|
|||
|
|
- 执行pivot模块的initSqlTest方法，参数是'select count 属性2 @ group by
|
|||
|
|
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
|||
|
|
include dirname(__FILE__, 2) . '/lib/model.class.php';
|
|||
|
|
|
|||
|
|
$pivot = new pivotModelTest();
|
|||
|
|
|
|||
|
|
r($pivot->initSqlTest('select id,name from zt_user;;;;', array('name' => array('field' => 'name', 'operator' => '=', 'value' => 'admin')), 'id,name')) && p('0') && e('select id,name from zt_user');
|
|||
|
|
r($pivot->initSqlTest('select * from zt_user where name = $username', array(), 'id')) && p('0') && e("select * from zt_user where name = ''");
|
|||
|
|
r($pivot->initSqlTest('select id from zt_user', array(), 'id')) && p('1') && e('~~');
|
|||
|
|
r($pivot->initSqlTest('select * from zt_task', array('status' => array('field' => 'status', 'operator' => 'like', 'value' => '%wait%')), 'status')) && p('1') && e(' where tt.`status` like %wait%');
|
|||
|
|
r($pivot->initSqlTest('select count(*) from zt_bug', array(), '')) && p('2') && e(' group by ');
|