Ticket #1247: test.php

<?php

require_once "lib/Doctrine.php";

spl_autoload_register(array('Doctrine', 'autoload'));


class Foo extends Doctrine_Record {
        public function setTableDefinition() {
                $this->hasColumn('id', 'integer', 4, array('primary' => true));
        }
        public function setUp() {
                $this->hasMany('Bar as bars', array('local' => 'foo_id', 'foreign' => 'bar_id', 'refClass' => 'Foobar'));
        }
};

class Bar extends Doctrine_Record {
        public function setTableDefinition() {
                $this->hasColumn('id', 'integer', 4, array('primary' => true));
        }
        public function setUp() {
                $this->hasMany('Foo as foos', array('local' => 'bar_id', 'foreign' => 'foo_id', 'refClass' => 'Foobar'));
        }
};

class Foobar extends Doctrine_Record {
        public function setTableDefinition() {
                $this->hasColumn('foo_id', 'integer', 4, array('primary' => true));
                $this->hasColumn('bar_id', 'integer', 4, array('primary' => true));
        }
};


$pdo = new PDO("mysql:host=localhost;dbname=doctrine", "doctrine", "test");

$pdo->query("DROP TABLE foo");
$pdo->query("DROP TABLE bar");
$pdo->query("DROP TABLE foobar");

$pdo->query("CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY)");
$pdo->query("CREATE TABLE bar (id INTEGER NOT NULL PRIMARY KEY)");
$pdo->query("CREATE TABLE foobar (foo_id INTEGER NOT NULL, bar_id INTEGER NOT NULL, PRIMARY KEY (foo_id, bar_id))");

$pdo->query("INSERT INTO foo VALUES (1),(2)");
$pdo->query("INSERT INTO bar VALUES (1),(2)");
$pdo->query("INSERT INTO foobar VALUES (1,1),(2,2)");

$db = Doctrine_Manager::connection($pdo, "pdo");
$db->setAttribute(Doctrine::ATTR_QUOTE_IDENTIFIER, true);

$foo_t = $db->getTable("Foo");
$foo = $foo_t->find(1);

// Below line causes exception
$bars = $foo->bars;