public void TestDbBulkInserter()
{
//init db
System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways <InsertContext>());
AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);
var connectString =
@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\TestDbBulkInserter.mdf;Initial Catalog=dbinserter;Integrated Security=True;Connect Timeout=30";
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter <Entity2>(connectString, "dbo.Seods", BlockContainerOptions.Default,
GSProduct.SEOD);
var entities = new Entity2[]
{
new Entity2(1, 0.5f, "a"),
new Entity2(2, 0.6f, "b"),
new Entity2(3, 0.7f, "c"),
};
foreach (var entity in entities)
{
inserter.InputBlock.SafePost(entity);
}
inserter.InputBlock.Complete();
inserter.CompletionTask.Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.FirstOrDefault(s => s.Id == 2).Name);
Assert.AreEqual(0.7f, context.Seods.FirstOrDefault(s => s.Id == 3).Price);
}
public void TestDbBulkInserter_NoNullCheck()
{
//init db
Database.SetInitializer(new DropCreateDatabaseAlways<InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter<Entity3>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var guid = Guid.NewGuid();
var entities = new Entity3[]
{
new Entity3(1) { Key = "a", Value = 0.5f, MyLeg = new Leg() {}},
new Entity3(2) { Key = "b", MyLeg = new Leg() { LegInt = 5, LegString = "bleg" } }
};
var entities2 = new[]
{
new Entity3(3)
{
Value = 0.7f,
MyLeg = new Leg(),
UID = guid,
RawData = Encoding.ASCII.GetBytes("abc")
}
};
inserter.ProcessMultipleAsync(true, entities, entities2).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual("LegString2", context.Seods.Find(2).LegString2);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
Assert.AreEqual("LegString2", context.Seods.Find(3).LegString2);
Assert.AreEqual(guid, context.Seods.Find(3).Uid);
Assert.AreEqual("abc", Encoding.ASCII.GetString(context.Seods.Find(3).RawData));
}
public void TestMultiDbBulkINserter()
{
System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways <InsertContext>());
AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);
var connectString =
@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\TestMultiDbBulkInserter_{0}.mdf;Initial Catalog=multidbinserter_{1};Integrated Security=True;Connect Timeout=30";
//init db
int profileIdCount = 3;
for (int i = 1; i <= profileIdCount; ++i)
{
var init = new Init2();
var context = new InsertContext(string.Format(connectString, i, i));
context.Inits.Add(init);
context.SaveChanges();
}
var profileDispatch = new Func <Entity2, int>(e => e.ProfileId);
var connectionGetter = new Func <int, string>(id => string.Format(connectString, id, id));
var multiDbBulkInserter = new MultiDbBulkInserter <Entity2>(BlockContainerOptions.Default, profileDispatch,
connectionGetter, "dbo.Seods", GSProduct.SEOD);
var entities = new[]
{
new Entity2(1, 1f, "a"),
new Entity2(2, 2f, "b"),
new Entity2(2, 2f, "c"),
new Entity2(3, 3f, "d"),
new Entity2(3, 3f, "e"),
new Entity2(3, 3f, "f")
};
foreach (var x in entities)
{
multiDbBulkInserter.InputBlock.Post(x);
}
multiDbBulkInserter.InputBlock.Complete();
multiDbBulkInserter.CompletionTask.Wait();
//assert result
for (int i = 1; i <= profileIdCount; ++i)
{
var connString = connectionGetter(i);
var curContext = new InsertContext(connString);
Assert.AreEqual(i, curContext.Seods.Count());
Assert.AreEqual(i, curContext.Seods.FirstOrDefault().Price);
}
}
public void TestDbBulkInserter()
{
//init db
Database.SetInitializer(new DropCreateDatabaseAlways <InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter <Entity2>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var entities = new Entity2[]
{
new Entity2(1)
{
Key = "a", Value = 0.5f
},
new Entity2(2)
{
Key = "b", MyLeg = new Leg()
{
LegInt = 5, LegString = "bleg"
}
},
new Entity2(3)
{
Value = 0.7f
},
};
inserter.ProcessAsync(entities, true).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
}
public void TestMultiDbBulkInserter()
{
Database.SetInitializer(new DropCreateDatabaseAlways <InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString("TestMultiDbBulkInserter_{0}");
//init db
int profileIdCount = 3;
for (int i = 1; i <= profileIdCount; ++i)
{
var init = new Init2();
var context = new InsertContext(string.Format(connectString, i, i));
context.Inits.Add(init);
context.SaveChanges();
}
var profileDispatch = new Func <Entity2, int>(e => e.ProfileId);
var connectionGetter = new Func <int, string>(id => string.Format(connectString, id, id));
var multiDbBulkInserter = new MultiDbBulkInserter <Entity2>(DataflowOptions.Default, profileDispatch,
connectionGetter, "dbo.Seods", GSProduct.SEOD);
var entities = new[]
{
new Entity2(1, 1f, "a"),
new Entity2(2, 2f, "b"),
new Entity2(2, 2f, "c"),
new Entity2(3, 3f, "d"),
new Entity2(3, 3f, "e"),
new Entity2(3, 3f, "f")
};
multiDbBulkInserter.ProcessAsync(entities).Wait();
//assert result
for (int i = 1; i <= profileIdCount; ++i)
{
var connString = connectionGetter(i);
var curContext = new InsertContext(connString);
Assert.AreEqual(i, curContext.Seods.Count());
Assert.AreEqual(i, curContext.Seods.FirstOrDefault().Price);
Assert.IsTrue(curContext.Seods.FirstOrDefault().Name.Length == 1);
Assert.IsTrue(curContext.Seods.FirstOrDefault().Name2.Length == 1);
}
}
public void TestDbBulkInserter()
{
//init db
Database.SetInitializer(new DropCreateDatabaseAlways<InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter<Entity2>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var entities = new Entity2[]
{
new Entity2(1) { Key = "a", Value = 0.5f },
new Entity2(2) { Key = "b", MyLeg = new Leg() { LegInt = 5, LegString = "bleg" } },
new Entity2(3) { Value = 0.7f },
};
inserter.ProcessAsync(entities, true).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
}
public void TestMultiDbBulkInserter()
{
Database.SetInitializer(new DropCreateDatabaseAlways<InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString("TestMultiDbBulkInserter_{0}");
//init db
int profileIdCount = 3;
for (int i = 1; i <= profileIdCount; ++i)
{
var init = new Init2();
var context = new InsertContext(string.Format(connectString, i, i));
context.Inits.Add(init);
context.SaveChanges();
}
var profileDispatch = new Func<Entity2, int>(e => e.ProfileId);
var connectionGetter = new Func<int, string>(id => string.Format(connectString, id, id));
var multiDbBulkInserter = new MultiDbBulkInserter<Entity2>(DataflowOptions.Default, profileDispatch,
connectionGetter, "dbo.Seods", GSProduct.SEOD);
var entities = new[]
{
new Entity2(1, 1f, "a"),
new Entity2(2, 2f, "b"),
new Entity2(2, 2f, "c"),
new Entity2(3, 3f, "d"),
new Entity2(3, 3f, "e"),
new Entity2(3, 3f, "f")
};
multiDbBulkInserter.ProcessAsync(entities).Wait();
//assert result
for (int i = 1; i <= profileIdCount; ++i)
{
var connString = connectionGetter(i);
var curContext = new InsertContext(connString);
Assert.AreEqual(i, curContext.Seods.Count());
Assert.AreEqual(i, curContext.Seods.FirstOrDefault().Price);
Assert.IsTrue(curContext.Seods.FirstOrDefault().Name.Length == 1);
Assert.IsTrue(curContext.Seods.FirstOrDefault().Name2.Length == 1);
}
}
public void TestDbBulkInserter_NoNullCheck()
{
//init db
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter <Entity3>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var guid = Guid.NewGuid();
var entities = new Entity3[]
{
new Entity3(1)
{
Key = "a", Value = 0.5f, MyLeg = new Leg()
{
}
},
new Entity3(2)
{
Key = "b", MyLeg = new Leg()
{
LegInt = 5, LegString = "bleg"
}
}
};
var entities2 = new[]
{
new Entity3(3)
{
Value = 0.7f,
MyLeg = new Leg(),
UID = guid,
RawData = Encoding.ASCII.GetBytes("abc")
}
};
inserter.ProcessMultipleAsync(true, entities, entities2).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual("LegString2", context.Seods.Find(2).LegString2);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
Assert.AreEqual("LegString2", context.Seods.Find(3).LegString2);
Assert.AreEqual(guid, context.Seods.Find(3).Uid);
Assert.AreEqual("abc", Encoding.ASCII.GetString(context.Seods.Find(3).RawData));
}
