summaryrefslogtreecommitdiff
path: root/tools/mmd/MmdDb.py
diff options
context:
space:
mode:
Diffstat (limited to 'tools/mmd/MmdDb.py')
-rw-r--r--tools/mmd/MmdDb.py9
1 files changed, 9 insertions, 0 deletions
diff --git a/tools/mmd/MmdDb.py b/tools/mmd/MmdDb.py
index 7d915cf..74b11bd 100644
--- a/tools/mmd/MmdDb.py
+++ b/tools/mmd/MmdDb.py
@@ -113,6 +113,15 @@ class Db:
self.cursor.execute ('DELETE FROM location WHERE id=?', (location_id,))
self.conn.commit ()
+ # satellite methods
+ def satelliteGetLatestSSP (self):
+ self.cursor.execute ('SELECT * FROM ssps ORDER BY timestamp DESC')
+ return self.cursor.fetchone ()
+
+ def satelliteInsertNewSSP (self, timestamp, longitude, latitude):
+ self.cursor.execute ('INSERT INTO ssps (timestamp, longitude, latitude) VALUES (?,?,?)', (timestamp, longitude, latitude,))
+ self.conn.commit ()
+
def close (self):
self.cursor.close ()
self.conn.close ()