/// <inheritdoc />
public void EmbeddedScript(string embeddedSqlScriptName, IDictionary <string, string> parameters)
{
var embeddedResourceProviders = _context.ServiceProvider.GetService <IEnumerable <IEmbeddedResourceProvider> >();
ExecuteEmbeddedSqlScriptExpression expression;
if (embeddedResourceProviders == null)
{
#pragma warning disable 612
Debug.Assert(_context.MigrationAssemblies != null, "_context.MigrationAssemblies != null");
expression = new ExecuteEmbeddedSqlScriptExpression(_context.MigrationAssemblies)
{
SqlScript = embeddedSqlScriptName,
Parameters = parameters,
};
#pragma warning restore 612
}
else
{
expression = new ExecuteEmbeddedSqlScriptExpression(embeddedResourceProviders)
{
SqlScript = embeddedSqlScriptName,
Parameters = parameters,
};
}
_context.Expressions.Add(expression);
}
public void EmbeddedScript(string EmbeddedSqlScriptName)
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = EmbeddedSqlScriptName, MigrationAssemblies = _context.MigrationAssemblies
};
_context.Expressions.Add(expression);
}
public void ErrorIsReturnWhenSqlScriptIsNullOrEmpty()
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = null
};
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.SqlScriptCannotBeNullOrEmpty);
}
public void ResourceFinderFindThrowsExceptionIfFoundMoreThenOneResource()
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = "NotUniqueResource.sql", MigrationAssemblies = new SingleAssembly(Assembly.GetExecutingAssembly())
};
var processor = new Mock <IMigrationProcessor>();
Assert.Throws <InvalidOperationException>(() => expression.ExecuteWith(processor.Object));
processor.Verify(x => x.Execute("NotUniqueResource"), Times.Never());
}
public void EmbeddedScript(string embeddedSqlScriptName, IDictionary <string, string> parameters)
{
var expression = new ExecuteEmbeddedSqlScriptExpression
{
SqlScript = embeddedSqlScriptName,
MigrationAssemblies = _context.MigrationAssemblies,
Parameters = parameters,
};
_context.Expressions.Add(expression);
}
public void ErrorIsReturnWhenSqlScriptIsNullOrEmpty()
{
var provider = new DefaultEmbeddedResourceProvider();
var expression = new ExecuteEmbeddedSqlScriptExpression(new[] { provider })
{
SqlScript = null
};
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.SqlScriptCannotBeNullOrEmpty);
}
public void CanExecuteEmbeddedResource()
{
Mock <IMigrationProcessor> mockProcessor = new Mock <IMigrationProcessor>();
ExecuteEmbeddedSqlScriptExpression expression = new ExecuteEmbeddedSqlScriptExpression {
MigrationAssembly = Assembly.GetExecutingAssembly(), SqlScript = "EmbeddedScript.txt"
};
expression.ExecuteWith(mockProcessor.Object);
mockProcessor.Verify(mock => mock.Execute("TEST SQL"));
}
public void ResourceFinderIsCaseInsensitive()
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = testSqlScript.ToUpper(), MigrationAssemblies = new SingleAssembly(Assembly.GetExecutingAssembly())
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(scriptContents)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ResourceFinderFindFileWithFullNameAndNamespace()
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = "FluentMigrator.Tests.EmbeddedResources.InitialSchema.sql", MigrationAssemblies = new SingleAssembly(Assembly.GetExecutingAssembly())
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute("InitialSchema")).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ExecutesTheStatement()
{
var expression = new ExecuteEmbeddedSqlScriptExpression {
SqlScript = testSqlScript, MigrationAssemblies = new SingleAssembly(Assembly.GetExecutingAssembly())
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(scriptContents)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ResourceFinderIsCaseInsensitive()
{
var provider = new DefaultEmbeddedResourceProvider(Assembly.GetExecutingAssembly());
var expression = new ExecuteEmbeddedSqlScriptExpression(provider)
{
SqlScript = TestSqlScript.ToUpper()
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(ScriptContents)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ResourceFinderFindFileWithFullName()
{
var provider = new DefaultEmbeddedResourceProvider(Assembly.GetExecutingAssembly());
var expression = new ExecuteEmbeddedSqlScriptExpression(provider)
{
SqlScript = "InitialSchema.sql"
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute("InitialSchema")).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ExecutesTheStatement()
{
var provider = new DefaultEmbeddedResourceProvider(Assembly.GetExecutingAssembly());
var expression = new ExecuteEmbeddedSqlScriptExpression(new[] { provider })
{
SqlScript = TestSqlScript
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(ScriptContents)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public void ExecutesTheStatementWithParameters()
{
const string scriptContentsWithParameters = "TEST SCRIPT ParameterValue $(escaped_parameter) $(missing_parameter)";
var provider = new DefaultEmbeddedResourceProvider(Assembly.GetExecutingAssembly());
var expression = new ExecuteEmbeddedSqlScriptExpression(provider)
{
SqlScript = "EmbeddedTestScriptWithParameters.sql",
Parameters = new Dictionary <string, string> {
{ "parameter", "ParameterValue" }
}
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(scriptContentsWithParameters)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
/// <inheritdoc />
public void EmbeddedScript(string embeddedSqlScriptName)
{
var embeddedResourceProviders = _context.ServiceProvider.GetService <IEnumerable <IEmbeddedResourceProvider> >();
if (embeddedResourceProviders == null)
{
#pragma warning disable 612
Debug.Assert(_context.MigrationAssemblies != null, "_context.MigrationAssemblies != null");
var expression = new ExecuteEmbeddedSqlScriptExpression(_context.MigrationAssemblies)
{
SqlScript = embeddedSqlScriptName
};
#pragma warning restore 612
_context.Expressions.Add(expression);
}
else
{
var expression = new ExecuteEmbeddedSqlScriptExpression(embeddedResourceProviders)
{
SqlScript = embeddedSqlScriptName
};
_context.Expressions.Add(expression);
}
}
public InternalExecuteEmbeddedSqlScriptExpression()
{
ExecuteEmbeddedSqlScriptExpression = new ExecuteEmbeddedSqlScriptExpression();
}
/// <summary>
/// Initializes a new instance of the <see cref="ExecuteEmbeddedSqlScriptExpression"/> class.
/// </summary>
/// <param name="embeddedResourceProviders">The embedded resource providers</param>
public InternalExecuteEmbeddedSqlScriptExpression([NotNull] IEnumerable <IEmbeddedResourceProvider> embeddedResourceProviders)
{
ExecuteEmbeddedSqlScriptExpression = new ExecuteEmbeddedSqlScriptExpression(embeddedResourceProviders);
}
public InternalExecuteEmbeddedSqlScriptExpression([NotNull] IAssemblyCollection assemblyCollection)
{
ExecuteEmbeddedSqlScriptExpression = new ExecuteEmbeddedSqlScriptExpression(assemblyCollection);
}