public void break_statements_inbetween_go_statements()
{
string filePath = "C:\\test";
string fileContents = @"test contents category
go
Test
GO
TEST
GO
GO
test
multiple
lines
GO";
using (Mock.Record())
{
//try to read the file
Expect.Call(_fileIo.ReadConentsOfFile(filePath))
.Return(fileContents);
}
using (Mock.Playback())
{
var sqlMigration = new TSqlMigration(filePath);//, _migrationHelper, _fileIo);
IList<string> sqlCommand = sqlMigration.GetSqlCommands();
//there should be 3 commands inside this fake sql file
Assert.That(sqlCommand.Count, Is.EqualTo(4));
Assert.That(sqlCommand[0], Is.EqualTo("test contents category\r\n"));
Assert.That(sqlCommand[1], Is.EqualTo("Test\r\n"));
Assert.That(sqlCommand[2], Is.EqualTo("TEST\r\n"));
//make sure it did not clump each line into one big string
Assert.That(sqlCommand[3], Is.Not.EqualTo("testmultiplelines"));
}
}
public void make_sure_we_attempt_to_read_the_contents_of_the_sql_file()
{
string filePath = "C:\\test";
string fileContents = "test contents\r\n";
using (Mock.Record())
{
//try to read the file
Expect.Call(_fileIo.ReadConentsOfFile(filePath))
.Return(fileContents);
}
using (Mock.Playback())
{
var sqlMigration = new TSqlMigration(filePath);//, _migrationHelper, _fileIo);
var sqlCommand = sqlMigration.GetSqlCommands();
Assert.AreEqual(fileContents, sqlCommand[0], "This should be the same contents");
}
}
public void parse_only_go_statements_not_any_word_containing_go()
{
string filePath = "C:\\test";
string fileContents = @"test contents category
go
Test
GO
TEST
GO";
using (Mock.Record())
{
//try to read the file
Expect.Call(_fileIo.ReadConentsOfFile(filePath))
.Return(fileContents);
}
using (Mock.Playback())
{
var sqlMigration = new TSqlMigration(filePath);//, _migrationHelper, _fileIo);
var sqlCommand = sqlMigration.GetSqlCommands();
Assert.AreEqual("test contents category\r\n", sqlCommand[0], "This should contain no GO or go statements");
Assert.AreEqual("Test\r\n", sqlCommand[1], "This should contain no GO or go statements");
Assert.AreEqual("TEST\r\n", sqlCommand[2], "This should contain no GO or go statements");
}
}
public void no_GO_statements()
{
string filePath = "C:\\test";
string fileContents = @"test contents category
Test
TEST";
using (Mock.Record())
{
//try to read the file
Expect.Call(_fileIo.ReadConentsOfFile(filePath))
.Return(fileContents);
}
using (Mock.Playback())
{
var sqlMigration = new TSqlMigration(filePath);//, _migrationHelper, _fileIo);
IList<string> sqlCommand = sqlMigration.GetSqlCommands();
//there should be 3 commands inside this fake sql file
Assert.That(sqlCommand.Count, Is.EqualTo(1));
Assert.That(sqlCommand[0], Is.EqualTo(fileContents + "\r\n"));
}
}