public RemoteFetchData FetchData(string databaseName, long startTimeTick, long endTimeTick, string consolFunctionName, long resolution)
{
RrdDb database = null;
try
{
log.DebugFormat("Read data from {0}", databaseName);
var nameValueCollection = (NameValueCollection)ConfigurationManager.GetSection("rrdbfileserver");
string dataBasePath = nameValueCollection["databasepath"];
log.DebugFormat("Database path:{0}", dataBasePath + databaseName);
database = new RrdDb(dataBasePath + databaseName, true);
FetchRequest fetchRequest = new FetchRequest(null, consolFunctionName, startTimeTick, endTimeTick, resolution);
FetchData data = database.fetchData(fetchRequest);
database.close();
RemoteFetchData remoteData = new RemoteFetchData();
remoteData.Timestamps = data.getTimestamps();
remoteData.Values = data.getValues();
remoteData.ArchiveEndTimeTicks = data.getArcEndTime();
remoteData.ArchiveSteps = data.getArcStep();
remoteData.DatasourceNames = data.getDsNames();
if (debugEnabled)
{
log.DebugFormat("Read data from {0} to {1}.", rrd4n.Common.Util.getDate(startTimeTick), rrd4n.Common.Util.getDate(endTimeTick));
}
return(remoteData);
}
catch (Exception ex)
{
log.Error("Fetchdata exception", ex);
throw;
}
finally
{
if (database != null)
{
database.close();
}
}
}
public rrd4n.DataAccess.Data.FetchData GetData(rrd4n.DataAccess.Data.FetchRequest request)
{
RrdDb rrdDb = null;
try
{
string dataPath;
if (DataPath.Contains("${APPDATA}"))
{
dataPath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
dataPath += DataPath.Substring(10);
}
else
{
dataPath = DataPath;
}
rrdDb = new RrdDb(dataPath + request.DatabasePath);
FetchRequest coreRequest = new FetchRequest(rrdDb.getPath(), request.ConsolidateFunctionName, request.FetchStart, request.FetchEnd, request.Resolution);
FetchData coreFetchData = rrdDb.fetchData(coreRequest);
return(new rrd4n.DataAccess.Data.FetchData(coreFetchData.getArcStep(), coreFetchData.getArcEndTime(), coreFetchData.getDsNames())
{
Values = coreFetchData.getValues(),
Timestamps = coreFetchData.getTimestamps()
});
}
finally
{
if (rrdDb != null)
{
rrdDb.close();
}
}
}
static void Main(string[] args)
{
DateTime EPOC = new DateTime(1970, 01, 1);
long startTimeInSeconds = 920804400;
DateTime startTime = EPOC.AddSeconds(startTimeInSeconds);
long endTimeInSeconds = 920808000;
string rrdPath = @"net_test.rrd";
String imgPath = @"net_test.png";
Console.WriteLine("== Starting demo");
RrdDb rrdDb;
FetchRequest request;
FetchData fetchData;
//List<FetchedData> unified = ReadAndUnifyData(@"C:\Development\CS_Project\rrd4n\RrDbTest\el.csv",
// new TimeSpan(0, 10, 0));
bool createDb = true;
if (createDb)
{
rrdDb = BuildRRd(rrdPath, startTime);
Console.WriteLine(rrdDb.dump());
rrdDb.close();
//rrdDb = new RrdDb(rrdPath, false);
int[] values = new int[] {
12345, 12357, 12363, 12363, 12363, 12373, 12383, 12393, 12399, 12405, 12411, 12415, 12420, 12422, 12423
};
//rrdtool update net_test.rrd 920804700:12345 920805000:12357 920805300:12363
//rrdtool update net_test.rrd 920805600:12363 920805900:12363 920806200:12373
//rrdtool update net_test.rrd 920806500:12383 920806800:12393 920807100:12399
//rrdtool update net_test.rrd 920807400:12405 920807700:12411 920808000:12415
//rrdtool update net_test.rrd 920808300:12420 920808600:12422 920808900:12423
for (int i = 0; i < 15; i++)
{
UpdateRRd(rrdPath, 920804700 + (i * 300), "speed", values[i]);
}
//rrdDb.close();
// Read back test
rrdDb = new RrdDb(rrdPath, true);
Console.WriteLine("File reopen in read-only mode");
Console.WriteLine("== Last update time was: " + rrdDb.getLastUpdateTime());
Console.WriteLine("== Last info was: " + rrdDb.getInfo());
// fetch data
Console.WriteLine("== Fetching data");
request = rrdDb.createFetchRequest(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), startTimeInSeconds, endTimeInSeconds);
Console.WriteLine(request.dump());
fetchData = rrdDb.fetchData(request);
Console.WriteLine("== Data fetched. " + fetchData.getRowCount() + " points obtained");
Console.WriteLine(fetchData.toString());
Console.WriteLine("== Fetch completed");
}
DateTime startDateTime = rrd4n.Common.Util.getDate(920804400);
DateTime endDateTime = rrd4n.Common.Util.getDate(920808000);
GraphParser parser = new GraphParser("net_speed_1.png --start \"" + startDateTime.ToString() + "\" --end \"" + endDateTime.ToString() + "\" --imgformat PNG DEF:myspeed=" + rrdPath + ":speed:AVERAGE LINE2:myspeed#FF0000");
RrdGraphDef gDef_1 = parser.CreateGraphDef();
RrdDbAccessInterface rrdDbAccess = container["databaseaccessor.local"] as RrdDbAccessInterface;
RrdGraph graph_1 = new RrdGraph(gDef_1, rrdDbAccess);
// Create graph
// rrdtool graph net_speed.png --start 920804400 --end 920808000
// DEF:myspeed=net_test.rrd:speed:AVERAGE
// LINE2:myspeed#FF0000
// --font "DEFAULT:0:C:\Windows\fonts\cour.ttf"
Console.WriteLine("Creating graph ");
RrdGraphDef gDef = new RrdGraphDef();
gDef.setWidth(IMG_WIDTH);
gDef.setHeight(IMG_HEIGHT);
gDef.setFilename(imgPath);
gDef.setStartTime(startTimeInSeconds);
gDef.setEndTime(endTimeInSeconds);
gDef.setTitle("Speed");
// gDef.setVerticalLabel("temperature");
gDef.datasource("myspeed", rrdPath, "speed", new rrd4n.Common.ConsolFun(rrd4n.Common.ConsolFun.ConsolFunTypes.AVERAGE));
gDef.line("myspeed", Color.Red, "My sPeedj", 2);
gDef.hrule(0.02, Color.Red, "Maximum 200", 3);
// gDef.print("shade", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), "avgShade = %.3f%S\\r");
// gDef.setImageInfo("<img src='%s' width='%d' height = '%d'>");
gDef.setPoolUsed(false);
gDef.setImageFormat("png");
//Console.WriteLine("Rendering graph " + rrd4n.Common.Util.getLapTime());
// create graph finally
RrdGraph graph = new RrdGraph(gDef, rrdDbAccess);
// Create bar chart test graph
//rrdtool graph speed3.png --start 920804400 --end 920808000 --vertical-label km/h DEF:myspeed=test.rrd:speed:AVERAGE "CDEF:kmh=myspeed,3600,*" CDEF:fast=kmh,100,GT,kmh,0,IF CDEF:good=kmh,100,GT,0,kmh,IF HRULE:100#0000FF:"Maximum allowed" AREA:good#00FF00:"Good speed" AREA:fast#FF0000:"Too fast" --font "DEFAULT:0:C:\Windows\fonts\cour.ttf"
imgPath = @"net_test_bar.png";
Console.WriteLine("Creating bar graph ");
gDef = new RrdGraphDef();
gDef.setWidth(IMG_WIDTH);
gDef.setHeight(IMG_HEIGHT);
gDef.setFilename(imgPath);
gDef.setStartTime(startTimeInSeconds);
gDef.setEndTime(endTimeInSeconds + 900);
gDef.setTitle("Speed");
gDef.setVerticalLabel("km/h");
//DEF:myspeed=test.rrd:speed:AVERAGE
gDef.datasource("myspeed", rrdPath, "speed", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE));
//"CDEF:kmh=myspeed,3600,*"
gDef.datasource("kmh", "myspeed,3600,*");
//CDEF:fast=kmh,100,GT,kmh,0,IF
gDef.datasource("fast", "kmh,100,GT,kmh,0,IF");
//CDEF:good=kmh,100,GT,0,kmh,IF HRULE:100#0000FF:"Maximum allowed" AREA:good#00FF00:"Good speed" AREA:fast#FF0000:"Too fast"
gDef.datasource("good", "kmh,100,GT,0,kmh,IF");
//HRULE:100#0000FF:"Maximum allowed"
gDef.hrule(100, Color.Red, "Maximum allowed", 3);
gDef.hrule(200, Color.Red, "Maximum 200", 3);
// AREA:good#00FF00:"Good speed"
gDef.area("good", Color.Green, "Good speed");
// AREA:fast#FF0000:"Too fast"
gDef.area("fast", Color.Red, "Too fast");
gDef.setPoolUsed(false);
gDef.setImageFormat("png");
//Console.WriteLine("Rendering graph " + Util.getLapTime());
// create graph finally
graph = new RrdGraph(gDef, rrdDbAccess);
//rrdtool graph speed4.png --start 920804400 --end 920808000 --vertical-label km/h DEF:myspeed=test.rrd:speed:AVERAGE CDEF:nonans=myspeed,UN,0,myspeed,IF CDEF:kmh=nonans,3600,* CDEF:fast=kmh,100,GT,100,0,IF CDEF:over=kmh,100,GT,kmh,100,-,0,IF CDEF:good=kmh,100,GT,0,kmh,IF HRULE:100#0000FF:"Maximum allowed" AREA:good#00FF00:"Good speed" AREA:fast#550000:"Too fast" STACK:over#FF0000:"Over speed" --font "DEFAULT:0:C:\Windows\fonts\cour.ttf"
Console.WriteLine("Creating stack graph ");
imgPath = @"net_test_stack.png";
gDef = new RrdGraphDef();
gDef.setWidth(IMG_WIDTH);
gDef.setHeight(IMG_HEIGHT);
gDef.setFilename(imgPath);
gDef.setStartTime(startTimeInSeconds + 300);
gDef.setEndTime(endTimeInSeconds + 1200);
gDef.setTitle("Speed");
//--vertical-label km/h
gDef.setVerticalLabel("km/h");
// DEF:myspeed=test.rrd:speed:AVERAGE
gDef.datasource("myspeed", rrdPath, "speed", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE));
// CDEF:nonans=myspeed,UN,0,myspeed,IF
gDef.datasource("nonans", "myspeed,UN,0,myspeed,IF");
//CDEF:kmh=nonans,3600,*
gDef.datasource("kmh", "nonans,3600,*");
//CDEF:fast=kmh,100,GT,100,0,IF
gDef.datasource("fast", "kmh,100,GT,100,0,IF");
//CDEF:over=kmh,100,GT,kmh,100,-,0,IF
gDef.datasource("over", "kmh,100,GT,kmh,100,-,0,IF");
//CDEF:good=kmh,100,GT,0,kmh,IF
gDef.datasource("good", "kmh,100,GT,0,kmh,IF");
//HRULE:100#0000FF:"Maximum allowed"
gDef.hrule(100, Color.Blue, "Maximum allowed", 3);
// AREA:good#00FF00:"Good speed"
gDef.area("good", Color.Green, "Good speed");
// AREA:fast#550000:"Too fast"
gDef.area("fast", Color.Black, "Too fast");
//STACK:over#FF0000:"Over speed"
gDef.stack("over", Color.Red, "Over speed");
gDef.setPoolUsed(false);
gDef.setImageFormat("png");
//Console.WriteLine("Rendering graph " + Util.getLapTime());
// create graph finally
graph = new RrdGraph(gDef, rrdDbAccess);
long startMillis = DateTime.Now.Millisecond;
return;
//if (args.Length > 0)
//{
// Console.WriteLine("Setting default backend factory to " + args[0]);
// RrdDb.setDefaultFactory(args[0]);
//}
//long start = START;
//long end = END;
////rrdPath = Util.getRrd4nDemoPath(FILE + ".rrd");
////String xmlPath = Util.getRrd4nDemoPath(FILE + ".xml");
////String rrdRestoredPath = Util.getRrd4nDemoPath(FILE + "_restored.rrd");
////imgPath = Util.getRrd4nDemoPath(FILE + ".png");
////String logPath = Util.getRrd4nDemoPath(FILE + ".log");
////PrintWriter log = new PrintWriter(new BufferedOutputStream(new FileOutputStream(logPath, false)));
//// creation
////Console.WriteLine("== Creating RRD file " + rrdPath);
////RrdDef rrdDef = new RrdDef(rrdPath, start - 1, 300);
////rrdDef.addDatasource("sun", new DsType(DsType.DsTypes.GAUGE), 600, 0, Double.NaN);
////rrdDef.addDatasource("shade", new DsType(DsType.DsTypes.GAUGE), 600, 0, Double.NaN);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), 0.5, 1, 600);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), 0.5, 6, 700);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), 0.5, 24, 775);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), 0.5, 288, 797);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.MAX), 0.5, 1, 600);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.MAX), 0.5, 6, 700);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.MAX), 0.5, 24, 775);
////rrdDef.addArchive(new ConsolFun(ConsolFun.ConsolFunTypes.MAX), 0.5, 288, 797);
////Console.WriteLine(rrdDef.dump());
//////log.Console.WriteLine(rrdDef.dump());
////Console.WriteLine("Estimated file size: " + rrdDef.getEstimatedSize());
////RrdDb rrdDb = new RrdDb(rrdDef);
////Console.WriteLine("== RRD file created.");
////if (rrdDb.getRrdDef().equals(rrdDef))
////{
//// Console.WriteLine("Checking RRD file structure... OK");
////}
////else
////{
//// Console.WriteLine("Invalid RRD file created. This is a serious bug, bailing out");
//// return;
////}
////rrdDb.close();
////Console.WriteLine("== RRD file closed.");
////// update database
////GaugeSource sunSource = new GaugeSource(1200, 20);
////GaugeSource shadeSource = new GaugeSource(300, 10);
////Console.WriteLine("== Simulating one month of RRD file updates with step not larger than " +
//// MAX_STEP + " seconds (* denotes 1000 updates)");
////long t = start;
////int n = 0;
////rrdDb = new RrdDb(rrdPath);
////Sample sample = rrdDb.createSample();
////while (t <= end + 86400L)
////{
//// sample.setTime(t);
//// sample.setValue("sun", sunSource.getValue());
//// sample.setValue("shade", shadeSource.getValue());
//// //log.Console.WriteLine(sample.dump());
//// sample.update();
//// t += (long)(RANDOM.NextDouble() * MAX_STEP) + 1;
//// if (((++n) % 1000) == 0)
//// {
//// Console.Write("*");
//// }
////}
////rrdDb.close();
////Console.WriteLine("");
////Console.WriteLine("== Finished. RRD file updated " + n + " times");
//// test read-only access!
//rrdDb = new RrdDb(rrdPath, true);
//Console.WriteLine("File reopen in read-only mode");
//Console.WriteLine("== Last update time was: " + rrdDb.getLastUpdateTime());
//Console.WriteLine("== Last info was: " + rrdDb.getInfo());
//// fetch data
//Console.WriteLine("== Fetching data for the whole month");
//request = rrdDb.createFetchRequest(new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), start, end);
//Console.WriteLine(request.dump());
//// log.Console.WriteLine(request.dump());
//fetchData = request.fetchData();
//Console.WriteLine("== Data fetched. " + fetchData.getRowCount() + " points obtained");
//Console.WriteLine(fetchData.toString());
//Console.WriteLine("== Dumping fetched data to XML format");
//// Console.WriteLine(fetchData.exportXml());
//Console.WriteLine("== Fetch completed");
//// dump to XML file
//Console.WriteLine("== Dumping RRD file to XML file " + xmlPath + " (can be restored with RRDTool)");
//// rrdDb.exportXml(xmlPath);
//Console.WriteLine("== Creating RRD file " + rrdRestoredPath + " from XML file " + xmlPath);
//// RrdDb rrdRestoredDb = new RrdDb(rrdRestoredPath, xmlPath);
//// close files
//Console.WriteLine("== Closing both RRD files");
//rrdDb.close();
//Console.WriteLine("== First file closed");
//// rrdRestoredDb.close();
//Console.WriteLine("== Second file closed");
//// create graph
//Console.WriteLine("Creating graph " + Util.getLapTime());
//Console.WriteLine("== Creating graph from the second file");
//gDef = new RrdGraphDef();
//gDef.setWidth(IMG_WIDTH);
//gDef.setHeight(IMG_HEIGHT);
//gDef.setFilename(imgPath);
//gDef.setStartTime(start);
//gDef.setEndTime(end);
//gDef.setTitle("Temperatures in May 2003");
//gDef.setVerticalLabel("temperature");
//gDef.datasource("sun", rrdPath/*rrdRestoredPath*/, "sun", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE));
//gDef.datasource("shade", rrdPath/*rrdRestoredPath*/, "shade", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE));
//gDef.datasource("median", "sun,shade,+,2,/");
//gDef.datasource("diff", "sun,shade,-,ABS,-1,*");
//gDef.datasource("sine", "TIME," + start + ",-," + (end - start) +
// ",/,2,PI,*,*,SIN,1000,*");
//gDef.line("sun", Color.Green, "sun temp");
//gDef.line("shade", Color.Blue, "shade temp");
//gDef.line("median", Color.Magenta, "median value");
//gDef.area("diff", Color.Yellow, "difference\\r");
//gDef.line("diff", Color.Red, null);
//gDef.line("sine", Color.Cyan, "sine function demo\\r");
//gDef.hrule(2568, Color.Green, "hrule");
//gDef.vrule((start + 2 * end) / 3, Color.Magenta, "vrule\\r");
//gDef.gprint("sun", new ConsolFun(ConsolFun.ConsolFunTypes.MAX), "maxSun = %.3f%s");
//gDef.gprint("sun", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), "avgSun = %.3f%S\\r");
//gDef.gprint("shade", new ConsolFun(ConsolFun.ConsolFunTypes.MAX), "maxShade = %.3f%S");
//gDef.gprint("shade", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), "avgShade = %.3f%S\\r");
//gDef.print("sun", new ConsolFun(ConsolFun.ConsolFunTypes.MAX), "maxSun = %.3f%s");
//gDef.print("sun", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), "avgSun = %.3f%S\\r");
//gDef.print("shade", new ConsolFun(ConsolFun.ConsolFunTypes.MAX), "maxShade = %.3f%S");
//gDef.print("shade", new ConsolFun(ConsolFun.ConsolFunTypes.AVERAGE), "avgShade = %.3f%S\\r");
//gDef.setImageInfo("<img src='%s' width='%d' height = '%d'>");
//gDef.setPoolUsed(false);
//gDef.setImageFormat("png");
//Console.WriteLine("Rendering graph " + Util.getLapTime());
//// create graph finally
//graph = new RrdGraph(gDef);
//Console.WriteLine(graph.getRrdGraphInfo().dump());
//Console.WriteLine("== Graph created " + Util.getLapTime());
//// locks info
////Console.WriteLine("== Locks info ==");
////Console.WriteLine(RrdSafeFileBackend.getLockInfo());
//// demo ends
////log.close();
//Console.WriteLine("== Demo completed in " +
// ((DateTime.Now.Millisecond - startMillis) / 1000.0) + " sec");
}