public ShefSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { m_location = ConnectionStringUtility.GetToken(ConnectionString, "ShefLocation", ""); m_pecode = ConnectionStringUtility.GetToken(ConnectionString, "ShefCode", ""); m_filename = ConnectionStringUtility.GetToken(ConnectionString, "File", ""); InitTimeSeries(null, "", this.TimeInterval, true); }
public void SiteInfoDesignTest() { var fn = FileUtility.GetTempFileName(".pdb"); SQLiteServer svr = new SQLiteServer(fn); var db = new TimeSeriesDatabase(svr, false); var siteCatalog = db.GetSiteCatalog(); siteCatalog.AddsitecatalogRow("BOII", "Boise station", "ID"); svr.SaveTable(siteCatalog); var sc = db.GetSeriesCatalog(); var s = new Series(); s.SiteID = "BOII"; sc.AddSeriesCatalogRow(s, sc.NextID(), db.GetRootObjects()[0].ID); sc.Save(); var si = db.SiteInfo("BOII"); bool idaho = si.state == "ID"; //idaho var timezone = si.timezone; TimeSeriesDatabaseDataSet.SeriesCatalogDataTable d = si.SeriesList(); TimeSeriesDatabaseDataSet.SeriesCatalogRow row = d[0]; row.Parameter = "Asce ET #5"; d.Save(); Console.WriteLine(si.SeriesList()[0].Parameter); //var goodStats = (si.Parameters()[0].statistic == "Avg"); }
public NrcsSnotelSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { siteNumber = ConnectionStringUtility.GetToken(ConnectionString, "SiteNumber", ""); parameterName = ConnectionStringUtility.GetToken(ConnectionString, "ParameterName", ""); //State = LookupState(siteNumber); }
public HDBWebSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { string str = ConnectionStringUtility.GetToken(ConnectionString, "server", ""); m_server = (HDBServer)Enum.Parse(typeof(HDBServer), str); m_sdi = ConnectionStringUtility.GetIntFromConnectionString(ConnectionString, "sdi"); }
public OwrdSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { var str_dataset = ConnectionStringUtility.GetToken(this.ConnectionString, "DataSet", "MDF"); dataset = (OwrdDataSet)System.Enum.Parse(typeof(OwrdDataSet), str_dataset); m_includeProvisional = ConnectionStringUtility.GetBoolean(this.ConnectionString, "Provisional", false); station_nbr = ConnectionStringUtility.GetToken(this.ConnectionString, "StationNumber", ""); }
public SnotelSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { m_triplet = ConnectionStringUtility.GetToken(ConnectionString, "Triplet", ""); var p = ConnectionStringUtility.GetToken(ConnectionString, "SnotelParameter", ""); m_parameter = (SnotelParameterCodes)Enum.Parse(typeof(SnotelParameterCodes), p); TimeInterval = TimeSeries.TimeInterval.Daily; }
public UsgsDailyValueSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { m_parameter = UsgsDailyParameter.DailyMeanDischarge; string str = ConnectionStringUtility.GetToken(ConnectionString, "UsgsDailyParameter", ""); if (Enum.IsDefined(typeof(UsgsDailyParameter), str)) { m_parameter = (UsgsDailyParameter)Enum.Parse(typeof(UsgsDailyParameter), str); } m_site_no = ConnectionStringUtility.GetToken(ConnectionString, "site_no", ""); }
public BasicRating(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(sr) { this.m_db = db; this.m_sr = sr; int id = Convert.ToInt32(ConnectionStringToken("id", "-1")); Console.WriteLine("ctor BasicRating id =" + id); var tbl = m_db.Hydrography.GetRatingTables(); m_rating_tablesRow = tbl.FindByid(id); }
public BasicMeasurement(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(sr) { this.m_db = db; this.m_sr = sr; int id = Convert.ToInt32(ConnectionStringToken("id", "-1")); Console.WriteLine("ctor BasicMeasurement id ="+id); var tbl = m_db.Hydrography.GetMeasurements(); m_measurementRow = tbl.FindByid(id); }
/// <summary> /// Creates UrgsimSeries from TimeSeriesDatabase /// </summary> /// <param name="sdi"></param> /// <param name="db"></param> /// <param name="sr"></param> public UrgsimSeries(int sdi, TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { this.ExternalDataSource = true; m_path = ConnectionStringUtility.GetToken(ConnectionString, "Path", ""); m_projection = ConnectionStringUtility.GetToken(ConnectionString, "Projection", ""); m_variable = Parameter; ScenarioName = m_projection; Appearance.LegendText = ScenarioName; Units = GetUrgsimUnits(Parameter); }
private CalculationSeries CreateCalcSeries(TimeSeriesDatabaseDataSet.SeriesCatalogRow r, string name, TimeSeriesName tn, string expression) { var s = new CalculationSeries(name) { Parameter = tn.pcode, SiteID = r.siteid, Expression = expression }; s.Table.TableName = tn.GetTableName(); s.TimeInterval = tn.GetTimeInterval(); sw.WriteLine("Created: " + tn.GetTableName() + " = " + expression); return(s); }
/// <summary> /// Creates RiverWareSeries from TimeSeriesDatabase /// </summary> /// <param name="sdi"></param> /// <param name="db"></param> public RiverWareSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { m_filename = ConnectionStringUtility.GetFileName(ConnectionString, m_db.DataSource); this.ExternalDataSource = true; m_objectName = ConnectionStringUtility.GetToken(ConnectionString, "ObjectName", ""); m_slotName = ConnectionStringUtility.GetToken(ConnectionString, "SlotName", ""); int.TryParse(ConnectionStringUtility.GetToken(ConnectionString, "ScenarioNumber", ""), out m_scenarioNumber); bool.TryParse(ConnectionStringUtility.GetToken(ConnectionString, "IsSnapShot", ""), out m_isSnapShot); InitTimeSeries(null, this.Units, this.TimeInterval, this.ReadOnly, false, true); ScenarioName = "Run " + m_scenarioNumber; Appearance.LegendText = Name; }
public HydrometDailySeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { HydrometInfoUtility.ParseConnectionString(ConnectionString, out server, out cbtt, out pcode); }
string m_path; // //CHJ/YT//IR-MONTH/IRVZZBZD/ public UsaceSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr) { m_path = ConnectionStringUtility.GetToken(sr.ConnectionString, "DssPath", ""); ExternalDataSource = true; }