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 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 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 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_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 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 GetMigrationId_should_throw_when_name_ambiguous()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory, "MyKey");
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 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_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 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_match_by_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(
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 GetMigrationId_should_match_on_name()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(Mock.Of<InternalContextForMock>(), 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 GetMigrationId_should_match_on_name()
{
ResetDatabase();
var historyRepository
= new HistoryRepository(ConnectionString, ProviderFactory);
ExecuteOperations(GetCreateHistoryTableOperation());
var model = CreateContext<ShopContext_v1>().GetModel();
ExecuteOperations(
new[]
{
historyRepository.CreateInsertOperation("201109192032331_Migration1", model)
});
ExecuteOperations(
new[]
{
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 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);
}