public when_generating_a_table_for_soft_deletes()
{
var mapping = DocumentMapping.For<Target>();
mapping.DeleteStyle = DeleteStyle.SoftDelete;
var schemaObjects = new DocumentSchemaObjects(mapping);
theTable = schemaObjects.StorageTable();
}
public when_generating_a_table_for_soft_deletes()
{
var mapping = DocumentMapping.For <Target>();
mapping.DeleteStyle = DeleteStyle.SoftDelete;
var schemaObjects = new DocumentSchemaObjects(mapping);
theTable = schemaObjects.StorageTable();
}
public void equivalency_positive_column_name_case_insensitive()
{
var users = DocumentSchemaObjects.For <User>();
var table1 = users.StorageTable();
var table2 = users.StorageTable();
table2.Column("username").ShouldBeSameAs(table1.Column("UserName"));
table2.ShouldBe(table1);
}
public void equivalency_negative_column_type_changed()
{
var users = DocumentSchemaObjects.For <User>();
var table1 = users.StorageTable();
var table2 = users.StorageTable();
table2.ReplaceOrAddColumn(table2.PrimaryKey.Name, "int", table2.PrimaryKey.Directive);
table2.ShouldNotBe(table1);
}
public void equivalency_negative_different_numbers_of_columns()
{
var users = DocumentSchemaObjects.For <User>();
var table1 = users.StorageTable();
var table2 = users.StorageTable();
table2.Columns.Add(new TableColumn("user_name", "character varying"));
table2.ShouldNotBe(table1);
}
public void equivalency_positive()
{
var users = DocumentSchemaObjects.For <User>();
var table1 = users.StorageTable();
var table2 = users.StorageTable();
table2.ShouldBe(table1);
table1.ShouldBe(table2);
table1.ShouldNotBeSameAs(table2);
}
public void perfect_match()
{
var users = DocumentSchemaObjects.For <User>();
var actual = users.StorageTable();
var expected = users.StorageTable();
var diff = new TableDiff(expected, actual);
diff.Matches.ShouldBeTrue();
}
public void can_match_up_on_columns()
{
var users = DocumentSchemaObjects.For <User>();
var actual = users.StorageTable();
var expected = users.StorageTable();
var diff = new TableDiff(expected, actual);
diff.Matched.OrderBy(x => x.Name).Select(x => x.Name)
.ShouldHaveTheSameElementsAs("data", "id", DocumentMapping.DotNetTypeColumn, DocumentMapping.LastModifiedColumn, DocumentMapping.VersionColumn);
}
public void not_matching_with_columns_of_same_name_that_are_different()
{
var users = DocumentSchemaObjects.For <User>();
var actual = users.StorageTable();
actual.ReplaceOrAddColumn("id", "int");
var expected = users.StorageTable();
var diff = new TableDiff(expected, actual);
diff.Matches.ShouldBeFalse();
diff.Different.Single().Name.ShouldBe("id");
}
public void not_matching_with_extra_columns()
{
var users = DocumentSchemaObjects.For <User>();
var actual = users.StorageTable();
var tableColumn = new TableColumn("new", "varchar");
actual.Columns.Add(tableColumn);
var expected = users.StorageTable();
var diff = new TableDiff(expected, actual);
diff.Matches.ShouldBeFalse();
diff.Extras.Single().ShouldBe(tableColumn);
}
public void can_do_substitutions()
{
var mapping = DocumentMapping.For <User>();
mapping.Duplicate(x => x.FirstName);
var users = new DocumentSchemaObjects(mapping);
var table = users.StorageTable();
table.BuildTemplate($"*{DdlRules.SCHEMA}*").ShouldBe($"*{table.Table.Schema}*");
table.BuildTemplate($"*{DdlRules.TABLENAME}*").ShouldBe($"*{table.Table.Name}*");
table.BuildTemplate($"*{DdlRules.COLUMNS}*").ShouldBe($"*id, data, mt_last_modified, mt_version, mt_dotnet_type, first_name*");
table.BuildTemplate($"*{DdlRules.NON_ID_COLUMNS}*").ShouldBe($"*data, mt_last_modified, mt_version, mt_dotnet_type, first_name*");
table.BuildTemplate($"*{DdlRules.METADATA_COLUMNS}*").ShouldBe("*mt_last_modified, mt_version, mt_dotnet_type*");
}
public void can_do_substitutions()
{
var mapping = DocumentMapping.For<User>();
mapping.Duplicate(x => x.FirstName);
var users = new DocumentSchemaObjects(mapping);
var table = users.StorageTable();
table.BuildTemplate($"*{DdlRules.SCHEMA}*").ShouldBe($"*{table.Table.Schema}*");
table.BuildTemplate($"*{DdlRules.TABLENAME}*").ShouldBe($"*{table.Table.Name}*");
table.BuildTemplate($"*{DdlRules.COLUMNS}*").ShouldBe($"*id, data, mt_last_modified, mt_version, mt_dotnet_type, first_name*");
table.BuildTemplate($"*{DdlRules.NON_ID_COLUMNS}*").ShouldBe($"*data, mt_last_modified, mt_version, mt_dotnet_type, first_name*");
table.BuildTemplate($"*{DdlRules.METADATA_COLUMNS}*").ShouldBe("*mt_last_modified, mt_version, mt_dotnet_type*");
}
