public void CreateTableWorks() { var config = new SimpleClassConfig(); var migrator = MakeMigrator(config); IEnumerable<string> errors; IEnumerable<string> warnings; var script = migrator.GenerateSqlDiff( new IMap[] { }, config.Maps, null, new Mock<ILogger>().Object, new string[0], out warnings, out errors); Assert.Equal( "create table [SimpleClasses] ([SimpleClassId] int not null identity(1,1) primary key, [Name] nvarchar(255) null, [CreatedDate] datetime not null default (current_timestamp));", script.Trim()); }
public void NonIgnoredIndexDropped() { var migrator = MakeMigrator(); var config = new SimpleClassConfig(); var config2 = new SimpleClassConfig(); config.Maps.ElementAt(0) .AddIndex(new Index(config.Maps.ElementAt(0), new[] { config.Maps.ElementAt(0).Columns.First().Value }, "Foo", false)); IEnumerable<string> warnings; IEnumerable<string> errors; var script = migrator.GenerateSqlDiff( config.Maps, config2.Maps, null, new Mock<ILogger>().Object, new string[0], out warnings, out errors); Assert.Equal(@"drop index [Foo] on [SimpleClasses];", script.Trim()); }
public void IgnoredIndexNotDeleted() { var migrator = MakeMigrator(); var config = new SimpleClassConfig(); var config2 = new SimpleClassConfig(); config.Maps.ElementAt(0) .AddIndex(new Index(config.Maps.ElementAt(0), new[] { config.Maps.ElementAt(0).Columns.First().Value }, "Foo", false)); IEnumerable<string> warnings; IEnumerable<string> errors; var script = migrator.GenerateSqlDiff( config.Maps, config2.Maps, null, new Mock<ILogger>().Object, new[] { "Foo" }, out warnings, out errors); Assert.Empty(script); }
public void CreateTableWorks() { var config = new SimpleClassConfig(); var migrator = MakeMigrator(config); IEnumerable <string> errors; IEnumerable <string> warnings; var script = migrator.GenerateSqlDiff( new IMap[] { }, config.Maps, null, new Mock <ILogger>().Object, new string[0], out warnings, out errors); Assert.Equal( "create table [SimpleClasses] ([SimpleClassId] int not null identity(1,1) primary key, [Name] nvarchar(255) null, [CreatedDate] datetime not null default (current_timestamp));", script.Trim()); }
public void NonIgnoredIndexDropped() { var migrator = MakeMigrator(); var config = new SimpleClassConfig(); var config2 = new SimpleClassConfig(); config.Maps.ElementAt(0) .AddIndex(new Index(config.Maps.ElementAt(0), new[] { config.Maps.ElementAt(0).Columns.First().Value }, "Foo", false)); IEnumerable <string> warnings; IEnumerable <string> errors; var script = migrator.GenerateSqlDiff( config.Maps, config2.Maps, null, new string[0], new string[0], out warnings, out errors); Assert.Equal(@"drop index [Foo] on [SimpleClasses];", script.Trim()); }
public void IgnoredIndexNotDeleted() { var migrator = MakeMigrator(); var config = new SimpleClassConfig(); var config2 = new SimpleClassConfig(); config.Maps.ElementAt(0) .AddIndex(new Index(config.Maps.ElementAt(0), new[] { config.Maps.ElementAt(0).Columns.First().Value }, "Foo", false)); IEnumerable <string> warnings; IEnumerable <string> errors; var script = migrator.GenerateSqlDiff( config.Maps, config2.Maps, null, new[] { "Foo" }, new string[0], out warnings, out errors); Assert.Empty(script); }