Mercurial > repos > greg > update_stag_database
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]