title: MySQL query with Python/Flask
body: <p>Just got back to a stalled project.  I'm learning Python (with Flask) and playing with a script that uses a bit of MySQL as well.</p>
  
  <p>I've got some Python running on a Raspberry Pi that detects bluetooth to see if people are in or out.  This writes to a MySQL table and works fine.</p>
  
  <p>I'm trying to read rows back and currently using this:</p>
  
  <pre><code>conn = MySQLdb.connect(host="localhost", user = "xxxxxxx", passwd = "xxxxxxxx", db = "mydb")
                  cursor = conn.cursor()
                  cursor.execute("select status from occupants WHERE id = '1'")
                  data = cursor.fetchall()
                  conn.commit()
                  if (data[0] == "In"):
                      result = "In"
  </code></pre>
  
  <p>In my template file I have this:</p>
  
  <pre><code>{% if result == "In" %}
     Do stuff
  {% else %}
     Do other stuff
  </code></pre>
  
  <p>result is always "None" at the moment... probably due to:</p>
  
  <pre><code>def index(iframe=None, result=None, targettemp=None, status=None, inttemp=None, result1=None, result2=None, result3=None, hiveSessionId=None):
  </code></pre>
  
  <p>I've done a load of searching but I don't even know if I'm searching for the right thing.</p>
  
  <p>Is this just so horribly wrong that it's not worth saving, or is it a simple mistake?</p>
  
  <p>EDIT:  This is the whole route in my Python script:</p>
  
  <p>I've changed one bit which is just to set the results to 1.  This just tests that they are being passed through to the template, which works.  I've also added an else to result.  So now when I look at my output, it displays "Blah" which proves that result != "In" even though I can see that it is in the MySQL table.</p>
  
  <pre><code>@app.route('/')
  def index(iframe=None, result=None, targettemp=None, status=None, inttemp=None, result1=None, result2=None, result3=None, hiveSessionId=None):
          import requests
          import bluetooth
          import time
          import datetime
          import MySQLdb
      iframe = "http://xx.xx.xx.xx:xxxx/cam/min.php"
      url = "https://api.prod.bgchprod.info:443/omnia/users"
          if 'hiveSessionId' in session:
                  hiveSessionId = session['hiveSessionId']
                  headers = {
                      'Content-Type': "application/vnd.alertme.zoo-6.1+json",
                      'Accept': "application/vnd.alertme.zoo-6.1+json",
                      'X-Omnia-Client': "Hive Web Dashboard",
                      'X-Omnia-Access-Token': hiveSessionId,
                      'Cache-Control': "no-cache"
                      }
                  response = requests.request("GET", url, headers=headers)
                  data=response.json()
                  if 'errors' in data:
                          return redirect(url_for('hivelogin'))
                  conn = MySQLdb.connect(host="localhost", user = "xxxxx", passwd = "xxxxxx", db = "mydb")
                  cursor = conn.cursor()
                  cursor.execute("select status from occupants WHERE id = '1'")
                  data = cursor.fetchall()
                  conn.commit()
                  if (data[0] == "In"):
                      result = "In"
                  else:
                      result = "Blah"
                  result1 = 1
                  result2 = 1
                  result3 = 1
  
          url = "https://api-prod.bgchprod.info:443/omnia/nodes/0e5f20fb-ab13-4d43-89ed-ec2481ea9012"
                  payload = "{\n    \"nodes\": [{\n        \"attributes\": {\n            \"state\": {\"targetValue\": \"OFF\"}\n        }\n    }]\n}"
                  headers = {
                  'Content-Type': "application/vnd.alertme.zoo-6.1+json",
                  'Accept': "application/vnd.alertme.zoo-6.1+json",
                  'X-Omnia-Client': "Hive Web Dashboard",
                  'X-Omnia-Access-Token': hiveSessionId,
                  'Cache-Control': "no-cache",
          }
                  responsetemp = requests.request("PUT", url, data=payload, headers=headers)
                  data=responsetemp.json()
                  inttemp  = (data['nodes'][0]['attributes']['temperature']['reportedValue'])
                  inttemp = round(inttemp,1)
          targettemp  = (data['nodes'][0]['attributes']['targetHeatTemperature']['reportedValue'])
          status  = (data['nodes'][0]['attributes']['stateHeatingRelay']['reportedValue'])
          return render_template('inout.html', iframe=iframe, status=status, targettemp=targettemp, inttemp=inttemp, hiveSessionId=hiveSessionId, result=result, result1=result1, result2=result2, result3=result3)
          return redirect(url_for('hivelogin'))
  </code></pre>