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); }