public void TestLoadFromCsv() { string path = @"D:\GreyHound\FILES\TMP\DSRoadVehicleFlowMoney.csv"; CsvConfiguration cfg = new CsvConfiguration(CultureInfo.InvariantCulture); Type tp = typeof(Dictionary <string, object>); using (SQLServerClientService sqlService = SQLServerClientService.GetInstance(conn1)) { using (StreamReader st = new StreamReader(path)) { using (CsvHelperReader csv = new CsvHelperReader(st, cfg)) { while (csv.Read()) { Dictionary <string, object> obj = csv.GetRecord(); obj["GroupUID"] = Guid.NewGuid(); obj["SystemUID"] = Guid.NewGuid(); sqlService.InsertItemDict("DSRoadVehicleFlowMoney", obj); } } } sqlService.Commit(); } }
public static void LoadCsvData(string tableName, string path, string dbconn, Func <Dictionary <string, object>, bool> preHandler) { CsvConfiguration cfg = new CsvConfiguration(CultureInfo.InvariantCulture, hasHeaderRecord: true, delimiter: "\t"); using (SQLServerClientService sqlService = SQLServerClientService.GetInstance(dbconn)) { using (StreamReader st = new StreamReader(path)) { using (CsvReader csv = new CsvReader(st, cfg)) { while (csv.Read()) { Dictionary <string, object> obj = csv.GetRecord(); if (!preHandler(obj)) { continue; } sqlService.InsertItemDict(tableName, obj); } } } sqlService.Commit(); } }
public static bool LoadCsvToDatabase(string tableName, string path, string connString, Func <Dictionary <string, object>, bool> preHandler) { using (SQLServerClientService s2 = SQLServerClientService.GetInstance(connString)) { LoadCsvData(path, (o) => { if (!preHandler(o)) { return(false); } s2.InsertItemDict(tableName, o); return(true); }); s2.Commit(); } return(true); }
public void InitData() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { Dictionary <string, object> obj = new Dictionary <string, object>() { { "ID", ID1 }, { "Name", "Name1" }, { "Age", 1 }, { "Aliase", null } }; if (!sqlBase.InsertItemDict(tableName, obj)) { Assert.Fail("Insert init failed"); } sqlBase.Commit(); } }
public void InitPagingData() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { for (int i = 0; i < 10; i++) { Dictionary <string, object> obj = new Dictionary <string, object>() { { "ID", Guid.NewGuid() }, { "Name", "Name" + i }, { "Age", i }, }; if (!sqlBase.InsertItemDict(tableName, obj)) { Assert.Fail("InitPagingData init failed"); } } sqlBase.Commit(); } }