public function testSchemaCanBeCreatedFromMySqlSchema() { $user = new User(); $schema = $user->getSchema(); $comparisonSchema = MySqlComparisonSchema::fromMySqlSchema($schema); $this->assertEquals(["UserID" => "`UserID` int(11) unsigned NOT NULL AUTO_INCREMENT", "CompanyID" => "`CompanyID` int(11) unsigned NOT NULL DEFAULT '0'", "UserType" => "`UserType` enum('Staff','Administrator') NOT NULL DEFAULT 'Staff'", "Username" => "`Username` varchar(40) NOT NULL DEFAULT ''", "Forename" => "`Forename` varchar(40) NOT NULL DEFAULT ''", "Surname" => "`Surname` varchar(40) NOT NULL DEFAULT ''", "Password" => "`Password` varchar(120) NOT NULL DEFAULT ''", "Active" => "`Active` tinyint(3) NOT NULL DEFAULT '0'", "Wage" => "`Wage` decimal(8,2) NOT NULL DEFAULT '0.00'"], $comparisonSchema->columns); $this->assertEquals(["PRIMARY KEY (`UserID`)", "KEY `CompanyID` (`CompanyID`)"], $comparisonSchema->indexes); }
public function testGetModelSchema() { $modelSchema = SolutionSchema::getModelSchema("UnitTestUser"); $user = new User(); $this->assertEquals($user->getSchema(), $modelSchema); }