protected override List <Action> GetActions()
{
List <Action> actions = Constants.ClassificationIds.Select(classificationId => (Action)(() =>
{
var actionStopwatch = new AFStopwatch();
actionStopwatch.Start();
string query = $"Template:EFOutageClassification |Id:={classificationId} SortField:ID";
// Sometimes we use AFSearchMode.StartInclusive other times AFSearchMode.Overlapped. StartInclusive we use when a start and end time is provided
// Is there a performance difference?
var afEventFrameSearch = new AFEventFrameSearch(AfDatabase, "ASearch", query);
var maxCount = 1000;
var eventFrames = afEventFrameSearch.FindEventFrames(0, true, maxCount).Take(maxCount).ToList();
var count = eventFrames.Count;
TestOutput.AddActionResult(
new ActionPerformanceResult
{
ActionMillis = actionStopwatch.ElapsedMilliseconds,
ResultCount = count
});
})).ToList();
return(actions);
}
protected override List <Action> GetActions()
{
if (ElementNames == null)
{
ElementNames = new[] { string.Empty };
}
var templateFilter = string.IsNullOrEmpty(TemplateName) ? string.Empty : $"Template:{TemplateName}";
List <Action> actions = ElementNames.Select(elementName => (Action)(() =>
{
var actionStopwatch = new AFStopwatch();
actionStopwatch.Start();
var elementNameFilter = elementName != String.Empty ? $"ElementName:{elementName}" : String.Empty;
string query = $"{elementNameFilter} {templateFilter} {ValueQuery} SortField:ID";
// Sometimes we use AFSearchMode.StartInclusive other times AFSearchMode.Overlapped. StartInclusive we use when a start and end time is provided
// Is there a performance difference?
var afEventFrameSearch = new AFEventFrameSearch(AfDatabase, "ASearch", query);
var maxCount = 1000;
var eventFrames = afEventFrameSearch.FindEventFrames(0, true, maxCount).Take(maxCount).ToList();
var count = eventFrames.Count;
TestOutput.AddActionResult(
new ActionPerformanceResult
{
ActionMillis = actionStopwatch.ElapsedMilliseconds,
ResultCount = count
});
})).ToList();
return(actions);
}
private int ReviewStatus_AFEventFrameSearch_CalculateCountOnAllTurbines(int reviewStatus, string windFarmName)
{
var templateName = "EFTCMVibrationEvent";
var attributeName = "ReviewStatus";
AFStopwatch stopwatch = new AFStopwatch();
var afEventFrameSearch = new AFEventFrameSearch(_afDatabase, "MyQuery", "ElementName:" + windFarmName + " Template:" + templateName + " |" + attributeName + ":=" + reviewStatus + " SortField:ID");
var countDictionary = new Dictionary <string, int>();
IEnumerable <AFEventFrame> efs = afEventFrameSearch.FindEventFrames(pageSize: pagesize);
//Console.WriteLine("Done : " + efs.Count() + ", " + stopwatch.ElapsedMilliseconds + "ms");
var eventFramesGroupedByPrimaryReferencedElementNames = efs.GroupBy(ef => ef.PrimaryReferencedElement.Name);
foreach (var eventFrameGroup in eventFramesGroupedByPrimaryReferencedElementNames)
{
countDictionary[eventFrameGroup.Key] = eventFrameGroup.Count();
}
//Console.WriteLine("Done2 : " + efs.Count() + ", " + stopwatch.ElapsedMilliseconds + "ms");
return(stopwatch.ElapsedMilliseconds);
//_log.Info($"Time:{stopwatch.Elapsed.TotalSeconds}, Template:{templateName}, {attributeName}:{reviewStatus}, Element:{windFarmName}, Element Count: {countDictionary.Keys.Count}, EventFrame Count:{countDictionary.Sum(e => e.Value)}");
//foreach (var counts in countDictionary)
//{
// _log.Info($"{counts.Key}:{counts.Value}");
//}
}
private int AFEventFrameSearch(string templateName, string elementName = null, string attributeName = null, object value = null)
{
AFStopwatch stopwatch = new AFStopwatch();
string elementNameFilter = elementName != null ? "ElementName:" + elementName + " " : string.Empty;
string query = $"Template:{templateName} SortField:ID";
if (elementName != null)
{
query += $" ElementName:{elementName}";
}
if (attributeName != null)
{
query += $" |{attributeName}:={value}";
}
var afEventFrameSearch = new AFEventFrameSearch(_afDatabase, "MyQuery" + value, query);
if (pageCount != 0)
{
afEventFrameSearch.CacheTimeout = TimeSpan.FromSeconds(30);
for (int page = 0; page < pageCount; page++)
{
var afEventFrames = afEventFrameSearch.FindEventFrames(startIndex: page * pagesize, fullLoad: false, pageSize: pagesize)
.ToList();
//var uniqueIds = afEventFrames.Select(ef => ef.Attributes["SourceSystemUniqueId"]);
//Console.WriteLine($"Page:{page + 1}, PageSize:{pagesize}, EFCount:{afEventFrames.Count}");
}
}
else
{
var afEventFrames = afEventFrameSearch.FindEventFrames(fullLoad: false, pageSize: pagesize).ToList();
//var uniqueIds = afEventFrames.Select(ef => ef.Attributes["SourceSystemUniqueId"]);
//Console.WriteLine($"EFCount:{afEventFrames.Count}");
}
//Console.WriteLine("Done : " + afEventFrames.Count + ", " + stopwatch.ElapsedMilliseconds + "ms");
return(stopwatch.ElapsedMilliseconds);
//_log.Info($"time:{stopwatch.Elapsed.TotalSeconds}, Template:{templateName}, {attributeName}:{value}, Element:{elementName}, count:{afEventFrames.Count}");
}
private void Button_Click(object sender, RoutedEventArgs re)
{
//parse the start and end times
AFTime startTime, endTime;
if (AFTime.TryParse(StartDate.Text, out startTime) && AFTime.TryParse(EndDate.Text, out endTime))
{
//find event frames with the event frame template in the time slot
var search = new AFEventFrameSearch(db, "Find", AFSearchMode.Overlapped, startTime, endTime, $"Template:={eventFrameTemplate.Name}");
List <AFEventFrame> efs = search.FindEventFrames().OrderBy(ef => ef.Attributes[matchingAttribute].GetValue().ValueAsInt32()).ToList();
//read in csv file
List <CSVLine> lines = new List <CSVLine>();
using (var reader = new StreamReader(CSV.Text))
{
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var split = line.Split(',');
int id;
if (int.TryParse(split[0], out id))
{
lines.Add(new CSVLine(id, split[1]));
}
}
}
lines = lines.OrderBy(line => line.ID).ToList();
//iterate through lines of csv
//match identifier column with "matchingAttribute"
int e = 0, l = 0;
while (e < efs.Count && l < lines.Count)
{
int ef_id = efs[e].Attributes[matchingAttribute].GetValue().ValueAsInt32();
int line_id = lines[l].ID;
if (ef_id == line_id)
{
//match -- update
efs[e].Attributes["Attribute1"].SetValue(new AFValue(lines[l].Value));
l++;
e++;
}
else if (ef_id > line_id)
{
l++;
}
else
{
e++;
}
}
}
}
public static IEnumerable <AFEventFrame> FindDowntimeEvents(AFDatabase afdb, string relayName, bool InProgress)
{
var eventSearch = new AFEventFrameSearch(afdb, "Template Search", $"Template:'Downtime' Name:{relayName}* InProgress:{InProgress}");
var events = eventSearch.FindEventFrames();
foreach (var item in events)
{
Console.WriteLine($"Event Found {item.Name}, time: {item.StartTime} - {item.EndTime} Duration: {item.Duration}");
}
return(events);
}
internal void InitialRun()
{
ComputeStatistics();
AFEventFrameSearch currentEventFrameQuery = new AFEventFrameSearch(afdatabse, "currentEvent", eventFrameQuery.Tokens.ToList());
currentEventFrameQuery.Tokens.Add(new AFSearchToken(AFSearchFilter.InProgress, AFSearchOperator.Equal, "True"));
IEnumerable <AFEventFrame> currentEventFrames = currentEventFrameQuery.FindEventFrames(0, true, int.MaxValue);
foreach (AFEventFrame currentEventFrame in currentEventFrames)
{
WriteValues(currentEventFrame.StartTime);
}
}
static void PrintReport(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
DateTime timereference = DateTime.Now.AddDays(-7);
AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
AFTime endTime = startTime.LocalTime.AddDays(+8);
string query = string.Format("template:\"{0}\" ElementName:\"{1}\"", eventFrameTemplate.Name, "Meter003");
AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFSearchMode.StartInclusive, startTime, endTime, query);
foreach (AFEventFrame ef in eventFrameSearch.FindEventFrames())
{
Console.WriteLine("{0}, {1}, {2}",
ef.Name,
ef.PrimaryReferencedElement.Name,
ef.Attributes["Average Energy Usage"].GetValue().Value);
}
}
static void PrintReport(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
AFTime startTime = DateTime.Today.AddDays(-7);
AFTime endTime = startTime.LocalTime.AddDays(+8); // Or DateTime.Today.AddDays(1);
string queryString = $"template:'{eventFrameTemplate.Name}' ElementName:Meter003";
using (AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFSearchMode.StartInclusive, startTime, endTime, queryString))
{
eventFrameSearch.CacheTimeout = TimeSpan.FromMinutes(5);
foreach (AFEventFrame ef in eventFrameSearch.FindEventFrames())
{
Console.WriteLine("{0}, {1}, {2}",
ef.Name,
ef.PrimaryReferencedElement.Name,
ef.Attributes["Average Energy Usage"].GetValue().Value);
}
}
}
internal void InitialRun()
{
currentFrameQuery = currentEventFrame(eventFrameQuery);
ComputeStatistics();
//AFEventFrameSearch currentEventFrameQuery = currentEventFrame(eventFrameQuery);
IEnumerable <AFEventFrame> currentEventFrames = currentFrameQuery.FindEventFrames(0, true, int.MaxValue);
try {
foreach (AFEventFrame currentEventFrame in currentEventFrames)
{
WriteValues(currentEventFrame.StartTime);
}
}
catch (System.Exception e)
{
logger.Error($"{calculationName} : Was not able to write initial data due {e.Message}");
}
}
private List <AFEventFrame> GetEventFramesFromAfEventFrameSearch(string templateName, string elementName,
string attributeName,
object value)
{
string query = $"Template:{templateName} SortField:ID";
if (elementName != null)
{
query += $" ElementName:{elementName}";
}
if (attributeName != null)
{
query += $" |{attributeName}:={value}";
}
var afEventFrameSearch = new AFEventFrameSearch(AfDatabase, "MyQuery" + value, AFSearchMode.StartInclusive, Start, End,
query);
return(afEventFrameSearch.FindEventFrames().ToList());
}
static public void CaptureValues(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
// Formulate search constraints on time and template
DateTime timereference = DateTime.Now.AddDays(-7);
AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
string query = string.Format("template:\"{0}\"", eventFrameTemplate.Name);
AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFEventFrameSearchMode.ForwardFromStartTime, startTime, query);
int startIndex = 0;
foreach (AFEventFrame item in eventFrameSearch.FindEventFrames())
{
item.CaptureValues();
if ((startIndex++ % 512) == 0)
{
database.CheckIn();
}
}
database.CheckIn();
}
private void lbNotificationRules_SelectedIndexChanged(object sender, EventArgs e)
{
// Selected notification rule
AFNotificationRule SelectedNotificationRule = lbNotificationRules.SelectedItem as AFNotificationRule;
// Clear the notificaiton list
lbNotificationInstances.Items.Clear();
// Check empty Selected
if (SelectedNotificationRule == null)
{
return;
}
// Get information from Notification Rule Selected;
AFTime startTime = new AFTime(tbStart.Text);
AFTime endTime = new AFTime(tbEnd.Text);
AFElement targetElement = SelectedNotificationRule.Target;
AFDatabase database = SelectedNotificationRule.Database;
// Consulting the dataBase
string query = string.Format("Element: '{0}' {1}", targetElement.GetPath(database), SelectedNotificationRule.Criteria);
AFEventFrameSearch search = new AFEventFrameSearch(database, "", AFSearchMode.Overlapped, startTime, endTime, query);
search.CacheTimeout = TimeSpan.FromMinutes(5);
IEnumerable <AFEventFrame> instances = search.FindEventFrames(fullLoad: false);
// Populate the eventframe listbox
foreach (AFEventFrame instance in instances)
{
string s = string.Format("Element: {0}, \t{1}, \t{2}"
, targetElement.Name
, instance.StartTime.LocalTime
, instance.EndTime == AFTime.MaxValue ? "Event is ongoing": instance.EndTime.LocalTime.ToString());
lbNotificationInstances.Items.Add(s);
}
}
static void Main(string[] args)
{
NetworkCredential credential = new NetworkCredential(connectionInfo.user, connectionInfo.password);
var piSystem = (new PISystems())[connectionInfo.AFServerName];
piSystem.Connect(credential);
var afdb = piSystem.Databases[connectionInfo.AFDatabaseName];
//using tokens
List <AFSearchToken> tokenList = new List <AFSearchToken>();
tokenList.Add(new AFSearchToken(AFSearchFilter.Template, AFSearchOperator.Equal, "Low Contaiment Strength"));
tokenList.Add(new AFSearchToken(AFSearchFilter.Name, AFSearchOperator.Equal, "T001*"));
var tokenSearch = new AFEventFrameSearch(afdb, "Template Search", tokenList);
//using search string
//var query = "Template:'Low Contaiment Strength' Name:T001*";
//var stringSearch = new AFEventFrameSearch(afdb, "Template Search", query);
var results = tokenSearch.FindEventFrames(0, false, 10);
var counter = 0;
foreach (var item in results)
{
Console.WriteLine($"Event {item.Name}, time: {item.StartTime} - {item.EndTime} Duration: {item.Duration}");
counter++;
if (counter > 9)
{
break;
}
}
Console.ReadKey();
}
static public void CaptureValues(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
// Formulate search constraints on time and template
AFTime startTime = DateTime.Today.AddDays(-7);
string queryString = $"template:\"{eventFrameTemplate.Name}\"";
using (AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFEventFrameSearchMode.ForwardFromStartTime, startTime, queryString))
{
eventFrameSearch.CacheTimeout = TimeSpan.FromMinutes(5);
int count = 0;
foreach (AFEventFrame item in eventFrameSearch.FindEventFrames())
{
item.CaptureValues();
if ((count++ % 500) == 0)
{
database.CheckIn();
}
}
if (database.IsDirty)
{
database.CheckIn();
}
}
}
internal void ComputeStatistics()
{
logger.Info($"{calculationName} Starting some recalcuations");
IEnumerable <AFEventFrame> eventFrames = eventFrameQuery.FindEventFrames(0, true, int.MaxValue);
//if (eventFrames)
List <AFValues> trends = new List <AFValues>();
try
{
foreach (AFEventFrame EF in eventFrames)
{
trends.Add(sensor.Data.InterpolatedValues(EF.TimeRange, interval, null, "", true));
}
logger.Debug($"{calculationName} : Succefully captured data and eventframes");
}
catch (System.Exception e)
{
logger.Error($"{calculationName} : Was not succesfull in querying data or event frames, {e.Message}");
return;
}
List <AFValues> slices = GetSlices(trends);
foreach (KeyValuePair <AFAttributeTrait, AFValues> bound in bounds)
{
bound.Value.Clear();
}
foreach (AFValues slice in slices)
{
foreach (KeyValuePair <AFAttributeTrait, AFValues> bound in bounds)
{
bound.Value.Add(performCalculation(calculationsToPerform[bound.Key], slice));
}
}
logger.Info($"{calculationName} : Finishing some recalculation");
}
//Get instances, which are Event Frames beginning with PI Notifications 2016
private void FindNotificationInstances()
{
gridNotificationInstances.Rows.Clear();
if (!btnView.Enabled)
{
return;
}
var rule = lboxNotificationRules.SelectedItem as AFNotificationRule;
var startTime = tbStartTime.Tag as AFTime?;
var endTime = tbEndTime.Tag as AFTime?;
var database = Element.Database;
//We echo the current notification rule search criteria, which includes literal "Criteria:"
//but include the Target element in the filter.
string query = string.Format("Element:'{0}' {1}", Element.GetPath(database), rule.Criteria);
AFEventFrameSearch search = new AFEventFrameSearch(database, "", AFSearchMode.Overlapped, startTime.Value, endTime.Value, query);
search.CacheTimeout = TimeSpan.FromMinutes(5);
IEnumerable <AFEventFrame> instances = search.FindEventFrames(fullLoad: true);
//Populate listbox with notification instances, which are just event frames in PI Notifications 2016 or later.
foreach (AFEventFrame instance in instances)
{
// For multi-trigger analyses, the "Start Trigger Name" would be null on the parent event frame if there were multiple triggers.
// We should suppress those. Note the "Start Trigger Name" is our default attribute.
object defaultObject = instance.DefaultAttribute?.GetValue() ?? (object)string.Empty;
if (!string.IsNullOrWhiteSpace(defaultObject.ToString()))
{
object endObject = (instance.EndTime == AFTime.MaxValue) ? (object)"ongoing/active" : instance.EndTime.LocalTime;
gridNotificationInstances.Rows.Add(instance.StartTime.LocalTime, endObject, defaultObject);
}
}
}
internal void ComputeStatistics()
{
IEnumerable <AFEventFrame> eventFrames = eventFrameQuery.FindEventFrames(0, true, int.MaxValue);
List <AFValues> trends = new List <AFValues>();
foreach (AFEventFrame EF in eventFrames)
{
// To Do add cases in case the value is very bad
trends.Add(sensor.Data.InterpolatedValues(EF.TimeRange, interval, null, "", true));
}
List <AFValues> slices = GetSlices(trends);
foreach (KeyValuePair <AFAttributeTrait, AFValues> bound in bounds)
{
bound.Value.Clear();
}
foreach (AFValues slice in slices)
{
foreach (KeyValuePair <AFAttributeTrait, AFValues> bound in bounds)
{
bound.Value.Add(performCalculation(calculationsToPerform[bound.Key], slice));
}
}
}
static public void CaptureValues(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
// Formulate search constraints on time and template
DateTime timereference = DateTime.Now.AddDays(-7);
AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
string query = string.Format("template:\"{0}\"", eventFrameTemplate.Name);
AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFEventFrameSearchMode.ForwardFromStartTime, startTime, query);
int startIndex = 0;
foreach (AFEventFrame item in eventFrameSearch.FindEventFrames())
{
item.CaptureValues();
if ((startIndex++ % 512) == 0)
database.CheckIn();
}
database.CheckIn();
}
static void PrintReport(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
DateTime timereference = DateTime.Now.AddDays(-7);
AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
AFTime endTime = startTime.LocalTime.AddDays(+8);
string query = string.Format("template:\"{0}\" ElementName:\"{1}\"", eventFrameTemplate.Name, "Meter003");
AFEventFrameSearch eventFrameSearch = new AFEventFrameSearch(database, "EventFrame Captures", AFSearchMode.StartInclusive, startTime, endTime, query);
foreach (AFEventFrame ef in eventFrameSearch.FindEventFrames())
{
Console.WriteLine("{0}, {1}, {2}",
ef.Name,
ef.PrimaryReferencedElement.Name,
ef.Attributes["Average Energy Usage"].GetValue().Value);
}
}