public void Test_GetBiData()
{
var id = DataService.CreateBiRecord("TEST_005", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = DataService.InsertBiData(id, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
res = DataService.InsertBiData(id, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("c", "3"),
new KeyValuePair <string, string>("d", "4")
});
Assert.AreEqual(res, true);
var table = DataService.GetBiData(id, 1);
Assert.AreEqual(table.Rows.Count, 1);
table = DataService.GetBiData(id, 2);
Assert.AreEqual(table.Rows.Count, 2);
table = DataService.GetBiData(id);
Assert.AreEqual(table.Rows.Count, 2);
var service = new DataService37(ConStr);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_GetBiRecord4()
{
var id1 = DataService.CreateBiRecord("TEST_012", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = DataService.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
res = DataService.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("c", "3"),
new KeyValuePair <string, string>("d", "4")
});
Assert.AreEqual(res, true);
DateTime startIime = DateTime.Now.AddHours(-1);
DateTime finishTime = DateTime.Now.AddHours(1);
res = DataService.UpdateBiReocordData(id1, finishTime, "60", "PASS");
Assert.AreEqual(res, true);
var id2 = DataService.CreateBiRecord("TEST_013", "QSFP28G", "TEST_PLAN", "L10_1", "1");
res = DataService.InsertBiData(id2, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
res = DataService.InsertBiData(id2, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("c", "3"),
new KeyValuePair <string, string>("d", "4")
});
Assert.AreEqual(res, true);
res = DataService.UpdateBiReocordData(id2, finishTime, "60", "FAIL");
Assert.AreEqual(res, true);
var table = DataService.GetBiRecord(Environment.MachineName, startIime, finishTime);
Assert.AreEqual(table.Rows.Count, 2);
table = DataService.GetBiRecord(Environment.MachineName, startIime, finishTime, "PASS");
Assert.AreEqual(table.Rows.Count, 1);
table = DataService.GetBiRecord(Environment.MachineName, startIime, finishTime, "FAIL");
Assert.AreEqual(table.Rows.Count, 1);
var service = new DataService37(ConStr);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_GetBiRecord1()
{
var id1 = DataService.CreateBiRecord("TEST_006", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = DataService.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
res = DataService.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("c", "3"),
new KeyValuePair <string, string>("d", "4")
});
Assert.AreEqual(res, true);
DateTime finishTime = DateTime.Now;
res = DataService.UpdateBiReocordData(id1, finishTime, "60", "PASS");
Assert.AreEqual(res, true);
var id2 = DataService.CreateBiRecord("TEST_007", "QSFP28G", "TEST_PLAN", "L10_1", "1");
res = DataService.InsertBiData(id2, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
res = DataService.InsertBiData(id2, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("c", "3"),
new KeyValuePair <string, string>("d", "4")
});
Assert.AreEqual(res, true);
res = DataService.UpdateBiReocordData(id2, finishTime, "60", "FAIL");
Assert.AreEqual(res, true);
string[] snSet = new[] { "TEST_007", "TEST_006" };
var table = DataService.GetBiRecord(snSet);
Assert.AreEqual(table.Rows.Count, 2);
table = DataService.GetBiRecord(snSet, "PASS");
Assert.AreEqual(table.Rows.Count, 1);
table = DataService.GetBiRecord(snSet, "FAIL");
Assert.AreEqual(table.Rows.Count, 1);
var service = new DataService37(ConStr);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_CreateBiRecord()
{
DataService.CreateBiRecord("TEST_001", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var service = new DataService37(ConStr);
var table = service.FetchLocalUploadData(service.DataTables.LocalBiSummaryDataTable, BurnState.Created);
Assert.AreEqual(table.Rows.Count, 1);
var res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_UpdateBiReocordData1()
{
var id = DataService.CreateBiRecord("TEST_002", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = DataService.UpdateBiReocordData(id, DateTime.Now);
Assert.AreEqual(res, true);
var service = new DataService37(ConStr);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_IsRemoteTableExist()
{
var connText = @"Data Source = wux-prod04\prod01; Initial Catalog = BI_Data; Persist Security Info = True; User ID = BI_Data_Admin; Password = BI_Data_Admin@123; Pooling = False";
var service = new DataService37(connText);
var res = service.IsTableExist(connText, "BI_Data_Summary_TEST");
Assert.AreEqual(res, true);
res = service.IsTableExist(connText, "BI_Data_TEST");
Assert.AreEqual(res, true);
}
public void TestCleanup()
{
var service = new DataService37(ConStr);
var res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiDataTable);
Assert.AreEqual(res, true);
}
public void Test_DeleteHaveUploadedData()
{
var service = new DataService37(ConStr);
service.SetRemoteConStr(ConStr);
var id1 = service.CreateBiRecord("ZWX_1", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = service.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
var id2 = service.CreateBiRecord("ZWX_2", "QSFP28G", "TEST_PLAN", "L10_1", "1");
res = service.InsertBiData(id2, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
service.TransDataToServer();
DateTime finishTime = DateTime.Now;
res = service.UpdateBiReocordData(id1, finishTime, "60", "PASS");
Assert.AreEqual(res, true);
res = service.UpdateBiReocordData(id2, finishTime, "60", "FAIL");
Assert.AreEqual(res, true);
service.TransDataToServer();
service.DeleteHaveUploadedData(service.DataTables.LocalBiSummaryDataTable);
service.DeleteHaveUploadedData(service.DataTables.LocalBiDataTable);
var table = service.FetchLocalUploadData(service.DataTables.LocalBiSummaryDataTable, BurnState.Delete);
Assert.AreEqual(table.Rows.Count, 0);
table = service.FetchLocalUploadData(service.DataTables.LocalBiDataTable, BurnState.Delete);
Assert.AreEqual(table.Rows.Count, 0);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiDataTable);
Assert.AreEqual(res, true);
}
public void Test_UpdateBiReocordData2()
{
var id = DataService.CreateBiRecord("TEST_003", "QSFP28G", "TEST_PLAN", "L10_1", "1");
DateTime finishTime = DateTime.Now;
var res = DataService.UpdateBiReocordData(id, finishTime, "60", "PASS");
Assert.AreEqual(res, true);
var service = new DataService37(ConStr);
var table = service.FetchLocalUploadData(service.DataTables.LocalBiSummaryDataTable, BurnState.End);
Assert.AreEqual(table.Rows.Count, 1);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
}
public void Test_TransDataToServer()
{
var service = new DataService37(ConStr);
service.SetRemoteConStr(ConStr);
var id1 = service.CreateBiRecord("ZWX_1", "QSFP28G", "TEST_PLAN", "L10_1", "1");
var res = service.InsertBiData(id1, new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("a", "1"),
new KeyValuePair <string, string>("b", "2")
});
Assert.AreEqual(res, true);
service.TransDataToServer();
var table = service.FetchLocalUploadData(service.DataTables.LocalBiSummaryDataTable, BurnState.Starting);
Assert.AreEqual(table.Rows.Count, 1);
table = service.FetchLocalUploadData(service.DataTables.LocalBiDataTable, BurnState.Delete);
Assert.AreEqual(table.Rows.Count, 1);
table = service.FetchLocalUploadData(service.DataTables.RemoteBiSummaryDataTable, BurnState.Created);
Assert.AreEqual(table.Rows.Count, 1);
table = service.FetchLocalUploadData(service.DataTables.RemoteBiDataTable, BurnState.Created);
Assert.AreEqual(table.Rows.Count, 1);
res = service.DeleteTableData(service.DataTables.LocalBiDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.LocalBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiSummaryDataTable);
Assert.AreEqual(res, true);
res = service.DeleteTableData(service.DataTables.RemoteBiDataTable);
Assert.AreEqual(res, true);
}
