lithium\tests\cases\data\source\DatabaseTest::testJoin PHP Method

    public function testJoin()
    {
        $model = $this->_model;
        $conn = $model::connection();
        $query = new Query(array('type' => 'read', 'model' => $model));
        $rel = $model::relations('MockDatabaseComment');
        $conn->join($query, $rel, null, null, array('published' => (object) "'yes'"));
        $joins = $query->joins();
        $expected = array('MockDatabaseComment' => array('constraints' => array('MockDatabasePost.id' => 'MockDatabaseComment.mock_database_post_id', 'MockDatabasePost.published' => (object) "'yes'"), 'model' => 'lithium\\tests\\mocks\\data\\model\\MockDatabaseComment', 'mode' => 'LEFT', 'alias' => 'MockDatabaseComment'));
        $this->assertEqual($expected, $joins);
        $query = new Query(array('type' => 'read', 'model' => $model));
        $rel = $model::relations('MockDatabaseComment');
        $conn->join($query, $rel, null, null, (object) array('published' => (object) "'yes'"));
        $joins = $query->joins();
        $expected = array('MockDatabaseComment' => array('constraints' => array('published' => (object) "'yes'"), 'model' => 'lithium\\tests\\mocks\\data\\model\\MockDatabaseComment', 'mode' => 'LEFT', 'alias' => 'MockDatabaseComment'));
        $this->assertEqual($expected, $joins);
    }