Skip to content

Instantly share code, notes, and snippets.

View programmersommer's full-sized avatar

Alexej Sommer programmersommer

  • Capgemini
  • Ratingen
View GitHub Profile
@programmersommer
programmersommer / storing_data_to_db.cs
Created July 17, 2022 17:02
Getting data from IoT Hub and saving it into SQL database
#r "System.Configuration"
#r "System.Data"
#r "System.Data.SqlClient"
#r "Newtonsoft.Json"
using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Threading.Tasks;
using System.Net;
@programmersommer
programmersommer / aws_sketch.ino
Created June 9, 2020 16:26
Скетч для связи NodeMCU с AWS
// based on https://electronicsinnovation.com/how-to-connect-nodemcu-esp8266-with-aws-iot-core-using-arduino-ide-mqtt/
// install https://github.com/esp8266/arduino-esp8266fs-plugin and upload certificates
#include "FS.h"
#include <ESP8266WiFi.h>
#include <PubSubClient.h>
#include <NTPClient.h>
#include <WiFiUdp.h>
// Update these with values suitable for your network.
@programmersommer
programmersommer / savetosql.cs
Created April 19, 2018 19:09
Save from IoT hub to SQL Server database Azure function
#r "System.Configuration"
#r "System.Data"
#r "Newtonsoft.Json"
using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Threading.Tasks;
using System.Net;
using Newtonsoft.Json;
@programmersommer
programmersommer / generateSASfunction
Created April 7, 2018 14:18
Azure Function as Token service
using System.Net;
using Microsoft.Azure.Devices;
using Microsoft.Azure.Devices.Common.Security;
using System.Globalization;
using System.Security.Cryptography;
using System.Text;
public static async Task<HttpResponseMessage> Run(HttpRequestMessage req, TraceWriter log)
{
string deviceid = req.GetQueryNameValuePairs()
@programmersommer
programmersommer / ArduinoAzure.c
Last active November 25, 2017 17:14
Arduino Azure IoT hub communications
// Define the Model
BEGIN_NAMESPACE(IoTSample);
DECLARE_MODEL
(LightSensorDataModel,
WITH_DATA(ascii_char_ptr, deviceId),
WITH_DATA(int, iotdata),
WITH_ACTION(DuckAction, int, light)
);
END_NAMESPACE(IoTSample);
#include <SPI.h>
#include <WiFi101.h>
unsigned long lastConnectionTime = 0;
const unsigned long pollingInterval = 2L * 1000L; // 5 sec polling delay, in milliseconds
// Generate SAS key using https://github.com/Azure/azure-iot-sdks/releases