public void Init(Dictionary <string, string> args) { if (_initialized) { return; } _initialized = true; string dbMapFile = args["dbcongxml"]; Log.DebugFormat("Loading mapping from {0}", dbMapFile); var ldcx = new LoadDbConfigXml(dbMapFile); DataSourseTableInfo[] tableInfos = ldcx.GetDataSourseTableInfo("/config/databases"); this.DoUpdateAsNecessary(tableInfos); }
/// <summary> /// 统一采集软件 /// </summary> /// <param name="args"></param> public void Init_Sqlite(Dictionary <string, string> args) { if (_initialized) { return; } _initialized = true; string dbMapFile = args["sqlitedbcongxml"]; Log.DebugFormat("Loading mapping from {0}", dbMapFile); var ldcx = new LoadDbConfigXml(dbMapFile); string[] connStrs = ldcx.GetSqlConnectionStrings("/config/databases"); if (connStrs == null || connStrs.Length == 0) { return; } sqlHelper = SqlHelperFactory.Create(DbType.SQLite, connStrs[0]); //DbAccessorHelper.Init(new SQLiteDbAccessor(connStrs[0])); DataSourseTableInfo[] tableInfos = ldcx.GetDataSourseTableInfo("/config/databases"); this.DoUpdateAsNecessary_Sqlite(tableInfos); }
public void TestLoadDbConfigxml() { var ldcx = new LoadDbConfigXml(this.path); DataSourseTableInfo[] tables = ldcx.GetDataSourseTableInfo("/config/databases"); if (tables.Length != 1) { Assert.Fail(); return; } Assert.AreEqual(tables[0].DataBaseName, "DW_iSecureCloud_Empty"); Assert.AreEqual(tables[0].DbType, DbType.MSSQL); string connectionString = "Initial Catalog=DW_iSecureCloud_Empty;Data Source=192.168.1.128;User Id=sa;Password=861004"; Assert.AreEqual(tables[0].ConnectionString, connectionString); Assert.AreEqual(tables[0].TableName, "T_THEMES_ENVI_WIND"); Assert.AreEqual(tables[0].Type, ProtocolType.GPS_ZHD); Assert.AreEqual(tables[0].Colums.Length, 6); if (tables[0].Colums.Length == 6) { Assert.AreEqual(tables[0].Colums[0], "ID"); Assert.AreEqual(tables[0].StandardFields[0], "ID"); Assert.AreEqual(tables[0].Colums[1], "SENSOR_ID"); Assert.AreEqual(tables[0].StandardFields[1], "SID"); Assert.AreEqual(tables[0].Colums[2], "ACQUISITION_DATETIME"); Assert.AreEqual(tables[0].StandardFields[2], "AcqTime"); Assert.AreEqual(tables[0].Colums[3], "WIND_SPEED_VALUE"); Assert.AreEqual(tables[0].StandardFields[3], "Value1"); Assert.AreEqual(tables[0].Colums[4], "WIND_DIRECTION_VALUE"); Assert.AreEqual(tables[0].StandardFields[4], "Value2"); Assert.AreEqual(tables[0].Colums[5], "WIND_ELEVATION_VALUE"); Assert.AreEqual(tables[0].StandardFields[5], "Value3"); } Assert.AreEqual(tables[0].DataCount, 3); Assert.AreEqual(tables[0].Filter, "where lastSyncTime is null"); }