26 lines
1.2 KiB
PHP
26 lines
1.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::getSQL();
|
|||
|
|
timeout=0
|
|||
|
|
cid=15180
|
|||
|
|
|
|||
|
|
- 测试mysql驱动，简单SELECT语句，默认分页 @2
|
|||
|
|
- 测试mysql驱动，带WHERE条件，自定义分页 @2
|
|||
|
|
- 测试duckdb驱动，返回数组长度 @2
|
|||
|
|
- 测试dm驱动，返回数组长度 @2
|
|||
|
|
- 测试复杂JOIN查询，mysql驱动 @2
|
|||
|
|
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
$bi = new biModelTest();
|
|||
|
|
|
|||
|
|
r($bi->getSQLTest('SELECT id FROM zt_user', 'mysql')) && p() && e('2'); // 测试mysql驱动，简单SELECT语句，默认分页
|
|||
|
|
r($bi->getSQLTest('SELECT id FROM zt_user WHERE id > 0', 'mysql', 5, 2)) && p() && e('2'); // 测试mysql驱动，带WHERE条件，自定义分页
|
|||
|
|
r($bi->getSQLTest('SELECT id FROM zt_user', 'duckdb')) && p() && e('2'); // 测试duckdb驱动，返回数组长度
|
|||
|
|
r($bi->getSQLTest('SELECT id FROM zt_user', 'dm')) && p() && e('2'); // 测试dm驱动，返回数组长度
|
|||
|
|
r($bi->getSQLTest('SELECT u.id FROM zt_user u JOIN zt_dept d ON u.dept = d.id', 'mysql')) && p() && e('2'); // 测试复杂JOIN查询，mysql驱动
|