public override void SetUp()
{
base.SetUp();
_factory = new SqlPrimaryXmlIndexDefinitionScriptElementFactory();
_xmlColumn = ColumnDefinitionObjectMother.CreateColumn("XmlColumn");
_customSchemaNameDefinition = new EntityNameDefinition("SchemaName", "TableName1");
_indexDefinitionWithCustomSchema = new SqlPrimaryXmlIndexDefinition("Index1", _xmlColumn);
_defaultSchemaNameDefinition = new EntityNameDefinition(null, "TableName2");
_indexDefinitionWithDefaultSchema = new SqlPrimaryXmlIndexDefinition("Index2", _xmlColumn);
}
public void GetCreateElement_WithAllOptionsOff()
{
var entityNameDefinition = new EntityNameDefinition(null, "TableName");
var indexDefinition = new SqlPrimaryXmlIndexDefinition(
"Index1", _xmlColumn, false, 0, false, false, false, false, false, 0);
var result = _factory.GetCreateElement(indexDefinition, entityNameDefinition);
var expectedResult =
"CREATE PRIMARY XML INDEX [Index1]\r\n"
+ " ON [dbo].[TableName] ([XmlColumn])\r\n"
+ " WITH (PAD_INDEX = OFF, FILLFACTOR = 0, SORT_IN_TEMPDB = OFF, STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ALLOW_ROW_LOCKS = OFF, "
+ "ALLOW_PAGE_LOCKS = OFF, MAXDOP = 0)";
Assert.That(result, Is.TypeOf(typeof(ScriptStatement)));
Assert.That(((ScriptStatement)result).Statement, Is.EqualTo(expectedResult));
}
public override void SetUp()
{
base.SetUp();
_indexDefinitionElementFactoryMock = MockRepository.GenerateStub <ISqlIndexDefinitionScriptElementFactory <SqlIndexDefinition> >();
_primaryIndexDefinitionElementFactoryMock = MockRepository.GenerateStub <ISqlIndexDefinitionScriptElementFactory <SqlPrimaryXmlIndexDefinition> > ();
_secondaryIndexDefinitionElementFactoryMock =
MockRepository.GenerateStub <ISqlIndexDefinitionScriptElementFactory <SqlSecondaryXmlIndexDefinition> >();
_factory = new SqlIndexScriptElementFactory(
_indexDefinitionElementFactoryMock, _primaryIndexDefinitionElementFactoryMock, _secondaryIndexDefinitionElementFactoryMock);
var simpleColumn = ColumnDefinitionObjectMother.CreateColumn("Column");
var indexedColumn = new SqlIndexedColumnDefinition(simpleColumn, IndexOrder.Desc);
_entityNameDefinition = new EntityNameDefinition(null, "Table");
_indexDefinition = new SqlIndexDefinition("Index1", new[] { indexedColumn });
_primaryIndexDefinition = new SqlPrimaryXmlIndexDefinition("Index2", simpleColumn);
_secondaryIndexDefinition = new SqlSecondaryXmlIndexDefinition(
"Index3", simpleColumn, "PrimaryIndexName", SqlSecondaryXmlIndexKind.Property);
_fakeScriptElement = MockRepository.GenerateStub <IScriptElement>();
}
void ISqlIndexDefinitionVisitor.VisitPrimaryXmlIndexDefinition(SqlPrimaryXmlIndexDefinition primaryXmlIndexDefinition)
{
_elementFactory.AddPrimaryXmlIndexDefinition(primaryXmlIndexDefinition, _ownerName);
}
private void AddPrimaryXmlIndexDefinition(SqlPrimaryXmlIndexDefinition indexDefinition, EntityNameDefinition ownerName)
{
_createScriptElement = _primaryIndexDefinitionElementFactory.GetCreateElement(indexDefinition, ownerName);
_dropScriptElement = _primaryIndexDefinitionElementFactory.GetDropElement(indexDefinition, ownerName);
}
public void SetUp()
{
_xmlColumn = ColumnDefinitionObjectMother.CreateColumn("XmlColumn");
_indexDefinition = new SqlPrimaryXmlIndexDefinition("IndexName", _xmlColumn, true, 5, true, true, true, true, true, 2);
}
