117 lines
3.2 KiB
PHP
117 lines
3.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=biModel->buildSQL();
|
||
|
|
timeout=0
|
||
|
|
cid=15151
|
||
|
|
|
||
|
|
- 测试 简单sql @SELECT `id`, `name` FROM `zt_task`
|
||
|
|
|
||
|
|
- 测试 简单别名sql @SELECT `t1`.`id`, `t1`.`name` FROM `zt_task` AS `t1`
|
||
|
|
|
||
|
|
- 测试 联表sql @SELECT `t1`.`id`, `t1`.`name`, `t2`.`name` AS `execution` FROM `zt_task` AS `t1` LEFT JOIN `zt_project` AS `t2` ON `t1`.`execution` = `t2`.`id`
|
||
|
|
|
||
|
|
- 测试 分组sql @SELECT `t1`.`type`, SUM(`t1`.`consumed`) AS `consumed` FROM `zt_task` AS `t1` GROUP BY `t1`.`type`, YEAR(`t1`.`date`)
|
||
|
|
|
||
|
|
- 测试 查询条件sql @SELECT `t1`.`id` FROM `zt_task` AS `t1` WHERE `t1`.`deleted` = '0' AND (`t1`.`status` = 'done' OR (`t1`.`status` = 'closed' AND `t1`.`closedReason` = 'done'))
|
||
|
|
|
||
|
|
*/
|
||
|
|
|
||
|
|
$bi = new biModelTest();
|
||
|
|
|
||
|
|
$simple = array
|
||
|
|
(
|
||
|
|
'selects' => array
|
||
|
|
(
|
||
|
|
array('id'),
|
||
|
|
array('name')
|
||
|
|
),
|
||
|
|
'from' => array('zt_task')
|
||
|
|
);
|
||
|
|
|
||
|
|
r($bi->buildSQLTest($simple)) && p('') && e("SELECT `id`, `name` FROM `zt_task`"); // 测试 简单sql
|
||
|
|
|
||
|
|
$simple = array
|
||
|
|
(
|
||
|
|
'selects' => array
|
||
|
|
(
|
||
|
|
array('t1', 'id'),
|
||
|
|
array('t1', 'name')
|
||
|
|
),
|
||
|
|
'from' => array('zt_task', null, 't1')
|
||
|
|
);
|
||
|
|
|
||
|
|
r($bi->buildSQLTest($simple)) && p('') && e("SELECT `t1`.`id`, `t1`.`name` FROM `zt_task` AS `t1`"); // 测试 简单别名sql
|
||
|
|
|
||
|
|
$withJoin = array
|
||
|
|
(
|
||
|
|
'selects' => array
|
||
|
|
(
|
||
|
|
array('t1', 'id'),
|
||
|
|
array('t1', 'name'),
|
||
|
|
array('t2', 'name', 'execution')
|
||
|
|
),
|
||
|
|
'from' => array('zt_task', null, 't1'),
|
||
|
|
'joins' => array
|
||
|
|
(
|
||
|
|
array
|
||
|
|
(
|
||
|
|
'zt_project', 't2',
|
||
|
|
array(array('t1', 'execution', '=', 't2', 'id'))
|
||
|
|
)
|
||
|
|
)
|
||
|
|
);
|
||
|
|
|
||
|
|
r($bi->buildSQLTest($withJoin)) && p('') && e("SELECT `t1`.`id`, `t1`.`name`, `t2`.`name` AS `execution` FROM `zt_task` AS `t1` LEFT JOIN `zt_project` AS `t2` ON `t1`.`execution` = `t2`.`id`"); // 测试 联表sql
|
||
|
|
|
||
|
|
$withGroup = array
|
||
|
|
(
|
||
|
|
'selects' => array
|
||
|
|
(
|
||
|
|
array('t1', 'type')
|
||
|
|
),
|
||
|
|
'functions' => array
|
||
|
|
(
|
||
|
|
array('t1', 'consumed', 'consumed', 'sum')
|
||
|
|
),
|
||
|
|
'from' => array('zt_task', null, 't1'),
|
||
|
|
'groups' => array
|
||
|
|
(
|
||
|
|
array('t1', 'type'),
|
||
|
|
array('t1', 'date', null, 'year')
|
||
|
|
)
|
||
|
|
);
|
||
|
|
|
||
|
|
r($bi->buildSQLTest($withGroup)) && p('') && e("SELECT `t1`.`type`, SUM(`t1`.`consumed`) AS `consumed` FROM `zt_task` AS `t1` GROUP BY `t1`.`type`, YEAR(`t1`.`date`)"); // 测试 分组sql
|
||
|
|
|
||
|
|
$withWhere = array
|
||
|
|
(
|
||
|
|
'selects' => array
|
||
|
|
(
|
||
|
|
array('t1', 'id')
|
||
|
|
),
|
||
|
|
'from' => array('zt_task', null, 't1'),
|
||
|
|
'wheres' => array
|
||
|
|
(
|
||
|
|
array('t1', 'deleted', '=', null, "'0'"),
|
||
|
|
'and',
|
||
|
|
array
|
||
|
|
(
|
||
|
|
array('t1', 'status', '=' , null, "'done'"),
|
||
|
|
'or',
|
||
|
|
array
|
||
|
|
(
|
||
|
|
array('t1', 'status', '=', null, "'closed'"),
|
||
|
|
'and',
|
||
|
|
array('t1', 'closedReason', '=', null, "'done'")
|
||
|
|
)
|
||
|
|
)
|
||
|
|
)
|
||
|
|
);
|
||
|
|
|
||
|
|
r($bi->buildSQLTest($withWhere)) && p('') && e("SELECT `t1`.`id` FROM `zt_task` AS `t1` WHERE `t1`.`deleted` = '0' AND (`t1`.`status` = 'done' OR (`t1`.`status` = 'closed' AND `t1`.`closedReason` = 'done'))"); // 测试 查询条件sql
|