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