public void ShouldBuildCreateUniqueConstraint()
{
IQuery query;
ICommandBuilder builder;
DbCommand command;
query = new CreateConstraint(TestDB.PersonnTable, ColumnConstraints.Unique, PersonnTable.PersonnID, PersonnTable.FirstName);
builder = new SqlCommandBuilder();
command = builder.BuildCommand(query);
Assert.AreEqual("ALTER TABLE [Personn] ADD CONSTRAINT [AK_Personn_PersonnID_FirstName] UNIQUE ([PersonnID], [FirstName])", command.CommandText);
Assert.AreEqual(0, command.Parameters.Count);
}
public void ShouldCreatePrimaryKeyConstraint()
{
ICreateConstraint query;
Assert.ThrowsException <ArgumentNullException>(() => new CreateConstraint(null, ColumnConstraints.PrimaryKey, PersonnTable.PersonnID));
Assert.ThrowsException <ArgumentNullException>(() => new CreateConstraint(TestDB.PersonnTable, ColumnConstraints.PrimaryKey, null));
query = new CreateConstraint(TestDB.PersonnTable, ColumnConstraints.PrimaryKey, PersonnTable.PersonnID);
Assert.AreEqual(TestDB.PersonnTable, query.Table);
Assert.AreEqual(ColumnConstraints.PrimaryKey, query.Constraint);
Assert.AreEqual(1, query.Columns.Count());
}
public void ShouldBuildCreatePrimaryKeyConstraint()
{
IQuery query;
ICommandBuilder builder;
DbCommand command;
query = new CreateConstraint(TestDB.PersonnTable, ColumnConstraints.PrimaryKey, PersonnTable.PersonnID);
builder = new SqlCommandBuilder();
command = builder.BuildCommand(query);
Assert.AreEqual("ALTER TABLE [Personn] ADD CONSTRAINT [AK_Personn_PersonnID] PRIMARY KEY ([PersonnID])", command.CommandText);
Assert.AreEqual(0, command.Parameters.Count);
}
public string visit(CreateConstraint ddl)
{
return "";
}
