/// <summary> /// The command Prompt for Pisces /// </summary> public void PiscesPrompt() { var input = new CommandLineInput(m_interval); do { Console.Write(">"); var s = Console.ReadLine(); if (s.Trim() == "") { continue; } input.Read(s); if (input.Parameters.Length == 0 && input.SiteList.Length == 1) // get all parameters in database { input.Parameters = GetAllParametersForSiteID(input.SiteList[0], m_interval, input.Command == Command.GetQ); } if (input.Command == Command.Exit) { break; } if (!input.Valid) { Console.WriteLine("Error: Invalid Input"); continue; } if (input.Command == Command.Help) { Help(); } if (input.Command == Command.Get || input.Command == Command.GetQ) { if (input.SiteList.Length == 0) { Console.WriteLine("site is required"); continue; } Print(input, m_interval); } if (input.Command == Command.Date) { Console.WriteLine(input.T1.ToString("yyyy-MM-dd")); } //Console.WriteLine("cmd = " + input.Command); //Console.WriteLine("sites = " + String.Join(",", input.SiteList)); //Console.WriteLine("parameters = " + String.Join(",", input.Parameters)); } while (true); }
public void PiscesPrompt() { var input = new CommandLineInput(); do { Console.Write("pisces>"); var s = Console.ReadLine(); if (s.Trim() == "") { continue; } input.Read(s); if (!input.Valid) { Console.WriteLine("Error: Invalid Input"); continue; } if (input.Command == Command.Exit) { break; } if (input.Command == Command.Help) { Help(); } if (input.Command == Command.Get) { if (input.SiteList.Length == 0) { Console.WriteLine("site is required"); continue; } Print(input, TimeInterval.Irregular); } Console.WriteLine("cmd = " + input.Command); Console.WriteLine("sites = " + String.Join(",", input.SiteList)); Console.WriteLine("parameters = " + String.Join(",", input.Parameters)); } while (true); }
/// <summary> /// /// </summary> /// <param name="input"></param> command line input /// <param name="interval"></param> time interval private void Print(CommandLineInput input, TimeInterval interval) { var list = CreateSeriesList(input, interval); //SeriesListDataTable sTable = new SeriesListDataTable(list, interval); //int counter = 0; list.Read(input.T1, input.T2);// example for read input if (interval == TimeInterval.Daily) { PrintDaily(list); } else { PrintInstant(list); } }
private void Print(CommandLineInput input, TimeInterval interval) { var list = CreateSeriesList(input, interval); //SeriesListDataTable sTable = new SeriesListDataTable(list, interval); int counter = 0; foreach (var s in list) { s.Read(input.T1, input.T2); if (s.Count <= 0) { continue; } var pt = s[s.Count - 1]; if (counter == 0)// print header { Console.Write(s.SiteID + " " + pt.DateTime.ToString("MMM dd hh:mm ")); } Console.Write("# " + pt.Value.ToString("F2")); counter++; } }
/// <summary> /// Create a Series List /// </summary> /// <param name="input"></param> input from the command line /// <param name="interval"></param> time interval /// <returns></returns> private SeriesList CreateSeriesList(CommandLineInput input, TimeInterval interval) { List <TimeSeriesName> names = new List <TimeSeriesName>(); foreach (var cbtt in input.SiteList) { foreach (var pcode in input.Parameters) { string sInterval = TimeSeriesName.GetTimeIntervalForTableName(interval); TimeSeriesName tn = new TimeSeriesName(cbtt + "_" + pcode, sInterval); names.Add(tn); } } var tableNames = (from n in names select n.GetTableName()).ToArray(); var sc = m_db.GetSeriesCatalog("tablename in ('" + String.Join("','", tableNames) + "')"); SeriesList sList = new SeriesList(); foreach (var tn in names) { Series s = new Series(); s.TimeInterval = interval; if (sc.Select("tablename = '" + tn.GetTableName() + "'").Length == 1) { s = m_db.GetSeriesFromTableName(tn.GetTableName()); } s.Table.TableName = tn.GetTableName(); sList.Add(s); } return(sList); }