public override Series CreateScenario(TimeSeriesDatabaseDataSet.ScenarioRow scenario)
{
//string s = ConfigurationManager.AppSettings["scenarioList"];
string fn = this.m_filename; // TO DO..update scenarioNumber if needed
if (m_scenarioNumber >= 0 && m_db != null)
{
int idx = Array.IndexOf(m_db.GetScenarios().GetNames(), scenario.Name);
m_scenarioNumber = idx + 1;
}
else
{
string path = Path.GetDirectoryName(m_filename);
fn = Path.Combine(path, scenario.Name + ".rdf");
Logger.WriteLine("Reading series from " + fn);
if (!File.Exists(fn))
{
Logger.WriteLine("Error: Can't create scenario '" + scenario.Name + "'");
return(new Series());
}
}
var rval = new RiverWareSeries(fn, m_objectName, m_slotName, m_scenarioNumber, m_isSnapShot);
rval.Appearance.LegendText = scenario.Name + " " + Name;
rval.ScenarioName = scenario.Name;
return(rval);
}
/// <summary>
/// Create series based on Scenario
/// Multiple Runs can be in the same file (Specified by Path.ScenarioNumber)
/// or Multiple Runs each in different file (Path.FileName)
/// or scenario can be by the Name
/// examples: https://github.com/usbr/Pisces/issues/161
/// </summary>
/// <param name="scenario"></param>
/// <returns></returns>
public override Series CreateScenario(TimeSeriesDatabaseDataSet.ScenarioRow scenario)
{
var fn = GetScenarioFileName(scenario);
int sn = GetScenarioNumber(scenario);
if (!File.Exists(fn))
{
Logger.WriteLine("Error: Can't create scenario '" + scenario.Name + "'");
return(new Series());
}
var rval = new RiverWareSeries(fn, m_objectName, m_slotName, sn, m_isSnapShot);
rval.Appearance.LegendText = scenario.Name + " " + Name;
rval.ScenarioName = scenario.Name;
return(rval);
}
/**********************************
*
* Create a tree file that is usable by pisces
*
* input : riverware rdf file
* output : comma seperated tree file.
*
*
* // example portion of input file.
* (this input file is using snapshots in riverware)
* -----------------------------------
* object_type: SnapShotObj
* object_name: Most Likely 2
* slot_name: Andrews Gage 12447390 at RM 3_5_Gage Outflow
* END_SLOT_PREAMBLE
* units: cfs
*
* // example output. There is no nesting of tree levels for now.
* RiverwareName,Description,RiverwareDataType,Level,Units
* Riverware Results,,,0,
* Yakima River at Parker PARW,Yakima River at Parker PARW,Gage Outflow,1,cfs
* Yakima River at Grandview,Yakima River at Grandview,Gage Inflow,1,cfs
* ...
*
**********************************/
public static void AddRiverWareFileToDatabase(string rdfFilename, PiscesFolder parent,
TimeSeriesDatabase db)
{
Reclamation.Core.TextFile tf = new Reclamation.Core.TextFile(rdfFilename);
#region notes
/*
* SnapShotStyle...
* -------------------------------------
* 2001-9-29 24:00
* 2001-9-30 24:00
* object_type: SnapShotObj
* object_name: Most Likely 2 ### scernario name
* slot_name: Andrews Gage 12447390 at RM 3_5_Gage Outflow # object_name slotName are combined.
* END_SLOT_PREAMBLE
* units: cfs
*
* Regular Style ...
* ---------------------------------------
* END_COLUMN
* END_SLOT
* object_type: StreamGage
* object_name: Yakima 202_0 at Easton EASW
* slot_name: Gage Outflow
* END_SLOT_PREAMBLE
* units: cfs
* scale: 1
*
*/
#endregion
int number_of_runs = LookupNumberOfRuns(tf);
PiscesFolder folder = parent;
if (number_of_runs == 1)
{
folder = db.AddFolder(parent, Path.GetFileNameWithoutExtension(rdfFilename));
}
int sz = tf.Length;
// object_type and object_name should occur on consecutive lines.
int index = tf.IndexOfBoth("object_name:", "slot_name:", 0);
var objectList = new List <string>(); //list to avoid duplicates in tree
Performance p1 = new Performance();
Performance p2 = new Performance();
p2.Pause();
int counter = 0;
db.SuspendTreeUpdates();
var sc = db.GetSeriesCatalog();
Dictionary <string, int> objTypeID = new Dictionary <string, int>();
Dictionary <string, int> objNameID = new Dictionary <string, int>();
while (index < sz && index > 0)
{
//slot_name: Andrews Gage 12447390 at RM 3_5_Gage Outflow
string slot_name = tf[index + 1].Substring(11); //Andrews Gage 12447390 at RM 3_5_Gage Outflow
string object_type = tf[index - 1].Substring(13);
string object_name = tf[index].Substring(13);
string units = tf[index + 3].Substring(6).Trim();
string tag = object_name + ":" + slot_name;
if (!objectList.Contains(tag))
{
int scenarioNumber = -1;
if (number_of_runs > 1)
{
scenarioNumber = 1;
}
RiverWareSeries s;
if (object_type == "SnapShotObj")
{
s = new RiverWareSeries(rdfFilename, "", slot_name, scenarioNumber, true, units);
}
else
{
s = new RiverWareSeries(rdfFilename, object_name, slot_name, scenarioNumber, false, units);
}
s.Units = units;
s.ConnectionString = ConnectionStringUtility.MakeFileNameRelative(s.ConnectionString, db.DataSource);
p2.Continue();
if (object_type.Contains("Reservoir"))
{
object_type = "Reservoir";
}
else if (object_type.Contains("Reach"))
{
object_type = "Reach";
}
else if (object_type.Contains("Diversion"))
{
object_type = "Diversion";
}
else if (object_type.Contains("Canal"))
{
object_type = "Canal";
}
int id = sc.NextID();
if (!sc.FolderExists(object_type, folder.ID))
{
objTypeID.Add(object_type, id);
sc.AddFolder(object_type, id, folder.ID);
id++;
}
if (!sc.FolderExists(object_name, objTypeID[object_type]))
{
objNameID.Add(object_name, id);
sc.AddFolder(object_name, id, objTypeID[object_type]);
id++;
}
sc.AddSeriesCatalogRow(s, id, objNameID[object_name], "");
objectList.Add(tag);
}
index = tf.IndexOfBoth("object_name:", "slot_name:", index + 2);
counter++;
}
p1.Report("total");
p2.Report("db.add()");
//398.7732813 seconds elapsed. total
//384.6792607 seconds elapsed. db.add()
// disable tree refresh (doubles perf)
// 255.9736646 seconds elapsed. total
// 241.7702669 seconds elapsed. db.add()
// implemented member ExternalDataSource
//34.8756696 seconds elapsed. total
//20.3753912 seconds elapsed. db.add()
var convention = Reclamation.TimeSeries.RiverWare.ImportRiverWare.ScenarioConvention.Default;
if (number_of_runs > 1) // Multiple runs.
{ // show dialog to allow water year naming or traces
var dlg = new Reclamation.TimeSeries.RiverWare.ImportRiverWare();
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
convention = dlg.NamingConvention;
}
// Add Scenarios.
var tblScen = db.GetScenarios();
for (int i = 0; i < number_of_runs; i++)
{
string name = "Run" + i;
if (convention == RiverWare.ImportRiverWare.ScenarioConvention.ByYear)
{
name = (dlg.FirstYear + i).ToString();
}
//string scenarioPath = ConnectionStringUtility.MakeFileNameRelative("FileName=" + item, DB.Filename);
tblScen.AddScenarioRow(name, true, "ScenarioNumber=" + (i + 1).ToString());
}
db.Server.SaveTable(tblScen);
}
db.Server.SaveTable(sc);
db.ResumeTreeUpdates();
db.RefreshFolder(parent);
}