Yii framework CRUD code sytax (all)

FROM:http://my.chinaunix.net/space.php?uid=395468&do=blog&id=213572

 

<
?
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
)
;
    }
}
?
>