public static void CompareLinuxToVMSCGI(string payload,TimeInterval interval= TimeInterval.Irregular)
{
//Program.Main(new string[] { "--cgi=instant", "--payload=?"+payload });
TimeSeriesDatabase db = TimeSeriesDatabase.InitDatabase(new Arguments(new string[]{}));
WebTimeSeriesWriter c = new WebTimeSeriesWriter(db,interval,payload);
var fn = FileUtility.GetTempFileName(".txt");
Console.WriteLine("linux temp file:"+fn);
c.Run(fn);
TextFile tf = new TextFile(fn);
tf.DeleteLines(0, 1);
var fnhyd0 = FileUtility.GetTempFileName(".txt");
Console.WriteLine("vms temp file:" + fnhyd0);
string url = "https://www.usbr.gov/pn-bin/webarccsv.pl?";
if( interval == TimeInterval.Irregular || interval == TimeInterval.Hourly)
url = "https://www.usbr.gov/pn-bin/webdaycsv.pl?";
Web.GetFile(url + payload, fnhyd0);
var tf2 = new TextFile(fnhyd0);
if (!CompareHydrometData(tf, tf2))
{
// do detailed comparision.
var diff = TextFile.Compare(tf, tf2);
if (diff.Length > 0)
{
for (int i = 0; i < tf.Length; i++)
{
Console.WriteLine(tf[i]);
}
}
Assert.IsTrue(diff.Length == 0);
}
}
private static string RunTest(string payload, TimeInterval interval)
{
Performance p = new Performance();
TimeSeriesDatabase db = TimeSeriesDatabase.InitDatabase(new Arguments(new string[] { }));
WebTimeSeriesWriter c = new WebTimeSeriesWriter(db,interval,payload);
var fn = FileUtility.GetTempFileName(".txt");
c.Run(fn);
if (File.Exists(fn))
p.Report(File.ReadAllLines(fn).Length + " lines read");
else
p.Report();
return fn;
}
/// <summary>
/// Examples:
///
/// --cgi=sites --propertyFilter=program:agrimet --json_required_properties=json_extra
/// --cgi=instant
/// </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|series|instant|daily|wyreport", 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);
}
}