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_1630_TestCase 24 * 25 * @package Doctrine 26 * @author Konsta Vesterinen <kvesteri@cc.hut.fi> 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_1630_TestCase extends Doctrine_UnitTestCase 34{ 35 public function prepareTables() 36 { 37 $this->tables[] = 'Ticket_1630_BlogPost'; 38 parent::prepareTables(); 39 } 40 41 public function prepareData() 42 { 43 $test = new Ticket_1630_BlogPost(); 44 $test->Translation['en']->title = 'en test'; 45 $test->Translation['fr']->title = 'fr test'; 46 $test->body = 'test'; 47 $test->save(); 48 49 $test = new Ticket_1630_BlogPost(); 50 $test->Translation['en']->title = 'cool'; 51 $test->body = 'very cool'; 52 $test->save(); 53 } 54 55 public function testTest() 56 { 57 $cacheConn = Doctrine_Manager::getInstance()->openConnection('sqlite::memory:', 'cache', false); 58 $cacheDriver = new Doctrine_Cache_Db(array('tableName' => 'cache', 'connection' => $cacheConn)); 59 $cacheDriver->createTable(); 60 61 $currentCacheDriver = $this->conn->getAttribute(Doctrine_Core::ATTR_QUERY_CACHE); 62 $this->conn->setAttribute(Doctrine_Core::ATTR_QUERY_CACHE, $cacheDriver); 63 64 try { 65 $q = Doctrine_Query::create() 66 ->from('Ticket_1630_BlogPost p') 67 ->leftJoin('p.Translation t INDEXBY t.lang'); 68 $results = $q->execute(); 69 $results = $q->execute(); 70 71 $this->pass(); 72 } catch (Exception $e) { 73 $this->fail(); 74 } 75 76 $this->conn->setAttribute(Doctrine_Core::ATTR_QUERY_CACHE, $currentCacheDriver); 77 } 78} 79 80class Ticket_1630_BlogPost extends Doctrine_Record 81{ 82 public function setTableDefinition() 83 { 84 $this->hasColumn('title', 'string', 255); 85 $this->hasColumn('body', 'clob'); 86 } 87 88 public function setUp() 89 { 90 $i18n = new Doctrine_Template_I18n(array('fields' => array('title'))); 91 $this->actAs($i18n); 92 } 93}