Ejemplo n.º 1
0
        public void CanCreateTableWithNameMultiColumnForeignKey()
        {
            var expression = GeneratorTestHelper.GetCreateTableWithNameMultiColumnForeignKey();

            var result = Generator.Generate(expression);

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