def print_coverage_stats(): total_count = Case.select().count() has_transcript_count = Case.select().where( Case.transcript.is_null(False)).count() coverage = float(has_transcript_count) / float(total_count) logging.info( "There are %s cases and %s cases with transcripts, for a coverage of %s%s." % (total_count, has_transcript_count, round(coverage * 100.0, 2), "%")) total_count = Transcript.select().count() has_case_count = len([ transcript for transcript in Transcript.select() if transcript.cases.count() > 0 ]) coverage = float(has_case_count) / float(total_count) logging.info( "There are %s transcripts and %s transcripts with cases, for a coverage of %s%s." % (total_count, has_case_count, round(coverage * 100.0, 2), "%"))
def reconciliate_cases_and_transcripts(): case_dockets = {} transcript_dockets = {} for case in Case.select(): try: case_dockets[preprocess_docket(case.docket)] = case except: continue for transcript in Transcript.select(): try: transcript_dockets[preprocess_docket( transcript.docket)] = transcript except: continue for docket in case_dockets: if docket in transcript_dockets: case = case_dockets[docket] case.transcript = transcript_dockets[docket] case.save()