<?php
//Create and instance of Morph_Storage passing in the appropriate database
$mongo = new Mongo();
$storage = new Morph_Storage($mongo->selectDb('myDB'));
$query = new Morph_Query();
$query->property('createdDate')->greaterThan(MongoDate(time() - 604800))->lessThan(new MondoDate(time()))->property('cost')->greaterThanOrEqualTo(12.99)->property('publisher')->in(array('publisherA', 'publisherB', 'publisherC'));
/**
* This query is roughly equivalent to the sql:
* SELECT * FROM `ABook` WHERE
* `createdDate` > DATE_SUB(now(), INTERVAL 1 WEEK)
* AND `createdDate` < now()
* AND `cost` >= 12.99
* AND `publisher` in ('publisherA', 'publisherB', 'publisherC');
*/
$users = $storage->findByQuery(new A_Book(), $query);
public static function getActiveSettings()
{
// lets only refresh the last 3 days for now
$qry = array("startdate" => array('$gt' => MongoDate(now() - 3600 * 24 * 3)));
return self::_find(__CLASS__, $qry);
}
<?php
//Initialise Morph_Storage passing in the appropriate database
$mongo = new Mongo();
Morph_Storage::init($mongo->selectDb('myDB'));
$query = new Morph_Query();
$query->property('createdDate')
->greaterThan(MongoDate(time() - 604800)) //last week
->lessThan(new MondoDate(time())) //today
->property('cost')
->greaterThanOrEqualTo(12.99)
->sort(Morph_Enum::DIRECTION_ASC)
->property('publisher')
->in(array('publisherA', 'publisherB', 'publisherC'));
/**
* This query is roughly equivalent to the sql:
* SELECT * FROM `ABook` WHERE
* `createdDate` > DATE_SUB(now(), INTERVAL 1 WEEK)
* AND `createdDate` < now()
* AND `cost` >= 12.99
* AND `publisher` in ('publisherA', 'publisherB', 'publisherC')
* ORDER BY `cost`;
*/
$book = new A_Book();
$books = $book->findByQuery($query);
