PHP SnippetPeer::doSelect示例

示例#1

文件： SnippetPeer.php 项目： hoydaa/snippets.hoydaa.org

 public static function getPopularCodes($max = 10)
 {
     $c = new Criteria();
     $c->add(SnippetPeer::DRAFT, false);
     $c->addDescendingOrderByColumn(SnippetPeer::AVERAGE_RATING);
     $c->setLimit($max);
     return SnippetPeer::doSelect($c);
 }

示例#2

文件： snippetSitemapGenerator.class.php 项目： hoydaa/snippets.hoydaa.org

 public static function generate()
 {
     $c = new Criteria();
     $c->add(SnippetPeer::DRAFT, false);
     $snippets = SnippetPeer::doSelect($c);
     $urls = array();
     foreach ($snippets as $snippet) {
         $urls[] = new sitemapURL("snippet/show?id=" . $snippet->getFriendlyUrl(), date('Y-m-d\\TH:i:s\\Z', strtotime($snippet->getUpdatedAt())), 'weekly', 1.0);
     }
     return $urls;
 }

示例#3

文件： save_all_again.php 项目： hoydaa/snippets.hoydaa.org

<?php

define('SF_ROOT_DIR', realpath(dirname(__FILE__) . '/..'));
define('SF_APP', 'frontend');
define('SF_ENVIRONMENT', 'dev');
define('SF_DEBUG', true);
require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php';
// initialize database manager
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
$snippets = SnippetPeer::doSelect(new Criteria());
foreach ($snippets as $snippet) {
    echo "Saving snippet#" . $snippet->getId() . ":" . $snippet->getTitle() . "\n";
    $snippet->save();
    echo "     Stripped title: " . $snippet->getFriendlyUrl() . "\n";
}