def sync_score_row(legacy_row): legacy_score_code = legacy_row[2] legacy_scorer = legacy_row[3] experiment = get_experiment(legacy_row[0], tile_to_well(legacy_row[1])) score_code = get_score_code(legacy_score_code) scorer = get_user(legacy_scorer) timestamp = get_timestamp_from_ymd(legacy_row[4], legacy_row[5]) if not timestamp: raise CommandError( 'ERROR: score of experiment {}, well {} ' 'could not be converted to a proper datetime' .format(legacy_row[0], legacy_row[1])) new_score = ManualScore( experiment=experiment, score_code=score_code, scorer=scorer, timestamp=timestamp) return update_or_save_object( command, new_score, recorded_scores, fields_to_compare, alternate_pk={'experiment': new_score.experiment, 'score_code': new_score.score_code, 'scorer': new_score.scorer, 'timestamp': new_score.timestamp})
def sync_score_row(legacy_row): legacy_score_code = legacy_row[2] legacy_scorer = legacy_row[3] experiment = get_experiment(legacy_row[0], tile_to_well(legacy_row[1])) score_code = get_score_code(legacy_score_code) scorer = get_user(legacy_scorer) timestamp = get_timestamp_from_ymd(legacy_row[4], legacy_row[5]) if not timestamp: raise CommandError( 'ERROR: score of experiment {}, well {} ' 'could not be converted to a proper datetime'.format( legacy_row[0], legacy_row[1])) new_score = ManualScore(experiment=experiment, score_code=score_code, scorer=scorer, timestamp=timestamp) return update_or_save_object(command, new_score, recorded_scores, fields_to_compare, alternate_pk={ 'experiment': new_score.experiment, 'score_code': new_score.score_code, 'scorer': new_score.scorer, 'timestamp': new_score.timestamp })
def sync_score_row(legacy_row): legacy_score_code = legacy_row[2] legacy_scorer = legacy_row[3] gene = legacy_row[9] screen = legacy_row[10] # Skip some scores entirely (see criteria above) skip_entirely = ('alejandro', 'katy') skip_ENH = ('eliana', 'lara') if ((legacy_scorer == 'Julie' and legacy_score_code != -2) or (legacy_scorer in skip_entirely) or (screen == 'ENH' and legacy_scorer in skip_ENH)): command.stderr.write( 'FYI: Skipping a {} {} score of {} by {}\n'.format( gene, screen, legacy_score_code, legacy_scorer)) return True # Convert some scorers to hueyling (see criteria above) if legacy_scorer == 'Julie' or legacy_scorer == 'expPeople': command.stderr.write( 'FYI: Converting a {} score by {} to hueyling\n'.format( legacy_score_code, legacy_scorer)) legacy_scorer = 'hueyling' # Convert some score codes (see criteria above) if legacy_score_code == -6: command.stderr.write('FYI: Converting score from -6 to -7\n') legacy_score_code = -7 # Following raise exceptions if improperly formatted or not found experiment = get_experiment(legacy_row[0], tile_to_well(legacy_row[1])) score_code = get_score_code(legacy_score_code) scorer = get_user(legacy_scorer) timestamp = get_timestamp(legacy_row[5], legacy_row[6], legacy_row[7], legacy_row[8], legacy_row[4]) if not timestamp: raise CommandError( 'ERROR: score of {} could not be converted to a proper ' 'datetime'.format(experiment)) new_score = ManualScore(experiment=experiment, score_code=score_code, scorer=scorer, timestamp=timestamp) return update_or_save_object(command, new_score, recorded_scores, fields_to_compare, alternate_pk={ 'experiment': new_score.experiment, 'score_code': new_score.score_code, 'scorer': new_score.scorer, 'timestamp': new_score.timestamp })
def sync_score_row(legacy_row): legacy_score_code = legacy_row[2] legacy_scorer = legacy_row[3] gene = legacy_row[9] screen = legacy_row[10] # Skip some scores entirely (see criteria above) skip_entirely = ('alejandro', 'katy') skip_ENH = ('eliana', 'lara') if ((legacy_scorer == 'Julie' and legacy_score_code != -2) or (legacy_scorer in skip_entirely) or (screen == 'ENH' and legacy_scorer in skip_ENH)): command.stderr.write( 'FYI: Skipping a {} {} score of {} by {}\n' .format(gene, screen, legacy_score_code, legacy_scorer)) return True # Convert some scorers to hueyling (see criteria above) if legacy_scorer == 'Julie' or legacy_scorer == 'expPeople': command.stderr.write( 'FYI: Converting a {} score by {} to hueyling\n' .format(legacy_score_code, legacy_scorer)) legacy_scorer = 'hueyling' # Convert some score codes (see criteria above) if legacy_score_code == -6: command.stderr.write('FYI: Converting score from -6 to -7\n') legacy_score_code = -7 # Following raise exceptions if improperly formatted or not found experiment = get_experiment(legacy_row[0], tile_to_well(legacy_row[1])) score_code = get_score_code(legacy_score_code) scorer = get_user(legacy_scorer) timestamp = get_timestamp(legacy_row[5], legacy_row[6], legacy_row[7], legacy_row[8], legacy_row[4]) if not timestamp: raise CommandError( 'ERROR: score of {} could not be converted to a proper ' 'datetime'.format(experiment)) new_score = ManualScore( experiment=experiment, score_code=score_code, scorer=scorer, timestamp=timestamp) return update_or_save_object( command, new_score, recorded_scores, fields_to_compare, alternate_pk={'experiment': new_score.experiment, 'score_code': new_score.score_code, 'scorer': new_score.scorer, 'timestamp': new_score.timestamp})