Ejemplos de bbs_assert en PHP

Ejemplo n.º 1

Archivo: test_db_mysql.php Proyecto: phpdn/xiunophp

$uid = $db->maxid('fuser-uid', '+1');
bbs_assert("maxid('fuser-uid', '+1')", $uid == 1);
$r = $db->set("fuser-fid-1-uid-{$uid}", array('username' => 'admin1', 'email' => '*****@*****.**'));
bbs_assert("set()", $r == TRUE);
// 增加一条记录:
$uid = $db->maxid('fuser-uid', '+1');
bbs_assert("maxid('fuser-uid', '+1')", $uid == 2);
$r = $db->set("fuser-fid-1-uid-{$uid}", array('username' => 'admin2', 'email' => '*****@*****.**'));
// 增加一条记录:
$uid = $db->maxid('fuser-uid', '+1');
bbs_assert("maxid('fuser-uid', '+1')", $uid == 3);
$r = $db->set("fuser-fid-1-uid-{$uid}", array('username' => 'admin3', 'email' => '*****@*****.**'));
$n = $db->count('fuser', '+3');
bbs_assert("count('fuser', '+3')", $n == 3);
// 取一条数据
$arr = $db->get('fuser-fid-1-uid-1');
bbs_assert("get('fuser-fid-1-uid-1')", $arr['username'] == 'admin1');
// 删除一条记录
$r = $db->delete("fuser-fid-1-uid-1");
bbs_assert("delete('fuser-fid-1-uid-1')", $r == TRUE);
$n = $db->count('fuser', '-1');
bbs_assert("count('fuser', '-1')", $n == 2);
$arr = $db->get("fuser-fid-1-uid-1");
bbs_assert("delete('fuser-fid-1-uid-1')", $arr == array());
// 翻页取数据
$n = $db->count('fuser');
bbs_assert("count('fuser')", $n == 2);
// 翻页取数据
$userlist = $db->index_fetch($table = 'fuser', $key = array('fid', 'uid'), $cond = array('uid' => array('>' => 0)), $sort = array(), $start = 0, $limit = 10);
print_r($userlist);
//print_r($_SERVER['sqls']);

Ejemplo n.º 2

Archivo: test_db_pdo_mysql.php Proyecto: phpdn/xiunophp

bbs_assert("maxid('user', '+1')", $uid == 3);
$r = $db->set("user-uid-{$uid}", array('username' => 'admin3', 'email' => '*****@*****.**'));
$n = $db->count('user', '+3');
bbs_assert("count('user', '+3')", $n == 3);
// 取一条数据
$arr = $db->get('user-uid-1');
bbs_assert("get('user-uid-1')", $arr['username'] == 'admin1');
$n = $db->index_update('user', array('uid' => array('>=' => 1)), array('posts' => 123));
$user = $db->get('user-uid-1');
bbs_assert("index_update()", $n == 3);
bbs_assert("index_update()", $user['posts'] == 123);
// 删除一条记录
$r = $db->delete("user-uid-1");
bbs_assert("delete('user-uid-1')", $r == TRUE);
$n = $db->count('user', '-1');
bbs_assert("count('user', '-1')", $n == 2);
$arr = $db->get("user-uid-1");
bbs_assert("delete('user-uid-1')", $arr == array());
// 翻页取数据
$n = $db->count('user');
bbs_assert("count('user')", $n == 2);
// 翻页取数据
$userlist = $db->index_fetch($table = 'user', $key = 'uid', $cond = array('uid' => array('>' => 0)), $sort = array(), $start = 0, $limit = 10);
print_r($userlist);
// 删除所有数据
$n = $db->index_delete('user', array('uid' => array('>' => 1)));
$user = $db->get('user-uid-1');
$user2 = $db->get('user-uid-2');
bbs_assert("index_delete()", $user['uid'] == 1);
bbs_assert("index_delete()", empty($user));
print_r($_SERVER['sqls']);