public void SetUp()
{
msDbAccessor = new MsDbAccessor(Connstr);
var loadxml = new LoadDbConfigXml(Xmlpath);
msDbAccessor.UpdateTables(loadxml.GeTableInfos());
}
public void TestGeTableInfos()
{
IList <TableInfo> tablelst = loadxml.GeTableInfos();
Assert.AreEqual(18, tablelst.Count);
Assert.AreEqual("T_DATA_ORIGINAL", tablelst[0].TableName);
Assert.AreEqual("SensorId,CollectTime,Value1,Value2,Value3,Value4", tablelst[0].Colums);
Assert.AreEqual("T_THEMES_CABLE_FORCE", tablelst[1].TableName);
Assert.AreEqual(T_THEMES_CABLE_FORCE, tablelst[1].Colums);
Assert.AreEqual("T_THEMES_DEFORMATION_BRIDGE_DEFLECTION", tablelst[2].TableName);
Assert.AreEqual(T_THEMES_DEFORMATION_BRIDGE_DEFLECTION, tablelst[2].Colums);
Assert.AreEqual("T_THEMES_DEFORMATION_CRACK", tablelst[3].TableName);
Assert.AreEqual(T_THEMES_DEFORMATION_CRACK, tablelst[3].Colums);
Assert.AreEqual("T_THEMES_DEFORMATION_DEEP_DISPLACEMENT", tablelst[4].TableName);
Assert.AreEqual(T_THEMES_DEFORMATION_DEEP_DISPLACEMENT, tablelst[4].Colums);
Assert.AreEqual("T_THEMES_DEFORMATION_SETTLEMENT", tablelst[5].TableName);
Assert.AreEqual(T_THEMES_DEFORMATION_SETTLEMENT, tablelst[5].Colums);
Assert.AreEqual("T_THEMES_DEFORMATION_SURFACE_DISPLACEMENT", tablelst[6].TableName);
Assert.AreEqual(T_THEMES_DEFORMATION_SURFACE_DISPLACEMENT, tablelst[6].Colums);
Assert.AreEqual("T_THEMES_ENVI_RAINFALL", tablelst[7].TableName);
Assert.AreEqual(T_THEMES_ENVI_RAINFALL, tablelst[7].Colums);
Assert.AreEqual("T_THEMES_ENVI_TEMP_HUMI", tablelst[8].TableName);
Assert.AreEqual(T_THEMES_ENVI_TEMP_HUMI, tablelst[8].Colums);
Assert.AreEqual("T_THEMES_ENVI_WATER_LEVEL", tablelst[9].TableName);
Assert.AreEqual(T_THEMES_ENVI_WATER_LEVEL, tablelst[9].Colums);
Assert.AreEqual("T_THEMES_ENVI_WIND", tablelst[10].TableName);
Assert.AreEqual(T_THEMES_ENVI_WIND, tablelst[10].Colums);
Assert.AreEqual("T_THEMES_FORCE_ANCHOR", tablelst[11].TableName);
Assert.AreEqual(T_THEMES_FORCE_ANCHOR, tablelst[11].Colums);
Assert.AreEqual("T_THEMES_FORCE_EARTH_PRESSURE", tablelst[12].TableName);
Assert.AreEqual(T_THEMES_FORCE_EARTH_PRESSURE, tablelst[12].Colums);
Assert.AreEqual("T_THEMES_FORCE_STEELBAR", tablelst[13].TableName);
Assert.AreEqual(T_THEMES_FORCE_STEELBAR, tablelst[13].Colums);
Assert.AreEqual("T_THEMES_STRESS_STRAIN_PORE_WATER_PRESSURE", tablelst[14].TableName);
Assert.AreEqual(T_THEMES_STRESS_STRAIN_PORE_WATER_PRESSURE, tablelst[14].Colums);
Assert.AreEqual("T_THEMES_STRESS_STRAIN_RETAININGWALL", tablelst[15].TableName);
Assert.AreEqual(T_THEMES_STRESS_STRAIN_RETAININGWALL, tablelst[15].Colums);
Assert.AreEqual("T_THEMES_FORCE_AXIAL", tablelst[16].TableName);
Assert.AreEqual(T_THEMES_FORCE_AXIAL, tablelst[16].Colums);
}
public void msDbAccessorTest()
{
try
{
MsDbAccessor msDbAccessor = new MsDbAccessor(Connstr);
var loadxml = new LoadDbConfigXml(string.Empty);
msDbAccessor.UpdateTables(loadxml.GeTableInfos());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Assert.True(true);
}
}
public void TestGeTableInfos()
{
IList <TableInfo> tablelst = loadxml.GeTableInfos();
Assert.AreEqual(9, tablelst.Count);
}
