X-Git-Url: https://git.rvb.name/pyrungps.git/blobdiff_plain/50682c1f7ad6f88896b241d11ab47b57c49364d2..efbf2acd157a4b92e2de85da4879ec7b34af18d8:/parsegpx.py diff --git a/parsegpx.py b/parsegpx.py index 5247c27..25161c8 100644 --- a/parsegpx.py +++ b/parsegpx.py @@ -6,10 +6,18 @@ import os from lxml import etree from urllib2 import unquote import pygpx -import pyosmname +import pygeocode import sqlite3 import datetime +def check_db_for_training(db,sport,timestamp): + + conn = sqlite3.connect(db) + cur = conn.cursor() + + cur.execute ("select count(*) from tracks where sport=? and start_time=?" , (sport,timestamp)) + return cur.fetchall()[0][0] + def write_parsed_to_db(db,gpx,filename): conn = sqlite3.connect(db) @@ -44,7 +52,7 @@ def write_parsed_to_db(db,gpx,filename): print "processing..." start = track.start() if start: - printable = pyosmname.GeoName(start.lat,start.lon).printable + printable = pygeocode.GeoName(start.lat,start.lon).printable start_time = track.start_time() full_duration = track.full_duration().total_seconds() distance = track.distance()