internal static QiType TypeMapOf(QiType keyType, QiType valueType) => new QiType(qi_type_map_of(keyType.Handle, valueType.Handle));
internal static IEnumerable <QiType> GetTupleTypes(QiType tupleType) => Enumerable .Range(0, GetTupleCount(tupleType)) .Select(i => GetTupleTypeAt(tupleType, i));
internal static QiType TypeListOf(QiType qiType) => new QiType(qi_type_list_of(qiType.Handle));
internal static QiType GetTupleTypeAt(QiType tupleType, int index) => new QiType(qi_type_get_element(tupleType.Handle, index));
private static void Main(string[] args) { // ==== Client constants ==== var tenant = ConfigurationManager.AppSettings["Tenant"]; var address = ConfigurationManager.AppSettings["Address"]; var resource = ConfigurationManager.AppSettings["Resource"]; var appId = ConfigurationManager.AppSettings["AppId"]; var appKey = ConfigurationManager.AppSettings["AppKey"]; var namespaceId = ConfigurationManager.AppSettings["Namespace"]; // ==== Setup the namespace. The namespace provides isolation within a Tenant. ==== var admin = QiService.GetAdministrationService(new Uri(address), tenant, new QiSecurityHandler(resource, tenant, appId, appKey)); var sampleNamespace = new QiNamespace(namespaceId); sampleNamespace = admin.GetOrCreateNamespaceAsync(sampleNamespace).GetAwaiter().GetResult(); // ==== Setup the type and stream ==== var config = QiService.GetMetadataService(new Uri(address), tenant, namespaceId, new QiSecurityHandler(resource, tenant, appId, appKey)); QiType type = QiTypeBuilder.CreateQiType <WaveData>(); type = config.GetOrCreateTypeAsync(type).GetAwaiter().GetResult(); var stream = new QiStream { Id = Guid.NewGuid().ToString(), Name = "Wave Data Sample", TypeId = type.Id, Description = "This is a sample QiStream for storing WaveData type measurements" }; stream = config.GetOrCreateStreamAsync(stream).GetAwaiter().GetResult(); // ==== Perform a number of CRUD opreations ==== var client = QiService.GetDataService(new Uri(address), tenant, namespaceId, new QiSecurityHandler(resource, tenant, appId, appKey)); // Insert a single event into a stream var wave = GetWave(0, 200, 2); client.InsertValueAsync(stream.Id, wave).GetAwaiter().GetResult(); // Update will add the event as well wave.Order += 1; client.UpdateValueAsync(stream.Id, wave).GetAwaiter().GetResult(); // Inserting a collection of events into a stream (more efficient) var waves = new List <WaveData>(); for (var i = 2; i <= 200; ++i) { waves.Add(GetWave(i, 200, 2)); } client.InsertValuesAsync(stream.Id, waves).GetAwaiter().GetResult(); // Retrieve events for a the range. Indexes are expected in string format. Order property is is the Key IEnumerable <WaveData> retrieved = client.GetWindowValuesAsync <WaveData>(stream.Id, "0", "200").GetAwaiter().GetResult(); Console.WriteLine("Retrieved {0} events", retrieved.Count()); Console.WriteLine("\tfrom {0} {1}", retrieved.First().Order, retrieved.First().Sin); Console.WriteLine("\tto {0} {1}", retrieved.Last().Order, retrieved.Last().Sin); // Update some events UpdateWave(retrieved.First(), 4); client.UpdateValueAsync(stream.Id, retrieved.First()).GetAwaiter().GetResult(); foreach (var value in waves) { UpdateWave(value, 4); } client.UpdateValuesAsync(stream.Id, waves.ToList()).GetAwaiter().GetResult(); retrieved = client.GetWindowValuesAsync <WaveData>(stream.Id, "0", "200").GetAwaiter().GetResult(); Console.WriteLine("Updated {0} events", retrieved.Count()); Console.WriteLine("\tfrom {0} {1}", retrieved.First().Order, retrieved.First().Sin); Console.WriteLine("\tto {0} {1}", retrieved.Last().Order, retrieved.Last().Sin); // Stream behaviors modify retrieval // Retrieve a range of three values using the default behavior. The default behavior is Continuous, // so ExactOrCalculated should bring back interpolated values retrieved = client.GetRangeValuesAsync <WaveData>(stream.Id, "1", 0, 3, false, QiBoundaryType.ExactOrCalculated).GetAwaiter().GetResult(); Console.WriteLine("Default behavior {0} events", retrieved.Count()); foreach (var value in retrieved) { Console.WriteLine("\t{0} {1}", value.Order, value.Sin); } // Modify the stream behavior to StepwiseContinuousLeading var stepwiseContinuousLeading = new QiStreamBehavior { Id = Guid.NewGuid().ToString(), Mode = QiStreamMode.StepwiseContinuousLeading }; stepwiseContinuousLeading = config.GetOrCreateBehaviorAsync(stepwiseContinuousLeading).GetAwaiter().GetResult(); stream.BehaviorId = stepwiseContinuousLeading.Id; config.UpdateStreamAsync(stream.Id, stream).GetAwaiter().GetResult(); retrieved = client.GetRangeValuesAsync <WaveData>(stream.Id, "1", 0, 3, false, QiBoundaryType.ExactOrCalculated).GetAwaiter().GetResult(); Console.WriteLine("StepwiseContinuousLeading behavior {0} events", retrieved.Count()); foreach (var value in retrieved) { Console.WriteLine("\t{0} {1}", value.Order, value.Sin); } // Delete the first event in the stream, the event at index zero client.RemoveValueAsync(stream.Id, 0).GetAwaiter().GetResult(); // Delete the rest of the Events client.RemoveWindowValuesAsync(stream.Id, 1, 200).GetAwaiter().GetResult(); retrieved = client.GetWindowValuesAsync <WaveData>(stream.Id, "0", "200").GetAwaiter().GetResult(); Console.WriteLine("After delete {0} events remain", retrieved.Count()); // Delete the stream and behavior config.DeleteStreamAsync(stream.Id).GetAwaiter().GetResult(); config.DeleteBehaviorAsync(stepwiseContinuousLeading.Id).GetAwaiter().GetResult(); // It is less common to remove the type and namespace config.DeleteTypeAsync(type.Id).GetAwaiter().GetResult(); // admin.DeleteNamespaceAsync(sampleNamespace.Id).GetAwaiter().GetResult(); }
internal static QiTypeKind GetKind(QiType qiType) => qi_type_get_kind(qiType.Handle);
internal static QiType GetMapValueType(QiType mapType) => new QiType(qi_type_get_value(mapType.Handle));
//NOTE: 既存のタイプをハンドリングする関数はこっから下 internal static void Destroy(QiType qiType) => qi_type_destroy(qiType.Handle);
static void Main(string[] args) { Console.WriteLine("Creating a .NET Qi Client..."); string server = Constants.QiServerUrl; QiType evtType = null; QiHttpClientFactory <IQiServer> clientFactory = new QiHttpClientFactory <IQiServer>(); clientFactory.ProxyTimeout = new TimeSpan(0, 1, 0); IQiServer qiclient = clientFactory.CreateChannel(new Uri(server)); IQiClientProxy proxy = (IQiClientProxy)qiclient; proxy.OnBeforeInvoke((handler) => { string token = AcquireAuthToken(); if (proxy.Client.DefaultHeaders.Contains("Authorization")) { proxy.Client.DefaultHeaders.Remove("Authorization"); } proxy.Client.DefaultHeaders.Add("Authorization", new AuthenticationHeaderValue("Bearer", token).ToString()); }); try { // Create a Qi Type to reflect the event data being stored in Qi. // The Qi Client Libraries provide QiTypeBuilder which constructs a QiType object // based upon a class you define in your code. Console.WriteLine("Creating a Qi type for WaveData instances"); QiTypeBuilder typeBuilder = new QiTypeBuilder(); evtType = typeBuilder.Create <WaveData>(); evtType.Id = "WaveType"; QiType tp = qiclient.GetOrCreateType(evtType); // now let's create the stream to contain the events // specify the type id of the QiType created above in the TypeId property of the QiStream object // All events submitted to this stream must be of this type Console.WriteLine("Creating a stream for simple event measurements"); QiStream sampleStream = new QiStream(); sampleStream.Name = "evtStream"; sampleStream.Id = "evtStream"; sampleStream.TypeId = tp.Id; sampleStream.Description = "This is a sample stream for storing WaveData type measurements"; QiStream strm = qiclient.GetOrCreateStream(sampleStream); #region CRUD Operations #region Create Events (Insert) Console.WriteLine("Artificially generating 100 events and inserting them into the Qi Service"); // Insert a single event into a stream TimeSpan span = new TimeSpan(0, 1, 0); WaveData evt = WaveData.Next(span, 2.0, 0); qiclient.InsertValue("evtStream", evt); // Inserting a collection of events into a stream List <WaveData> events = new List <WaveData>(); for (int i = 2; i < 200; i += 2) { WaveData newEvt = WaveData.Next(span, 2.0, i); events.Add(newEvt); Thread.Sleep(400); } qiclient.InsertValues("evtStream", events); Thread.Sleep(2000); #endregion #region Retrieve events for a time range // use the round trip formatting for time Console.WriteLine("Retrieving the inserted events"); Console.WriteLine("=============================="); IEnumerable <WaveData> foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); #endregion #region Update an event Console.WriteLine(); Console.WriteLine("Updating values"); // take the first value inserted and update the value using a multiplier of 4, while retaining the order evt = foundEvts.First(); evt = WaveData.Next(span, 4.0, evt.Order); qiclient.UpdateValue("evtStream", evt); // update the collection of events (same span, multiplier of 4, retain order) List <WaveData> newEvents = new List <WaveData>(); foreach (WaveData evnt in events) { WaveData newEvt = WaveData.Next(span, 4.0, evnt.Order); newEvents.Add(newEvt); Thread.Sleep(500); } qiclient.UpdateValues("evtStream", newEvents); Thread.Sleep(2000); Console.WriteLine("Retrieving the updated values"); Console.WriteLine("============================="); foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); // illustrate how stream behaviors modify retrieval // First, pull three items back with GetRangeValues for range values between events. // The default behavior is continuous, so ExactOrCalculated should bring back interpolated values Console.WriteLine(); Console.WriteLine(@"Retrieving three events without a stream behavior"); foundEvts = qiclient.GetRangeValues <WaveData>("evtStream", "1", 0, 3, false, QiBoundaryType.ExactOrCalculated); DumpEvents(foundEvts); // now, create a stream behavior with Discrete and attach it to the existing stream QiStreamBehavior behavior = new QiStreamBehavior(); behavior.Id = "evtStreamStepLeading"; behavior.Mode = QiStreamMode.StepwiseContinuousLeading; behavior = qiclient.GetOrCreateBehavior(behavior); // update the stream to include this behavior sampleStream.BehaviorId = behavior.Id; qiclient.UpdateStream("evtStream", sampleStream); // repeat the retrieval Console.WriteLine(); Console.WriteLine("Retrieving three events with a stepwise stream behavior in effect -- compare to last retrieval"); foundEvts = qiclient.GetRangeValues <WaveData>("evtStream", "1", 0, 3, false, QiBoundaryType.ExactOrCalculated); DumpEvents(foundEvts); #endregion #region Delete events Console.WriteLine(); Console.WriteLine("Deleting events"); qiclient.RemoveValue("evtStream", 0); qiclient.RemoveWindowValues("evtStream", 2, 198); Thread.Sleep(2000); Console.WriteLine("Checking for events"); Console.WriteLine("==================="); foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); Console.WriteLine("Test ran successfully"); Console.WriteLine("===================="); Console.WriteLine("Press any button to shutdown"); Console.ReadLine(); #endregion #endregion } catch (QiHttpClientException qiex) { Console.WriteLine("Error in Qi Service Client: " + qiex.Message); } catch (Exception ex) { Console.WriteLine("Other error: " + ex.Message); } finally { // clean up all created entities so you can run this again // all entities are reference counted, so you must delete the stream, then the type it uses try { qiclient.DeleteStream("evtStream"); qiclient.DeleteBehavior("evtStreamStepLeading"); qiclient.DeleteType(evtType.Id); } catch (Exception) { } } }
static void Main(string[] args) { Console.WriteLine("Creating a .NET Qi Client..."); string server = ConfigurationManager.AppSettings["QiServerUrl"]; // set up a client to the Qi Service -- it is essential that you set the QiTenant header QiHttpClientFactory <IQiServer> clientFactory = new QiHttpClientFactory <IQiServer>(); clientFactory.ProxyTimeout = new TimeSpan(0, 1, 0); clientFactory.OnCreated((p) => p.DefaultHeaders.Add("QiTenant", "sampletenant")); IQiServer qiclient = clientFactory.CreateChannel(new Uri(server)); try { // TODO -- remove tenant creation when provisioning is accomplished Console.WriteLine("Creating a tenant named sampletenant"); QiTenant tenant = new QiTenant("sampletenant"); // submit to PI Cloud Historian to create the tenant in storage qiclient.GetOrCreateTenant(tenant); // Create a Qi Type -- the Qi Libraries let you do this via reflection // First, create a type builder, then pass it the name of the class you are using for events. // This greatly simplifies type creation QiTypeBuilder typeBuilder = new QiTypeBuilder(); QiType evtType = typeBuilder.Create <SimpleEvent>(); evtType.Name = "SimpleEvent"; evtType.Id = "SimpleEvent"; QiType tp = qiclient.GetOrCreateType(evtType); Console.WriteLine("Creating a stream in this tenant for simple event measurements"); QiStream sampleStream = new QiStream(); sampleStream.Name = "evtStream"; sampleStream.Id = "evtStream"; // set the TypeId property to the value of the Id property of the type you submitted // All events submitted to this stream must be of this type // Note there are Async versions of the client methods, too, using .NET TPL sampleStream.TypeId = "SimpleEvent"; sampleStream.Description = "This is a sample stream for storing SimpleEvent type measurements"; QiStream strm = qiclient.GetOrCreateStream(sampleStream); #region CRUD Operations #region Create Events (Insert) Console.WriteLine("Artificially generating 100 events at one second intervals and inserting them into the Qi Service"); Random rnd = new Random(); // How to insert a single event SimpleEvent evt = new SimpleEvent(rnd.NextDouble() * 100, "deg C"); // for our contrived purposes, let's manually set the timestamp to 100 seconds in the past DateTime start = DateTime.UtcNow.AddSeconds(-100.0); evt.Timestamp = start; qiclient.InsertValue("evtStream", evt); List <SimpleEvent> events = new List <SimpleEvent>(); // how to insert an a collection of events for (int i = 1; i < 100; i++) { evt = new SimpleEvent(rnd.NextDouble() * 100, "deg C"); evt.Timestamp = start.AddSeconds((double)i); events.Add(evt); } qiclient.InsertValues <SimpleEvent>("evtStream", events); Thread.Sleep(2000); #endregion #region Retrieve events for a time range // use the round trip formatting for time Console.WriteLine("Retrieving the inserted events"); Console.WriteLine("=============================="); IEnumerable <SimpleEvent> foundEvts = qiclient.GetWindowValues <SimpleEvent>("evtStream", start.ToString("o"), DateTime.UtcNow.ToString("o")); DumpEvents(foundEvts); #endregion #region Update an event Console.WriteLine(); Console.WriteLine("Updating values"); // take the first value inserted and update the value and UOM evt = foundEvts.First <SimpleEvent>(); evt.Units = "deg F"; evt.Value = 212.0; qiclient.UpdateValue <SimpleEvent>("evtStream", evt); // update the collection of events (convert to deg F) foreach (SimpleEvent evnt in events) { evnt.Units = "deg F"; evnt.Value = evnt.Value * 9 / 5 + 32.0; } qiclient.UpdateValues <SimpleEvent>("evtStream", events); Thread.Sleep(2000); Console.WriteLine("Retrieving the updated values"); Console.WriteLine("============================="); foundEvts = qiclient.GetWindowValues <SimpleEvent>("evtStream", start.ToString("o"), DateTime.UtcNow.ToString("o")); DumpEvents(foundEvts); #endregion #region Delete events Console.WriteLine(); Console.WriteLine("Deleting events"); qiclient.RemoveValue <DateTime>("evtStream", evt.Timestamp); qiclient.RemoveWindowValues("evtStream", foundEvts.First <SimpleEvent>().Timestamp.ToString("o"), foundEvts.Last <SimpleEvent>().Timestamp.ToString("o")); Thread.Sleep(2000); Console.WriteLine("Checking for events"); Console.WriteLine("==================="); foundEvts = qiclient.GetWindowValues <SimpleEvent>("evtStream", start.ToString("o"), DateTime.UtcNow.ToString("o")); DumpEvents(foundEvts); #endregion #endregion } catch (QiHttpClientException qiex) { Console.WriteLine("Error in Qi Service Client: " + qiex.Message); } catch (Exception ex) { Console.WriteLine("Other error: " + ex.Message); } finally { // clean up all created entities so you can run this again // all entities are reference counted, so you must delete the stream, then the type it uses try { qiclient.DeleteStream("evtStream"); } catch (Exception exStrm) { Console.WriteLine("Error deleting stream, type is left: " + exStrm.Message); } try { qiclient.DeleteType("SimpleEvent"); } catch (Exception exTyp) { Console.WriteLine("Error deleting stream: " + exTyp.Message); } try { qiclient.DeleteTenant("sampletenant"); } catch (Exception exTnt) { Console.WriteLine("Error deleting tenant: " + exTnt.Message); } Console.WriteLine("Press ENTER to finish"); Console.ReadLine(); } }
private static async Task MainAsync() { IConfigurationBuilder builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json"); IConfiguration configuration = builder.Build(); // ==== Client constants ==== var tenantId = configuration["TenantId"]; var namespaceId = configuration["NamespaceId"]; var address = configuration["Address"]; var resource = configuration["Resource"]; var clientId = configuration["ClientId"]; var clientKey = configuration["ClientKey"]; // ==== Metadata IDs ==== string streamId = "SampleStream"; string typeId = "SampleType"; string behaviorId = "SampleBehavior"; string targetTypeId = "SampleType_Target"; string targetIntTypeId = "SampleType_TargetInt"; string autoViewId = "SampleAutoView"; string manualViewId = "SampleManualView"; // Get Qi Services to communicate with server QiSecurityHandler securityHandler = new QiSecurityHandler(resource, tenantId, clientId, clientKey); QiService qiService = new QiService(new Uri(address), securityHandler); var metadataService = qiService.GetMetadataService(tenantId, namespaceId); var dataService = qiService.GetDataService(tenantId, namespaceId); LoggerCallbackHandler.UseDefaultLogging = false; Console.WriteLine(@"---------------------------------------------------"); Console.WriteLine(@"________ .__ _______ ______________________"); Console.WriteLine(@"\_____ \ |__| \ \ \_ _____/\__ ___/"); Console.WriteLine(@" / / \ \| | / | \ | __)_ | | "); Console.WriteLine(@"/ \_/. \ | / | \| \ | | "); Console.WriteLine(@"\_____\ \_/__| /\ \____|__ /_______ / |____| "); Console.WriteLine(@" \__> \/ \/ \/ "); Console.WriteLine(@"---------------------------------------------------"); Console.WriteLine(); Console.WriteLine($"Qi endpoint at {address}"); Console.WriteLine(); try { // create a QiType Console.WriteLine("Creating a QiType"); QiType type = QiTypeBuilder.CreateQiType <WaveData>(); type.Id = typeId; type = await metadataService.GetOrCreateTypeAsync(type); // create a QiStream Console.WriteLine("Creating a QiStream"); var stream = new QiStream { Id = streamId, Name = "Wave Data Sample", TypeId = type.Id, Description = "This is a sample QiStream for storing WaveData type measurements" }; stream = await metadataService.GetOrCreateStreamAsync(stream); // insert data Console.WriteLine("Inserting data"); // insert a single event var wave = GetWave(0, 200, 2); await dataService.InsertValueAsync(stream.Id, wave); // insert a list of events var waves = new List <WaveData>(); for (var i = 2; i <= 18; i += 2) { waves.Add(GetWave(i, 200, 2)); } await dataService.InsertValuesAsync(stream.Id, waves); // get last event Console.WriteLine("Getting latest event"); var latest = await dataService.GetLastValueAsync <WaveData>(streamId); Console.WriteLine(latest.ToString()); Console.WriteLine(); // get all events Console.WriteLine("Getting all events"); var allEvents = (List <WaveData>) await dataService.GetWindowValuesAsync <WaveData>(streamId, "0", "180"); Console.WriteLine($"Total events found: {allEvents.Count}"); foreach (var evnt in allEvents) { Console.WriteLine(evnt.ToString()); } Console.WriteLine(); // update events Console.WriteLine("Updating events"); // update one event var updatedWave = UpdateWave(allEvents.First(), 4); await dataService.UpdateValueAsync(stream.Id, updatedWave); // update all events, adding ten more var updatedCollection = new List <WaveData>(); for (int i = 2; i < 40; i = i + 2) { updatedCollection.Add(GetWave(i, 400, 4)); } await dataService.UpdateValuesAsync(stream.Id, updatedCollection); allEvents = (List <WaveData>) await dataService.GetWindowValuesAsync <WaveData>(stream.Id, "0", "180"); Console.WriteLine("Getting updated events"); Console.WriteLine($"Total events found: {allEvents.Count}"); foreach (var evnt in allEvents) { Console.WriteLine(evnt.ToString()); } Console.WriteLine(); // replacing events Console.WriteLine("Replacing events"); // replace one event var replaceEvent = allEvents.First(); replaceEvent.Sin = 0.717; replaceEvent.Cos = 0.717; replaceEvent.Tan = Math.Sqrt(2 * (0.717 * 0.717)); await dataService.ReplaceValueAsync <WaveData>(streamId, replaceEvent); // replace all events foreach (var evnt in allEvents) { evnt.Sin = 5.0 / 2; evnt.Cos = 5 * Math.Sqrt(3) / 2; evnt.Tan = 5 / Math.Sqrt(3); } await dataService.ReplaceValuesAsync <WaveData>(streamId, allEvents); Console.WriteLine("Getting replaced events"); var replacedEvents = (List <WaveData>) await dataService.GetWindowValuesAsync <WaveData>(streamId, "0", "180"); Console.WriteLine($"Total events found: {replacedEvents.Count}"); foreach (var evnt in replacedEvents) { Console.WriteLine(evnt.ToString()); } Console.WriteLine(); // Stream behaviors Console.WriteLine("QiStreamBehaviors determine whether Qi interpolates or extrapolates data at the requested index location"); Console.WriteLine(); // Stream behaviors modify retrieval. We will retrieve three events using the default behavior, Continuous var retrieved = await dataService .GetRangeValuesAsync <WaveData>(stream.Id, "1", 3, QiBoundaryType.ExactOrCalculated); Console.WriteLine("Default (Continuous) stream behavior, requesting data starting at index location '1', Qi will interpolate this value:"); foreach (var value in retrieved) { Console.WriteLine($"Order: {value.Order}, Radians: {value.Radians}"); } Console.WriteLine(); // create a Discrete stream behavior var behavior = new QiStreamBehavior { Id = behaviorId, Mode = QiStreamMode.Discrete }; behavior = await metadataService.GetOrCreateBehaviorAsync(behavior); // update the stream stream.BehaviorId = behavior.Id; await metadataService.CreateOrUpdateStreamAsync(stream); retrieved = await dataService .GetRangeValuesAsync <WaveData>(stream.Id, "1", 3, QiBoundaryType.ExactOrCalculated); Console.WriteLine("Discrete stream behavior, Qi does not interpolate and returns the data starting at the next index location containing data:"); foreach (var value in retrieved) { Console.WriteLine($"Order: {value.Order}, Radians: {value.Radians}"); } Console.WriteLine(); // Stream views Console.WriteLine("QiViews"); // create target types var targetType = QiTypeBuilder.CreateQiType <WaveDataTarget>(); targetType.Id = targetTypeId; var targetIntType = QiTypeBuilder.CreateQiType <WaveDataInteger>(); targetIntType.Id = targetIntTypeId; await metadataService.CreateOrUpdateTypeAsync(targetType); await metadataService.CreateOrUpdateTypeAsync(targetIntType); // create views var autoView = new QiView() { Id = autoViewId, SourceTypeId = typeId, TargetTypeId = targetTypeId }; // create explicit mappings var vp1 = new QiViewProperty() { SourceId = "Order", TargetId = "OrderTarget" }; var vp2 = new QiViewProperty() { SourceId = "Sin", TargetId = "SinInt" }; var vp3 = new QiViewProperty() { SourceId = "Cos", TargetId = "CosInt" }; var vp4 = new QiViewProperty() { SourceId = "Tan", TargetId = "TanInt" }; var manualView = new QiView() { Id = manualViewId, SourceTypeId = typeId, TargetTypeId = targetIntTypeId, Properties = new List <QiViewProperty>() { vp1, vp2, vp3, vp4 } }; await metadataService.CreateOrUpdateViewAsync(autoView); await metadataService.CreateOrUpdateViewAsync(manualView); Console.WriteLine("Here is some of our data as it is stored on the server:"); foreach (var evnt in retrieved) { Console.WriteLine($"Sin: {evnt.Sin}, Cos: {evnt.Cos}, Tan {evnt.Tan}"); } Console.WriteLine(); // get autoview data var autoViewData = await dataService.GetRangeValuesAsync <WaveDataTarget>(stream.Id, "1", 3, QiBoundaryType.ExactOrCalculated, autoViewId); Console.WriteLine("Specifying a view with a QiType of the same shape returns values that are automatically mapped to the target QiType's properties:"); foreach (var value in autoViewData) { Console.WriteLine($"SinTarget: {value.SinTarget} CosTarget: {value.CosTarget} TanTarget: {value.TanTarget}"); } Console.WriteLine(); // get manaulview data Console.WriteLine("QiViews can also convert certain types of data, here we return integers where the original values were doubles:"); var manualViewData = await dataService.GetRangeValuesAsync <WaveDataInteger>(stream.Id, "1", 3, QiBoundaryType.ExactOrCalculated, manualViewId); foreach (var value in manualViewData) { Console.WriteLine($"SinInt: {value.SinInt} CosInt: {value.CosInt} TanInt: {value.TanInt}"); } Console.WriteLine(); // get QiViewMap Console.WriteLine("We can query Qi to return the QiViewMap for our QiView, here is the one generated automatically:"); var autoViewMap = await metadataService.GetViewMapAsync(autoViewId); PrintViewMapProperties(autoViewMap); Console.WriteLine("Here is our explicit mapping, note QiViewMap will return all properties of the Source Type, even those without a corresponding Target property:"); var manualViewMap = await metadataService.GetViewMapAsync(manualViewId); PrintViewMapProperties(manualViewMap); // delete values Console.WriteLine("Deleting values from the QiStream"); // delete one event await dataService.RemoveValueAsync(stream.Id, 0); // delete all events await dataService.RemoveWindowValuesAsync(stream.Id, 1, 200); retrieved = await dataService.GetWindowValuesAsync <WaveData>(stream.Id, "0", "200"); if (retrieved.ToList <WaveData>().Count == 0) { Console.WriteLine("All values deleted successfully!"); } Console.WriteLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { Console.WriteLine("Cleaning up"); // Delete the stream, types, views and behavior Console.WriteLine("Deleteing stream"); await metadataService.DeleteStreamAsync(streamId); Console.WriteLine("Deleteing types"); await metadataService.DeleteTypeAsync(typeId); await metadataService.DeleteTypeAsync(targetTypeId); await metadataService.DeleteTypeAsync(targetIntTypeId); Console.WriteLine("Deleteing views"); await metadataService.DeleteViewAsync(autoViewId); await metadataService.DeleteViewAsync(manualViewId); Console.WriteLine("Deleteing behavior"); await metadataService.DeleteBehaviorAsync(behaviorId); Console.WriteLine("done"); Console.ReadKey(); } }
internal static QiType TypeTupleOf(QiType[] qiTypes) => new QiType(qi_type_tuple_of( qiTypes.Length, qiTypes.Select(q => q.Handle).ToArray() ));
internal static QiType GetMapKeyType(QiType mapType) => new QiType(qi_type_get_key(mapType.Handle));
internal static int GetTupleCount(QiType tupleType) => qi_type_get_element_count(tupleType.Handle);
internal static IEnumerable<QiType> GetTupleTypes(QiType tupleType) => Enumerable .Range(0, GetTupleCount(tupleType)) .Select(i => GetTupleTypeAt(tupleType, i));
static void Main(string[] args) { Console.WriteLine("Creating a .NET Qi Client..."); string server = ConfigurationManager.AppSettings["QiServerUrl"]; QiType evtType = null; // acquire an authentication token from Azure AD string token = AcquireAuthToken(); // set up a client to the Qi Service -- it is essential that you set the QiTenant header QiHttpClientFactory <IQiServer> clientFactory = new QiHttpClientFactory <IQiServer>(); clientFactory.ProxyTimeout = new TimeSpan(0, 1, 0); clientFactory.OnCreated((p) => p.DefaultHeaders.Add("Authorization", new AuthenticationHeaderValue("Bearer", token).ToString())); IQiServer qiclient = clientFactory.CreateChannel(new Uri(server)); try { // Create a Qi Type -- the Qi Libraries let you do this via reflection // First, create a type builder, then pass it the name of the class you are using for events. // This greatly simplifies type creation Console.WriteLine("Creating a Qi type for WaveData instances"); QiTypeBuilder typeBuilder = new QiTypeBuilder(); evtType = typeBuilder.Create <WaveData>(); evtType.Id = "WaveType"; QiType tp = qiclient.GetOrCreateType(evtType); Console.WriteLine("Creating a stream in this tenant for simple event measurements"); QiStream sampleStream = new QiStream(); sampleStream.Name = "evtStream"; sampleStream.Id = "evtStream"; // set the TypeId property to the value of the Id property of the type you submitted // All events submitted to this stream must be of this type // Note there are Async versions of the client methods, too, using .NET TPL sampleStream.TypeId = tp.Id; sampleStream.Description = "This is a sample stream for storing WaveData type measurements"; QiStream strm = qiclient.GetOrCreateStream(sampleStream); #region CRUD Operations #region Create Events (Insert) Console.WriteLine("Artificially generating 100 events and inserting them into the Qi Service"); // How to insert a single event TimeSpan span = new TimeSpan(0, 1, 0); WaveData evt = WaveData.Next(span, 2.0, 0); qiclient.InsertValue("evtStream", evt); List <WaveData> events = new List <WaveData>(); // how to insert an a collection of events for (int i = 2; i < 200; i += 2) { WaveData newEvt = WaveData.Next(span, 2.0, i); events.Add(newEvt); Thread.Sleep(400); } qiclient.InsertValues <WaveData>("evtStream", events); Thread.Sleep(2000); #endregion #region Retrieve events for a time range // use the round trip formatting for time Console.WriteLine("Retrieving the inserted events"); Console.WriteLine("=============================="); IEnumerable <WaveData> foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); #endregion #region Update an event Console.WriteLine(); Console.WriteLine("Updating values"); // take the first value inserted and update the value using a multiplier of 4, while retaining the order evt = foundEvts.First <WaveData>(); evt = WaveData.Next(span, 4.0, evt.Order); qiclient.UpdateValue <WaveData>("evtStream", evt); // update the collection of events (same span, multiplier of 4, retain order) List <WaveData> newEvents = new List <WaveData>(); foreach (WaveData evnt in events) { WaveData newEvt = WaveData.Next(span, 4.0, evnt.Order); newEvents.Add(newEvt); Thread.Sleep(500); } qiclient.UpdateValues <WaveData>("evtStream", newEvents); Thread.Sleep(2000); Console.WriteLine("Retrieving the updated values"); Console.WriteLine("============================="); foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); // illustrate how stream behaviors modify retrieval // First, pull three items back with GetRangeValues for range values between events. // The default behavior is continuous, so ExactOrCalculated should bring back interpolated values Console.WriteLine(); Console.WriteLine(@"Retrieving three events without a stream behavior"); foundEvts = qiclient.GetRangeValues <WaveData>("evtStream", "1", 0, 3, false, QiBoundaryType.ExactOrCalculated); DumpEvents(foundEvts); // now, create a stream behavior with Discrete and attach it to the existing stream QiStreamBehavior behavior = new QiStreamBehavior(); behavior.Id = "evtStreamStepLeading"; behavior.Mode = QiStreamMode.StepwiseContinuousLeading; behavior = qiclient.GetOrCreateBehavior(behavior); // update the stream to include this behavior sampleStream.BehaviorId = behavior.Id; qiclient.UpdateStream("evtStream", sampleStream); // repeat the retrieval Console.WriteLine(); Console.WriteLine("Retrieving three events with a stepwise stream behavior in effect -- compare to last retrieval"); foundEvts = qiclient.GetRangeValues <WaveData>("evtStream", "1", 0, 3, false, QiBoundaryType.ExactOrCalculated); DumpEvents(foundEvts); #endregion #region Delete events Console.WriteLine(); Console.WriteLine("Deleting events"); qiclient.RemoveValue <int>("evtStream", 0); qiclient.RemoveWindowValues <int>("evtStream", 2, 198); Thread.Sleep(2000); Console.WriteLine("Checking for events"); Console.WriteLine("==================="); foundEvts = qiclient.GetWindowValues <WaveData>("evtStream", "0", "198"); DumpEvents(foundEvts); #endregion #endregion } catch (QiHttpClientException qiex) { Console.WriteLine("Error in Qi Service Client: " + qiex.Message); } catch (Exception ex) { Console.WriteLine("Other error: " + ex.Message); } finally { // clean up all created entities so you can run this again // all entities are reference counted, so you must delete the stream, then the type it uses try { qiclient.DeleteStream("evtStream"); qiclient.DeleteBehavior("evtStreamStepLeading"); qiclient.DeleteType(evtType.Id); } catch (Exception) { } } }