def get_recorded_position():
from geojson import Feature, Point, FeatureCollection
from geojson import dumps as geo_dumps
conn = get_db()
res = conn.execute('SELECT * FROM position ORDER BY Timestamp')
features_list = []
for row in res:
feature = Feature(geometry=Point(
(row["longitude"], row["latitude"])),
properties={
"vin": row["vin"],
"date": row["Timestamp"],
"mileage": row["mileage"],
"level": row["level"]
})
features_list.append(feature)
feature_collection = FeatureCollection(features_list)
conn.close()
return geo_dumps(feature_collection, sort_keys=True)
def get_recorded_position():
conn = Database.get_db()
res = conn.execute('SELECT * FROM position ORDER BY Timestamp')
features_list = []
for row in res:
if row["longitude"] is None or row["latitude"] is None:
continue
feature = Feature(geometry=Point(
(row["longitude"], row["latitude"])),
properties={
"vin": row["vin"],
"date": row["Timestamp"].strftime("%x %X"),
"mileage": row["mileage"],
"level": row["level"],
"level_fuel": row["level_fuel"]
})
features_list.append(feature)
feature_collection = FeatureCollection(features_list)
conn.close()
return geo_dumps(feature_collection, sort_keys=True)
def get_recorded_position(self):
import sqlite3
from geojson import Feature, Point, FeatureCollection
from geojson import dumps as geo_dumps
conn = sqlite3.connect('info.db')
conn.row_factory = sqlite3.Row
res = conn.execute('SELECT * FROM position ORDER BY Timestamp')
features_list = []
for row in res:
print(row)
feature = Feature(geometry=Point(
(row["longitude"], row["latitude"])),
properties={
"vin": row["vin"],
"date": row["Timestamp"],
"mileage": row["mileage"],
"level": row["level"]
})
features_list.append(feature)
feature_collection = FeatureCollection(features_list)
return geo_dumps(feature_collection, sort_keys=True)