C# (CSharp) GeneratorTestHelper.GetCreateTableWithForeignKey Examples

Example #1

File: SQLiteTableTests.cs Project: whilelie/fluentmigrator

        public void CanCreateTableWithForeignKey()
        {
            var expression = GeneratorTestHelper.GetCreateTableWithForeignKey();

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" TEXT NOT NULL, \"TestColumn2\" INTEGER NOT NULL, CONSTRAINT \"FK_TestT_TestT\" FOREIGN KEY (\"TestColumn1\") REFERENCES \"TestTable2\" (\"TestColumn2\"))");
        }