Open g-simmons opened 5 years ago
Getting the following error on pyctd.update():
pyctd.update()
DataError Traceback (most recent call last) <ipython-input-7-0bd0285b3ed5> in <module>() ----> 1 pyctd.update() /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in update(connection, urls, force_download) 451 """ 452 db = DbManager(connection) --> 453 db.db_import(urls=urls, force_download=force_download) 454 db.session.close() 455 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in db_import(self, urls, force_download) 177 self.download_urls(urls=urls, force_download=force_download) 178 self.create_all() --> 179 self.import_tables() 180 self.session.close() 181 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_tables(self, only_tables, exclude_tables) 233 if exclude_tables is not None and table.name in exclude_tables: 234 continue --> 235 self.import_table(table) 236 237 @classmethod /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_table(self, table) 289 ) 290 --> 291 self.import_table_in_db(file_path, use_columns_with_index, column_names_in_db, table) 292 293 for column_in_file, column_in_one2many_table in table.one_to_many: /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_table_in_db(self, file_path, use_columns_with_index, column_names_in_db, table) 391 392 table_with_prefix = defaults.TABLE_PREFIX + table.name --> 393 chunk.to_sql(name=table_with_prefix, if_exists='append', con=self.engine) 394 395 del chunks /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/core/generic.pyc in to_sql(self, name, con, schema, if_exists, index, index_label, chunksize, dtype, method) 2529 sql.to_sql(self, name, con, schema=schema, if_exists=if_exists, 2530 index=index, index_label=index_label, chunksize=chunksize, -> 2531 dtype=dtype, method=method) 2532 2533 def to_pickle(self, path, compression='infer', /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(frame, name, con, schema, if_exists, index, index_label, chunksize, dtype, method) 458 pandas_sql.to_sql(frame, name, if_exists=if_exists, index=index, 459 index_label=index_label, schema=schema, --> 460 chunksize=chunksize, dtype=dtype, method=method) 461 462 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(self, frame, name, if_exists, index, index_label, schema, chunksize, dtype, method) 1172 schema=schema, dtype=dtype) 1173 table.create() -> 1174 table.insert(chunksize, method=method) 1175 if (not name.isdigit() and not name.islower()): 1176 # check for potentially case sensitivity issues (GH7815) /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in insert(self, chunksize, method) 684 685 chunk_iter = zip(*[arr[start_i:end_i] for arr in data_list]) --> 686 exec_insert(conn, keys, chunk_iter) 687 688 def _query_iterator(self, result, chunksize, columns, coerce_float=True, /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in _execute_insert(self, conn, keys, data_iter) 597 """ 598 data = [dict(zip(keys, row)) for row in data_iter] --> 599 conn.execute(self.table.insert(), data) 600 601 def _execute_insert_multi(self, conn, keys, data_iter): /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, object_, *multiparams, **params) 986 raise exc.ObjectNotExecutableError(object_) 987 else: --> 988 return meth(self, multiparams, params) 989 990 def _execute_function(self, func, multiparams, params): /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/sql/elements.pyc in _execute_on_connection(self, connection, multiparams, params) 285 def _execute_on_connection(self, connection, multiparams, params): 286 if self.supports_execution: --> 287 return connection._execute_clauseelement(self, multiparams, params) 288 else: 289 raise exc.ObjectNotExecutableError(self) /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_clauseelement(self, elem, multiparams, params) 1105 distilled_params, 1106 compiled_sql, -> 1107 distilled_params, 1108 ) 1109 if self._has_events or self.engine._has_events: /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args) 1246 except BaseException as e: 1247 self._handle_dbapi_exception( -> 1248 e, statement, parameters, cursor, context 1249 ) 1250 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _handle_dbapi_exception(self, e, statement, parameters, cursor, context) 1464 util.raise_from_cause(newraise, exc_info) 1465 elif should_wrap: -> 1466 util.raise_from_cause(sqlalchemy_exception, exc_info) 1467 else: 1468 util.reraise(*exc_info) /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/util/compat.pyc in raise_from_cause(exception, exc_info) 396 exc_type, exc_value, exc_tb = exc_info 397 cause = exc_value if exc_value is not exception else None --> 398 reraise(type(exception), exception, tb=exc_tb, cause=cause) 399 400 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args) 1222 if not evt_handled: 1223 self.dialect.do_executemany( -> 1224 cursor, statement, parameters, context 1225 ) 1226 elif not parameters and context.no_parameters: /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyc in do_executemany(self, cursor, statement, parameters, context) 130 131 def do_executemany(self, cursor, statement, parameters, context=None): --> 132 rowcount = cursor.executemany(statement, parameters) 133 if context is not None: 134 context._rowcount = rowcount /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in executemany(self, query, args) 195 return self._do_execute_many(q_prefix, q_values, q_postfix, args, 196 self.max_stmt_length, --> 197 self._get_db().encoding) 198 199 self.rowcount = sum(self.execute(query, arg) for arg in args) /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in _do_execute_many(self, prefix, values, postfix, args, max_stmt_length, encoding) 227 v = v.encode(encoding, 'surrogateescape') 228 if len(sql) + len(v) + len(postfix) + 1 > max_stmt_length: --> 229 rows += self.execute(sql + postfix) 230 sql = bytearray(prefix) 231 else: /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in execute(self, query, args) 168 query = self.mogrify(query, args) 169 --> 170 result = self._query(query) 171 self._executed = query 172 return result /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in _query(self, q) 326 self._last_executed = q 327 self._clear_result() --> 328 conn.query(q) 329 self._do_get_result() 330 return self.rowcount /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in query(self, sql, unbuffered) 515 sql = sql.encode(self.encoding, 'surrogateescape') 516 self._execute_command(COMMAND.COM_QUERY, sql) --> 517 self._affected_rows = self._read_query_result(unbuffered=unbuffered) 518 return self._affected_rows 519 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in _read_query_result(self, unbuffered) 730 else: 731 result = MySQLResult(self) --> 732 result.read() 733 self._result = result 734 if result.server_status is not None: /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in read(self) 1073 def read(self): 1074 try: -> 1075 first_packet = self.connection._read_packet() 1076 1077 if first_packet.is_ok_packet(): /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in _read_packet(self, packet_type) 682 683 packet = packet_type(buff, self.encoding) --> 684 packet.check_error() 685 return packet 686 /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/protocol.pyc in check_error(self) 218 errno = self.read_uint16() 219 if DEBUG: print("errno =", errno) --> 220 err.raise_mysql_exception(self._data) 221 222 def dump(self): /Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/err.pyc in raise_mysql_exception(data) 107 errval = data[3:].decode('utf-8', 'replace') 108 errorclass = error_map.get(errno, InternalError) --> 109 raise errorclass(errno, errval) DataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'number_of_receptors' at row 1520") [SQL: INSERT INTO pyctd_exposure_event (id, stressor_source_category, stressor_source_details, number_of_stressor_samples, stress_or_notes, number_of_receptors, receptors, receptor_notes, smoking_status, age, age_units_of_measurement, age_qualifier, sex, race, methods, detection_limit, detection_limit_uom, detection_frequency, medium, exposure_marker, exposure_marker_id, marker_level, marker_units_of_measurement, marker_measurement_statistic, assay_notes, study_countries, state_or_province, city_town_region_area, exposure_event_notes, outcome_relationship, phenotype_name, phenotype_id, phenotype_action_degree_type, anatomy, exposure_outcome_notes, reference, associated_study_titles, enrollment_start_year, enrollment_end_year, study_factors, chemical__id, disease__id) VALUES (%(id)s, %(stressor_source_category)s, %(stressor_source_details)s, %(number_of_stressor_samples)s, %(stress_or_notes)s, %(number_of_receptors)s, %(receptors)s, %(receptor_notes)s, %(smoking_status)s, %(age)s, %(age_units_of_measurement)s, %(age_qualifier)s, %(sex)s, %(race)s, %(methods)s, %(detection_limit)s, %(detection_limit_uom)s, %(detection_frequency)s, %(medium)s, %(exposure_marker)s, %(exposure_marker_id)s, %(marker_level)s, %(marker_units_of_measurement)s, %(marker_measurement_statistic)s, %(assay_notes)s, %(study_countries)s, %(state_or_province)s, %(city_town_region_area)s, %(exposure_event_notes)s, %(outcome_relationship)s, %(phenotype_name)s, %(phenotype_id)s, %(phenotype_action_degree_type)s, %(anatomy)s, %(exposure_outcome_notes)s, %(reference)s, %(associated_study_titles)s, %(enrollment_start_year)s, %(enrollment_end_year)s, %(study_factors)s, %(chemical__id)s, %(disease__id)s)] [parameters: ({'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '10th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 1, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '25th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 2, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '50th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 3, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '75th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 4, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '90th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 5, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '95th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 6, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '99th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 7, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 78.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '10th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 8, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'May 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '2.2', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'} ... displaying 10 of 142715 total bound parameter sets ... {'number_of_receptors': 132.0, 'anatomy': None, 'methods': 'inductively coupled plasma mass spectrometry', 'reference': 25151427.0, 'marker_units_of_measurement': None, 'number_of_stressor_samples': None, 'marker_measurement_statistic': 'median', 'age_units_of_measurement': None, 'associated_study_titles': None, 'study_factors': None, 'id': 142714, 'enrollment_start_year': None, 'city_town_region_area': 'Buxton Derbyshire', 'receptor_notes': 'Adults, occupationally unexposed', 'enrollment_end_year': None, 'smoking_status': None, 'receptors': 'Study subjects', 'exposure_marker': 'Zirconium', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United Kingdom', 'medium': 'urine', 'age_qualifier': None, 'exposure_marker_id': 'D015040', 'phenotype_id': None, 'exposure_event_notes': None, 'marker_level': '<LOQ', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': None, 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Environmental', 'detection_limit': '0.945', 'detection_frequency': '4.0', 'chemical__id': 170653, 'race': None, 'assay_notes': 'LOQ = three times the standard deviation of all blank samples run throughout analyses multiplied by dilution factor of urine sample (varied from 10 to 20)', 'age': None, 'detection_limit_uom': 'micrograms per liter'}, {'number_of_receptors': 132.0, 'anatomy': None, 'methods': 'inductively coupled plasma mass spectrometry', 'reference': 25151427.0, 'marker_units_of_measurement': None, 'number_of_stressor_samples': None, 'marker_measurement_statistic': 'median', 'age_units_of_measurement': None, 'associated_study_titles': None, 'study_factors': None, 'id': 142715, 'enrollment_start_year': None, 'city_town_region_area': 'Buxton Derbyshire', 'receptor_notes': 'Adults, occupationally unexposed', 'enrollment_end_year': None, 'smoking_status': None, 'receptors': 'Study subjects', 'exposure_marker': 'Zirconium', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United Kingdom', 'medium': 'urine', 'age_qualifier': None, 'exposure_marker_id': 'D015040', 'phenotype_id': None, 'exposure_event_notes': None, 'marker_level': '<LOQ', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': None, 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Environmental', 'detection_limit': '0.945', 'detection_frequency': '4.0', 'chemical__id': 170653, 'race': None, 'assay_notes': 'LOQ = three times the standard deviation of all blank samples run throughout analyses multiplied by dilution factor of urine sample (varied from 10 to 20)', 'age': None, 'detection_limit_uom': 'micrograms per liter'})] (Background on this error at: http://sqlalche.me/e/9h9h)
Getting the following error on
pyctd.update():