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_1706_TestCase
24 *
25 * @package     Doctrine
26 * @author      David Abdemoulaie <doctrine@hobodave.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_1706_TestCase extends Doctrine_UnitTestCase
34{
35    public function testCachedResultsAreSpecificToDsn()
36    {
37        $cacheDriver = new Doctrine_Cache_Array();
38
39        $conn1 = Doctrine_Manager::connection('sqlite::memory:', 'conn_1');
40        $conn1->setAttribute(Doctrine_Core::ATTR_RESULT_CACHE, $cacheDriver);
41
42        $conn2 = Doctrine_Manager::connection('sqlite::memory:', 'conn_2');
43        $conn2->setAttribute(Doctrine_Core::ATTR_RESULT_CACHE, $cacheDriver);
44        $this->assertNotEqual($conn1, $conn2);
45
46        $manager = Doctrine_Manager::getInstance();
47        $manager->setCurrentConnection('conn_1');
48        $this->assertEqual($conn1, Doctrine_Manager::connection());
49
50        Doctrine_Core::createTablesFromArray(array('Ticket_1706_User'));
51
52        $user = new Ticket_1706_User();
53        $user->name = 'Allen';
54        $user->save();
55
56        $manager->setCurrentConnection('conn_2');
57        $this->assertEqual($conn2, Doctrine_Manager::connection());
58
59        Doctrine_Core::createTablesFromArray(array('Ticket_1706_User'));
60
61        $user = new Ticket_1706_User();
62        $user->name = 'Bob';
63        $user->save();
64
65        $manager->setCurrentConnection('conn_1');
66        $u1 = Doctrine_Query::create()
67            ->from('Ticket_1706_User u')
68            ->useResultCache()
69            ->execute();
70
71        $this->assertEqual(1, count($u1));
72        $this->assertEqual('Allen', $u1[0]->name);
73
74        $manager->setCurrentConnection('conn_2');
75        $u2 = Doctrine_Query::create()
76            ->from('Ticket_1706_User u')
77            ->useResultCache()
78            ->execute();
79
80        $this->assertEqual(1, count($u2));
81        $this->assertEqual('Bob', $u2[0]->name);
82    }
83}
84
85class Ticket_1706_User extends Doctrine_Record
86{
87    public function setTableDefinition()
88    {
89        $this->hasColumn('name', 'string');
90        $this->hasColumn('password', 'string');
91    }
92}
93