static void CreateEventFrames(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
string queryString = "Template:MeterBasic";
{
// This method returns the collection of AFBaseElement objects that were created with this template.
using (AFElementSearch elementQuery = new AFElementSearch(database, "Meters", queryString))
{
DateTime timeReference = DateTime.Today.AddDays(-7);
int count = 0;
foreach (AFElement meter in elementQuery.FindElements())
{
foreach (int day in Enumerable.Range(1, 7))
{
AFTime startTime = new AFTime(timeReference.AddDays(day - 1));
AFTime endTime = new AFTime(startTime.LocalTime.AddDays(1));
AFEventFrame ef = new AFEventFrame(database, "*", eventFrameTemplate);
ef.SetStartTime(startTime);
ef.SetEndTime(endTime);
ef.PrimaryReferencedElement = meter;
// It is good practice to periodically check in the database
if (++count % 500 == 0)
{
database.CheckIn();
}
}
}
}
}
if (database.IsDirty)
{
database.CheckIn();
}
}
private void CreateEventFrame(AFDatabase afDatabase, string name, string startTime = null, string endTime = null, string template = null)
{
// look to get the template, if template=null then aftemplate will be null as well
var afTemplate = GetEventFrameTemplate(afDatabase, template);
var eventFrame = new AFEventFrame(afDatabase, name, afTemplate);
if (!string.IsNullOrEmpty(startTime))
{
eventFrame.SetStartTime(startTime);
}
if (!string.IsNullOrEmpty(endTime))
{
eventFrame.SetEndTime(endTime);
}
// when using a template, you'll want to assign a primary element to the event frame:
// here is an example:
eventFrame.PrimaryReferencedElement = null;
eventFrame.Description = "";
// for demonstration purpose, we add some attributes to the event frame created, only if there was no template passed.
if (afTemplate == null)
{
AddAttributes(afDatabase, eventFrame);
}
// the checkin writes the event frame to the database
eventFrame.CheckIn();
Logger.InfoFormat("EventFrameCreated: name: {0} GUID: {1}", eventFrame.Name, eventFrame.ID);
}
public void EventFrameAFSDK2018SP3Patch1Check()
{
AFEventFrame ef = null;
try
{
AFRpcMetric[] rpcBefore = Fixture.AFDatabase.PISystem.GetClientRpcMetrics();
ef = new AFEventFrame(Fixture.AFDatabase, "OSIsoftTests_Patch2107Applied_EF1");
ef.CheckIn();
ef.SetEndTime("*");
ef.CheckIn();
AFRpcMetric[] rpcAfter = Fixture.AFDatabase.PISystem.GetClientRpcMetrics();
IList <AFRpcMetric> rpcDiff = AFRpcMetric.SubtractList(rpcAfter, rpcBefore);
foreach (AFRpcMetric rpcMetric in rpcDiff)
{
Assert.False(rpcMetric.Name.Equals("getcheckoutinfo", StringComparison.InvariantCultureIgnoreCase), "Error: GetCheckOutInfo rpc was still called after Checkin with 2018 SP3 Patch 1!");
}
}
finally
{
if (ef != null)
{
ef.Delete();
Fixture.AFDatabase.PISystem.CheckIn();
}
}
}
public string CreateEventFrame()
{
if (currentDb == null)
{
currentDb = InitializeAf();
}
string result;
var eventFrame = new EventFrame();
if (currentDb != null)
{
AFEventFrame myEventFrame = new AFEventFrame(currentDb, "RandomEventFrame*");
myEventFrame.SetStartTime("T-1w");
myEventFrame.SetEndTime(AFTime.Now);
myEventFrame.Template = currentDb.ElementTemplates["Сообщение"];
AFValue myValue = new AFValue {
Value = "Test"
};
myEventFrame.Attributes["Текст сообщения"].SetValue(myValue);
myEventFrame.Description = "This is my EventFrame";
myEventFrame.CheckIn();
eventFrame.Id = myEventFrame.ID.ToString();
eventFrame.Name = myEventFrame.Name;
eventFrame.DateTime = myEventFrame.EndTime.ToString();
var serializer = new JavaScriptSerializer();
result = serializer.Serialize(eventFrame);
}
else
{
result = "disconnect";
}
return(result);
}
public void WriteQuery(Query q)
{
AFEventFrame ef = new AFEventFrame(db, $"{eftemplate.Name}_{q.StartTime.ToShortDateString()}", eftemplate);
ef.SetStartTime(q.StartTime);
ef.SetEndTime(q.EndTime);
ef.Attributes["ID"].SetValue(new AFValue(q.id));
db.CheckIn();
}
private void CreateEventFrames(AFDatabase afDatabase)
{
AFElementTemplate efTemplate = afDatabase.ElementTemplates["BasicEventFrameTemplate"];
for (int i = 0; i < 5; i++)
{
AFEventFrame ef = new AFEventFrame(afDatabase, "EF_" + i, efTemplate);
ef.SetStartTime(new AFTime(string.Format("t-{0}d", i + 1)));
ef.SetEndTime(new AFTime(string.Format("t-{0}d", i)));
AFElement element = afDatabase.Elements["Region_0"].Elements["BoilerA"];
ef.PrimaryReferencedElement = element;
}
// Do a bulk check in of all changes made so far.
afDatabase.CheckIn();
}
/// <summary>
/// Create an Event Frame when the leaf element shows the target mode
/// </summary>
/// <param name="obj"></param>
private void CreateEFOnTargetMode(AFValue obj)
{
var newMode = ((AFEnumerationValue)obj.Value).Name;
if (String.Equals(newMode, _leafTargetMode, StringComparison.OrdinalIgnoreCase))
{
var element = (AFElement)obj.Attribute.Element;
var time = obj.Timestamp;
AFEventFrame ef = new AFEventFrame(element.Database, String.Format("{0}_{1}_{2}", element.Name, time.ToString("yyyy_MM_dd_HH_mm"), _leafTargetMode));
ef.PrimaryReferencedElement = element;
ef.SetStartTime(time);
ef.SetEndTime(AFTime.Now);
ef.CheckIn();
}
}
private void CreateEventFrames(AFDatabase afDatabase)
{
AFElementTemplate efTemplate = afDatabase.ElementTemplates["BasicEventFrameTemplate"];
for (int i = 0; i < 5; i++)
{
AFEventFrame ef = new AFEventFrame(afDatabase, "EF_" + i, efTemplate);
ef.SetStartTime(new AFTime(string.Format("t-{0}d", i + 1)));
ef.SetEndTime(new AFTime(string.Format("t-{0}d", i)));
AFElement element = afDatabase.Elements["Region_0"].Elements["BoilerA"];
ef.PrimaryReferencedElement = element;
}
// Do a bulk check in of all changes made so far.
afDatabase.CheckIn();
}
private AFEventFrame CreateEventFrame(AFDatabase db, AFElementTemplate eventFrameTemplate, AFCategory elementCategory)
{
AFEventFrame ef = null;
if (eventFrameTemplate == null)
{
AFElement el2 = db.Elements[Constants.AF_ELEMENT_NAME + "2"];
AFElement el = db.Elements[Constants.AF_ELEMENT_NAME];
AFTime startTime = new AFTime(DateTime.Now.AddDays(-1));
ef = new AFEventFrame(db, Constants.AF_EVENT_FRAME_NAME);
ef.ReferencedElements.Add(el);
ef.ReferencedElements.Add(el2);
ef.PrimaryReferencedElement = el;
ef.SetStartTime(startTime);
ef.CanBeAcknowledged = true;
ef.SetEndTime(new AFTime("*"));
ef.Categories.Add(elementCategory);
AFEventFrame ef1 = ef.EventFrames.Add(Constants.AF_EVENT_FRAME_NAME + "Child1");
AFEventFrame ef2 = ef.EventFrames.Add(Constants.AF_EVENT_FRAME_NAME + "Child2");
ef.Attributes.Add(Constants.AF_ATTRIBUTE_NAME);
IList <AFAnnotation> annotations = el.GetAnnotations();
AFAnnotation ann = new AFAnnotation(ef);
ann.Name = Constants.AF_EVENT_FRAME_ANNOTATION_NAME;
ann.Value = "Sample value for annotation";
ann.Save();
}
else
{
AFElement myTank1 = db.Elements["Tank 1"];
AFElement myTank2 = db.Elements["Tank 2"];
AFTime startTime = new AFTime("*-1d");
ef = new AFEventFrame(db, "Tank Level 1", eventFrameTemplate);
ef.ReferencedElements.Add(myTank1);
ef.ReferencedElements.Add(myTank2);
ef.PrimaryReferencedElement = myTank1;
ef.SetStartTime(AFTime.Now);
ef.CheckIn();
AFTime endTime = AFTime.Now;
ef.SetEndTime(endTime);
}
return(ef);
}
static void CreateEventFrames(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
const int pageSize = 1000;
int startIndex = 0;
int totalCount;
do
{
AFNamedCollectionList <AFBaseElement> results = database.ElementTemplates["MeterBasic"].FindInstantiatedElements(
includeDerived: true,
sortField: AFSortField.Name,
sortOrder: AFSortOrder.Ascending,
startIndex: startIndex,
maxCount: pageSize,
totalCount: out totalCount
);
IList <AFElement> meters = results.Select(elm => (AFElement)elm).ToList();
DateTime timereference = DateTime.Now.AddDays(-7);
//AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
foreach (AFElement meter in meters)
{
foreach (int day in Enumerable.Range(1, 7))
{
AFTime startTime = new AFTime(timereference.AddDays(day - 1));
AFTime endTime = new AFTime(startTime.LocalTime.AddDays(1));
AFEventFrame ef = new AFEventFrame(database, "*", eventFrameTemplate);
ef.SetStartTime(startTime);
ef.SetEndTime(endTime);
ef.PrimaryReferencedElement = meter;
}
}
database.CheckIn();
startIndex += pageSize;
} while (startIndex < totalCount);
database.CheckIn();
}
public bool CreateEventFrame(string name, AFTime start, AFTime end, AFElement primaryReferencedElement, AFElementTemplate efTemplate)
{
try
{
AFEventFrame newEF = new AFEventFrame(_db, name, efTemplate);
newEF.SetStartTime(start);
newEF.SetEndTime(end);
newEF.PrimaryReferencedElement = primaryReferencedElement;
newEF.CheckIn();
_db.CheckIn(AFCheckedOutMode.ObjectsCheckedOutThisThread);
_db.Refresh();
return true;
}
catch
{
return false;
}
}
public void CreateEventFrames()
{
const int pageSize = 1000;
int startIndex = 0;
int totalCount;
do
{
AFNamedCollectionList<AFBaseElement> results = _database.ElementTemplates["MeterBasic"].FindInstantiatedElements(
includeDerived: true,
sortField: AFSortField.Name,
sortOrder: AFSortOrder.Ascending,
startIndex: startIndex,
maxCount: pageSize,
totalCount: out totalCount
);
IList<AFElement> meters = results.Select(elm => (AFElement)elm).ToList();
foreach (AFElement meter in meters)
{
foreach (int day in Enumerable.Range(1, 31))
{
DateTime start = new DateTime(2015, 12, day, 0, 0, 0, DateTimeKind.Local);
AFTime startTime = new AFTime(start);
AFTime endTime = new AFTime(start.AddDays(1));
AFEventFrame ef = new AFEventFrame(_database, "*", _eventFrameTemplate);
ef.SetStartTime(startTime);
ef.SetEndTime(endTime);
ef.PrimaryReferencedElement = meter;
}
}
_database.CheckIn();
startIndex += pageSize;
} while (startIndex < totalCount);
}
private void CreateEventFrame(AFDatabase afDatabase, string name, string startTime = null, string endTime = null, string template = null)
{
// look to get the template, if template=null then aftemplate will be null as well
var afTemplate = GetEventFrameTemplate(afDatabase, template);
var eventFrame = new AFEventFrame(afDatabase, name, afTemplate);
if (!string.IsNullOrEmpty(startTime)) eventFrame.SetStartTime(startTime);
if (!string.IsNullOrEmpty(endTime)) eventFrame.SetEndTime(endTime);
// when using a template, you'll want to assign a primary element to the event frame:
// here is an example:
eventFrame.PrimaryReferencedElement = null;
eventFrame.Description = "";
// for demonstration purpose, we add some attributes to the event frame created, only if there was no template passed.
if (afTemplate == null)
AddAttributes(afDatabase, eventFrame);
// the checkin writes the event frame to the database
eventFrame.CheckIn();
Logger.InfoFormat("EventFrameCreated: name: {0} GUID: {1}", eventFrame.Name, eventFrame.ID);
}
public void NotificationRuleSendWebServiceEventFrameNotifyOptionTest(AFNotifyOption afNotifyOption, bool eventFrameStartSent, bool eventFrameEndSent)
{
Assert.True(NotificationsFixture.SoapWebServiceHost != null, "The Web Service host couldn't be started.");
AFDatabase db = AFFixture.AFDatabase;
var elementName = $"{NotificationsFixture.TestPrefix}_{NotificationsFixture.TestInfix}_{nameof(NotificationRuleSendWebServiceEventFrameNotifyOptionTest)}_{afNotifyOption.ToString()}";
var notificationRuleName = $"{NotificationsFixture.TestPrefix}_{NotificationsFixture.TestInfix}_NotificationRule1";
var eventFrameName = $"{NotificationsFixture.TestPrefix}_{NotificationsFixture.TestInfix}_EventFrame1";
AFFixture.RemoveElementIfExists(elementName, Output);
Guid?eventFrameId = null;
try
{
Output.WriteLine($"Run test {nameof(NotificationRuleSendWebServiceEventFrameNotifyOptionTest)} with notify option [{afNotifyOption.ToString()}].");
Output.WriteLine($"Create element [{elementName}] with notification rule [{notificationRuleName}].");
var element = db.Elements.Add(elementName);
var notificationRule = element.NotificationRules.Add(notificationRuleName);
notificationRule.Criteria = $"Name:{NotificationsFixture.TestPrefix}*";
notificationRule.NonrepetitionInterval = TimeSpan.FromMinutes(1);
var format = notificationRule.DeliveryFormats.Add("testFormat", WebServicePlugIn);
NotificationsFixture.SetFormatProperties(format.Properties, nameof(NotificationRuleSendWebServiceEventFrameNotifyOptionTest));
var webServiceEndpoint = NotificationsFixture.GetSoapWebServiceEndpoint();
var subscriber = notificationRule.Subscribers.Add(webServiceEndpoint);
subscriber.DeliveryFormat = format;
subscriber.NotifyOption = afNotifyOption;
notificationRule.SetStatus(AFStatus.Enabled);
db.CheckIn();
Output.WriteLine("Waiting for notification to startup.");
Thread.Sleep(TimeSpan.FromSeconds(10));
var eventFrame = new AFEventFrame(db, eventFrameName)
{
PrimaryReferencedElement = element,
};
Output.WriteLine($"Created event frame [{eventFrameName}].");
eventFrame.SetStartTime(AFTime.Now);
eventFrame.CheckIn();
eventFrameId = eventFrame.ID;
Output.WriteLine("Event frame start send.");
Message msg;
if (eventFrameStartSent)
{
msg = NotificationsFixture.Service.WaitForMessage(TimeSpan.FromMinutes(1));
Assert.True(notificationRule.ID == msg.NotificationRuleId, "Notification rule is not set properly.");
Assert.True(msg.Content == nameof(NotificationRuleSendWebServiceEventFrameNotifyOptionTest), "The message content is not set properly.");
}
else
{
var foundMessage = NotificationsFixture.Service.TryWaitForMessage(TimeSpan.FromMinutes(1), out msg);
Assert.False(foundMessage, $"Notification rule should not send any notification, but found message for notification rule Id: [{msg?.NotificationRuleId}].");
}
// Waiting for event frame close send
eventFrame.SetEndTime(AFTime.Now);
eventFrame.CheckIn();
if (eventFrameEndSent)
{
msg = NotificationsFixture.Service.WaitForMessage(TimeSpan.FromMinutes(1));
Assert.True(notificationRule.ID == msg.NotificationRuleId, "Notification rule is not set properly.");
Assert.True(msg.Content == nameof(NotificationRuleSendWebServiceEventFrameNotifyOptionTest), "The message content is not set properly.");
}
else
{
var foundMessage = NotificationsFixture.Service.TryWaitForMessage(TimeSpan.FromMinutes(1), out msg);
Assert.False(foundMessage, $"Notification rule should not send any notification, but found message for notification rule Id: [{msg?.NotificationRuleId}].");
}
}
finally
{
AFFixture.RemoveElementIfExists(elementName, Output);
if (eventFrameId != null)
{
AFFixture.RemoveEventFrameIfExists(eventFrameId.GetValueOrDefault(), Output);
}
}
}
static void CreateEventFrames(AFDatabase database, AFElementTemplate eventFrameTemplate)
{
const int pageSize = 1000;
int startIndex = 0;
int totalCount;
do
{
AFNamedCollectionList<AFBaseElement> results = database.ElementTemplates["MeterBasic"].FindInstantiatedElements(
includeDerived: true,
sortField: AFSortField.Name,
sortOrder: AFSortOrder.Ascending,
startIndex: startIndex,
maxCount: pageSize,
totalCount: out totalCount
);
IList<AFElement> meters = results.Select(elm => (AFElement)elm).ToList();
DateTime timereference = DateTime.Now.AddDays(-7);
//AFTime startTime = new AFTime(new DateTime(timereference.Year, timereference.Month, timereference.Day, 0, 0, 0, DateTimeKind.Local));
foreach (AFElement meter in meters)
{
foreach (int day in Enumerable.Range(1, 7))
{
AFTime startTime = new AFTime(timereference.AddDays(day - 1));
AFTime endTime = new AFTime(startTime.LocalTime.AddDays(1));
AFEventFrame ef = new AFEventFrame(database, "*", eventFrameTemplate);
ef.SetStartTime(startTime);
ef.SetEndTime(endTime);
ef.PrimaryReferencedElement = meter;
}
}
database.CheckIn();
startIndex += pageSize;
} while (startIndex < totalCount);
database.CheckIn();
}
