import paho.mqtt.client as mqtt
from Dbclass import Dbclass
import mysql.connector as connector

topic = "jumptie"
db = Dbclass()

def on_connect(client, userdate, flags, rc):
    print("Connected with result code " + str(rc))
    client.subscribe(topic)

def on_message(client, userdate, msg):
    if(msg.topic == topic):
        payload = str(msg.payload)
        #print(msg.topic + " - " + payload)
        payload = payload.replace("b","")
        payload = payload.replace("'","")
        #print("Received: " + payload)

        if(payload == "Jump"):
            db.updateSession()
            db.getSession()


client = mqtt.Client()
client.connect("192.168.0.100", 1883, 60)

client.on_connect = on_connect
client.on_message = on_message

client.loop_forever()