1<?php
2/*
3 *  $Id$
4 *
5 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
6 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
7 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
8 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
9 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
10 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
11 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
12 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
13 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
14 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
15 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
16 *
17 * This software consists of voluntary contributions made by many individuals
18 * and is licensed under the LGPL. For more information, see
19 * <http://www.doctrine-project.org>.
20 */
21
22/**
23 * Doctrine_Ticket_DC86_TestCase
24 *
25 * @package     Doctrine
26 * @author      Jacek Dębowczyk <j.debowczyk@gmail.com>
27 * @license     http://www.opensource.org/licenses/lgpl-license.php LGPL
28 * @category    Object Relational Mapping
29 * @link        www.doctrine-project.org
30 * @since       1.0
31 * @version     $Revision$
32 */
33class Doctrine_Ticket_DC86_TestCase extends Doctrine_UnitTestCase
34{
35    public function prepareTables()
36    {
37        $this->tables[] = 'Ticket_DC86_Test';
38        parent::prepareTables();
39    }
40
41    public function prepareData()
42    {
43    	$r = new Ticket_DC86_Test();
44    	$r->id = 1;
45    	$r->date = date('Y-m-d h:i:s', strtotime("- 10 week"));
46    	$r->save();
47
48    	$r = new Ticket_DC86_Test();
49    	$r->id = 2;
50    	$r->date = date('Y-m-d h:i:s', strtotime("- 5 week"));
51    	$r->save();
52
53    	$r = new Ticket_DC86_Test();
54    	$r->id = 3;
55    	$r->date = date('Y-m-d h:i:s', strtotime("+ 1 week"));
56    	$r->save();
57    }
58
59    public function testTest()
60    {
61    	$past = Doctrine_Query::create()->from('Ticket_DC86_Test')->addWhere('date < now()')->orderBy('date')->execute();
62		$this->assertEqual(2, count($past));
63		$this->assertEqual(1, $past[0]->id);
64		$this->assertEqual(2, $past[1]->id);
65
66    	$future = Doctrine_Query::create()->from('Ticket_DC86_Test')->addWhere('date > now()')->orderBy('date')->execute();
67		$this->assertEqual(1, count($future));
68		$this->assertEqual(3, $future[0]->id);
69    }
70}
71
72class Ticket_DC86_Test extends Doctrine_Record
73{
74    public function setTableDefinition()
75    {
76		$this->hasColumn('id', 'integer', 4, array('primary', 'notnull'));
77        $this->hasColumn('date', 'timestamp');
78    }
79}