- changed ground track color to page background color

- started working on class Satellite
  - creating SSPs works
  - database contains table ssps (SubSatellitePoint) now


git-svn-id: https://svn.spreadspace.org/mur.sat@118 7de4ea59-55d0-425e-a1af-a3118ea81d4c

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 ()