public void TestGetSqlConnectionStrings() { string connstr = loadxml.GetSqlConnectionStrings(); Assert.AreEqual( "Initial Catalog=DW_iSecureCloud_Empty;Data Source=192.168.1.128;User Id=sa;Password=861004", connstr); }
public void TestGetSqlConnectionStrings() { string connstr = loadxml.GetSqlConnectionStrings(); Assert.AreEqual( @"FSUSDB\FSUSDataValueDB.db3", connstr); }
public void TestHasMoreData() { DbDacDataProvider p = new DbDacDataProvider(); Dictionary <string, string> args = new Dictionary <string, string>(); args.Add("sqlitedbcongxml", this.path); p.Init_Sqlite(args); // 5. // var cs = connstr.Split(','); LoadDbConfigXml lc = new LoadDbConfigXml(this.path); string[] sonstr = lc.GetSqlConnectionStrings("/config/databases"); ISqlHelper sqlHelper = SqlHelperFactory.Create(DbType.SQLite, sonstr[0]); sqlHelper.Query("update D_OriginalWindData set lastSyncTime = null"); Assert.IsTrue(p.HasMoreData()); Console.WriteLine("TotalReminder: {0} records.", p.Remainder); Assert.IsTrue(p.Remainder > 0); int len = 0; TranMsg[] msgs = p.NextPackages(out len); Assert.IsNotNull(msgs); byte[] buff = msgs[0].Data; Console.WriteLine(ValueHelper.BytesToHexStr(buff, 0, len, "")); // Record 4. Assert.IsTrue(len > 0); // Data Sent p.OnPackageSent(); var ds = sqlHelper.Query("select count(ID) from D_OriginalWindData where lastSyncTime is null"); Assert.AreEqual(0, Convert.ToInt32(ds.Tables[0].Rows[0][0])); }
/// <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); }