/**
* @test
*/
public function getTableFieldsDetails()
{
$details = $this->databaseConnection->getTableFieldsDetails('users');
$excepted = array(array('field' => 'id', 'field_type' => 'int', 'field_type_detailed' => 'int(10) unsigned', 'key_type' => 'primary', 'foreign_table' => NULL, 'unique' => true, 'required' => true, 'auto_increment' => true), array('field' => 'first_name', 'field_type' => 'varchar', 'field_type_detailed' => 'varchar(64)', 'key_type' => 'none', 'foreign_table' => NULL, 'unique' => false, 'required' => true, 'auto_increment' => false), array('field' => 'last_name', 'field_type' => 'varchar', 'field_type_detailed' => 'varchar(64)', 'key_type' => 'none', 'foreign_table' => NULL, 'unique' => false, 'required' => true, 'auto_increment' => false), array('field' => 'email', 'field_type' => 'varchar', 'field_type_detailed' => 'varchar(256)', 'key_type' => 'none', 'foreign_table' => NULL, 'unique' => false, 'required' => true, 'auto_increment' => false), array('field' => 'username', 'field_type' => 'varchar', 'field_type_detailed' => 'varchar(64)', 'key_type' => 'none', 'foreign_table' => NULL, 'unique' => false, 'required' => true, 'auto_increment' => false), array('field' => 'password', 'field_type' => 'varchar', 'field_type_detailed' => 'varchar(32)', 'key_type' => 'none', 'foreign_table' => NULL, 'unique' => false, 'required' => true, 'auto_increment' => false), array('field' => 'type_id', 'field_type' => 'int', 'field_type_detailed' => 'int(10) unsigned', 'key_type' => 'foreign', 'foreign_table' => 'types', 'unique' => false, 'required' => false, 'auto_increment' => false), array('field' => 'status_id', 'field_type' => 'int', 'field_type_detailed' => 'int(10) unsigned', 'key_type' => 'foreign', 'foreign_table' => 'sTaT_useS', 'unique' => false, 'required' => false, 'auto_increment' => false));
$this->assertSame($excepted, $details);
}
