Mercurial > repos > greg > update_stag_database
changeset 3:18a1fae17003 draft
Uploaded
| author | greg |
|---|---|
| date | Fri, 20 Sep 2019 09:17:54 -0400 |
| parents | 681d8497a691 |
| children | 852b9fd0e3cd |
| files | update_stag_database.py |
| diffstat | 1 files changed, 5 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/update_stag_database.py Fri Sep 20 08:42:07 2019 -0400 +++ b/update_stag_database.py Fri Sep 20 09:17:54 2019 -0400 @@ -537,7 +537,7 @@ # Columns in the sample file are: # affy_id colony_location collection_date user_specimen_id registry_id # depth dna_extraction_method dna_concentration public public_after_date - # percent_missing_data_coral percent_missing_data_sym percent_reference_coral percent_reference_sym percent_alternative_coral + # percent_missing_data_coral percent_missing_data_sym percent_acerv_coral percent_reference_sym percent_apalm_coral # percent_alternative_sym percent_heterozygous_coral percent_heterozygous_sym field_call, bcoral_genet_id sample_table_inserts = 0 with open(file_path) as fh: @@ -575,9 +575,9 @@ public_after_date = items[9] percent_missing_data_coral = handle_column_value(items[10], get_sql_param=False) percent_missing_data_sym = handle_column_value(items[11], get_sql_param=False) - percent_reference_coral = handle_column_value(items[12], get_sql_param=False) + percent_acerv_coral = handle_column_value(items[12], get_sql_param=False) percent_reference_sym = handle_column_value(items[13], get_sql_param=False) - percent_alternative_coral = handle_column_value(items[14], get_sql_param=False) + percent_apalm_coral = handle_column_value(items[14], get_sql_param=False) percent_alternative_sym = handle_column_value(items[15], get_sql_param=False) percent_heterozygous_coral = handle_column_value(items[16], get_sql_param=False) percent_heterozygous_sym = handle_column_value(items[17], get_sql_param=False) @@ -591,8 +591,8 @@ experiment_id, colony_id, colony_location, taxonomy_id, collector_id, collection_date, user_specimen_id, registry_id, depth, dna_extraction_method, dna_concentration, public, public_after_date, - percent_missing_data_coral, percent_missing_data_sym, percent_reference_coral, - percent_reference_sym, percent_alternative_coral, percent_alternative_sym, + percent_missing_data_coral, percent_missing_data_sym, percent_acerv_coral, + percent_reference_sym, percent_apalm_coral, percent_alternative_sym, percent_heterozygous_coral, percent_heterozygous_sym, field_call, bcoral_genet_id] cur = self.update(cmd, args) self.flush()