public virtual void DatabaseSchemaCreation_Returns_DatabaseSchemaResult_Where_DetermineInstalledVersion_Is_4_7_0() { // Arrange var db = GetConfiguredDatabase(); var schema = new DatabaseSchemaCreation(db); //Create db schema and data from old Total.sql file for Sql Ce string statements = GetDatabaseSpecificSqlScript(); // replace block comments by whitespace statements = FindComments.Replace(statements, " "); // execute all non-empty statements foreach (string statement in statements.Split(";".ToCharArray())) { string rawStatement = statement.Replace("GO", "").Trim(); if (rawStatement.Length > 0) db.Execute(new Sql(rawStatement)); } // Act var result = schema.ValidateSchema(); // Assert var expected = new Version(4, 7, 0); Assert.AreEqual(expected, result.DetermineInstalledVersion()); }
public void DatabaseSchemaCreation_Produces_DatabaseSchemaResult_With_Zero_Errors() { // Arrange var db = DatabaseContext.Database; var schema = new DatabaseSchemaCreation(db); // Act var result = schema.ValidateSchema(); // Assert Assert.That(result.Errors.Count, Is.EqualTo(0)); Assert.AreEqual(result.DetermineInstalledVersion(), UmbracoVersion.Current); }
internal DatabaseSchemaResult ValidateDatabaseSchema() { if (_configured == false || (string.IsNullOrEmpty(_connectionString) || string.IsNullOrEmpty(ProviderName))) return new DatabaseSchemaResult(); if (_result == null) { var database = new UmbracoDatabase(_connectionString, ProviderName); var dbSchema = new DatabaseSchemaCreation(database); _result = dbSchema.ValidateSchema(); } return _result; }