/** * Returns the schema for this data object. * * @return \Rhubarb\Stem\Schema\ModelSchema */ protected function createSchema() { $schema = new MySqlModelSchema("tblCompany"); $schema->uniqueIdentifierColumnName = "CompanyID"; $schema->addColumn(new AutoIncrement("CompanyID"), new String("CompanyName", 200), new Money("Balance"), new Date("InceptionDate"), new DateTime("LastUpdatedDate"), new Time("KnockOffTime"), new Boolean("BlueChip", false), new Integer("ProjectCount"), new Json("CompanyData"), new Boolean("Active", true)); $schema->addIndex(new Index("CompanyID", Index::PRIMARY)); $schema->labelColumnName = "CompanyName"; return $schema; }
public function testSchemaIsModified() { // Note this test relies on the previous test to leave tblExample behind. $schema = new MySqlModelSchema("tblExample"); $schema->addColumn(new AutoIncrement("ID")); $schema->addColumn(new String("Name", 40, "StrangeDefault")); $schema->addColumn(new MySqlEnum("Type", "A", ["A", "B", "C"])); $schema->addColumn(new MySqlEnum("Type", "B", ["A", "B", "C", "D"])); $schema->addColumn(new String("Town", 60, null)); $schema->addIndex(new Index("ID", Index::PRIMARY)); $schema->checkSchema(Repository::getNewDefaultRepository(new Example())); $newSchema = MySqlComparisonSchema::fromTable("tblExample"); $columns = $newSchema->columns; $this->assertCount(4, $columns); $this->assertEquals("`Town` varchar(60) DEFAULT NULL", $columns["Town"]); $this->assertEquals("`Type` enum('A','B','C','D') NOT NULL DEFAULT 'B'", $columns["Type"]); }