
平台论坛博客文库

› 论坛 › 程序设计 › Web开发 › Yii framework CRUD code sytax (all)

Yii framework CRUD code sytax (all) [复制链接]

liu1084

丰衣足食

论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-12-20 09:48 |只看该作者 |倒序浏览

<?php
class PostTest extends CDbTestCase{
public $fixtures = array(
'posts' => 'Post',
'tags' => 'Tag',
);
public function testFindPost(){
//调用 find 时，我们使用 $condition 和 $params 指定查询条件。
//此处 $condition 可以是 SQL 语句中的 WHERE 字符串，$params 则是一个参数数组，
//其中的值应绑定到 $condation 中的占位符。
$post = $this->posts('post1');
$fPost = Post::model()->find('id = :id', array(':id' => $post->id));
//SELECT * FROM `tbl_post` `t` WHERE `t`.`id`=1 LIMIT 1
$fPost = Post::model()->find('?', array($post->id));
//SELECT * FROM `tbl_post` `t` WHERE '1' LIMIT 1
//find返回符合条件的第一条记录，而findAll会返回符合条件的所有行。
$fAllPost = Post::model()->findAll('id = :id', array(':id' => $post->id));
//SELECT * FROM `tbl_post` `t` WHERE id = '1'
$fAllPost = Post::model()->findAll('?', array($post->id));
//SELECT * FROM `tbl_post` `t` WHERE '1'
$criteria = new CDbCriteria();
$criteria->condition = 'id = :id AND title = :title';
$criteria->params = array(':id' => $post->id, ':title' => $post->title);
$fPost = Post::model()->find($criteria);
//SELECT * FROM `tbl_post` `t` WHERE id = '1' AND title = 'post1' LIMIT 1
$fAllPost = Post::model()->findAll($criteria);
//SELECT * FROM `tbl_post` `t` WHERE id = '1' AND title = 'post1'
$fPost = Post::model()->findByPk($post->id, 'title = :title', array(':title' => $post->title));
//SELECT * FROM `tbl_post` `t` WHERE `t`.`id`=1 AND (title = 'post1') LIMIT 1
$fPost = Post::model()->findByAttributes(array('id' => $post->id, 'title' => $post->title));
//SELECT * FROM `tbl_post` `t` WHERE `t`.`id`='1' AND `t`.`title`='post1' LIMIT 1
$sql = 'SELECT id, title from {{post}} WHERE id = ? AND title = ?'; //必须设置表前缀
$fPost = Post::model()->findBySql($sql, array($post->id, $post->title));
$sql = 'SELECT id, title from {{post}} WHERE id = :id AND title = :title';
$fPost = Post::model()->findBySql($sql, array(':id' => $post->id, ':title' => $post->title));
//如果没有找到符合条件的行，find返回null，findAll 返回 array()。
}
public function testCountPost(){
$post = $this->posts('post1');
$cPost = Post::model()->count('?', array($post->title));
//SELECT COUNT(*) FROM `tbl_post` `t` WHERE 'post1' 无意义
$cPost = Post::model()->countByAttributes(array('title' => $post->title, 'content' => $post->content));
//SELECT COUNT(*) FROM `tbl_post` `t` WHERE `t`.`title`='post1' AND `t`.`content`='content1'
$sql = "SELECT title from {{post}} WHERE title LIKE '%" . $post->title . "%'";
$cPost = Post::model()->countBySql($sql);
//至少有一条记录符合查询条件
$ePost = Post::model()->exists('id = ? AND title = ?', array($post->id, $post->title));
//SELECT 1 FROM `tbl_post` `t` WHERE id = '1' AND title = 'post1' LIMIT 1
}
public function testUpdatePost(){
$post = $this->posts('post1');
$post->title = 'update post 1';
if ($post->isNewRecord){
$post->create_time = $post->update_time = new CDbExpression('NOW()');
//UPDATE `tbl_post` SET `id`=1, `title`='update post 1', `content`='content1', `tags`=NULL, `status`=1, `create_time`=NULL, `update_time`=1302161123, `author_id`=1 WHERE `tbl_post`.`id`=1
}else{
$post->update_time = time();
}
$post->save();
//updateAll
$sql = "SELECT * FROM {{post}} WHERE title LIKE '%" . "post" . "%'";
//SELECT * FROM tbl_post WHERE title LIKE '%post%'
$post = Post::model()->findBySql($sql);
$post->updateAll(array('update_time' => time()), 'id <= ?', array('2'));
//UPDATE `tbl_post` SET `update_time`=1302161123 WHERE id <= '2'
$post->updateByPk($post->id + 2, array('title' => 'update post 3'));
$post->updateByPk($post->id, array('title' => 'update post 3'), 'id = ?', array('3'));
//updateCounter 更新某个字段的数值，一般是计数器(+/-)。
$tag = $this->tags('tag1');
$uTag = Tag::model()->updateCounters(array('frequency' => '3'), 'id = ?', array('1'));
}
public function testDeletePost(){
$post = $this->posts('post1');
$post->delete();
$this->assertEquals(1, $post->id); //删除数据库表中的记录，但是post的这个实例还在。
$post2 = Post::model()->findByPk($post->id);
$this->assertEquals(null, $post2);
//多条记录
$delete = Post::model()->deleteAll('(id = ? AND title = ?) || (id = \'4\') ', array(1, 'post 1'));
$this->assertEquals(0, $delete);
$delete = Post::model()->deleteAllByAttributes(array('id' => '2'), 'content = ?', array('content2'));
//DELETE FROM `tbl_post` WHERE `tbl_post`.`id`='2' AND (content = 'content2')
$this->assertEquals(1, $delete);
}
}
?>

文库|博客

返回列表

Chinaunix › 论坛 › 程序设计 › Web开发 › Yii framework CRUD code sytax (all)