public void Can_convert_delete_command_trees_when_many_to_many()
{
var model = TestContext.CreateDynamicUpdateModel();
var modificationFunctionMapping
= TestContext.GetAssociationModificationFunctionMapping("OrderThing_Orders");
var converter
= new DynamicToFunctionModificationCommandConverter(
modificationFunctionMapping.Item1, modificationFunctionMapping.Item2);
var modificationCommandTreeGenerator
= new ModificationCommandTreeGenerator(model);
var commandTrees
= modificationCommandTreeGenerator
.GenerateAssociationDelete(modificationFunctionMapping.Item1.AssociationSet.ElementType.FullName);
Assert.Equal(1, commandTrees.Count());
var resultTrees = converter.Convert(commandTrees);
Assert.Equal(1, resultTrees.Count());
var commandTree = resultTrees.First();
Assert.Equal(5, commandTree.Parameters.Count());
Assert.Equal("order_thing_id", commandTree.Parameters.ElementAt(0).Key);
Assert.Equal("Order_Id", commandTree.Parameters.ElementAt(1).Key);
Assert.Equal("Order_Key", commandTree.Parameters.ElementAt(2).Key);
Assert.Equal("teh_codez_bro", commandTree.Parameters.ElementAt(3).Key);
Assert.Equal("Order_Signature", commandTree.Parameters.ElementAt(4).Key);
Assert.NotNull(commandTree.Predicate);
}
public void Can_convert_insert_command_trees_when_table_splitting()
{
var model = TestContext.CreateDynamicUpdateModel();
var modificationFunctionMapping
= TestContext.GetModificationFunctionMapping("JobTask");
var converter
= new DynamicToFunctionModificationCommandConverter(
modificationFunctionMapping.Item1, modificationFunctionMapping.Item2);
var modificationCommandTreeGenerator
= new ModificationCommandTreeGenerator(model);
var commandTrees
= modificationCommandTreeGenerator
.GenerateInsert(modificationFunctionMapping.Item1.EntityType.FullName)
.ToList();
Assert.Equal(1, commandTrees.Count());
var resultTrees = converter.Convert(commandTrees).ToList();
Assert.Equal(1, resultTrees.Count());
var firstCommandTree = (DbUpdateCommandTree)resultTrees.First();
Assert.Equal(2, firstCommandTree.Parameters.Count());
}
public void Can_convert_update_command_trees()
{
var model = TestContext.CreateDynamicUpdateModel();
var modificationFunctionMapping
= TestContext.GetModificationFunctionMapping("ExtraSpecialOrder");
var converter
= new DynamicToFunctionModificationCommandConverter(
modificationFunctionMapping.Item1, modificationFunctionMapping.Item2);
var modificationCommandTreeGenerator
= new ModificationCommandTreeGenerator(model);
var commandTrees
= modificationCommandTreeGenerator
.GenerateUpdate(modificationFunctionMapping.Item1.EntityType.FullName);
Assert.Equal(3, commandTrees.Count());
var resultTrees = converter.Convert(commandTrees);
Assert.Equal(3, resultTrees.Count());
var firstCommandTree = (DbUpdateCommandTree)resultTrees.First();
Assert.Equal(12, firstCommandTree.Parameters.Count());
Assert.Equal(6, firstCommandTree.SetClauses.Count());
Assert.Equal("Name", firstCommandTree.Parameters.ElementAt(0).Key);
Assert.Equal("Address_Street", firstCommandTree.Parameters.ElementAt(1).Key);
Assert.Equal("Address_City", firstCommandTree.Parameters.ElementAt(2).Key);
Assert.Equal("Address_CountryOrRegion_Name", firstCommandTree.Parameters.ElementAt(3).Key);
Assert.Equal("OrderGroupId", firstCommandTree.Parameters.ElementAt(4).Key);
Assert.Equal("Customer_CustomerId", firstCommandTree.Parameters.ElementAt(5).Key);
Assert.Equal("xid", firstCommandTree.Parameters.ElementAt(6).Key);
Assert.Equal("key_for_update", firstCommandTree.Parameters.ElementAt(7).Key);
Assert.Equal("Code", firstCommandTree.Parameters.ElementAt(8).Key);
Assert.Equal("Signature", firstCommandTree.Parameters.ElementAt(9).Key);
Assert.Equal("Name_Original", firstCommandTree.Parameters.ElementAt(10).Key);
Assert.Equal("RowVersion_Original", firstCommandTree.Parameters.ElementAt(11).Key);
var properties = ((RowType)firstCommandTree.Returning.ResultType.EdmType).Properties;
Assert.Equal(2, properties.Count);
Assert.Equal("order_fu", properties[0].Name);
}
public void Can_convert_insert_command_trees()
{
var model = TestContext.CreateDynamicUpdateModel();
var modificationFunctionMapping
= TestContext.GetModificationFunctionMapping("ExtraSpecialOrder");
var converter
= new DynamicToFunctionModificationCommandConverter(
modificationFunctionMapping.Item1, modificationFunctionMapping.Item2);
var modificationCommandTreeGenerator
= new ModificationCommandTreeGenerator(model);
var commandTrees
= modificationCommandTreeGenerator
.GenerateInsert(modificationFunctionMapping.Item1.EntityType.FullName);
Assert.Equal(3, commandTrees.Count());
var resultTrees = converter.Convert(commandTrees);
Assert.Equal(3, resultTrees.Count());
var firstCommandTree = (DbInsertCommandTree)resultTrees.First();
Assert.Equal(8, firstCommandTree.Parameters.Count());
Assert.Equal(8, firstCommandTree.SetClauses.Count());
Assert.Equal("teh_codez", firstCommandTree.Parameters.ElementAt(0).Key);
Assert.Equal("Signature", firstCommandTree.Parameters.ElementAt(1).Key);
Assert.Equal("the_name", firstCommandTree.Parameters.ElementAt(2).Key);
Assert.Equal("Address_Street", firstCommandTree.Parameters.ElementAt(3).Key);
Assert.Equal("Address_City", firstCommandTree.Parameters.ElementAt(4).Key);
Assert.Equal("Address_CountryOrRegion_Name", firstCommandTree.Parameters.ElementAt(5).Key);
Assert.Equal("OrderGroupId", firstCommandTree.Parameters.ElementAt(6).Key);
Assert.Equal("Customer_CustomerId", firstCommandTree.Parameters.ElementAt(7).Key);
var properties = ((RowType)firstCommandTree.Returning.ResultType.EdmType).Properties;
Assert.Equal(4, properties.Count);
Assert.Equal("key_result", properties[1].Name);
}
public void Can_convert_delete_command_trees()
{
var model = TestContext.CreateDynamicUpdateModel();
var modificationFunctionMapping
= TestContext.GetModificationFunctionMapping("ExtraSpecialOrder");
var converter
= new DynamicToFunctionModificationCommandConverter(
modificationFunctionMapping.Item1, modificationFunctionMapping.Item2);
var modificationCommandTreeGenerator
= new ModificationCommandTreeGenerator(model);
var commandTrees
= modificationCommandTreeGenerator
.GenerateDelete(modificationFunctionMapping.Item1.EntityType.FullName);
Assert.Equal(3, commandTrees.Count());
var resultTrees = converter.Convert(commandTrees);
Assert.Equal(3, resultTrees.Count());
var lastCommandTree = resultTrees.Last();
Assert.Equal(7, lastCommandTree.Parameters.Count());
Assert.Equal("xid", lastCommandTree.Parameters.ElementAt(0).Key);
Assert.Equal("key_for_delete", lastCommandTree.Parameters.ElementAt(1).Key);
Assert.Equal("Code", lastCommandTree.Parameters.ElementAt(2).Key);
Assert.Equal("Signature", lastCommandTree.Parameters.ElementAt(3).Key);
Assert.Equal("Name_Original", lastCommandTree.Parameters.ElementAt(4).Key);
Assert.Equal("RowVersion_Original", lastCommandTree.Parameters.ElementAt(5).Key);
Assert.Equal("Customer_CustomerId", lastCommandTree.Parameters.ElementAt(6).Key);
}
