def flat_complete_data_row(cls, ser):
return (
ser['id'],
ser['url'],
ser['name'],
'|'.join([d['name'] for d in ser['effects']]),
ser['system'],
ser['organ'],
ser['effect'],
ser['effect_subtype'],
ser['observation_time'],
ser['observation_time_units'],
ser['observation_time_text'],
ser['data_location'],
ser['response_units'],
ser['data_type'],
ser['variance_name'],
ser['confidence_interval'],
ser['data_reported'],
ser['data_extracted'],
ser['values_estimated'],
ser['expected_adversity_direction_text'],
ser['monotonicity'],
ser['statistical_test'],
ser['trend_value'],
ser['trend_result'],
ser['diagnostic'],
ser['power_notes'],
cleanHTML(ser['results_notes']),
cleanHTML(ser['endpoint_notes']),
json.dumps(ser['additional_fields']),
)
def flat_complete_data_row(ser):
return (
ser['id'],
ser['url'],
ser['name'],
'|'.join([d['name'] for d in ser['effects']]),
ser['system'],
ser['organ'],
ser['effect'],
ser['effect_subtype'],
ser['observation_time'],
ser['observation_time_units'],
ser['observation_time_text'],
ser['data_location'],
ser['response_units'],
ser['data_type'],
ser['variance_name'],
ser['confidence_interval'],
ser['data_reported'],
ser['data_extracted'],
ser['values_estimated'],
ser['expected_adversity_direction_text'],
ser['monotonicity'],
ser['statistical_test'],
ser['trend_value'],
ser['trend_result'],
ser['diagnostic'],
ser['power_notes'],
cleanHTML(ser['results_notes']),
cleanHTML(ser['endpoint_notes']),
json.dumps(ser['additional_fields']),
)
def flat_complete_data_row(ser):
return (ser['id'], ser['url'], ser['short_citation'],
ser['full_citation'], ser['coi_reported'], ser['coi_details'],
ser['funding_source'], ser['bioassay'], ser['epi'],
ser['epi_meta'], ser['in_vitro'], ser['study_identifier'],
ser['contact_author'], ser['ask_author'],
cleanHTML(ser['summary']), ser['published'])
def flat_complete_data_row(ser):
return (ser['id'], ser['url'], ser['name'], ser['type'],
ser['chemical'], ser['cas'], ser['chemical_source'],
ser['purity_available'], ser['purity_qualifier'],
ser['purity'], ser['vehicle'], ser['diet'],
ser['litter_effects'], ser['litter_effect_notes'],
ser['guideline_compliance'], cleanHTML(ser['description']))
def flat_complete_data_row(cls, ser):
return (ser['id'], ser['url'], ser['name'], ser['sex'],
ser['animal_source'], ser['lifestage_exposed'],
ser['lifestage_assessed'], ser['duration_observation'],
cls.get_relation_id(ser['siblings']),
'|'.join([cls.get_relation_id(p)
for p in ser['parents']]), ser['generation'],
cleanHTML(ser['comments']), ser['species'], ser['strain'])
def flat_complete_data_row(ser):
return (
ser['id'],
AnimalGroup.getRelatedAnimalGroupID(ser['dosed_animals']),
ser['route_of_exposure'],
ser['duration_exposure'],
ser['duration_exposure_text'],
ser['num_dose_groups'],
ser['positive_control'],
ser['negative_control'],
cleanHTML(ser['description']),
)
def flat_complete_data_row(ser):
return (
ser['id'],
AnimalGroup.get_relation_id(ser['dosed_animals']),
ser['route_of_exposure'],
ser['duration_exposure'],
ser['duration_exposure_text'],
ser['num_dose_groups'],
ser['positive_control'],
ser['negative_control'],
cleanHTML(ser['description']),
)
def flat_complete_data_row(ser):
return (
ser['metric']['domain']['id'],
ser['metric']['domain']['name'],
ser['metric']['domain']['description'],
ser['metric']['id'],
ser['metric']['metric'],
ser['metric']['description'],
ser['id'],
ser['score'],
ser['score_description'],
cleanHTML(ser['notes']),
)
def flat_complete_data_row(ser):
return (
ser['metric']['domain']['id'],
ser['metric']['domain']['name'],
ser['metric']['domain']['description'],
ser['metric']['id'],
ser['metric']['name'],
ser['metric']['description'],
ser['id'],
ser['score'],
ser['score_description'],
cleanHTML(ser['notes']),
)
def flat_complete_data_row(ser):
return (
ser["metric"]["domain"]["id"],
ser["metric"]["domain"]["name"],
ser["metric"]["domain"]["description"],
ser["metric"]["id"],
ser["metric"]["metric"],
ser["metric"]["description"],
ser["id"],
cleanHTML(ser["notes"]),
ser["score_description"],
ser["score"],
)
def flat_complete_data_row(cls, ser):
return (
ser["id"],
ser["url"],
ser["short_citation"],
ser["full_citation"],
ser["coi_reported"],
ser["coi_details"],
ser["funding_source"],
ser["study_type"],
ser["study_identifier"],
ser["contact_author"],
ser["ask_author"],
cleanHTML(ser["summary"]),
ser["published"],
)
def flat_complete_data_row(cls, ser):
return (
ser['id'],
ser['url'],
ser['short_citation'],
ser['full_citation'],
ser['coi_reported'],
ser['coi_details'],
ser['funding_source'],
ser['study_type'],
ser['study_identifier'],
ser['contact_author'],
ser['ask_author'],
cleanHTML(ser['summary']),
ser['published']
)
def flat_complete_data_row(cls, ser):
return (
ser['id'],
ser['url'],
ser['name'],
ser['sex'],
ser['animal_source'],
ser['lifestage_exposed'],
ser['lifestage_assessed'],
ser['duration_observation'],
cls.get_relation_id(ser['siblings']),
'|'.join([cls.get_relation_id(p) for p in ser['parents']]),
ser['generation'],
cleanHTML(ser['comments']),
ser['species'],
ser['strain']
)
def flat_complete_data_row(ser):
return (
ser['id'],
ser['url'],
ser['name'],
ser['type'],
ser['chemical'],
ser['cas'],
ser['chemical_source'],
ser['purity_available'],
ser['purity_qualifier'],
ser['purity'],
ser['vehicle'],
ser['diet'],
ser['litter_effects'],
ser['litter_effect_notes'],
ser['guideline_compliance'],
cleanHTML(ser['description'])
)
