changeset 2:681d8497a691 draft

Uploaded
author greg
date Fri, 20 Sep 2019 08:42:07 -0400
parents f0c4f7f2ecd4
children 18a1fae17003
files update_stag_database.py
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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]