public void ImportCsvFromPath() { var saver = new TestInsertSaver(); using (var importer = new CsvTableImporter <TestClass>(new MappingOptions(), saver)) { importer.Import(TestXlsxPath); } }
public void ImportCsvFromPathAndEvents() { var saver = new TestInsertSaver(); using (var importer = new CsvTableImporter <TestClass>(new MappingOptions(), saver)) { saver.Progress += Importer_Progress; importer.Import(TestCsvPath); saver.Progress -= Importer_Progress; } }
private static void Test() { var runner = new IntegrationTestsRunner(); var result = runner.CreateDatabase("schoolDb"); PrintResult(result); result = runner.ExecuteQuery("CREATE TABLE students (Id:int,FirstName:string,LastName:string,Grade:int)", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("CREATE TABLE objects (Name:string,Points:int)", "schoolDb"); PrintResult(result); var firstNames = new List <string>() { "Vasile", "Ion", "Gheorghe", "Nicolai", "Elena", "Stefan", "Alexandra", "Mihai", "Maria", "Ana" }; var lastNames = new List <string>() { "Pojoga", "Munteanu", "Herta", "Ailenei", "Creanga", "Stan", "Budescu", "Apostol", "Mironica", "Velea" }; var grades = new List <int>() { 9, 4, 8, 7, 10, 9, 3, 2, 8, 10 }; for (var i = 0; i < 10; i++) { result = runner.ExecuteQuery(string.Format("INSERT INTO students(Id,FirstName,LastName,Grade) VALUES({0},'{1}','{2}',{3})", i + 1, firstNames[i], lastNames[i], grades[i]), "schoolDb"); PrintResult(result); } result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("SELECT * FROM students WHERE Id>0 AND Id<2 OR Grade>9 AND Id>=2 AND FirstName!='Vasile'", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("DELETE FROM students WHERE Id=1 OR Id>=8", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("UPDATE students SET Grade=5 WHERE Grade<5", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("UPDATE students SET Grade=5,LastName='Failed' WHERE Grade<5 OR FirstName='Vasile'", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); PrintResult(result); result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); IQueryResultSerializer serializer = new CsvQueryResultSerializer(); var csv = serializer.Serialize(result); System.Console.WriteLine(csv); result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb"); serializer = new XmlQueryResultSerializer(); var xml = serializer.Serialize(result); System.Console.WriteLine(xml); result = runner.ExecuteQuery("DELETE FROM students", "schoolDb"); PrintResult(result); var databaseConnection = new DatabaseConnection(new DatabaseCofiguration(new DatabaseStorageService()), Constants.ServerLocation, "schoolDb"); ITableImporter importer = new CsvTableImporter(); var success = importer.Import(databaseConnection, "students", csv); System.Console.WriteLine(string.Format("Import from csv: {0}", success)); importer = new XmlTableImporter(); success = importer.Import(databaseConnection, "students", xml); System.Console.WriteLine(string.Format("Import from xml: {0}", success)); System.Console.ReadKey(); }