static void Main(string[] args)
{
var fn = @"C:\temp\pn.pdb";
//var svr_vm = MySqlServer.GetMySqlServer("vm", "timeseries");
var svr_vm = new SQLiteServer(fn);
if (svr_vm.TableExists("seriescatalog"))
{
svr_vm.RunSqlCommand("truncate seriescatalog");
}
if (svr_vm.TableExists("sitescatalog"))
{
svr_vm.RunSqlCommand("truncate sitecatalog");
}
var db_vm = new TimeSeriesDatabase(svr_vm, Reclamation.TimeSeries.Parser.LookupOption.TableName);
var sites_vm = db_vm.GetSiteCatalog();
var svr = PostgreSQL.GetPostgresServer("timeseries", "lrgs1");
var db = new TimeSeriesDatabase(svr, Reclamation.TimeSeries.Parser.LookupOption.TableName);
var sites = db.GetSiteCatalog();
string program = "agrimet";
var sc = db.GetSeriesCatalog("timeinterval='Daily'", "program:" + program);
var sc_vm = db_vm.GetSeriesCatalog();
LoadDailyUsbrCatalog(sc, sc_vm, program);
//db_vm.Server.SaveTable(sc_vm);
LoadUpperSnakeHydromet(sc_vm);
db_vm.Server.SaveTable(sc_vm);
// install all sites that are referenced in series catalog
var tmp = db_vm.Server.Table("tmp", "select distinct siteid from seriescatalog");
for (int i = 0; i < tmp.Rows.Count; i++)
{
string siteid = tmp.Rows[i]["siteid"].ToString();
var rows = sites.Select("siteid='" + siteid + "'");
if (rows.Length > 0)
{
var newRow = sites_vm.NewsitecatalogRow();
newRow.ItemArray = rows[0].ItemArray;
sites_vm.Rows.Add(newRow);
}
}
db_vm.Server.SaveTable(sites_vm);
}
public void TestSQLite()
{
var fn = FileUtility.GetTempFileName(".pdb");
SQLiteServer svr = new SQLiteServer(fn);
var db = new TimeSeriesDatabase(svr);
var sql = "insert into quality_limit values ('*_OB',120,-50,null); ";
svr.RunSqlCommand(sql);
var s = new Series();
s.Table.TableName = "karl_ob";
s.Add("1-1-2013", 100);
s.Add("1-2-2013", -51);
s.Add("1-3-2013", 100);
s.Add("1-4-2013", 150);
//db.TimeSeriesImporter.Process(s);
TimeSeriesImporter ti = new TimeSeriesImporter(db);
ti.Import(s);
//db.ImportSeriesUsingTableName(s, true, setQualityFlags: true);
s = db.GetSeriesFromTableName("karl_ob");
s.Read();
Console.WriteLine("has flags = " + s.HasFlags);
s.WriteToConsole(true);
Assert.AreEqual("", s["1-1-2013"].Flag);
Assert.AreEqual("-", s["1-2-2013"].Flag);
Assert.AreEqual("", s["1-3-2013"].Flag);
Assert.AreEqual("+", s["1-4-2013"].Flag);
}