public void GetCreateScript_GetDropScript_ValidConnectionString()
{
var statement1 = new ScriptStatement("Test1");
var statement2 = new ScriptStatement("Test2");
var fakeCreateResult = new ScriptElementCollection();
fakeCreateResult.AddElement(statement1);
fakeCreateResult.AddElement(statement2);
var fakeDropResult = new ScriptElementCollection();
fakeDropResult.AddElement(statement2);
fakeDropResult.AddElement(statement1);
_innerScriptBuilderMock.Expect(mock => mock.GetCreateScript()).Return(fakeCreateResult);
_innerScriptBuilderMock.Expect(mock => mock.GetDropScript()).Return(fakeDropResult);
var createScriptResult = _builder.GetCreateScript();
var dropScriptResult = _builder.GetDropScript();
Assert.That(((ScriptElementCollection)createScriptResult).Elements.Count, Is.EqualTo(2));
Assert.That(((ScriptStatement)((ScriptElementCollection)createScriptResult).Elements[0]).Statement, Is.EqualTo("USE MyDataBase"));
Assert.That(((ScriptElementCollection)createScriptResult).Elements[1], Is.SameAs(fakeCreateResult));
Assert.That(((ScriptElementCollection)dropScriptResult).Elements.Count, Is.EqualTo(2));
Assert.That(((ScriptStatement)((ScriptElementCollection)dropScriptResult).Elements[0]).Statement, Is.EqualTo("USE MyDataBase"));
Assert.That(((ScriptElementCollection)dropScriptResult).Elements[1], Is.SameAs(fakeDropResult));
}
public IScriptElement GetDropScript()
{
var dropScriptElements = new ScriptElementCollection();
dropScriptElements.AddElement(new ScriptStatement("USE " + GetDatabaseName()));
dropScriptElements.AddElement(_innerScriptBuilder.GetDropScript());
return(dropScriptElements);
}
public void Convert_OneScriptElement()
{
_fakeCreateElements.AddElement(_scriptElement1);
_fakeDropElements.AddElement(_scriptElement2);
var result = _converter.Convert(_scriptBuilderStub);
Assert.That(result.SetUpScript, Is.EqualTo("Test1\r\n"));
Assert.That(result.TearDownScript, Is.EqualTo("Test2\r\n"));
}
private void AddIndexes(IEnumerable <IIndexDefinition> indexes, EntityNameDefinition ownerName)
{
foreach (var index in indexes)
{
_createScriptElements.AddElement(_indexScriptElementFactory.GetCreateElement(index, ownerName));
_dropScriptElements.AddElement(_indexScriptElementFactory.GetDropElement(index, ownerName));
}
}
public override void SetUp()
{
base.SetUp();
_builder1Mock = MockRepository.GenerateStrictMock <IScriptBuilder>();
_builder2Mock = MockRepository.GenerateStrictMock <IScriptBuilder>();
_fakeStatement1 = new ScriptStatement("Fake1");
_fakeStatement2 = new ScriptStatement("Fake2");
_fakeStatement3 = new ScriptStatement("Fake3");
_fakeResultCollection1 = new ScriptElementCollection();
_fakeResultCollection1.AddElement(_fakeStatement1);
_fakeResultCollection2 = new ScriptElementCollection();
_fakeResultCollection2.AddElement(_fakeStatement2);
_fakeResultCollection2.AddElement(_fakeStatement3);
}
public IScriptElement GetDropScript()
{
var scriptElementCollection = new ScriptElementCollection();
foreach (var scriptBuilder in _scriptBuilders.Reverse())
{
scriptElementCollection.AddElement(scriptBuilder.GetDropScript());
}
return(scriptElementCollection);
}
public IScriptElement GetCreateScript()
{
var scriptElementCollection = new ScriptElementCollection();
foreach (var scriptBuilder in _scriptBuilders)
{
scriptElementCollection.AddElement(scriptBuilder.GetCreateScript());
}
return(scriptElementCollection);
}
public TableScriptBuilder(ITableScriptElementFactory elementFactory, ICommentScriptElementFactory commentFactory)
{
ArgumentUtility.CheckNotNull("elementFactory", elementFactory);
ArgumentUtility.CheckNotNull("commentFactory", commentFactory);
_elementFactory = elementFactory;
_createScriptElements = new ScriptElementCollection();
_createScriptElements.AddElement(commentFactory.GetCommentElement("Create all tables"));
_dropScriptElements = new ScriptElementCollection();
_dropScriptElements.AddElement(commentFactory.GetCommentElement("Drop all tables"));
}
public IndexScriptBuilder(IIndexScriptElementFactory indexScriptElementFactory, ICommentScriptElementFactory commentFactory)
{
ArgumentUtility.CheckNotNull("indexScriptElementFactory", indexScriptElementFactory);
ArgumentUtility.CheckNotNull("commentFactory", commentFactory);
_indexScriptElementFactory = indexScriptElementFactory;
_createScriptElements = new ScriptElementCollection();
_createScriptElements.AddElement(commentFactory.GetCommentElement("Create indexes for tables that were created above"));
_dropScriptElements = new ScriptElementCollection();
_dropScriptElements.AddElement(commentFactory.GetCommentElement("Drop all indexes"));
}
public IScriptElement GetCreateElement(T entityDefinition)
{
ArgumentUtility.CheckNotNull("entityDefinition", entityDefinition);
var statements = new ScriptElementCollection();
statements.AddElement(CreateBatchDelimiterStatement());
statements.AddElement(
new ScriptStatement(
string.Format(
"CREATE VIEW [{0}].[{1}] ({2})\r\n"
+ " {3}AS\r\n{4}{5}",
entityDefinition.ViewName.SchemaName ?? DefaultSchema,
entityDefinition.ViewName.EntityName,
GetColumnList(entityDefinition.GetAllColumns()),
UseSchemaBinding(entityDefinition) ? "WITH SCHEMABINDING " : string.Empty,
GetSelectStatements(entityDefinition),
UseCheckOption(entityDefinition) ? "\r\n WITH CHECK OPTION" : string.Empty)));
statements.AddElement(CreateBatchDelimiterStatement());
return(statements);
}
public void AppendToScript_OneElement()
{
var script = new List <ScriptStatement> ();
_elementCollection.AddElement(_elementMock1);
_elementMock1.Expect(mock => mock.AppendToScript(script));
_elementMock1.Replay();
_elementCollection.AppendToScript(script);
_elementMock1.VerifyAllExpectations();
Assert.That(script, Is.Empty);
}
public SynonymScriptBuilder(
ISynonymScriptElementFactory <TableDefinition> tableViewElementFactory,
ISynonymScriptElementFactory <UnionViewDefinition> unionViewElementFactory,
ISynonymScriptElementFactory <FilterViewDefinition> filterViewElementFactory,
ISynonymScriptElementFactory <EmptyViewDefinition> emptyViewElementFactory,
ICommentScriptElementFactory commentFactory)
{
ArgumentUtility.CheckNotNull("tableViewElementFactory", tableViewElementFactory);
ArgumentUtility.CheckNotNull("unionViewElementFactory", unionViewElementFactory);
ArgumentUtility.CheckNotNull("filterViewElementFactory", filterViewElementFactory);
ArgumentUtility.CheckNotNull("emptyViewElementFactory", emptyViewElementFactory);
ArgumentUtility.CheckNotNull("commentFactory", commentFactory);
_tableViewElementFactory = tableViewElementFactory;
_unionViewElementFactory = unionViewElementFactory;
_filterViewElementFactory = filterViewElementFactory;
_emptyViewElementFactory = emptyViewElementFactory;
_createScriptElements = new ScriptElementCollection();
_createScriptElements.AddElement(commentFactory.GetCommentElement("Create synonyms for tables that were created above"));
_dropScriptElements = new ScriptElementCollection();
_dropScriptElements.AddElement(commentFactory.GetCommentElement("Drop all synonyms"));
}
public ViewScriptBuilder(
IViewScriptElementFactory <TableDefinition> tableViewElementFactory,
IViewScriptElementFactory <UnionViewDefinition> unionViewElementFactory,
IViewScriptElementFactory <FilterViewDefinition> filterViewElementFactory,
IViewScriptElementFactory <EmptyViewDefinition> emptyViewElementFactory,
ICommentScriptElementFactory commentFactory)
{
ArgumentUtility.CheckNotNull("tableViewElementFactory", tableViewElementFactory);
ArgumentUtility.CheckNotNull("unionViewElementFactory", unionViewElementFactory);
ArgumentUtility.CheckNotNull("filterViewElementFactory", filterViewElementFactory);
ArgumentUtility.CheckNotNull("emptyViewElementFactory", emptyViewElementFactory);
ArgumentUtility.CheckNotNull("commentFactory", commentFactory);
_tableViewElementFactory = tableViewElementFactory;
_unionViewElementFactory = unionViewElementFactory;
_filterViewElementFactory = filterViewElementFactory;
_emptyViewElementFactory = emptyViewElementFactory;
_createScriptElements = new ScriptElementCollection();
_createScriptElements.AddElement(commentFactory.GetCommentElement("Create a view for every class"));
_dropScriptElements = new ScriptElementCollection();
_dropScriptElements.AddElement(commentFactory.GetCommentElement("Drop all views"));
}
private void AddElements(IScriptElement createElement, IScriptElement dropElement)
{
_createScriptElements.AddElement(createElement);
_dropScriptElements.AddElement(dropElement);
}
private void AddTableDefinition(TableDefinition tableDefinition)
{
_createScriptElements.AddElement(_elementFactory.GetCreateElement(tableDefinition));
_dropScriptElements.AddElement(_elementFactory.GetDropElement(tableDefinition));
}