public ContentResult Get()
{
int start = GetInt(Request, "start", 0);
int end = GetInt(Request, "end", 0);
var site = GetStr(Request, "site");
var parameter = GetStr(Request, "parameter");
var format = GetStr(Request, "format", "usgs-html");
var db = Database.GetTimeSeriesDatabase();
WaterYearReport r = new WaterYearReport(db, site, parameter, start, end, format);
var x = r.Run();
Response.ContentType = "text/plain";
if (format == "usgs-html")
{
Response.ContentType = "Content-type: text/html";
}
if (format == "csv-analysis")
{
Response.ContentType = "Content-type: text/csv";
}
//var pre = "";
//if (format == "usgs-html")
// pre = "<html>;"
return(Content(x));
}
/// <summary>
/// Examples:
///
/// --cgi=sites --propertyFilter=program:agrimet --json_required_properties=json_extra
/// </summary>
/// <param name="args"></param>
public static void Main(string[] args)
{
var siteType = ""; // agrimet, hydromet (blank means all)
var cgi = "";
var json_property_stubs = "";
var payload = "";
var p = new OptionSet();
var format = "json";
var verbose = false;
bool selfHost = false;
var sqLiteDatabaseFileName = "";
p.Add("server", x => selfHost = true);
p.Add("cgi=", "required cgi to execute cgi=sites or cgi=series", x => cgi = x);
p.Add("json_property_stubs=", "comma separated list of properties (i.e. 'region,url,') to created empty stubs if neeed ",
x => json_property_stubs = x);
p.Add("site-type=", "filter agrimet sites", x => siteType = BasicDBServer.SafeSqlLikeClauseLiteral(x));
p.Add("payload=", "test query data for a CGI", x => payload = x);
p.Add("format=", "format json(default) | csv ", x => format = x);
p.Add("verbose", " get more details", x => verbose = true);
p.Add("database", "filename for SQLite database", x => sqLiteDatabaseFileName = x);
try
{
p.Parse(args);
}
catch (OptionException e)
{
Console.WriteLine(e.Message);
return;
}
Database.InitDB(args);
var db = Database.DB();
if (selfHost)
{
try
{
var serverUri = "http://localhost:8080";
var cfg = new HostConfiguration();
//cfg.RewriteLocalhost = false;
//c..fg.UrlReservations.CreateAutomatically=true;
var host = new Nancy.Hosting.Self.NancyHost(cfg, new Uri(serverUri));
//var host = new Nancy.Hosting.Self.NancyHost();
using (host)
{
host.Start();
Console.WriteLine("Running on " + serverUri);
Console.ReadLine();
}
}
catch (Exception nancyEx)
{
Console.WriteLine(nancyEx.Message);
}
return;
}
if (cgi == "")
{
ShowHelp(p);
return;
}
if (verbose)
{
Console.Write("Content-type: text/html\n\n");
Logger.EnableLogger();
Logger.WriteLine("verbose=true");
Logger.WriteLine("payload = " + payload);
}
if (cgi == "inventory")
{
Console.Write("Content-Type: text/html\n\n");
db.Inventory();
}
else if (cgi == "sites")
{
if (format == "json")
{
JSONSites d = new JSONSites(db);
d.Execute(json_property_stubs.Split(','), siteType);
}
else if (format == "csv")
{
SiteCsvTable c = new SiteCsvTable(db);
c.Execute(siteType);
}
}
else if (cgi == "instant" || cgi == "daily")
{
try
{
WebTimeSeriesWriter c = null;
if (cgi == "instant")
{
c = new WebTimeSeriesWriter(db, TimeInterval.Irregular, payload);
}
else
if (cgi == "daily")
{
c = new WebTimeSeriesWriter(db, TimeInterval.Daily, payload);
}
c.Run();
}
catch (Exception e)
{
Logger.WriteLine("Error: " + e.Message);
}
}
else if (cgi == "wyreport")
{
try
{
WaterYearReport wy = new WaterYearReport(db, payload);
wy.Run();
}
catch (Exception e)
{
Logger.WriteLine("Error: " + e.Message);
}
}
else if (cgi == "site")
{
SiteInfoCGI si = new SiteInfoCGI(db);
si.Run(payload);
}
else if (cgi == "test-perf-large")
{
var c = new HydrometGCITests();
c.CGI_PerfTestLarge();
}
else if (cgi == "test-perf-small")
{
var c = new HydrometGCITests();
c.CGI_PerfTestSmall();
}
else if (cgi == "dump")
{
var c = new HydrometGCITests();
c.DumpTest();
}
else
{
Console.WriteLine("invalid cgi: " + cgi);
}
}
/// <summary>
/// PiscesWebServices contains several CGI programs in support
/// of migrating from the Legacy Hydromet System.
/// Longer term the PiscesAPI (.net core) project can replace this program
/// </summary>
/// <param name="args"></param>
public static void Main(string[] args)
{
var siteType = ""; // agrimet, hydromet (blank means all)
var cgi = "";
var json_property_stubs = "";
var payload = "";
var p = new OptionSet();
var format = "json";
var verbose = false;
p.Add("cgi=", "required cgi to execute cgi=help|sites|series|instant|daily|monthly|wyreport|inventory", x => cgi = x);
p.Add("json_property_stubs=", "comma separated list of properties (i.e. 'region,url,') to created empty stubs if neeed ",
x => json_property_stubs = x);
p.Add("site-type=", "filter agrimet sites", x => siteType = BasicDBServer.SafeSqlLikeClauseLiteral(x));
p.Add("payload=", "test query data for a CGI", x => payload = System.Uri.EscapeDataString(x));
p.Add("format=", "format json(default) | csv ", x => format = x);
p.Add("verbose", " get more details", x => verbose = true);
p.Add("debug", " get more details", x => verbose = true);
try
{
p.Parse(args);
}
catch (OptionException e)
{
Console.WriteLine(e.Message);
return;
}
Database.InitDB(args);
var db = Database.DB();
if (cgi == "")
{
ShowHelp(p);
return;
}
if (verbose)
{
Console.Write("Content-type: text/html\n\n");
Logger.EnableLogger();
var ev = Environment.GetEnvironmentVariables();
foreach (DictionaryEntry item in ev)
{
Console.WriteLine(item.Key + ": " + item.Value + "<br/>");
}
Logger.WriteLine("verbose=true");
Logger.WriteLine("payload = " + payload);
}
if (cgi == "help")
{
if (!verbose)
{
Console.Write("Content-type: text/html\n\n");
}
Help.Print();
return;
}
if (cgi == "inventory")
{
try
{
InventoryReport r = new InventoryReport(db, payload);
r.Run();
}
catch (Exception e)
{
Logger.WriteLine(e.Message);
}
}
else if (cgi == "sites")
{
if (format == "json")
{
JSONSites d = new JSONSites(db);
d.Execute(json_property_stubs.Split(','), siteType);
}
else if (format == "csv")
{
SiteCsvTable c = new SiteCsvTable(db);
c.Execute(siteType);
}
else if (format == "test")
{
SiteCsvTable c = new SiteCsvTable(db);
c.Execute(siteType, "jck");
}
}
else if (cgi == "instant" || cgi == "daily" || cgi == "monthly")
{
try
{
WebTimeSeriesWriter c = null;
if (cgi == "instant")
{
c = new WebTimeSeriesWriter(db, TimeInterval.Irregular, payload);
}
else
if (cgi == "daily")
{
c = new WebTimeSeriesWriter(db, TimeInterval.Daily, payload);
}
if (cgi == "monthly")
{
c = new WebTimeSeriesWriter(db, TimeInterval.Monthly, payload);
}
c.Run();
}
catch (Exception e)
{
Logger.WriteLine("Error: " + e.Message);
}
}
else if (cgi == "wyreport")
{
try
{
WaterYearReport wy = new WaterYearReport(db, payload);
wy.Run();
}
catch (Exception e)
{
Logger.WriteLine("Error: " + e.Message);
}
}
else if (cgi == "site")
{
SiteInfoCGI si = new SiteInfoCGI(db);
si.Run(payload);
}
else
{
Console.WriteLine("invalid cgi: " + cgi);
}
}