data-henrik

This flow uses the sipgate.io service of German phone company Sipgate to get notified about incoming calls. The from/to (who is calling which number) information is logged in a Cloudant database and a SMS is sent out using the Twilio service.

All was created on the IBM Bluemix service with a free trial account. http://bluemix.net

More information in this blog entry: http://blog.4loeser.net/2014/10/nodered-simple-phoney-json-entries-in.html

data-henrik

Flow to automatically respond to tweets in Twitter. If the tag "archive" is used, then the incoming tweet is stored in the DB2-based sqldb service. A simple Web service is provided to retrieve the archived tweets from DB2.

To work, the table "twitarchive" needs to be created.

create table twitarchive(
id int generated always as identity,
tstamp timestamp,
tweet varchar(200),
username varchar(100)

data-henrik

# for full example visit https://github.com/IBM-Cloud/github-traffic-stats/blob/master/backend/ghstats.py
# as part of this tutorial: https://console.bluemix.net/docs/tutorials/serverless-github-traffic-analytics.html


# import all kinds of modules

# this one is needed for the OIDC client
from flask_pyoidc.flask_pyoidc import OIDCAuthentication

# initialize Flask, etc.

data-henrik

# Masked wordcloud
# ================
# Using a mask you can generate wordclouds in arbitrary shapes.

import sys, getopt
from os import path
from PIL import Image
import numpy as np
import random
import matplotlib.pyplot as plt

data-henrik

From database into Watson Discovery

The code shown is a simple Python example of pulling data from a SQL database supported by SQLAlchemy, and then injecting the data as new JSON document into a collection of Watson Discovery Service on IBM Cloud.

data-henrik

# Simple test of the Db2 on Cloud REST API
# Written by Henrik Loeser, hloeser@de.ibm.com
# https://cloud.ibm.com/apidocs/db2-on-cloud
import requests, json, sys, time

# Read credentials from file
def readCreds(filename):
    with open(filename) as data_file:
        credentials = json.load(data_file)
    return credentials

data-henrik

Setup

Add this to your .profile, .bashrc, .zshrc...

BASE64_DECODER_PARAM="-d" # option -d for Linux base64 tool
echo AAAA | base64 -d > /dev/null 2>&1 || BASE64_DECODER_PARAM="-D" # option -D on MacOS

decode_base64_url() {
  local len=$((${#1} % 4))
  local result="$1"
 if [ $len -eq 2 ]; then result="$1"'=='

data-henrik

#!/bin/bash
#
# Obtain the necessary credentials from environment, encode them
# as base64 JSON and upload them a new key to IBM Cloud Key Protect
#
# The following software is used:
# - base64
# - ibmcloud: IBM Cloud CLI with Key Protect (kp) plugin

data-henrik

# IBM Cloud Functions / OpenWhisk action to 
# 1) obtain an IAM Bearer token based on API key from env
# 2) fetch credentials in JSON object from Key Protect key
# 3) return the arguments, credentials and token

import json,sys,os
import requests,base64

# obtain IAM access token 
def getAuthToken(api_key):

data-henrik

import ibm_db
import pandas as pd
import ibm_db_dbi as dbi
import json,sys,os

def db2test(iamKey,hostname):
    connstr="DATABASE=BLUDB;Authentication=GSSplugin;HOSTNAME={};PORT=50001;PROTOCOL=TCPIP;SECURITY=SSL;APIKEY={};".format(hostname,iamKey)
    conn1 = dbi.connect(connstr)
    # Quick test with Pandas and dataframe
    df = pd.read_sql("select count(*) from syscat.tables", conn1)