diff update_stag_database.py @ 7:75ae6c480918 draft

Uploaded
author greg
date Mon, 18 Jan 2021 13:52:55 +0000
parents c34d08494c35
children e3d8b5bfdc11
line wrap: on
line diff
--- a/update_stag_database.py	Wed Nov 11 18:26:15 2020 +0000
+++ b/update_stag_database.py	Mon Jan 18 13:52:55 2021 +0000
@@ -310,7 +310,7 @@
                 except Exception:
                     # Insert a row into the colony table.
                     cmd = "INSERT INTO colony VALUES (nextval('colony_id_seq'), %s, %s, %s, %s, %s, %s) RETURNING id;"
-                    args = ['NOW()', 'NOW()', longitude, latitude, depth, reef_id]
+                    args = ['NOW()', 'NOW()', latitude, longitude, depth, reef_id]
                     cur = self.update(cmd, args)
                     self.flush()
                     colony_id = cur.fetchone()[0]