PopTest\Db\SqlTest::testSelectJoinDifferentColumns PHP Method

testSelectJoinDifferentColumns() public method

    public function testSelectJoinDifferentColumns()
    {
        $s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
        $s->select()->join('user_data', array('id', 'user_id'), 'LEFT JOIN');
        $this->assertEquals('SELECT * FROM "users" LEFT JOIN "user_data" ON "users"."id" = "user_data"."user_id"', $s->render(true));
    }