public void SetupDbMigrationTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); Assert.True(dbAccessFacade.AppliedItems.Count == 5); }
public void ParametersAndFiltersTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); config.AddScriptsLocation(Assembly.GetExecutingAssembly(), "TemplateTestScripts"); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); PendingItem script = dbAccessFacade.ClasspathScripts.First(s => s.Version.Equals("201701171635")); Assert.NotNull(script); Assert.True(script.Content.ToString().Contains("0x")); }
public void ParametersTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); config.AddParameter("parameters_test_key_1", "col1"); config.AddParameter("parameters_test_key_2", "col2"); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); PendingItem script = dbAccessFacade.ClasspathScripts.First(s => s.Version.Equals("201606201610")); Assert.NotNull(script); Assert.True(script.Content.ToString().Contains("[col1]")); Assert.True(script.Content.ToString().Contains("[col2]")); Assert.False(script.Content.ToString().Contains("{{parameters_test_key_1}}")); Assert.False(script.Content.ToString().Contains("{{parameters_test_key_2}}")); }
public void UpdateSchemaTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); dbAccessFacade.DbItems.Add(new AppliedItem { Id = "201606201607", Type = ItemType.Versioned, Version = "201606201607", Name = "V2016.06.20_1607_test1.sql", Executed = DateTime.Now, Checksum = "2e542df38430899677f99ce8be5b97a6" }); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); Assert.True(dbAccessFacade.DbItems.Count == 5); Assert.True(dbAccessFacade.AppliedItems.Count == 4); }
public void RepeatableScriptsNoReapplyTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); dbAccessFacade.DbItems.Add(new AppliedItem { Id = "201606201701", Type = ItemType.Repeatable, Version = "201606201701", Name = "R2016.06.20_1701_repeatable_test2.sql", Executed = DateTime.Now, Checksum = "470f6a50c4fd0323b2dc95be00ab72e1" }); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); Assert.True(dbAccessFacade.DbItems.Count == 1); Assert.True(dbAccessFacade.AppliedItems.Count == 0); }
public void RepeatableScriptsReapplyTest() { DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock(); dbAccessFacade.DbItems.Add(new AppliedItem { Id = "201606201701", Type = ItemType.Repeatable, Version = "201606201701", Name = "R2016.06.20_1701_repeatable_test2.sql", Executed = DateTime.Now, Checksum = "2e542df38430899677f99ce8be5b97a7" }); IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade); migrator.Migrate(new SqlConnection()); Assert.True(dbAccessFacade.DbItems.Count == 1); Assert.True(dbAccessFacade.AppliedItems.Count == 1); }