diff options
Diffstat (limited to 'tools/mmd/MmdDb.py')
-rw-r--r-- | tools/mmd/MmdDb.py | 9 |
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 () |