public void SuccesfulImportTest()
{
ImportStatement statement = new ImportStatement("declare @test table (id int) insert into @test values (0)", "0");
SQLServerDataImporter importer = new SQLServerDataImporter(getConfig());
ImportResult result = importer.ImportData(statement);
SuccesfulImport import = (SuccesfulImport)result;
Assert.AreEqual(1, import.RowsAffected);
Assert.AreEqual(statement, import.Statement);
}
public void MultipImportsTest()
{
ImportStatement statement1 = new ImportStatement("declare @test table (id int) insert into @test values (0)", "0");
ImportStatement statement2 = new ImportStatement("declare @test table (id int) insert into @test values (0) insert into @test values (0)", "1");
ImportStatement statement3 = new ImportStatement("'a'", "2");
SQLServerDataImporter importer = new SQLServerDataImporter(getConfig());
ImportResult[] result = importer.ImportData(new ImportStatement[] { statement1, statement2, statement3 });
SuccesfulImport import1 = (SuccesfulImport)result[0];
SuccesfulImport import2 = (SuccesfulImport)result[1];
UnsuccesfulImport import3 = (UnsuccesfulImport)result[2];
Assert.AreEqual(1, import1.RowsAffected);
Assert.AreEqual(statement1, import1.Statement);
Assert.AreEqual(2, import2.RowsAffected);
Assert.AreEqual(statement2, import2.Statement);
Assert.AreEqual("Incorrect syntax near 'a'.", import3.ErrorMsg);
Assert.AreEqual(statement3, import3.Statement);
}