public void ReplicationBasicTest() { string SOURCE_DATABASE_NAME = _testDatabaseProvider.GenerateUniqueDatabaseName("TestReplication_Source"); string TARGET_DATABASE_NAME = _testDatabaseProvider.GenerateUniqueDatabaseName("TestReplication_Target"); const string SCHEMA = "dbo"; _testDatabaseProvider.CreateTestDatabase(SOURCE_DATABASE_NAME); try { _testDatabaseProvider.CreateTestDatabase(TARGET_DATABASE_NAME); try { Student student; using (var testContext = new TestContext(_connectionString + $";Database={SOURCE_DATABASE_NAME}")) { var standard = new Standard() { StandardName = "Standard" }; testContext.Standards.Add(standard); student = testContext.Students.Add(new Student() { Standard = standard, Weight = 70, Height = 178, StudentName = "Jan Halama", DateOfBirth = DateTime.Now, Photo = new byte[] { 0, 1, 2, 3 } }); testContext.SaveChanges(); } using (var testContext = new TestContext(_connectionString + $";Database={TARGET_DATABASE_NAME}")) { testContext.Standards.Select(s => s.StandardId > 0); testContext.Students.Select(s => s.StudentId > 0); testContext.SaveChanges(); } IReplicationStrategy replicationStrategy = new Strategies.TableSnapshotReplicationStrategy(_connectionString, _connectionString, _logMock.Object, _foreignKeysDropCreateScriptProvider, new SqlCommandFactory()); replicationStrategy.Replicate(new ReplicationArticle() { SourceDatabaseName = SOURCE_DATABASE_NAME, TargetDatabaseName = TARGET_DATABASE_NAME, ArticleName = "Standards", SourceSchema = SCHEMA, TargetSchema = SCHEMA, ArticleType = DataContracts.Enums.eArticleType.TABLE }); replicationStrategy.Replicate(new ReplicationArticle() { SourceDatabaseName = SOURCE_DATABASE_NAME, TargetDatabaseName = TARGET_DATABASE_NAME, ArticleName = "Students", SourceSchema = SCHEMA, TargetSchema = SCHEMA, ArticleType = DataContracts.Enums.eArticleType.TABLE }); using (var testContext = new TestContext(_connectionString + $";Database={TARGET_DATABASE_NAME}")) { Assert.True(testContext.Students.Any(s => s.StudentId == student.StudentId && s.StudentName == s.StudentName && s.Standard.StandardId == student.Standard.StandardId), "Target db not as expected after replication"); } } finally { _testDatabaseProvider.DropTestDatabase(TARGET_DATABASE_NAME); } } finally { _testDatabaseProvider.DropTestDatabase(SOURCE_DATABASE_NAME); } }
public void ReplicationTest100kRows() { string SOURCE_DATABASE_NAME = _testDatabaseProvider.GenerateUniqueDatabaseName("TestReplication_Source"); string TARGET_DATABASE_NAME = _testDatabaseProvider.GenerateUniqueDatabaseName("TestReplication_Target"); const string SCHEMA = "dbo"; _testDatabaseProvider.CreateTestDatabase(SOURCE_DATABASE_NAME); try { _testDatabaseProvider.CreateTestDatabase(TARGET_DATABASE_NAME); try { using (var testContext = new TestContext(_connectionString + $";Database={SOURCE_DATABASE_NAME}")) { var standard = new Standard() { StandardName = "Standard" }; standard = testContext.Standards.Add(standard); testContext.SaveChanges(); List<Student> students2Add = new List<Student>(); for (int i = 0; i < 100000; i++) { students2Add.Add(new Student() { StandardId = standard.StandardId, Weight = 70 + i, Height = 178 + i, StudentName = $"Student {i}", DateOfBirth = DateTime.Now, Photo = new byte[] { 0, 1, 2, 3 } }); } testContext.BulkInsert(students2Add); testContext.SaveChanges(); } using (var testContext = new TestContext(_connectionString + $";Database={TARGET_DATABASE_NAME}")) { var standard = new Standard() { StandardName = "Standard" }; standard = testContext.Standards.Add(standard); testContext.SaveChanges(); List<Student> students2Add = new List<Student>(); for (int i = 0; i < 100000; i++) { students2Add.Add(new Student() { StandardId = standard.StandardId, Weight = 0, Height = 0, StudentName = $"Student old {i}", DateOfBirth = DateTime.Now, Photo = new byte[] { 0, 1, 2, 3 } }); } testContext.BulkInsert(students2Add); testContext.SaveChanges(); } IReplicationStrategy replicationStrategy = new Strategies.TableSnapshotReplicationStrategy(_connectionString, _connectionString, _logMock.Object, _foreignKeysDropCreateScriptProvider, new SqlCommandFactory()); replicationStrategy.Replicate(new ReplicationArticle() { SourceDatabaseName = SOURCE_DATABASE_NAME, TargetDatabaseName = TARGET_DATABASE_NAME, ArticleName = "Standards", SourceSchema = SCHEMA, TargetSchema = SCHEMA, ArticleType = DataContracts.Enums.eArticleType.TABLE }); replicationStrategy.Replicate(new ReplicationArticle() { SourceDatabaseName = SOURCE_DATABASE_NAME, TargetDatabaseName = TARGET_DATABASE_NAME, ArticleName = "Students", SourceSchema = SCHEMA, TargetSchema = SCHEMA, ArticleType = DataContracts.Enums.eArticleType.TABLE }); using (var testContext = new TestContext(_connectionString + $";Database={TARGET_DATABASE_NAME}")) { Assert.Equal(100000, testContext.Students.Count()); for (int i = 0; i < 100000; i += 99) { string expectedStudentName = $"Student {i}"; Assert.True(null != testContext.Students.Single(s => s.StudentName == expectedStudentName && s.Weight == 70 + i && s.Height == 178 + i), $"Student {i} not found"); } } } finally { _testDatabaseProvider.DropTestDatabase(TARGET_DATABASE_NAME); } } finally { _testDatabaseProvider.DropTestDatabase(SOURCE_DATABASE_NAME); } }