Hi everybody.
I search the right way to export a data from the autopi to mysql database. Because I have already a web app ready to work with.
It is for EV car, for now I just need the SoC (state of charge)
@Plord seem find the command who is something like that:
obd.query mode=220 pid=101 force=true
Then if the dongle answer, I want put the data to mysql.
So, I try to write in the autopi cloud this:
“my evdat script”
import serial
import MySQLdb
import re
import time
import string
import io
db = MySQLdb.connect(host=“External-IP :3307”, # your host, usually localhost
user=“user”, # your username
passwd=“Password”, # your password
db=“kona”) # name of the data base
cur = db.cursor()
ser = serial.Serial("/dev/rfcomm0", timeout=None)
ser.baudrate = 9600
ser.flushInput()
ser.write(b’2105\r\n’)
ser.flush()
seq = []
while True:
reading = ser.read()
seq.append(reading)
joineddata = ’ ‘.join(str(v) for v in seq).replace(’ ', ‘’)
err = re.search('ERROR', joineddata)
if err:
break
m = re.search('4([^;]*)5:', joineddata) #'/4([^;]*)\n5', joineddata)
if m:
ser.close()
test = str(m.group(0))
x = (test[-8:])
SoC = (int( x[3:5], 16)/2)
if SoC > 0 & SoC <= 100:
print(SoC)
cur.execute("""INSERT INTO bms (soc) VALUES (%s)""", (SoC,) )
db.commit()
break
I don’t know if it is the right way to do it
Anyone know ?