public void insert_with_fk_on_existing_special_child_inserts_parent_and_not_child()
{
var logger = CreateMockLogger();
var newDto = new ParentDto()
{
OneToOneSpecialChildDtoWithFk = new OneToOneSpecialChildDtoWithFk
{
ChildKey = 100,
Name = "You, sir, are drunk!"
}
};
try
{
using (var connection = new SqlConnection())
{
connection.Create(newDto);
}
}
catch (InvalidOperationException)
{
// Do nothing because we deliberately didn't open the connection
}
var scripts = logger.Scripts;
Assert.AreEqual(2, scripts.Count, "Unexpected number of scripts.");
var sql = scripts[0].Buffer.ToString();
Assert.IsTrue(sql.Contains("INSERT INTO dbo.[Parent]"), "No INSERT on parent.");
sql = scripts[1].Buffer.ToString();
Assert.IsTrue(sql.Contains("UPDATE dbo.OneToOneSpecialChildWithFk"), "Should be an UPDATE on child.");
}
public void insert_with_no_reference_data_inserts_in_parent_and_child()
{
var newDto = new ParentDto {
OneToManyChildDto = new [] { new OneToManyChildDto() }
};
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(ParentDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected table name for parent.");
command = list[1] as InsertCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(OneToManyChildDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected table name for child.");
}
public void soft_delete_only_updates_parent_type()
{
var dto = new ParentDto
{
ParentKey = 1,
OneToManyChildDto = new[]
{
new OneToManyChildDto
{
ChildKey = 2
}
}
};
var cache = new DtoMetadataCache();
var builder = new TransactionBuilder(cache);
var scripts = builder.BuildUpdateScripts(dto, null, true);
Assert.AreEqual(1, scripts.Count, "Unexpected number of scripts.");
var script = scripts[0];
var sql = script.Buffer.ToString();
Assert.IsTrue(sql.Contains("UPDATE dbo.[Parent]"), "No update on parent.");
Assert.AreEqual(1, Regex.Matches(sql, "UPDATE").Count, "Unexpected number of UPDATEs.");
Assert.AreEqual(0, Regex.Matches(sql, "INSERT").Count, "Should be no INSERTs.");
Assert.AreEqual(0, Regex.Matches(sql, "DELETE").Count, "Should be no DELETEs.");
Assert.AreEqual(0, Regex.Matches(sql, "SELECT").Count, "Should be no SELECTs.");
}
public void insert_child_with_existing_parent_sets_parent_pk_as_fk_value_on_child()
{
var oldDto = new ParentDto
{
ParentKey = 1,
OneToManyChildDto = new[]
{
new OneToManyChildDto
{
ChildKey = 2,
ParentDtoKey = 1
}
}
};
var scripts = Generate(
oldDto,
new ParentDto
{
ParentKey = 1,
OneToManyChildDto = new []
{
new OneToManyChildDto
{
ChildKey = 2,
ParentDtoKey = 1
},
new OneToManyChildDto
{
ChildKey = 3,
ParentDtoKey = 1
}
}
},
1);
scripts.AssertFragment(0, "INSERT INTO dbo.OneToManyChild");
Assert.AreEqual(
1,
((Func<object>) scripts[0].Parameters["p0"])(),
"Invalid FK value in child - should be same as parent key.");
}
public void update_with_no_reference_data_updates_in_parent_and_child() {
var oldDto = new ParentDto {
ParentKey = 1,
OneToManyChildDto = new [] { new OneToManyChildDto
{
ChildKey = 2
} }
};
var newDto = new ParentDto
{
ParentKey = 1,
ParentName = "ParentNameUpdated",
OneToManyChildDto = new [] { new OneToManyChildDto
{
ChildKey = 2,
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(OneToManyChildDto)).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(ParentDto)).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 ParentDto
{
ParentKey = 532,
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto { ChildKey = 1 } }
};
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(OneToManySpecialChildDto)).TableName,
update.Operations.FirstOrDefault().ValueMetadata.TableName,
"Unexpected child table name.");
var delete = list[1] as DeleteCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(ParentDto)).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 ParentDto
{
ParentKey = 1,
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto
{
ChildKey = 2
} }
};
var newDto = new ParentDto
{
ParentKey = 1,
ParentName = "ParentNameUpdated",
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto
{
ChildKey = 2,
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 ParentDto
{
ParentKey = 1,
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto { ChildKey = 1 } }
};
var newDto = new ParentDto
{
ParentKey = 1,
ParentName = "ParentNameUpdated",
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto { ChildKey = 1 } }
};
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(ParentDto)).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 ParentDto {
OneToManySpecialChildDto = new [] { new OneToManySpecialChildDto() }
};
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(ParentDto)).TableName,
insert.Operation.ValueMetadata.TableName,
"Unexpected table name for parent.");
var update = list[1] as UpdateCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(OneToManySpecialChildDto)).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(OneToManySpecialChildDto)).TableName,
update.Operations.FirstOrDefault().ValueMetadata.TableName,
"Unexected child table name.");
}
public void delete_with_reference_data_in_child_is_invalid() {
var oldDto = new ParentDto
{
ParentKey = 1,
OneToManyReferenceChildDto = new [] { new OneToManyReferenceChildDto { ChildKey = 1 } }
};
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 ParentDto
{
ParentKey = 1,
OneToManyReferenceChildDto = new [] { new OneToManyReferenceChildDto
{
ChildKey = 2
} }
};
var newDto = new ParentDto
{
ParentKey = 1,
ParentName = "ParentNameUpdated",
OneToManyReferenceChildDto = new [] { new OneToManyReferenceChildDto
{
ChildKey = 2,
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 ParentDto {
OneToManyReferenceChildDto = new [] { new OneToManyReferenceChildDto() }
};
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 ParentDto
{
ParentKey = 1,
OneToManyChildDto = new [] { new OneToManyChildDto { ChildKey = 1 }}
};
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(OneToManyChildDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected child table name.");
command = list[1] as DeleteCommand;
Assert.AreEqual(
cache.GetMetadataFor(typeof(ParentDto)).TableName,
command.Operation.ValueMetadata.TableName,
"Unexpected parent table name.");
}
