public void Test_ExecuteScripts_TwoFileContent_WithGo() { const string fileContent = @"create table BackendUser (BackendUserId int, Username nvarchar(30)) go create table Company (CompanyId int, Name nvarchar(30)) go"; const bool expectedResult = true; var dbConnectionMock = new Mock<IDbConnection>(); var databaseMock = new Mock<IDatabase>(); var dbCommandMock = new Mock<IDbCommand>(); databaseMock.Setup(t => t.GetDbConnection()).Returns(dbConnectionMock.Object); databaseMock.Setup(t => t.GetDbCommand()).Returns(dbCommandMock.Object); dbConnectionMock.Setup(t => t.Open()); dbCommandMock.Setup(t => t.ExecuteNonQuery()); IDbProvider provider = new MsSqlDbProvider(databaseMock.Object); var actualResult = provider.ExecuteScript(fileContent); dbCommandMock.VerifyAll(); databaseMock.VerifyAll(); dbCommandMock.VerifyAll(); Assert.Equal(expectedResult, actualResult); }
public void Test_ExecuteScripts_OneFileContent_WithoutGo() { const string fileContent = "MsSQL Script"; const bool expectedResult = true; var dbConnectionMock = new Mock<IDbConnection>(); var databaseMock = new Mock<IDatabase>(); var dbCommandMock = new Mock<IDbCommand>(); databaseMock.Setup(t => t.GetDbConnection()).Returns(dbConnectionMock.Object); databaseMock.Setup(t => t.GetDbCommand()).Returns(dbCommandMock.Object); dbConnectionMock.Setup(t => t.Open()); dbCommandMock.Setup(t => t.ExecuteNonQuery()); IDbProvider provider = new MsSqlDbProvider(databaseMock.Object); var actualResult = provider.ExecuteScript(fileContent); dbCommandMock.VerifyAll(); databaseMock.VerifyAll(); dbCommandMock.VerifyAll(); Assert.Equal(expectedResult, actualResult); }