UpdateTestCase.php 1.11 KB
Newer Older
1 2 3 4 5 6 7
<?php
class Doctrine_Query_Update_TestCase extends Doctrine_UnitTestCase {
    public function testUpdateAllWithColumnAggregationInheritance() {
        $q = new Doctrine_Query();

        $q->parseQuery("UPDATE User u SET u.name = 'someone'");

zYne's avatar
zYne committed
8
        $this->assertEqual($q->getQuery(), "UPDATE entity e SET e.name = 'someone' WHERE (e.type = 0)");
9 10 11

        $q = new Doctrine_Query();

zYne's avatar
zYne committed
12
        $q->update('User u')->set('u.name', "'someone'");
13

zYne's avatar
zYne committed
14 15 16 17 18 19 20 21 22 23 24 25 26 27
        $this->assertEqual($q->getQuery(), "UPDATE entity e SET e.name = 'someone' WHERE (e.type = 0)");
    }
    public function testUpdateWorksWithMultipleColumns() {
        $q = new Doctrine_Query();

        $q->parseQuery("UPDATE User u SET u.name = 'someone', u.email_id = 5");

        $this->assertEqual($q->getQuery(), "UPDATE entity e SET e.name = 'someone', e.email_id = 5 WHERE (e.type = 0)");

        $q = new Doctrine_Query();

        $q->update('User u')->set('u.name', "'someone'")->set('u.email_id', 5);

        $this->assertEqual($q->getQuery(), "UPDATE entity e SET e.name = 'someone', e.email_id = 5 WHERE (e.type = 0)");
28 29 30
    }
}
?>