コード例 #1
0
ファイル: test_base_model.php プロジェクト: phpdn/xiunophp
xn_assert('b->count("+2")', $r == 2);
$arr = $b->get(2);
xn_assert('b->get("+2")', count($arr) == 2);
$list = $b->index_fetch($cond = array(), $orderby = array('uid' => -1), 0, $pagesize = 30);
print_r($list);
// ---------------------> 测试主键包含多列字段的情况, 实例 primary key(fid, user)
$b = new base_model();
$b->db->query(" DROP TABLE IF EXISTS `xn_mblog`");
$b->db->query("\n\t CREATE TABLE `xn_mblog` (                                \n           `fid` int(11) unsigned NOT NULL default '0',       \n           `blogid` int(11) unsigned NOT NULL default '0',       \n           `uid` int(11) unsigned NOT NULL default '0',       \n           `dateline` int(11) unsigned NOT NULL default '0',     \n           `subject` char(80) NOT NULL default '',               \n           `message` longtext NOT NULL,                          \n           `username` char(16) NOT NULL default '',              \n           `isprivate` tinyint(4) NOT NULL default '0',          \n           PRIMARY KEY  (`fid`, `blogid`),                              \n           KEY `uidblogid` (`uid`,`blogid`)                \n         ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8  \n");
$b->table = 'mblog';
$b->primarykey = array('fid', 'blogid');
$b->cacheconf['enable'] = FALSE;
$n = $b->count(0);
xn_assert('b->count(0)', $n == 0);
$m = $b->maxid(0);
xn_assert('b->maxid(0)', $m == 0);
$m = $b->maxid('+1');
xn_assert('b->maxid(\'+1\')', $m == 1);
$r = $b->set(1, 1, array('subject' => 'this is subject 111 .', 'message' => 'this is message 111'));
xn_assert('b->set(1)', $r);
$m = $b->maxid('+1');
xn_assert('b->maxid(\'+1\')', $m == 2);
$r = $b->set(1, 2, array('subject' => 'this is subject 222 .', 'message' => 'this is message 222'));
xn_assert('b->set(2)', $r);
$r = $b->count('+2');
$r = $b->count('+2');
xn_assert('b->count("+2")', $r == 4);
$arr = $b->get(1, 2);
xn_assert('b->get("+2")', count($arr) == 2);
$list = $b->index_fetch($cond = array('fid' => 1), $orderby = array('uid' => -1), 0, $pagesize = 30);
print_r($list);