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