public void ExistingDatabase_FieldAdded_NewFieldExists(IDestinationManagerTestHelper db) { using (db.TestRun()) { var definition = new Database("MyDatabase", new Table( "MyTable", new Field("MyField", FieldType.String, 20) ) ); var upgrader = db.Init(DbUpgrader.Upgrade) .FromDefinition(definition) .LogToXunit(_output) .Build(); Assert.True(upgrader.Run()); db.AssertTableExists("MyDatabase", "MyTable"); db.AssertFieldExists("MyDatabase", "MyTable", "MyField"); db.AssertFieldSizeEquals("MyDatabase", "MyTable", "MyField", 20); ((Table)definition.GetTables().First()).AddField(new Field("Field2", FieldType.String, 10)); Assert.True(upgrader.Run()); db.AssertTableExists("MyDatabase", "MyTable"); db.AssertFieldExists("MyDatabase", "MyTable", "MyField"); db.AssertFieldExists("MyDatabase", "MyTable", "Field2"); } }
public void NoDatabase_Create_TableAndFieldExists(IDestinationManagerTestHelper db) { using (db.TestRun()) { var definition = new Database("MyDatabase", new Table( "MyTable", new Field("MyField", FieldType.String, 20) ) ); var upgrader = db.Init(DbUpgrader.Upgrade) .FromDefinition(definition) .LogToXunit(_output) .Build(); Assert.True(upgrader.Run()); db.AssertTableExists("MyDatabase", "MyTable"); db.AssertFieldExists("MyDatabase", "MyTable", "MyField"); db.AssertFieldSizeEquals("MyDatabase", "MyTable", "MyField", 20); } }
public void NoDatabase_Create_OneOfEachType(IDestinationManagerTestHelper db) { using (db.TestRun()) { var definition = new Database("MyDatabase", new Table( "OneOfEach", new Field("StringField", FieldType.String, 20), new Field("IntField", FieldType.Integer), new Field("BoolField", FieldType.Boolean), new Field("DecimalField", FieldType.Decimal), new Field("LongStringField", FieldType.LongString), new Field("BinaryField", FieldType.Binary, 20) ) ); var upgrader = db.Init(DbUpgrader.Upgrade) .FromDefinition(definition) .LogToXunit(_output) .Build(); Assert.True(upgrader.Run()); db.AssertTableExists("MyDatabase", "OneOfEach"); db.AssertFieldExists("MyDatabase", "OneOfEach", "StringField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "StringField", FieldType.String); db.AssertFieldSizeEquals("MyDatabase", "OneOfEach", "StringField", 20); db.AssertFieldExists("MyDatabase", "OneOfEach", "IntField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "IntField", FieldType.Integer); db.AssertFieldExists("MyDatabase", "OneOfEach", "BoolField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "BoolField", FieldType.Boolean); db.AssertFieldExists("MyDatabase", "OneOfEach", "DecimalField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "DecimalField", FieldType.Decimal); db.AssertFieldExists("MyDatabase", "OneOfEach", "LongStringField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "LongStringField", FieldType.LongString); db.AssertFieldExists("MyDatabase", "OneOfEach", "BinaryField"); db.AssertFieldTypeEquals("MyDatabase", "OneOfEach", "BinaryField", FieldType.Binary); db.AssertFieldSizeEquals("MyDatabase", "OneOfEach", "BinaryField", 20); } }