/**
* testColumn method
*
* @return void
*/
public function testColumn()
{
$result = $this->Dbo->column('varchar(50)');
$expected = 'string';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('text');
$expected = 'text';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('int(11)');
$expected = 'integer';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('int(11) unsigned');
$expected = 'integer';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('tinyint(1)');
$expected = 'boolean';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('boolean');
$expected = 'boolean';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('float');
$expected = 'float';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('float unsigned');
$expected = 'float';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('double unsigned');
$expected = 'float';
$this->assertEquals($expected, $result);
$result = $this->Dbo->column('decimal(14,7) unsigned');
$expected = 'float';
$this->assertEquals($expected, $result);
}
/**
* testColumnParsing method
*
* @return void
*/
public function testColumnParsing()
{
$this->assertEquals('text', $this->Dbo2->column('text'));
$this->assertEquals('date', $this->Dbo2->column('date'));
$this->assertEquals('boolean', $this->Dbo2->column('boolean'));
$this->assertEquals('string', $this->Dbo2->column('character varying'));
$this->assertEquals('time', $this->Dbo2->column('time without time zone'));
$this->assertEquals('datetime', $this->Dbo2->column('timestamp without time zone'));
$result = $this->Dbo2->column('bigint');
$expected = 'biginteger';
$this->assertEquals($expected, $result);
}
/**
* testColumnParsing method
*
* @return void
*/
public function testColumnParsing()
{
$this->assertEquals($this->Dbo2->column('text'), 'text');
$this->assertEquals($this->Dbo2->column('date'), 'date');
$this->assertEquals($this->Dbo2->column('boolean'), 'boolean');
$this->assertEquals($this->Dbo2->column('character varying'), 'string');
$this->assertEquals($this->Dbo2->column('time without time zone'), 'time');
$this->assertEquals($this->Dbo2->column('timestamp without time zone'), 'datetime');
}
