private void _store_candles(string fstr, string d2)
{
DataTable dic = default(DataTable);
QuandlAPI.QuandlError err = default(QuandlAPI.QuandlError);
WnF_DBType dbt = (WnF_DBType)Properties.Settings.Default.dbms;
string cstr;
err = _api.GetCandlesTable(fstr, d2, out dic, _tname);
if (err != null)
{
Console.WriteLine("[QuandlChart._store_candles()] GetCandlesTable failed...\r\n" + err.message);
return;
}
#if DEBUG
dynamic watch = System.Diagnostics.Stopwatch.StartNew();
#endif
cstr = string.Format(Properties.Settings.Default.dbConn, _database);
using (WnFDbConnectionWrapper dbcw = WnFDbConnectionWrapper.GetWrapper(dbt, cstr))
dbcw.InsertTable(dic);
#if DEBUG
watch.Stop();
Console.WriteLine("[QuandlChart._store_candles()] " + dic.Rows.Count + " ellapsed " + watch.ElapsedMilliseconds);
#endif
dic = null;
}
public WnFDbConnectionWrapper(WnF_DBType k, string s)
{
if (string.IsNullOrEmpty(s))
{
throw new ArgumentException("Connection String Empty", "connStr");
}
connStr = s;
type = k;
}
public static WnFDbConnectionWrapper GetWrapper(WnF_DBType k, string s)
{
WnFDbConnectionWrapper wrpper = default(WnFDbConnectionWrapper);
if (k == WnF_DBType.SQLCE)
{
retry:
wrpper = new SqlCeWrapper(k, s);
if (!wrpper.InitConnection())
{
wrpper = null; Thread.Sleep(10);
goto retry;
}
}
else
{
throw new NotImplementedException();
}
return(wrpper);
}
public SQLiteWrapper(WnF_DBType k, string s) : base(k, s)
{
}
public MySqlWrapper(WnF_DBType k, string s) : base(k, s)
{
dbname = string.Empty;
SetDBName(s);
}
public SqlCeWrapper(WnF_DBType k, string s) : base(k, s)
{
}
