public void TestRemoveItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { Data obj = new Data() { ID = ID1, Name = "d2", Aliase = null }; if (!sqlBase.InsertItem(tableName, obj)) { Assert.Fail("Insert failed before delete"); } FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); if (!sqlBase.RemoveItem <Data>(tableName, filter)) { Assert.Fail("Delete failed"); } sqlBase.Commit(); } }
public void TestUpdateItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); Data result = new Data() { ID = ID1, Name = "UpdatedName", Aliase = "UpdatedAliase", }; if (!sqlBase.UpdateItem(tableName, filter, result, new string[] { "Name", "Aliase" })) { Assert.Fail("UpdateItem Failed"); } sqlBase.Commit(); var obj = sqlBase.GetItem <Data>(tableName, filter); Assert.AreEqual(result.ID, obj.ID); Assert.AreEqual(result.Name, obj.Name); Assert.AreEqual(result.Aliase, obj.Aliase); sqlBase.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 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 void TestGetItemListDict() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); var result = new Dictionary <string, object>() { { "ID", ID1 }, { "Name", "Name1" }, { "Age", 1 }, { "Aliase", null } }; List <Dictionary <string, object> > list = sqlBase.GetItemListDict(tableName, filter); Assert.AreEqual(list.Count, 1); var obj = list[0]; Assert.AreEqual(result["ID"], obj["ID"]); Assert.AreEqual(result["Name"], obj["Name"]); Assert.AreEqual(result["Aliase"], obj["Aliase"]); sqlBase.Commit(); } }
public void TestUpdateItemDict() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); var result = new Dictionary <string, object>() { { "ID", ID1 }, { "Name", "UpdatedName" }, { "Age", 1 }, { "Aliase", "UpdatedAliase" } }; if (!sqlBase.UpdateItemDict(tableName, filter, result, new string[] { "Name", "Aliase" })) { Assert.Fail("UpdateItemDict Failed"); } var obj = sqlBase.GetItemDict(tableName, filter); Assert.AreEqual(result["ID"], obj["ID"]); Assert.AreEqual(result["Name"], obj["Name"]); Assert.AreEqual(result["Aliase"], obj["Aliase"]); sqlBase.Commit(); } }
public void CleanData() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); sqlBase.RemoveItemDict(tableName, filter); sqlBase.Commit(); } }
public void TestConnect() { using (SQLServerClientService s1 = SQLServerClientService.GetInstance(conn1)) { using (SQLServerClientService s2 = SQLServerClientService.GetInstance(conn1)) { // Connect Success } } }
public static void UpdateData() { string tb = "OMRoadYearTask"; using (SQLServerClientService sv204 = SQLServerClientService.GetInstance(conn3)) using (SQLServerClientService svLocal = SQLServerClientService.GetInstance(conn1)) { List <Dictionary <string, object> > gp = sv204.GetAllItemDict(tb); svLocal.InsertItemListDict(tb, gp); svLocal.Commit(); } }
public void TestRemoveItemDict() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); if (!sqlBase.RemoveItemDict(tableName, filter)) { Assert.Fail("Delete failed"); } sqlBase.Commit(); } }
public void CleanPagingData() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition ft = new FilterCondition("Age", TableCompareType.LT, 10); if (!sqlBase.RemoveItemDict(tableName, ft)) { Assert.Fail("CleanPagingData init failed"); } sqlBase.Commit(); } }
public void TestGetItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); Data result = new Data() { ID = ID1, Name = "Name1", Aliase = null }; Data obj = sqlBase.GetItem <Data>(tableName, filter); Assert.AreEqual(result.ID, obj.ID); Assert.AreEqual(result.Name, obj.Name); Assert.AreEqual(result.Aliase, obj.Aliase); } }
public void TestGetItemListDictPaging2() { InitPagingData(); using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { List <FilterCondition> fts = new List <FilterCondition>() { new FilterCondition("Age", TableCompareType.LT, 10), new FilterCondition("Age", TableCompareType.GTE, 5), }; List <Dictionary <string, object> > list = sqlBase.GetItemListDict(tableName, fts); Assert.AreEqual(list.Count, 5); sqlBase.Commit(); } CleanPagingData(); }
public void TestInsertItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { Data obj = new Data() { ID = ID1, Name = "d2", Aliase = null }; if (!sqlBase.InsertItem(tableName, obj)) { Assert.Fail(); } sqlBase.Commit(); } }
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 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 TestGetItemListDictEmpty() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter2 = new FilterCondition("id", TableCompareType.EQ, Guid.NewGuid()); var result = new Dictionary <string, object>() { { "ID", ID1 }, { "Name", "d2" }, { "Age", 1 }, { "Aliase", null } }; List <Dictionary <string, object> > list2 = sqlBase.GetItemListDict(tableName, filter2); Assert.IsNotNull(list2); Assert.AreEqual(list2.Count, 0); 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(); } }