lithium\tests\integration\data\source\database\adapter\Sqlite3Test::testColumnAbstraction PHP Method

testColumnAbstraction() public method

    public function testColumnAbstraction()
    {
        $result = $this->_db->invokeMethod('_column', array('varchar'));
        $this->assertEqual(array('type' => 'string', 'length' => 255), $result);
        $result = $this->_db->invokeMethod('_column', array('tinyint(1)'));
        $this->assertEqual(array('type' => 'boolean'), $result);
        $result = $this->_db->invokeMethod('_column', array('varchar(255)'));
        $this->assertEqual(array('type' => 'string', 'length' => 255), $result);
        $result = $this->_db->invokeMethod('_column', array('text'));
        $this->assertEqual(array('type' => 'text'), $result);
        $result = $this->_db->invokeMethod('_column', array('text'));
        $this->assertEqual(array('type' => 'text'), $result);
        $result = $this->_db->invokeMethod('_column', array('decimal(12,2)'));
        $this->assertEqual(array('type' => 'float', 'length' => 12, 'precision' => 2), $result);
        $result = $this->_db->invokeMethod('_column', array('int(11)'));
        $this->assertEqual(array('type' => 'integer', 'length' => 11), $result);
    }