public void ShouldWriteQueryWithFillFactorAndOptionsForAddUniqueConstraint() { var schemaName = "schemaName"; var tableName = "tableName"; string[] columnName = new string[] { "column1", "column2" }; bool clustered = true; int fillfactor = 80; string[] options = new string[] { "option1", "options2" }; string fileGroup = "fileGroup"; var op = new AddUniqueKeyOperation(schemaName, tableName, "name", columnName, clustered, fillfactor, options, fileGroup); var expectedQuery = "alter table [schemaName].[tableName] add constraint [name] unique clustered ([column1], [column2]) with (option1, options2, fillfactor = 80) on fileGroup"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldWriteQueryForAddUniqueConstraintWithCustomName() { var schemaName = "schemaName"; var tableName = "tableName"; string[] columnName = new string[] { "column1", "column2" }; var customConstraintName = "customConstraintName"; bool clustered = true; int fillfactor = 0; string[] options = null; string fileGroup = "fileGroup"; var op = new AddUniqueKeyOperation(schemaName, tableName, customConstraintName, columnName, clustered, fillfactor, options, fileGroup); var expectedQuery = "alter table [schemaName].[tableName] add constraint [customConstraintName] unique clustered ([column1], [column2]) on fileGroup"; Assert.AreEqual(expectedQuery, op.ToQuery()); }