# HG changeset patch
# User greg
# Date 1568983327 14400
# Node ID 681d8497a691e751e1158ecf79950058524e6651
# Parent  f0c4f7f2ecd4116a833882d9c7f6b1c7509f4056
Uploaded

diff -r f0c4f7f2ecd4 -r 681d8497a691 update_stag_database.py
--- a/update_stag_database.py	Mon Aug 19 13:26:54 2019 -0400
+++ b/update_stag_database.py	Fri Sep 20 08:42:07 2019 -0400
@@ -296,7 +296,7 @@
                 else:
                     latitude = DEFAULT_MISSING_NUMERIC_VALUE
                     longitude = DEFAULT_MISSING_NUMERIC_VALUE
-                depth = handle_column_value(items[2], get_sql_param=False, default=-9)
+                depth = handle_column_value(items[2], get_sql_param=False, default=-9.0)
                 reef_id = self.reef_ids[id_index]
                 # See if we need to add a row to the table.
                 cmd = "SELECT id FROM colony WHERE latitude = %s " % latitude
@@ -562,7 +562,7 @@
                 user_specimen_id = items[3]
                 affy_id = handle_column_value(items[0], get_sql_param=False, default="%s_%s" % (sample_id, user_specimen_id))
                 registry_id = handle_column_value(items[4], get_sql_param=False, default=-9)
-                depth = handle_column_value(items[5], get_sql_param=False, default=-9)
+                depth = handle_column_value(items[5], get_sql_param=False, default=-9.0)
                 dna_extraction_method = handle_column_value(items[6], get_sql_param=False)
                 dna_concentration = handle_column_value(items[7], get_sql_param=False)
                 public = items[8]