/// <summary>
/// Asserts the table does exist.
/// </summary>
/// <param name="name">The name of the table.</param>
protected void AssertTableExists(string name)
{
var syntax = new MsSqlDbmsSyntax();
var schema = this.ExecuteScalar <int>(syntax.TableExists(name));
schema.Should().BeGreaterThan(0);
}
public void ShouldInsertBeginAndEndTransactionStatementsForEachDelta()
{
const string deltaScriptContent = @"foo bar";
using (StreamWriter stream = script.GetFile().CreateText())
stream.Write(deltaScriptContent);
StringWriter writer = new StringWriter();
MsSqlDbmsSyntax syntax = new MsSqlDbmsSyntax("changeOwner");
ChangeScriptExecuter executer = new ChangeScriptExecuter(writer, syntax, true);
executer.ApplyChangeDoScript(script);
string deltaFragment = writer.ToString();
System.Console.Write(deltaFragment);
string expectedBegin = syntax.GenerateBeginTransaction();
int startOfBegin = deltaFragment.IndexOf(deltaScriptContent) - expectedBegin.Length - Environment.NewLine.Length;
string resultBegin = deltaFragment.Substring(startOfBegin, expectedBegin.Length);
Assert.AreEqual(expectedBegin, resultBegin);
string expectedCommit = syntax.GenerateCommitTransaction();
int startOfCommit = deltaFragment.IndexOf(deltaScriptContent) + deltaScriptContent.Length + Environment.NewLine.Length;
string resultCommit = deltaFragment.Substring(startOfCommit, expectedCommit.Length);
Assert.AreEqual(expectedCommit, resultCommit);
}
public void ShouldNotInsertBeginOrEndTransactionStatementIfPropertyIsNotSet()
{
const string deltaScriptContent = @"foo bar";
using (StreamWriter stream = script.GetFile().CreateText())
stream.Write(deltaScriptContent);
StringWriter writer = new StringWriter();
MsSqlDbmsSyntax syntax = new MsSqlDbmsSyntax("changeOwner");
ChangeScriptExecuter executer = new ChangeScriptExecuter(writer, syntax, false);
executer.ApplyChangeDoScript(script);
string deltaFragment = writer.ToString();
System.Console.Write(deltaFragment);
int beingIndex = deltaFragment.IndexOf(syntax.GenerateBeginTransaction());
Assert.AreEqual(-1, beingIndex);
int endIndex = deltaFragment.IndexOf(syntax.GenerateCommitTransaction());
Assert.AreEqual(-1, endIndex);
}
/// <summary>
/// Asserts the table does exist.
/// </summary>
/// <param name="name">The name of the table.</param>
private void AssertTableExists(string name)
{
var syntax = new MsSqlDbmsSyntax();
var schema = this.ExecuteScalar <string>(syntax.TableExists(name));
Assert.IsNotEmpty(schema, "'{0}' table was not created.", name);
}
