public void GetLastModel_should_return_model_based_on_passed_context_key_when_custom_default_schema()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "LegacyKey", null, HistoryContext.DefaultFactory)
{
CurrentSchema = "foo"
};
using (var context = CreateContext <ShopContext_v1>())
{
var model = context.GetModel();
var versionedModel = new VersionedModel(model);
ExecuteOperations(
GetCreateHistoryTableOperation(historyRepository.CurrentSchema),
historyRepository.CreateInsertOperation("Migration", versionedModel));
historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(),
ConnectionString,
ProviderFactory,
"NewKey",
null,
HistoryContext.DefaultFactory,
schemas: new[] { "foo" });
string migrationId, _;
model = historyRepository.GetLastModel(out migrationId, out _, "LegacyKey");
Assert.NotNull(model);
Assert.Equal("Migration", migrationId);
}
}
public void Can_explicit_update_when_custom_history_factory()
{
ResetDatabase();
var migrator
= CreateMigrator<ShopContext_v1>(historyContextFactory: _testHistoryContextFactoryA);
var generatedMigration
= new MigrationScaffolder(migrator.Configuration).Scaffold("Migration");
migrator
= CreateMigrator<ShopContext_v1>(
automaticMigrationsEnabled: false,
scaffoldedMigrations: generatedMigration,
historyContextFactory: _testHistoryContextFactoryA);
migrator.Update();
Assert.True(TableExists("MigrationsCustomers"));
Assert.True(TableExists("__Migrations"));
migrator.Update("0");
Assert.False(TableExists("MigrationsCustomers"));
Assert.False(TableExists("__Migrations"));
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
Assert.Null(historyRepository.GetLastModel());
}
public void GetLastModel_should_return_model_when_row()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model1 = context.GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository.CreateInsertOperation("Migration 1", model1));
ExecuteOperations(
new[] { historyRepository.CreateInsertOperation("Migration 2", model1) });
string migrationId;
var model2 = historyRepository.GetLastModel(out migrationId);
Assert.NotNull(model2);
Assert.True(XNode.DeepEquals(model1, model2));
Assert.Equal("Migration 2", migrationId);
}
}
public void GetModel_should_return_model_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "Key1", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model = context.GetModel();
var versionedModel = new VersionedModel(model);
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", versionedModel));
var historyRepository2
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "Key2", null, HistoryContext.DefaultFactory);
ExecuteOperations(
new[] { historyRepository2.CreateInsertOperation("Migration 2", versionedModel) });
string productVersion;
model = historyRepository1.GetModel("Migration 1", out productVersion);
Assert.NotNull(model);
Assert.Equal(typeof(DbContext).Assembly().GetInformationalVersion(), productVersion);
string _;
model = historyRepository2.GetModel("Migration 2", out _);
Assert.NotNull(model);
}
}
public void GetMigrationsSince_should_return_subset_when_target_valid()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
using (var context = CreateContext <ShopContext_v1>())
{
var model = context.GetModel();
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("Migration1", model),
historyRepository.CreateInsertOperation("Migration2", model)
});
}
var migrations = historyRepository.GetMigrationsSince("Migration1");
Assert.Equal(1, migrations.Count());
Assert.Equal("Migration2", migrations.Single());
}
public void GetMigrationsSince_should_return_empty_when_target_valid_but_is_latest()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("Migration1", model),
historyRepository.CreateInsertOperation("Migration2", model)
});
}
var migrations = historyRepository.GetMigrationsSince("Migration2");
Assert.Equal(0, migrations.Count());
}
public void GetLastModel_should_return_model_based_on_passed_context_key_when_custom_default_schema()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "LegacyKey")
{
CurrentSchema = "foo"
};
var model = CreateContext <ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(historyRepository.CurrentSchema),
historyRepository.CreateInsertOperation("Migration", model));
historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "NewKey", new[] { "foo" });
string migrationId;
model = historyRepository.GetLastModel(out migrationId, "LegacyKey");
Assert.NotNull(model);
Assert.Equal("Migration", migrationId);
}
public void GetLastModel_should_return_model_when_row()
{
ResetDatabase();
var historyRepository = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model1 = new VersionedModel(context.GetModel());
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository.CreateInsertOperation("Migration 1", model1));
ExecuteOperations(
new[] { historyRepository.CreateInsertOperation("Migration 2", model1) });
string migrationId, productVersion;
var model2 = historyRepository.GetLastModel(out migrationId, out productVersion);
Assert.NotNull(model2);
Assert.True(XNode.DeepEquals(model1.Model, model2));
Assert.Equal("Migration 2", migrationId);
Assert.Equal(typeof(DbContext).Assembly().GetInformationalVersion(), productVersion);
}
}
public void GetModel_should_return_model_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "Key1", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model = context.GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", model));
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "Key2", null, HistoryContext.DefaultFactory);
ExecuteOperations(
new[] { historyRepository2.CreateInsertOperation("Migration 2", model) });
model = historyRepository1.GetModel("Migration 1");
Assert.NotNull(model);
model = historyRepository2.GetModel("Migration 2");
Assert.NotNull(model);
}
}
public void GetMigrationId_should_throw_when_name_ambiguous()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("201109192032331_Migration", model),
historyRepository.CreateInsertOperation("201109192032332_Migration", model)
});
}
Assert.Equal(
Strings.AmbiguousMigrationName("Migration"),
Assert.Throws <MigrationsException>(() => historyRepository.GetMigrationId("Migration")).Message);
}
public void HasMigrations_should_return_false_when_context_key_not_matching()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey1", null, HistoryContext.DefaultFactory);
var historyRepository2
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey2", null, HistoryContext.DefaultFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
new[]
{
historyRepository2.CreateInsertOperation("Migration2", model)
});
}
Assert.False(historyRepository1.HasMigrations());
}
public void GetMigrationId_should_match_by_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey1", null, HistoryContext.DefaultFactory);
var historyRepository2
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey2", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
new[]
{
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("201109192032331_Migration1", model),
historyRepository1.CreateInsertOperation("201109192032332_Migration2", model),
historyRepository2.CreateInsertOperation("201109192032331_Migration1", model),
historyRepository2.CreateInsertOperation("201109192032332_Migration2", model)
});
}
var migrationId = historyRepository1.GetMigrationId("Migration1");
Assert.Equal("201109192032331_Migration1", migrationId);
migrationId = historyRepository1.GetMigrationId("migrATIon2");
Assert.Equal("201109192032332_Migration2", migrationId);
}
public void Can_create_count_query_command_trees_when_sql_azure_execution_strategy()
{
ResetDatabase();
try
{
MutableResolver.AddResolver <Func <IDbExecutionStrategy> >(
key => (Func <IDbExecutionStrategy>)(() => new SqlAzureExecutionStrategy()));
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
var commandTrees = historyRepository.CreateDiscoveryQueryTrees();
foreach (var commandTree in commandTrees)
{
Assert.NotNull(commandTree);
Assert.Equal(DataSpace.SSpace, commandTree.DataSpace);
Assert.Equal(0, commandTree.Parameters.Count());
}
}
finally
{
MutableResolver.ClearResolvers();
}
}
public void GetPendingMigrations_should_return_migrations_based_on_context_key()
{
ResetDatabase();
var historyRepository1 = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey1", null, HistoryContext.DefaultFactory);
var historyRepository2 = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey2", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", model),
historyRepository2.CreateInsertOperation("Migration 1", model),
historyRepository1.CreateInsertOperation("Migration 3", model),
historyRepository1.CreateInsertOperation("Migration 5", model));
}
var pendingMigrations =
historyRepository1.GetPendingMigrations(
new[] { "Migration 1", "Migration 2", "Migration 3", "Migration 4", "Migration 5" });
Assert.Equal("Migration 2", pendingMigrations.First());
Assert.Equal("Migration 4", pendingMigrations.Last());
}
public void CreateInsertOperation_should_return_valid_history_operation()
{
var modelBuilder = new DbModelBuilder();
var model = modelBuilder.Build(ProviderInfo);
var edmxString = new StringBuilder();
using (var xmlWriter = XmlWriter.Create(
edmxString, new XmlWriterSettings
{
Indent = true
}))
{
EdmxWriter.WriteEdmx(model, xmlWriter);
}
var modelDocument = model.GetModel();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey");
var historyOperation
= (HistoryOperation)historyRepository.CreateInsertOperation("Migration1", modelDocument);
Assert.NotEmpty(historyOperation.Commands);
Assert.Equal(4, historyOperation.Commands.Single().Parameters.Count());
}
public void CreateInsertOperation_should_return_valid_history_operation()
{
var modelBuilder = new DbModelBuilder();
var model = modelBuilder.Build(ProviderInfo);
var edmxString = new StringBuilder();
using (var xmlWriter = XmlWriter.Create(
edmxString, new XmlWriterSettings
{
Indent = true
}))
{
EdmxWriter.WriteEdmx(model, xmlWriter);
}
var modelDocument = model.GetModel();
var historyRepository = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
var historyOperation
= (HistoryOperation)historyRepository.CreateInsertOperation("Migration1", new VersionedModel(modelDocument));
Assert.NotEmpty(historyOperation.CommandTrees);
Assert.Equal(DbCommandTreeKind.Insert, historyOperation.CommandTrees.Single().CommandTreeKind);
}
public void GetLastModel_should_return_model_based_on_passed_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "Key1");
var model = CreateContext <ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", model));
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "Key2");
ExecuteOperations(
new[] { historyRepository2.CreateInsertOperation("Migration 2", model) });
string migrationId;
model = historyRepository1.GetLastModel(out migrationId, "Key2");
Assert.NotNull(model);
Assert.Equal("Migration 2", migrationId);
}
public void GetMigrationId_should_match_on_name()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
using (var context = CreateContext <ShopContext_v1>())
{
var model = context.GetModel();
ExecuteOperations(
new[]
{
GetCreateHistoryTableOperation(),
historyRepository.CreateInsertOperation("201109192032331_Migration1", model),
historyRepository.CreateInsertOperation("201109192032332_Migration2", model)
});
}
var migrationId = historyRepository.GetMigrationId("Migration1");
Assert.Equal("201109192032331_Migration1", migrationId);
migrationId = historyRepository.GetMigrationId("migrATIon2");
Assert.Equal("201109192032332_Migration2", migrationId);
}
public void GetMigrationsSince_should_return_all_migrations_when_target_is_empty()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("Migration1", model)
});
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("Migration2", model)
});
var migrations = historyRepository.GetMigrationsSince(DbMigrator.InitialDatabase);
Assert.Equal(2, migrations.Count());
Assert.Equal("Migration2", migrations.First());
}
public void Repository_should_work_gracefully_when_no_context_key_column()
{
ResetDatabase();
var historyRepository = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
var createHistoryTableOperation = GetCreateHistoryTableOperation();
createHistoryTableOperation.Columns.Remove(
createHistoryTableOperation.Columns.Single(c => c.Name == "ContextKey"));
createHistoryTableOperation.PrimaryKey.Columns.Remove("ContextKey");
ExecuteOperations(
createHistoryTableOperation,
new SqlOperation(
@"INSERT INTO [__MigrationHistory] ([MigrationId], [ProductVersion], [Model])
VALUES ('000000000000000_ExistingMigration',
'1.0',
0x1F8B0800000000000400ECBD07601C499625262F6DCA7B7F4AF54AD7E074A10880601324D8904010ECC188CDE692EC1D69472329AB2A81CA6556655D661640CCED9DBCF7DE7BEFBDF7DE7BEFBDF7BA3B9D4E27F7DFFF3F5C6664016CF6CE4ADAC99E2180AAC81F3F7E7C1F3F22FEC7BFF71F7CFC7BBC5B94E9655E3745B5FCECA3DDF1CE4769BE9C56B36279F1D947EBF67CFBE0A3DFE3E8374E1E9FCE16EFD29F34EDF6D08EDE5C369F7D346FDBD5A3BB779BE93C5F64CD78514CEBAAA9CEDBF1B45ADCCD66D5DDBD9D9D83BBBB3B777302F111C14AD3C7AFD6CBB658E4FC07FD79522DA7F9AA5D67E517D52C2F1BFD9CBE79CD50D317D9226F56D934FFEC236ADB54657EBC5A95C5346B099DDD8FD2E3B2C80895D77979FE9E78ED3C045E1FD91EA9CF53C2ADBDA67EDAAC58E63577CEFDB6F9BBF6A3F4AEC3EEAEA067867177601C8FBFC8562B22A8372EFD247DAD83DA7EFDFE782F04C6DD69B3097DDB535BD5D945DEF916E39AE5CF8ABA699F666D36C99AFCA3F464B688348B0C5F61DBF177C6F958FBBCCDA4769090261FA52FEBEAB2980181D7D74D9B2FC668307EFD8BCA93B2C897AD6BF045B62CCEF3A67D53BDCDC1A044A3AFCF160FEFEEEC812DEE36CDACBC156FF468B8814BFA54797CD71788C74FF3A6B820E89E782CF32958DD01356DCE96E715D16095D7EDF5EBBCF571354DCCD78AEC17799BCD08CFE3BA2DCEB3694B5F4FF3A6A179FB28FDC9AC5C5393D3C5249F9D2DBF5CB7AB757BDC34F962525E8763DADC3F8B4288F3E32F57F8CB6383AF3F0442B3A021E45F2E9FAC8B7266F17E969521ED874160CA3ECFE9735621AF5BFA995F5C5B482FAAE52D0129F99EE6AB7C3923967C932F5625016BBE5CBECE2EF361DC6EA66148B1C74F8BECA2CE163E05E513C5E475463D7B5D5007FE1BAE3FFAF3F15D28F4A3FF270000FFFF4817137F02060000)"));
Assert.True(historyRepository.Exists());
string _;
Assert.NotNull(historyRepository.GetLastModel(out _, out _));
Assert.NotEmpty(historyRepository.GetMigrationsSince("0"));
Assert.NotNull(historyRepository.GetModel("000000000000000_ExistingMigration", out _));
Assert.Equal("000000000000000_ExistingMigration", historyRepository.GetMigrationId("ExistingMigration"));
}
public void GetMigrationId_should_match_by_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey1");
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey2");
var model = CreateContext <ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("201109192032331_Migration1", model),
historyRepository1.CreateInsertOperation("201109192032332_Migration2", model),
historyRepository2.CreateInsertOperation("201109192032331_Migration1", model),
historyRepository2.CreateInsertOperation("201109192032332_Migration2", model)
});
var migrationId = historyRepository1.GetMigrationId("Migration1");
Assert.Equal("201109192032331_Migration1", migrationId);
migrationId = historyRepository1.GetMigrationId("migrATIon2");
Assert.Equal("201109192032332_Migration2", migrationId);
}
public void GetMigrationsSince_should_return_subset_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey1", null, HistoryContext.DefaultFactory);
var historyRepository2
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey2", null, HistoryContext.DefaultFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
using (var context = CreateContext <ShopContext_v1>())
{
var model = new VersionedModel(context.GetModel());
ExecuteOperations(
new[]
{
historyRepository1.CreateInsertOperation("Migration1", model),
historyRepository1.CreateInsertOperation("Migration2", model),
historyRepository2.CreateInsertOperation("Migration1", model),
historyRepository2.CreateInsertOperation("Migration2", model)
});
}
var migrations = historyRepository1.GetMigrationsSince("Migration1");
Assert.Equal(1, migrations.Count());
Assert.Equal("Migration2", migrations.Single());
}
public void GetMigrationsSince_should_return_subset_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey1");
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey2");
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext <ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository1.CreateInsertOperation("Migration1", model),
historyRepository1.CreateInsertOperation("Migration2", model),
historyRepository2.CreateInsertOperation("Migration1", model),
historyRepository2.CreateInsertOperation("Migration2", model)
});
var migrations = historyRepository1.GetMigrationsSince("Migration1");
Assert.Equal(1, migrations.Count());
Assert.Equal("Migration2", migrations.Single());
}
public void Exists_should_return_false_when_no_table()
{
ResetDatabase();
var historyRepository = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
Assert.False(historyRepository.Exists());
}
public void GetPendingMigrations_should_return_empty_set_when_no_data()
{
ResetDatabase();
var historyRepository = new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
Assert.False(historyRepository.GetPendingMigrations(Enumerable.Empty <string>()).Any());
}
public void GetPendingMigrations_should_return_empty_set_when_no_data()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey");
Assert.False(historyRepository.GetPendingMigrations(Enumerable.Empty <string>()).Any());
}
public void Exists_should_return_false_when_no_table()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey");
Assert.False(historyRepository.Exists());
}
public void GetMigrationId_should_return_null_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"), ProviderFactory, "MyKey");
Assert.Null(historyRepository.GetMigrationId(DbMigrator.InitialDatabase));
}
public void Exists_should_return_false_when_no_database()
{
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(),
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"),
ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
Assert.False(historyRepository.Exists());
}
public void GetUpgradeOperations_should_return_nothing_when_table_not_present()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey");
Assert.False(historyRepository.GetUpgradeOperations().Any());
}
public void GetPendingMigrations_should_return_empty_set_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"),
ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
Assert.False(historyRepository.GetPendingMigrations(Enumerable.Empty <string>()).Any());
}
public void GetUpgradeOperations_should_return_nothing_when_table_not_present()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
Assert.False(historyRepository.GetUpgradeOperations().Any());
}
public void GetUpgradeOperations_should_return_nothing_when_table_not_present()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of <InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
Assert.False(historyRepository.GetUpgradeOperations().Any());
}
public void Should_discover_column_max_lengths_from_model()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
Assert.Equal(150, historyRepository.MigrationIdMaxLength);
Assert.Equal(300, historyRepository.ContextKeyMaxLength);
}
public void AppendHistoryModel_should_add_system_elements_and_normalize_namespaces()
{
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory);
var modelBuilder = new DbModelBuilder(DbModelBuilderVersion.V4_1);
modelBuilder.Entity<FakeEntity>();
var model = modelBuilder.Build(ProviderInfo).GetModel();
historyRepository.AppendHistoryModel(model, ProviderInfo);
Assert.Equal(1, model.Descendants(EdmXNames.Csdl.EntityTypeNames.Last()).Count(e => e.IsSystemAttribute() == "true"));
Assert.Equal(1, model.Descendants(EdmXNames.Msl.EntitySetMappingNames.Last()).Count(e => e.IsSystemAttribute() == "true"));
Assert.Equal(1, model.Descendants(EdmXNames.Ssdl.EntityTypeNames.Last()).Count(e => e.IsSystemAttribute() == "true"));
Assert.Equal(1, model.Descendants(EdmXNames.Ssdl.EntitySetNames.Last()).Count(e => e.IsSystemAttribute() == "true"));
}
public void GetUpgradeOperations_should_return_alter_migration_id_column_when_5_to_6()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of<InternalContextForMock>(), ConnectionString, ProviderFactory, "MyKey", null, HistoryContext.DefaultFactory);
var createTableOperation = GetCreateHistoryTableOperation();
createTableOperation.Columns.Remove(createTableOperation.Columns.Single(c => c.Name == "ContextKey"));
createTableOperation.PrimaryKey.Columns.RemoveAt(1);
ExecuteOperations(createTableOperation);
var alterColumnOperation = historyRepository.GetUpgradeOperations().OfType<AlterColumnOperation>().Single();
Assert.Equal("MigrationId", alterColumnOperation.Column.Name);
Assert.Equal(150, alterColumnOperation.Column.MaxLength);
}
public void GetUpgradeOperations_should_return_add_product_version_column_when_not_present()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var createTableOperation = GetCreateHistoryTableOperation();
createTableOperation.Columns.Remove(createTableOperation.Columns.Last());
ExecuteOperations(createTableOperation);
var addColumnOperation = (AddColumnOperation)historyRepository.GetUpgradeOperations().Last();
Assert.Equal("ProductVersion", addColumnOperation.Column.Name);
Assert.Equal("0.7.0.0", addColumnOperation.Column.DefaultValue);
Assert.Equal(32, addColumnOperation.Column.MaxLength);
Assert.False(addColumnOperation.Column.IsNullable.Value);
}
public void GetUpgradeOperations_should_return_context_key_column_when_not_present()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var createTableOperation = GetCreateHistoryTableOperation();
createTableOperation.Columns.Remove(createTableOperation.Columns.Single(c => c.Name == "ContextKey"));
createTableOperation.PrimaryKey.Columns.RemoveAt(1);
ExecuteOperations(createTableOperation);
var addColumnOperation = historyRepository.GetUpgradeOperations().OfType<AddColumnOperation>().Single();
Assert.Equal("ContextKey", addColumnOperation.Column.Name);
Assert.Equal("MyKey", addColumnOperation.Column.DefaultValue);
Assert.Equal(512, addColumnOperation.Column.MaxLength);
Assert.False(addColumnOperation.Column.IsNullable.Value);
}
public void Generate_can_handle_update_database_operations()
{
var migrationSqlGenerator = new SqlCeMigrationSqlGenerator();
var providerInvariantName = ProviderRegistry.SqlCe4_ProviderInfo.ProviderInvariantName;
var historyRepository
= new HistoryRepository(
new SqlCeConnectionFactory(providerInvariantName)
.CreateConnection("Foo").ConnectionString,
DbProviderFactories.GetFactory(providerInvariantName),
"MyKey",
null);
var updateDatabaseOperation
= new UpdateDatabaseOperation(historyRepository.CreateDiscoveryQueryTrees().ToList());
updateDatabaseOperation.AddMigration("M1", new []{ new DropColumnOperation("Customers", "Foo") });
var sql = migrationSqlGenerator.Generate(new[] { updateDatabaseOperation }, "2008").Join(s => s.Sql, Environment.NewLine);
Assert.Equal(@"ALTER TABLE [Customers] DROP COLUMN [Foo]", sql);
}
public void Should_throw_when_upgrading_5_6_and_custom_history_context_factory_specified()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(
ConnectionString,
ProviderFactory,
"MyKey",
null,
historyContextFactory: (c, s) => new HistoryContext(c, s));
var createTableOperation = GetCreateHistoryTableOperation();
createTableOperation.Columns.Remove(createTableOperation.Columns.Single(c => c.Name == "ContextKey"));
createTableOperation.PrimaryKey.Columns.RemoveAt(1);
ExecuteOperations(createTableOperation);
Assert.Equal(
Strings.UnableToUpgradeHistoryWhenCustomFactory,
Assert.Throws<MigrationsException>(() => historyRepository.GetUpgradeOperations().ToList()).Message);
}
public void Exists_should_return_true_when_database_and_table()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
ExecuteOperations(GetCreateHistoryTableOperation());
Assert.True(historyRepository.Exists());
}
public void Exists_should_return_false_when_no_table()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
Assert.False(historyRepository.Exists());
}
public void Exists_should_return_false_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"),
ProviderFactory, "MyKey", null);
Assert.False(historyRepository.Exists());
}
public void GetModel_should_return_model_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "Key1", null);
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", model));
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "Key2", null);
ExecuteOperations(
new[] { historyRepository2.CreateInsertOperation("Migration 2", model) });
model = historyRepository1.GetModel("Migration 1");
Assert.NotNull(model);
model = historyRepository2.GetModel("Migration 2");
Assert.NotNull(model);
}
public void GetMigrationsSince_should_return_empty_when_target_valid_but_is_latest()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("Migration1", model),
historyRepository.CreateInsertOperation("Migration2", model)
});
var migrations = historyRepository.GetMigrationsSince("Migration2");
Assert.Equal(0, migrations.Count());
}
internal DbMigrator(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, bool calledByCreateDatabase)
: base(null)
{
Check.NotNull(configuration, "configuration");
Check.NotNull(configuration.ContextType, "configuration.ContextType");
_configuration = configuration;
_calledByCreateDatabase = calledByCreateDatabase;
_existenceState = existenceState;
if (usersContext != null)
{
_usersContextInfo = new DbContextInfo(usersContext);
}
else
{
_usersContextInfo
= configuration.TargetDatabase == null
? new DbContextInfo(configuration.ContextType)
: new DbContextInfo(configuration.ContextType, configuration.TargetDatabase);
if (!_usersContextInfo.IsConstructible)
{
throw Error.ContextNotConstructible(configuration.ContextType);
}
}
_modelDiffer = _configuration.ModelDiffer;
var context = usersContext ?? _usersContextInfo.CreateInstance();
_usersContext = context;
try
{
_migrationAssembly
= new MigrationAssembly(
_configuration.MigrationsAssembly,
_configuration.MigrationsNamespace);
_currentModel = context.GetModel();
_connection = context.Database.Connection;
_providerFactory = DbProviderServices.GetProviderFactory(_connection);
_defaultSchema
= context.InternalContext.DefaultSchema
?? EdmModelExtensions.DefaultSchema;
_historyContextFactory
= _configuration
.GetHistoryContextFactory(_usersContextInfo.ConnectionProviderName);
_historyRepository
= new HistoryRepository(
context.InternalContext,
_usersContextInfo.ConnectionString,
_providerFactory,
_configuration.ContextKey,
_configuration.CommandTimeout,
_historyContextFactory,
schemas: new[] { _defaultSchema }.Concat(GetHistorySchemas()),
contextForInterception: _usersContext,
initialExistence: _existenceState);
_providerManifestToken
= context.InternalContext.ModelProviderInfo != null
? context.InternalContext.ModelProviderInfo.ProviderManifestToken
: DbConfiguration
.DependencyResolver
.GetService<IManifestTokenResolver>()
.ResolveManifestToken(_connection);
var modelBuilder
= context.InternalContext.CodeFirstModel.CachedModelBuilder;
_modificationCommandTreeGenerator
= new Lazy<ModificationCommandTreeGenerator>(
() =>
new ModificationCommandTreeGenerator(
modelBuilder.BuildDynamicUpdateModel(
new DbProviderInfo(
_usersContextInfo.ConnectionProviderName,
_providerManifestToken)),
CreateConnection()));
var interceptionContext = new DbInterceptionContext();
interceptionContext = interceptionContext.WithDbContext(_usersContext);
_targetDatabase
= Strings.LoggingTargetDatabaseFormat(
DbInterception.Dispatch.Connection.GetDataSource(_connection, interceptionContext),
DbInterception.Dispatch.Connection.GetDatabase(_connection, interceptionContext),
_usersContextInfo.ConnectionProviderName,
_usersContextInfo.ConnectionStringOrigin == DbConnectionStringOrigin.DbContextInfo
? Strings.LoggingExplicit
: _usersContextInfo.ConnectionStringOrigin.ToString());
_legacyContextKey = context.InternalContext.DefaultContextKey;
_emptyModel = GetEmptyModel();
}
finally
{
if (usersContext == null)
{
_usersContext = null;
context.Dispose();
}
}
}
public void CreateDeleteOperation_should_return_valid_history_operation()
{
var modelBuilder = new DbModelBuilder();
var model = modelBuilder.Build(ProviderInfo);
var edmxString = new StringBuilder();
using (var xmlWriter = XmlWriter.Create(
edmxString, new XmlWriterSettings
{
Indent = true
}))
{
EdmxWriter.WriteEdmx(model, xmlWriter);
}
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var historyOperation
= (HistoryOperation)historyRepository.CreateDeleteOperation("Migration1");
Assert.NotEmpty(historyOperation.Commands);
Assert.Equal(2, historyOperation.Commands.Single().Parameters.Count);
}
public void GetLastModel_should_return_null_when_no_data()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var modelBuilder = new DbModelBuilder();
modelBuilder.Entity<MigrationsCustomer>();
Assert.Null(historyRepository.GetLastModel());
}
public void GetLastModel_should_return_null_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"),
ProviderFactory, "MyKey", null);
var modelBuilder = new DbModelBuilder();
modelBuilder.Entity<MigrationsCustomer>();
Assert.Null(historyRepository.GetLastModel());
}
public void GetPendingMigrations_should_ignore_InitialCreate_timestamps()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository.CreateInsertOperation("000000000000001_InitialCreate", model));
var pendingMigrations = historyRepository.GetPendingMigrations(
new[] { "000000000000002_InitialCreate", "Migration 1" });
Assert.Equal("Migration 1", pendingMigrations.Single());
}
public void GetPendingMigrations_should_return_migrations_based_on_context_key()
{
ResetDatabase();
var historyRepository1 = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey1", null);
var historyRepository2 = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey2", null);
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository1.CreateInsertOperation("Migration 1", model),
historyRepository2.CreateInsertOperation("Migration 1", model),
historyRepository1.CreateInsertOperation("Migration 3", model),
historyRepository1.CreateInsertOperation("Migration 5", model));
var pendingMigrations =
historyRepository1.GetPendingMigrations(
new[] { "Migration 1", "Migration 2", "Migration 3", "Migration 4", "Migration 5" });
Assert.Equal("Migration 2", pendingMigrations.First());
Assert.Equal("Migration 4", pendingMigrations.Last());
}
public void GetPendingMigrations_should_return_empty_set_when_no_data()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
Assert.False(historyRepository.GetPendingMigrations(Enumerable.Empty<string>()).Any());
}
public void GetPendingMigrations_should_return_empty_set_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"),
ProviderFactory, "MyKey", null);
Assert.False(historyRepository.GetPendingMigrations(Enumerable.Empty<string>()).Any());
}
public void Repository_should_work_gracefully_when_no_context_key_column()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var createHistoryTableOperation = GetCreateHistoryTableOperation();
createHistoryTableOperation.Columns.Remove(
createHistoryTableOperation.Columns.Single(c => c.Name == "ContextKey"));
createHistoryTableOperation.PrimaryKey.Columns.Remove("ContextKey");
ExecuteOperations(
createHistoryTableOperation,
new SqlOperation(
@"INSERT INTO [__MigrationHistory] ([MigrationId], [ProductVersion], [Model])
VALUES ('000000000000000_ExistingMigration',
'1.0',
0x1F8B0800000000000400ECBD07601C499625262F6DCA7B7F4AF54AD7E074A10880601324D8904010ECC188CDE692EC1D69472329AB2A81CA6556655D661640CCED9DBCF7DE7BEFBDF7DE7BEFBDF7BA3B9D4E27F7DFFF3F5C6664016CF6CE4ADAC99E2180AAC81F3F7E7C1F3F22FEC7BFF71F7CFC7BBC5B94E9655E3745B5FCECA3DDF1CE4769BE9C56B36279F1D947EBF67CFBE0A3DFE3E8374E1E9FCE16EFD29F34EDF6D08EDE5C369F7D346FDBD5A3BB779BE93C5F64CD78514CEBAAA9CEDBF1B45ADCCD66D5DDBD9D9D83BBBB3B777302F111C14AD3C7AFD6CBB658E4FC07FD79522DA7F9AA5D67E517D52C2F1BFD9CBE79CD50D317D9226F56D934FFEC236ADB54657EBC5A95C5346B099DDD8FD2E3B2C80895D77979FE9E78ED3C045E1FD91EA9CF53C2ADBDA67EDAAC58E63577CEFDB6F9BBF6A3F4AEC3EEAEA067867177601C8FBFC8562B22A8372EFD247DAD83DA7EFDFE782F04C6DD69B3097DDB535BD5D945DEF916E39AE5CF8ABA699F666D36C99AFCA3F464B688348B0C5F61DBF177C6F958FBBCCDA4769090261FA52FEBEAB2980181D7D74D9B2FC668307EFD8BCA93B2C897AD6BF045B62CCEF3A67D53BDCDC1A044A3AFCF160FEFEEEC812DEE36CDACBC156FF468B8814BFA54797CD71788C74FF3A6B820E89E782CF32958DD01356DCE96E715D16095D7EDF5EBBCF571354DCCD78AEC17799BCD08CFE3BA2DCEB3694B5F4FF3A6A179FB28FDC9AC5C5393D3C5249F9D2DBF5CB7AB757BDC34F962525E8763DADC3F8B4288F3E32F57F8CB6383AF3F0442B3A021E45F2E9FAC8B7266F17E969521ED874160CA3ECFE9735621AF5BFA995F5C5B482FAAE52D0129F99EE6AB7C3923967C932F5625016BBE5CBECE2EF361DC6EA66148B1C74F8BECA2CE163E05E513C5E475463D7B5D5007FE1BAE3FFAF3F15D28F4A3FF270000FFFF4817137F02060000)"));
Assert.True(historyRepository.Exists());
Assert.NotNull(historyRepository.GetLastModel());
Assert.NotEmpty(historyRepository.GetMigrationsSince("0"));
Assert.NotNull(historyRepository.GetModel("000000000000000_ExistingMigration"));
Assert.Equal("000000000000000_ExistingMigration", historyRepository.GetMigrationId("ExistingMigration"));
}
public void GetMigrationId_should_throw_when_name_ambiguous()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("201109192032331_Migration", model),
historyRepository.CreateInsertOperation("201109192032332_Migration", model)
});
Assert.Equal(
Strings.AmbiguousMigrationName("Migration"),
Assert.Throws<MigrationsException>(() => historyRepository.GetMigrationId("Migration")).Message);
}
public void GetMigrationId_should_return_null_when_no_database()
{
var historyRepository
= new HistoryRepository(
ConnectionString.Replace(DatabaseProviderFixture.DefaultDatabaseName, "NoSuchDatabase"), ProviderFactory, "MyKey", null);
Assert.Null(historyRepository.GetMigrationId(DbMigrator.InitialDatabase));
}
public void HistoryRepository_sets_timeout_onto_HistoryContext()
{
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", 77);
using (var connection = new SqlConnection())
{
using (var context = historyRepository.CreateContext(connection))
{
Assert.Equal(77, context.Database.CommandTimeout);
}
}
}
public void GetLastModel_should_return_model_when_row()
{
ResetDatabase();
var historyRepository = new HistoryRepository(ConnectionString, ProviderFactory, "MyKey", null);
var model1 = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(),
historyRepository.CreateInsertOperation("Migration 1", model1));
ExecuteOperations(
new[] { historyRepository.CreateInsertOperation("Migration 2", model1) });
string migrationId;
var model2 = historyRepository.GetLastModel(out migrationId);
Assert.NotNull(model2);
Assert.True(XNode.DeepEquals(model1, model2));
Assert.Equal("Migration 2", migrationId);
}
public void GetLastModel_should_return_model_based_on_passed_context_key_when_custom_default_schema()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "LegacyKey", null)
{
CurrentSchema = "foo"
};
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
GetCreateHistoryTableOperation(historyRepository.CurrentSchema),
historyRepository.CreateInsertOperation("Migration", model));
historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "NewKey", null, new[] { "foo" });
string migrationId;
model = historyRepository.GetLastModel(out migrationId, "LegacyKey");
Assert.NotNull(model);
Assert.Equal("Migration", migrationId);
}
public void GetMigrationsSince_should_return_subset_based_on_context_key()
{
ResetDatabase();
var historyRepository1
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey1", null);
var historyRepository2
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey2", null);
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository1.CreateInsertOperation("Migration1", model),
historyRepository1.CreateInsertOperation("Migration2", model),
historyRepository2.CreateInsertOperation("Migration1", model),
historyRepository2.CreateInsertOperation("Migration2", model)
});
var migrations = historyRepository1.GetMigrationsSince("Migration1");
Assert.Equal(1, migrations.Count());
Assert.Equal("Migration2", migrations.Single());
}
