public HdbOracleSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
ExternalDataSource = true;
ReadOnly = true;
Init();
}
public SimpleMathSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
string[] idList = ConnectionStringUtility.GetToken(ConnectionString, "SeriesList", "").Split(',');
string[] opList = ConnectionStringUtility.GetToken(ConnectionString, "OperatorList", "").Split(',');
m_operation = new MathOperation[opList.Length];
m_items = new SeriesList();
for (int i = 0; i < idList.Length; i++)
{
int id = -1;
if (!Int32.TryParse(idList[i], out id) || !db.SeriesExists(id))
{
Logger.WriteLine("Cannot calculate series. Has the data this calculation needs been deleted?");
Name = "Error: source data missing " + Name;
m_sourceDeleted = true;
break;
}
else
{
Series s = db.GetSeries(id);
m_items.Add(s);
}
}
ScenarioName = m_items[0].ScenarioName;
// TO DO assuming all scenarioNames are the same.
for (int i = 0; i < opList.Length; i++)
{
m_operation[i] = MathOperationFromString(opList[i]);
}
}
/// <summary>
/// Used to create ModsimSeries from TimeSeriesDatabase
/// </summary>
public ModsimSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
m_defaultUnits = Units;
m_xyFilename = ConnectionStringUtility.GetFileName(ConnectionString, db.DataSource);
m_mdbFilename = Path.ChangeExtension(m_xyFilename, null) + "OUTPUT.mdb";
m_accdbFilename = Path.ChangeExtension(m_xyFilename, null) + "OUTPUT.accdb";
if (File.Exists(m_accdbFilename))
{
m_databaseName = m_accdbFilename;
}
else
{
m_databaseName = m_mdbFilename;
}
if (File.Exists(m_xyFilename))
{
StreamReader srr = File.OpenText(m_xyFilename);
string line1 = srr.ReadLine();
string[] line1Parts = line1.Split(' ');
m_xyFileVersion = new Version(line1Parts[1]);
srr.Close();
}
else
{
Logger.WriteLine("Error: File missing " + m_xyFilename);
}
ScenarioName = Path.GetFileNameWithoutExtension(m_xyFilename);
ExternalDataSource = true;
modsimName = ConnectionStringToken("ModsimName");
timeSeriesName = ConnectionStringToken("TimeSeriesName");
ReadOnly = true;
}
public UsgsRealTimeSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
var p = ConnectionStringUtility.GetToken(ConnectionString, "UsgsParameter", "");
m_parameter = (UsgsRealTimeParameter)Enum.Parse(typeof(UsgsRealTimeParameter), p);
m_site_no = ConnectionStringToken("site_no");
}
/// ctor used by PiscesFactory
public EnsembleSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
_timeseries_blobs_id = ConnectionStringUtility.GetIntFromConnectionString(ConnectionString, "timeseries_blobs.id");
_member_length = ConnectionStringUtility.GetIntFromConnectionString(ConnectionString, "member_length");
var strDate = ConnectionStringToken("timeseries_start_date", "");
_timeseries_start_date = DateTime.Parse(strDate);
_ensemble_member_index = ConnectionStringUtility.GetIntFromConnectionString(ConnectionString, "ensemble_member_index");
}
public MonthlySnowCourseSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.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);
Init();
}
public HydrometMonthlySeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
string str = ConnectionStringToken("server");
if (str.Trim() != "")
{
server = (HydrometHost)Enum.Parse(typeof(HydrometHost), str);
}
m_pcode = ConnectionStringToken("pcode");
m_cbtt = ConnectionStringToken("cbtt");
}
public HdbModelSeries(TimeSeriesDatabase db,
Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
ExternalDataSource = true;
ReadOnly = true;
m_table = ConnectionStringUtility.GetToken(ConnectionString, "m_table", "");
site_datatype_id = ConnectionStringUtility.GetToken(ConnectionString, "site_datatype_id", "-1");
model_run_id = ConnectionStringUtility.GetToken(ConnectionString, "model_run_id", "-1");
model_run_name = ConnectionStringUtility.GetToken(ConnectionString, "mode_run_name", "");
run_date = ConnectionStringUtility.GetToken(ConnectionString, "run_date", "");
hdb_host_name = ConnectionStringUtility.GetToken(ConnectionString, "hdb_host_name", "");
ScenarioName = BuildScenairoName(model_run_name, model_run_id, run_date);
Appearance.LegendText = SiteID + " " + Name;
}
public PiscesObject CreateObject(SeriesCatalogRow sr)
{
if (sr.IsFolder)
{
var v = new PiscesFolder(db, sr);
v.Icon = AssignIcon(sr.iconname);
return(v);
}
else
{
return(GetSeries(sr)); //11.53125 seconds elapsed.
//return GetSeries(sdi, db); //31.96875
}
//return new PiscesObject();
}
public PiscesObject CreateObject(SeriesCatalogRow sr)
{
PiscesObject rval = null;
if (sr.IsFolder == 1)
{
rval = new PiscesFolder(db, sr);
}
else
{
return(GetSeries(sr)); //11.53125 seconds elapsed.
}
// rval.Icon = AssignIcon(sr.iconname);
return(rval);
}
public HecDssSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
ExternalDataSource = true;
m_filename = ConnectionStringToken("FileName");
if (!Path.IsPathRooted(m_filename))
{
string dir = Path.GetDirectoryName(m_db.DataSource);
m_filename = Path.Combine(dir, m_filename);
}
m_dssPath = ConnectionStringToken("DssPath");
path = new HecDssPath(m_dssPath);
ReadOnly = true;
ScenarioName = Path.GetFileNameWithoutExtension(m_filename);
InitTimeSeries(null, this.Units, this.TimeInterval, this.ReadOnly, true, true);
Appearance.LegendText = Name;
}
public Cr10xSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
ExternalDataSource = true;
ReadOnly = true;
m_filename = ConnectionStringUtility.GetToken(ConnectionString, "FileName", "");
if (!Path.IsPathRooted(m_filename))
{
string dir = Path.GetDirectoryName(m_db.DataSource);
m_filename = Path.Combine(dir, m_filename);
}
m_interval = ConnectionStringToken("Interval");
m_columnNumber = Convert.ToInt32(ConnectionStringUtility.GetToken(ConnectionString, "ColumnNumber", ""));
InitTimeSeries(null, this.Units, this.TimeInterval, this.ReadOnly, false, true);
Appearance.LegendText = Name;
}
private int[] GetSelectedIndices(SelectionTypes t)
{
List <int> rval = new List <int>();
if (IsCommandLine)
{
return(rval.ToArray());
}
for (int i = 0; i < treeView1.SelectedNodes.Count; i++)
{
SeriesCatalogRow si = treeView1.SelectedNodes[i].Tag as SeriesCatalogRow;
if (t == SelectionTypes.Series && si.IsFolder == 0)
{
rval.Add(si.id);
}
if (t == SelectionTypes.Folder && si.IsFolder == 1)
{
rval.Add(si.id);
}
}
return(rval.ToArray());
}
public PiscesObject CreateObject(SeriesCatalogRow sr)
{
PiscesObject rval = null;
if (sr.IsFolder)
{
rval = new PiscesFolder(db, sr);
}
else if (sr.IsMeasurement)
{
rval = GetMeasurement(sr);
}
else if (sr.IsRatingTable)
{
rval = GetRatingTable(sr);
}
else
{
return(GetSeries(sr)); //11.53125 seconds elapsed.
}
rval.Icon = AssignIcon(sr.iconname);
return(rval);
}
public Series GetSeries(int id)
{
SeriesCatalogRow si = db.GetSeriesRow(id);
return(GetSeries(si));
}
public UsgsGroundWaterLevelSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
m_site_no = ConnectionStringUtility.GetToken(ConnectionString, "site_no", "");
}
public BasicRating GetRatingTable(SeriesCatalogRow sr)
{
var r = new BasicRating(db, sr);
return r;
}
public ExcelDataReaderSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
}
private void SaveStandaloneSeries(SeriesCatalogRow row,
Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.ScenarioRow sRow,
bool scenarios)
{
if (row.IsFolder == 0)
{
if (!m_server.TableExists(row.TableName + sRow.Name)) // table name is blank for MODSIM
{
Series s = Factory.GetSeries(row); // from RiverWare rdf (for example)
s.ScenarioName = sRow.Name;
s.Read();
// save to pisces database
var tn = s.Name;
if (sRow.Name != "")
{ tn += "_" + sRow.Name; }
s.SeriesCatalogRow.TableName = GetUniqueTableName(tn);
s.Table.TableName = s.SeriesCatalogRow.TableName;
row.Provider = "Series";
ImportTimeSeriesTable(s.Table, row, DatabaseSaveOptions.Insert);
}
else // may be Hydromet data with existing data
{
row.Provider = "Series";
}
}
}
///// <summary>
///// Creates or returns folder named 'missing'
///// for importing data not defined.
///// </summary>
///// <returns></returns>
//private int GetOrCreateFoldera(string name)
//{
// var tbl = GetSeriesCatalog("name = '"+name+"'");
// if (tbl.Rows.Count == 1)
// {
// return Convert.ToInt32(tbl.Rows[0]["name"]);
// }
// return -1;
//}
private void SaveSeriesRow(SeriesCatalogRow si)
{
m_server.SaveTable(si.Table);
}
/// <summary>
/// Imports DataTable to the Database
/// </summary>
private int ImportTimeSeriesTable(DataTable table, SeriesCatalogRow sr,
DatabaseSaveOptions option)
{
// Performance perf = new Performance();
table.Columns[0].ColumnName = "datetime";
table.Columns[1].ColumnName = "value";
// table.Columns[2].ColumnName = "flag";
table.TableName = sr.TableName;
if (table.Columns.Count == 2)
{
table.Columns.Add("flag");
table.Columns["flag"].DefaultValue = "";
}
if (m_tableNames.Count == 0) // table name cache speed up of 17%
{
m_tableNames.AddRange(m_server.TableNames());
}
if( m_tableNames.IndexOf(table.TableName) <0 )
{
CreateSeriesTable(sr.TableName, true);
m_tableNames.Add(sr.TableName);
}
int count = 0;
if( option == DatabaseSaveOptions.Upsert)
{
try
{
count = m_server.InsertTable(table);
}catch (Exception eprimary)
{
Logger.WriteLine("Error: insert did not work.. deleting existing data first "+eprimary.Message);
DeleteExistingData(table);
count = m_server.InsertTable(table);
}
}
else
if (option == DatabaseSaveOptions.UpdateExisting)
{
//count = InsertOrUpdate(table, si.FileIndex);
DeleteExistingData(table);
count = m_server.InsertTable(table);
}
else
if (option == DatabaseSaveOptions.DeleteAllExisting)
{
Truncate(sr.id);
count = m_server.InsertTable(table);
}
else if (option == DatabaseSaveOptions.Insert)
{
count = m_server.InsertTable(table);
}
else if (option == DatabaseSaveOptions.Save)
{
count = m_server.SaveTable(table);
}
string por = "";
if( table.Rows.Count > 0)
{
por = "("+table.Rows[0][0].ToString()+", "+table.Rows[table.Rows.Count-1][0].ToString()+")";
}
Logger.WriteLine("TimeSeriesDatabase: Saved " + count + " records "+ table.TableName+" "+por);
return count;
}
public BpaHydsimSeriesAccess(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
ExternalDataSource = true;
Init(db);
}
public BasicRating GetRatingTable(SeriesCatalogRow sr)
{
var r = new BasicRating(db, sr);
return(r);
}
public BasicMeasurement GetMeasurement(SeriesCatalogRow sr)
{
BasicMeasurement bm = new BasicMeasurement(db, sr);
return(bm);
}
public TextSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
}
public BasicMeasurement GetMeasurement(SeriesCatalogRow sr)
{
BasicMeasurement bm = new BasicMeasurement(db, sr);
return bm;
}
///// <summary>
///// Creates AccessSeries
///// </summary>
//public AccessSeries(int sdi, TimeSeriesDatabase db)
// : base(sdi, db)
//{
// SetupLocals();
//}
public AccessSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
SetupLocals();
}
public SpreadsheetGearSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
}
public HydrossSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
ExternalDataSource = true;
Init(db);
}
public PiscesObject CreateObject(SeriesCatalogRow sr)
{
PiscesObject rval = null;
if (sr.IsFolder == 1)
{
rval = new PiscesFolder(db, sr);
}
else if( sr.IsMeasurement)
{
rval = GetMeasurement(sr);
}
else if( sr.IsRatingTable)
{
rval = GetRatingTable(sr);
}
else
{
return GetSeries(sr); //11.53125 seconds elapsed.
}
rval.Icon = AssignIcon(sr.iconname);
return rval;
}
