/** * 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'); }