Esempio n. 1
0
def write_location_to_log(imei , data):
    connection, cur = open_connection()
    
    row = {}
    row['imei'] = imei
    row['speed'] = gps_functions.get_speed(data)
    row['heading'] = gps_functions.get_heading(data)
    utm =  gps_functions.get_utm(data)
    row['utm_lat'] = utm[0]
    row['utm_long'] = utm[1]
    #Get unit id according to imei and add current locsation
    cur.execute("SELECT unit_id FROM unit WHERE imei ="+str(imei))
    unit_id = cur.fetchall()
    row['unit_id'] = str(unit_id[0]['unit_id'])
    row['timestamp'] = datetime.now()
    cur.execute("INSERT INTO `gpstracker`.`location_log` (`location_log_id`, `unit_id`, `timestamp`, `utm`, `speed`, `heading`) VALUES (NULL, '%(unit_id)s','%(timestamp)s', GeomFromText('POINT(%(utm_lat)s %(utm_long)s)',0), '%(speed)s', '%(heading)s');" % row)
    row['location_log_id'] = connection.insert_id() 
    cur.close()
    connection.close()
    return row
Esempio n. 2
0
import MySQLdb  
import gps_functions
from datetime import datetime  

                             
connection=MySQLdb.connect(host="127.0.0.1", user="******", passwd="amir", db="gpstracker")  
cur=connection.cursor() 

imei = '863070011991451'
data = 'imei:863070011991451,ac alarm,1301160114,,F,171446.000,A,3205.4899,N,03447.3367,E,0.00,,;'
speed = gps_functions.get_speed(data)
heading = gps_functions.get_heading(data) #problem while null
utm = gps_functions.get_utm(data)
#Get unit id according to imei and add current location
cur.execute("SELECT unit_id FROM unit WHERE imei ="+str(imei))
unit_id = cur.fetchall()
unit_id = str(unit_id[0][0])
timestamp = datetime.now()
print "unit_id: "+unit_id
print "utm: "+str(utm)
print "speed: "+str(speed)
print "heading: "+str(heading) 
cur.execute("INSERT INTO `gpstracker`.`location_log` (`location_log_id`, `unit_id`, `timestamp`, `utm`, `speed`, `heading`) VALUES (NULL, '"+unit_id+"','"+str(timestamp)+"', GeomFromText('POINT("+str(utm[0]) +' '+ str(utm[1])+")',0), '"+str(speed)+"', '"+str(heading)+"');")
############

cur.close()
connection.close()