public void insert_with_no_reference_data_inserts_in_parent_and_child()
{
var newDto = new GuidParentDto {
OneToManyChildDto = new [] { new GuidOneToManyChildDto() }
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, null, newDto, 2, 2, 2, 0, 0, 2, 2, 0, 0);
var list = new List<BaseCommand>(commands);
Assert.AreEqual(
2,
list.Count,
"Unexpected number of commands.");
var command = list[0] as InsertCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected table name for parent.");
command = list[1] as InsertCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManyChildDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected table name for child.");
}
public void update_with_no_reference_data_updates_in_parent_and_child() {
var oldDto = new GuidParentDto {
ParentKey = Guid.NewGuid(),
OneToManyChildDto = new [] { new GuidOneToManyChildDto
{
ChildKey = Guid.NewGuid()
} }
};
var newDto = new GuidParentDto
{
ParentKey = oldDto.ParentKey,
ParentName = "ParentNameUpdated",
OneToManyChildDto = new [] { new GuidOneToManyChildDto
{
ChildKey = oldDto.OneToManyChildDto[0].ChildKey,
Name = "Maximum Whoopee! Enabled"
} }
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, oldDto, newDto, 2, 2, 0, 2, 0, 2, 0, 2, 0);
var list = new List<BaseCommand>(commands);
Assert.AreEqual(
2,
list.Count,
"Unexpected number of commands.");
var command = list[0] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManyChildDto)).TableName,
command.TableName,
"Unexpected child table name.");
Assert.AreEqual(
"ChildKey",
command.PrimaryKeyColumn,
"Unexpected child primary key column.");
Assert.AreEqual(
1,
command.Operations.Count(),
"Unexpected number of update operations on child table.");
Assert.AreEqual(
"Name",
command.Operations.FirstOrDefault().OwnerPropertyMetadata.ColumnName,
"Unexpected column for child table UPDATE.");
Assert.AreEqual(
newDto.OneToManyChildDto[0].Name,
command.Operations.FirstOrDefault().Value,
"Unexpected child column value.");
command = list[1] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
command.TableName,
"Unexpected parent table name.");
Assert.AreEqual(
"ParentKey",
command.PrimaryKeyColumn,
"Unexpected parent primary key column.");
Assert.AreEqual(
1,
command.Operations.Count(),
"Unexpected number of update operations on child table.");
Assert.AreEqual(
"ParentName",
command.Operations.FirstOrDefault().OwnerPropertyMetadata.ColumnName,
"Unexpected column for parent table UPDATE.");
Assert.AreEqual(
newDto.ParentName,
command.Operations.FirstOrDefault().Value,
"Unexpected parent column value.");
}
public void delete_with_special_data_in_child_updates_child_and_deletes_parent() {
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto { ChildKey = Guid.NewGuid() } }
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, oldDto, null, 2, 2, 0, 1, 1, 2, 0, 1, 1);
var list = new List<BaseCommand>(commands);
Assert.AreEqual(
2,
list.Count,
"Unexpected command count.");
var update = list[0] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManySpecialChildDto)).TableName,
update.Operations.FirstOrDefault().ValueMetadata.TableName,
"Unexpected child table name.");
var delete = list[1] as DeleteCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
delete.Operation.ValueMetadata.TableName);
}
public void update_of_parent_and_non_fk_columns_in_child_with_special_data_in_child_is_invalid()
{
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto
{
ChildKey = Guid.NewGuid()
} }
};
var newDto = new GuidParentDto
{
ParentKey = oldDto.ParentKey,
ParentName = "ParentNameUpdated",
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto
{
ChildKey = oldDto.OneToManySpecialChildDto[0].ChildKey,
Name = "Maximum Whoopee! Enabled"
} }
};
var cache = new DtoMetadataCache();
GetCommands(cache, oldDto, newDto, 2, 2, 0, 2, 0, 2, 0, 2, 0, false);
}
public void update_with_special_data_in_child_updates_parent() {
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto { ChildKey = Guid.NewGuid() } }
};
var newDto = new GuidParentDto
{
ParentKey = oldDto.ParentKey,
ParentName = "ParentNameUpdated",
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto { ChildKey = oldDto.OneToManySpecialChildDto[0].ChildKey } }
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, oldDto, newDto, 1, 1, 0, 1, 0, 1, 0, 1, 0);
var list = new List<BaseCommand>(commands);
var command = list[0] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
command.Operations.FirstOrDefault().TableName);
Assert.AreEqual(
1,
command.Operations.Count(),
"Unexpected number of operations.");
}
public void insert_with_special_data_in_child_inserts_in_parent_and_updates_child() {
var newDto = new GuidParentDto {
OneToManySpecialChildDto = new [] { new GuidOneToManySpecialChildDto() }
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, null, newDto, 2, 2, 1, 1, 0, 2, 1, 1, 0);
var list = new List<BaseCommand>(commands);
Assert.AreEqual(
2,
list.Count,
"Unexpected number of commands.");
var insert = list[0] as InsertCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
insert.Operation.ValueMetadata.TableName,
"Unexpected table name for parent.");
var update = list[1] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManySpecialChildDto)).TableName,
update.Operations.FirstOrDefault().ValueMetadata.TableName,
"Unexpected table owner name for child update.");
Assert.AreEqual(
"OneToManySpecialChildDto",
update.Operations.FirstOrDefault().ColumnName,
"Unexpected owner's column name for child update.");
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManySpecialChildDto)).TableName,
update.Operations.FirstOrDefault().ValueMetadata.TableName,
"Unexected child table name.");
}
public void delete_with_reference_data_in_child_is_invalid() {
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManyReferenceChildDto = new [] { new GuidOneToManyReferenceChildDto { ChildKey = Guid.NewGuid() } }
};
var cache = new DtoMetadataCache();
GetCommands(cache, oldDto, null, 2, 2, 0, 0, 2, 2, 0, 0, 2);
}
public void update_with_reference_data_in_child_is_invalid() {
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManyReferenceChildDto = new [] { new GuidOneToManyReferenceChildDto
{
ChildKey = Guid.NewGuid()
} }
};
var newDto = new GuidParentDto
{
ParentKey = oldDto.ParentKey,
ParentName = "ParentNameUpdated",
OneToManyReferenceChildDto = new [] { new GuidOneToManyReferenceChildDto
{
ChildKey = oldDto.OneToManyReferenceChildDto[0].ChildKey,
Name = "Maximum Whoopee! Enabled"
} }
};
var cache = new DtoMetadataCache();
GetCommands(cache, oldDto, newDto, 2, 2, 0, 2, 0, 2, 0, 2, 0, false);
}
public void insert_with_reference_data_in_child_is_invalid() {
var newDto = new GuidParentDto {
OneToManyReferenceChildDto = new [] { new GuidOneToManyReferenceChildDto() }
};
var cache = new DtoMetadataCache();
GetCommands(cache, null, newDto, 2, 2, 1, 1, 0, 2, 1, 1, 0);
}
public void delete_with_no_reference_data_deletes_in_child_and_parent() {
var oldDto = new GuidParentDto
{
ParentKey = Guid.NewGuid(),
OneToManyChildDto = new [] { new GuidOneToManyChildDto { ChildKey = Guid.NewGuid() }}
};
var cache = new DtoMetadataCache();
var commands = GetCommands(cache, oldDto, null, 2, 2, 0, 0, 2, 2, 0, 0, 2);
var list = new List<BaseCommand>(commands);
Assert.AreEqual(
2,
list.Count,
"Unexpected number of commands.");
var command = list[0] as DeleteCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidOneToManyChildDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected child table name.");
command = list[1] as DeleteCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(GuidParentDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected parent table name.");
}