Phalcon\Test\Db\Dialect\OracleTest::testDescribeColumnsForSchemaWithDots PHP Метод

testDescribeColumnsForSchemaWithDots() публичный Метод

    public function testDescribeColumnsForSchemaWithDots()
    {
        $dialect = new Oracle();
        $sql = $dialect->describeColumns('table', 'database.name.with.dots');
        $expected = ['SELECT TC.COLUMN_NAME, TC.DATA_TYPE, TC.DATA_LENGTH, TC.DATA_PRECISION, TC.DATA_SCALE, TC.NULLABLE, ', 'C.CONSTRAINT_TYPE, TC.DATA_DEFAULT, CC.POSITION FROM ALL_TAB_COLUMNS TC LEFT JOIN (ALL_CONS_COLUMNS CC ', 'JOIN ALL_CONSTRAINTS C ON (CC.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND CC.TABLE_NAME = C.TABLE_NAME ', "AND CC.OWNER = C.OWNER AND C.CONSTRAINT_TYPE = 'P')) ON TC.TABLE_NAME = CC.TABLE_NAME AND ", "TC.COLUMN_NAME = CC.COLUMN_NAME WHERE TC.TABLE_NAME = 'TABLE' AND ", "TC.OWNER = 'DATABASE.NAME.WITH.DOTS' ORDER BY TC.COLUMN_ID"];
        $this->assertEquals(join('', $expected), $sql);
    }