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