Alexa + home energy efficiency + big data

welcome: |
    Welcome to the Alexa Skills Kit sample. Please tell what do you need by
    saying, give me a report of valdivia

send_report: |
    I now know that you need a report of {{ city }}. let me check it
    
welcome_reprompt: Please tell me your favorite city by saying, my favorite city is red

known_city: |
    I now know that your favorite city is {{ city }}. You can ask me your favorite city
    by saying, what's my favorite city?

known_city_reprompt: You can ask me your favorite city by saying, what's my favorite city?

known_temp: |
    the temperature in {{ city }} is {{ temp }} degrees celsius. do you need other information?
    
#all_temp_report
all_temp_report: |  
    {% for row in DataAll %}
        the temperature in {{ row[1] }} is {{ row[2] }} degrees celsius.
        the Co2 in {{ row[1] }} is {{ row[3] }} data.
        the humidity in {{ row[1] }} is {{ row[4] }} data.
        report at {{ row[5] }}.
    {% endfor %}
    this is all resume, do you need other information?
all_temp_report_splunk: |
        the temperature in Valdivia detected by Arduino is {{ DataAll[0] }} degrees celsius.
        the Co2 is {{ DataAll[1] }} percent.
        the humidity is {{ DataAll[2] }} percent.
        the heat index is {{ DataAll[3] }} percent.
        this is all resume, do you need other information?
    
known_temp_reprompt: You can ask me your favorite color by saying, what's my favorite color?

known_city_bye: Your favorite city is {{ city }}. Goodbye

unknown_city: I'm not sure what your favorite city is, please try again

unknown_city_reprompt: |
    I'm not sure what your favorite city is. You can tell me your favorite city by saying,
    my favorite city is red
card_title: Session    
round: Can you give me the number?

win: Good job Joel, have you found the key!

lose: Sorry, that's the wrong answer.

#!/bin/bash 
# Descripcion: Script para capturar informacion
/usr/local/bin/python2.7 /opt/splunk/bin/scripts/sdk.py

import logging
import mysql.connector
import subprocess
from subprocess import Popen, PIPE

from random import randint

from flask import Flask, render_template

from flask_ask import Ask, statement, question, session


app = Flask(__name__)

ask = Ask(app, "/")

logging.getLogger("flask_ask").setLevel(logging.DEBUG)


def connectDB(city):

		conn = mysql.connector.connect(
				 user='root',
				 password='telsur',
				 host='127.0.0.1',
				 database='alexa')

		cur = conn.cursor()

		query = ("SELECT * FROM dataArduino where city ='%s'") % (city)

		cur.execute(query)

		# fetch all of the rows from the query
		data = cur.fetchall ()

		# print the rows
		for row in data :
			temp = row[2]

		cur.close()
		conn.close()

		return temp

def connectDBAll():

		conn = mysql.connector.connect(
				 user='root',
				 password='telsur',
				 host='127.0.0.1',
				 database='alexa')

		cur = conn.cursor()

		query = ("SELECT * FROM dataArduino") 

		cur.execute(query)

		# fetch all of the rows from the query
		data = cur.fetchall ()

		cur.close()
		conn.close()

		return data		

def connectSplunk():

	s = Popen(['/opt/splunk/bin/scripts/shellScript.sh'], stdin=PIPE, stdout=PIPE, stderr=PIPE)
	input = 'España'
	output, errs = s.communicate(input.encode())
	output, errs = output.decode(), errs.decode()
	output = output.replace("\n", " ")
	return output
		
		
CITY_KEY = "CITY"


@ask.launch

def new_game():

    welcome_msg = render_template('welcome')

    return question(welcome_msg)


@ask.intent('MyCityIsIntent', mapping={'city': 'City'})
def my_city_is(city):
	card_title = render_template('card_title')
	if city is not None:
		session.attributes[CITY_KEY] = city
		temp = connectDB(city)
		question_text = render_template('known_temp',city=city, temp=temp)
		reprompt_text = render_template('known_temp_reprompt')
	else:
		question_text = render_template('unknown_city')
		reprompt_text = render_template('unknown_city_reprompt')
	return question(question_text).reprompt(reprompt_text).simple_card(card_title, question_text)
	
'''
@ask.intent("YesIntent")

def YesIntent():

	#winning_numbers = session.attributes['numbers']
	DataAll = connectDBAll()
	question_text = render_template('all_temp_report',DataAll=DataAll)
	# print the rows
	return statement(question_text)
'''	
@ask.intent("YesIntent")

def YesIntent():

	#winning_numbers = session.attributes['numbers']
	DataAll = connectSplunk()
	DataAll = DataAll.replace("[", "")
	DataAll = DataAll.replace("]", "")
	DataAll = DataAll.replace(" ' ", "")
	DataAll = DataAll.split(",")
	question_text = render_template('all_temp_report_splunk',DataAll=DataAll)
	# print the rows
	return statement(question_text)
	
@ask.intent('WhatsMyColorIntent')
def whats_my_color():
    card_title = render_template('card_title')
    color = session.attributes.get(COLOR_KEY)
    if color is not None:
        statement_text = render_template('known_color_bye', color=color)
        return statement(statement_text).simple_card(card_title, statement_text)
    else:
        question_text = render_template('unknown_color_reprompt')
        return question(question_text).reprompt(question_text).simple_card(card_title, question_text)	

@ask.intent("AnswerIntent" , convert={'first': int})

def answer(first):

    #winning_numbers = session.attributes['numbers']

    if first == 2:

        msg = render_template('win')

    else:

        msg = render_template('lose')

    return statement(msg)



	
if __name__ == '__main__':

    app.run(debug=True)

{
  "intents": [
    {
      "slots": [
        {
          "name": "City",
          "type": "LIST_OF_CITY"
        },
        {
          "name": "temp",
          "type": "AMAZON.NUMBER"
        }
      ],
      "intent": "MyCityIsIntent"
    },
    {
      "intent": "WhatsMyCityIntent"
    },
    {
      "intent": "YesIntent"
    }
  ]
}