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