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); }