天生我才必有用

在这里的总结中我们都已Symfony书中所讲的article作为Table所对应的ORM对象(ORM Class)

1.保存

$article->save();

2.删除

$article->delete();

3.通过主键Primary Key来获取资料

$article = ArticlePeer::retrieveByPk(7);

4.使用Select语句来获取资料

$c = new Criteria();
$articles = ArticlePeer::doSelect($c);

5.获取资料个数。

$c = new Criteria();
$articles = ArticlePeer::doCount($c);

6.条件删除、添加、更新

doDelete(), doInsert(), and doUpdate()

7.取得满足条件的第一笔资料

doSelectOne

8. RAW SQL命令

$connection = Propel::getConnection();
$query = 'SELECT MAX(%s) AS max FROM %s';
$query =  sprintf($query, ArticlePeer::CREATED_AT, ArticlePeer::TABLE_NAME);
$statement = $connnection->prepareStatement($query);
$resultset = $statement->executeQuery();
$resultset->next();
$max = $resultset->getInt('max');