public void GeneratorForeignKeyComposite2(SqlEngineVersion version)
{
var db = new ForeignKeyCompositeSetForeignKeyTo();
var generator = new BimGenerator(DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer()), version, "ForeignKeyCompositeSetForeignKeyTo");
generator.Generate(db);
}
public void GeneratorForeignKeyComposite1(SqlEngineVersion version)
{
var db = new ForeignKeyComposite();
var generator = new BimGenerator(DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version), version, "ForeignKeyComposite");
generator.Generate(db);
}
public void GeneratorTestDatabaseFks(SqlEngineVersion version)
{
var db = new TestDatabaseFks();
var generator = new BimGenerator(DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer()), version, "TestDatabaseFks");
generator.Generate(db);
}
public void GeneratorTabularRelation(SqlEngineVersion version)
{
var db = new TabularRelation();
var generator = new BimGenerator(DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version), version, "TabularRelation");
generator.Generate(db);
}
public void GeneratorUniqueConstratintAsFk(SqlEngineVersion version)
{
var db = new DbUniqueConstratintAsFk();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpWriterFactory.GetCSharpWriter(version, documenterContext, "DbUniqueConstratintAsFk");
var generator = new CSharpGenerator(writer, version, "DbUniqueConstratintAsFk", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateMultiFile(db);
}
public void GeneratorForeignKeyComposite2(SqlEngineVersion version)
{
var db = new ForeignKeyCompositeSetForeignKeyTo();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpTypedWriterFactory.GetCSharpTypedWriter(version, documenterContext, "ForeignKeyCompositeSetForeignKeyTo");
var generator = new CSharpTypedGenerator(writer, version, "ForeignKeyCompositeSetForeignKeyTo", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateMultiFile(db);
}
public void DocumentTestUniqueConstraint(SqlEngineVersion version)
{
var db = new TestDatabaseUniqueConstraint();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "TestDatabaseUniqueConstraint");
documenter.Document(db);
}
public void DocumentTestIndexMultiColumnAndInclude(SqlEngineVersion version)
{
var db = new TestDatabaseIndexMultiColumnAndInclude();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "TestDatabaseIndexMultiColumnAndInclude");
documenter.Document(db);
}
public void TableCustomizerTest(SqlEngineVersion version)
{
var db = new TestDatabaseFks();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version, new TableCustomizer()), version, "TestDatabaseFks");
documenter.Document(db);
}
public void DocumentTestForeignKeyComposite(SqlEngineVersion version)
{
var db = new ForeignKeyComposite();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "ForeignKeyComposite");
documenter.Document(db);
}
public void GeneratorIndex(SqlEngineVersion version)
{
var db = new TestDatabaseIndex();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpTypedWriterFactory.GetCSharpTypedWriter(version, documenterContext, "TestDatabaseIndex");
var generator = new CSharpTypedGenerator(writer, version, "TestDatabaseIndex", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateMultiFile(db);
}
public void GeneratorForeignKeyComposite2Typed_SingleFile(SqlEngineVersion version)
{
var dd = new ForeignKeyCompositeSetForeignKeyTo();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpTypedWriterFactory.GetCSharpTypedWriter(version, documenterContext, "ForeignKeyCompositeSetForeignKeyTo");
var generator = new CSharpTypedGenerator(writer, version, "TestDatabaseFkNoCheckTest", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateSingleFile(dd, $"GeneratorForeignKeyComposite2Typed_SingleFile_{version}.cs");
}
public void GeneratorSqlTableCustomPropertyConstructor(SqlEngineVersion version)
{
var db = new SqlTableCustomPropertyConstructor();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpTypedWriterFactory.GetCSharpTypedWriter(version, documenterContext, "SqlTableCustomPropertyDbTyped");
var generator = new CSharpTypedGenerator(writer, version, "SqlTableCustomPropertyConstructor", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateSingleFile(db, $"SqlTableCustomPropertyConstructor_{version}.cs");
}
public void CircularDdA0B1C1_B2C2(SqlEngineVersion version)
{
var dd = new CircularDdA0B1C1_B2C2();
dd.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "CircularDdA0B1C1_B2C2");
documenter.Document(dd);
}
public void GeneratorForeignKeyComposite1(SqlEngineVersion version)
{
var db = new ForeignKeyComposite();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version);
var writer = CSharpWriterFactory.GetCSharpWriter(version, documenterContext, "ForeignKeyComposite");
var generator = new CSharpGenerator(writer, version, "ForeignKeyComposite", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateMultiFile(db);
}
public void FkNoCheckTest()
{
var version = MsSqlVersion.MsSql2016;
var dd = new TestDatabaseFkNoCheckTest();
var documenterContext = DataDefinitionDocumenterTestsHelper.CreateTestGeneratorContext(version, new DocumenterTests.TableCustomizer());
var writer = CSharpTypedWriterFactory.GetCSharpTypedWriter(version, documenterContext, "TestDatabaseFkNoCheckTest");
var generator = new CSharpTypedGenerator(writer, version, "TestDatabaseFkNoCheckTest", "FizzCode.DbTools.DataDefinitionDocumenter.Tests");
generator.GenerateSingleFile(dd, $"TestDatabaseFkNoCheckTest_Typed_{version}.cs");
}
public void CircularFKDetectorABC_X(SqlEngineVersion version)
{
var dd = new CircularDdABC_X();
dd.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "CircularDdABC_X");
documenter.Document(dd);
// TODO move to dd test
// CircularFKDetector.DectectCircularFKs(dd.GetTables());
// var cs = dd.GetTables().Select(t => t.Properties.OfType<CircularFK>()).ToList();
}
public void TableCustomizerFromCsv()
{
using (var file =
new StreamWriter("TestDatabaseFks.DbTools.Patterns.csv"))
{
file.WriteLine("PatternSchema;PatternTableName;PatternExceptSchema;PatternExceptTableName;ShouldSkipIfMatch;CategoryIfMatch;BackGroundColorIfMatch");
file.WriteLine(";Parent;;;0;Parent;606060");
file.WriteLine(";Child;;;1");
file.WriteLine(";*ildC*;;;0;TestCategory");
}
var db = new TestDatabaseFks();
db.SetVersions(GenericVersion.Generic1.GetTypeMapper());
var patternMatching = PatternMatchingTableCustomizerFromPatterns.FromCsv("TestDatabaseFks", null);
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(GenericVersion.Generic1, patternMatching), GenericVersion.Generic1, "TestDatabaseFks");
documenter.Document(db);
}
public void FkCheckNoCheckTest()
{
var version = MsSqlVersion.MsSql2016;
var ddOriginal = new TestDatabaseFk();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddFkChanged = new TestDatabaseFk();
ddFkChanged.SetVersions(version.GetTypeMapper());
var fk = ddFkChanged.GetTable("Foreign").Properties.OfType <ForeignKey>().First();
fk.SqlEngineVersionSpecificProperties[version, "Nocheck"] = "false";
var changeDocumenter = new ChangeDocumenter(DataDefinitionDocumenterTestsHelper.CreateTestChangeContext(version), version, "TestDatabaseFk", "TestDatabaseFk_FkCheckNoCheckTest");
changeDocumenter.Document(ddOriginal, ddFkChanged);
}
private static void Document(SqlEngineVersion version, DatabaseDefinitions dds)
{
var changeDocumenter = new ChangeDocumenter(DataDefinitionDocumenterTestsHelper.CreateTestChangeContext(version), version, dds.DbNameOriginal, dds.DbNameNew);
changeDocumenter.Document(dds.Original, dds.New);
}
