public void CreateStatementOneForeignKeyTwoPrimaryKeyTest()
{
var foreignKeyStatement = new ForeignKeyStatement
{
CascadeDelete = false,
ForeignKey = new List<string> { "dummyForeignKey1" },
ForeignPrimaryKey = new List<string> { "dummForeignPrimaryKey1", "dummForeignPrimaryKey2" },
ForeignTable = "dummyForeignTable"
};
string output = foreignKeyStatement.CreateStatement();
Assert.AreEqual(output, "FOREIGN KEY (dummyForeignKey1) REFERENCES dummyForeignTable(dummForeignPrimaryKey1, dummForeignPrimaryKey2)");
}
public void CreateStatementOneForeignKeyCascadeDeleteTest()
{
var foreignKeyStatement = new ForeignKeyStatement
{
CascadeDelete = true,
ForeignKey = new List<string> { "dummyForeignKey1" },
ForeignPrimaryKey = new List<string> { "dummForeignPrimaryKey1" },
ForeignTable = "dummyForeignTable"
};
string output = foreignKeyStatement.CreateStatement();
Assert.AreEqual(output, "FOREIGN KEY (dummyForeignKey1) REFERENCES dummyForeignTable(dummForeignPrimaryKey1) ON DELETE CASCADE");
}