Python

#!/usr/bin/python2.7
import serial
import re
import sys
import MySQLdb as mdb
import time

try:
    con = mdb.connect('localhost', 'root', 'rpistuff', 'plants')
    con.autocommit(1)

except mdb.Error, e:

    print "Error %d: %s" % (e.args[0],e.args[1])


ser = serial.Serial('/dev/arduino', 115200)
time.sleep(3)
insert = 0
while insert == 0:
    val = ser.readline()

    val = val.splitlines()[0]

    data = val.split('::')

    if len(data) == 2:
        data_top = data[0].split('-')
        data_bottom = data[1].split('-')

        cur = con.cursor()
        sql = """INSERT INTO data(data_place, temperature, humidity) values(%s, %s, %s)"""

        if len(data_top) == 2:
            cur.execute(sql, ('Top', data_top[1], data_top[0]))

        if len(data_bottom) == 2:
            cur.execute(sql, ('Bottom', data_bottom[1], data_bottom[0]))

        cur.close()
        ser.close()
        con.close();
        insert = 1
    else:
        f = open('/home/mf/pythonstuff/errors', 'a')
        f.write(val+"\n")
        f.close()
        con.close()
        sys.exit()