def existing_variant():
    return {
        'Variant_frequency_LOVD': '-',
        'ClinVarAccession_ENIGMA': 'SCV000244373.2',
        'Variant_in_LOVD': True,
        'Chr': '17',
        'Co_occurrence_LR_exLOVD': '1.23',
        'Reference_Sequence': 'NM_007294.3',
        'Submitter_ClinVar': 'Breast_Cancer_Information_Core_(BIC)_(BRCA1),Ambry_Genetics,GeneDx,Counsyl,Invitae,Evidence-based_Network_for_the_Interpretation_of_Germline_Mutant_Alleles_(ENIGMA),Sharing_Clinical_Reports_Project_(SCRP)',
        'Clinical_classification_BIC': 'Pending',
        'Method_ClinVar': 'curation,clinical_testing,literature_only',
        'Allele_Frequency': '1.647e-05 (ExAC)',
        'Pathogenicity_all': 'Benign(ENIGMA); Benign,Likely_benign,Uncertain_significance (ClinVar); Pending (BIC)',
        'Germline_or_Somatic_BIC': 'G',
        'BIC_Nomenclature': '5074T>C',
        'Clinical_significance_citations_ENIGMA': 'PMID:21990134',
        'Change_Type_id': 1,
        'Collection_method_ENIGMA': 'Curation',
        'Sum_family_LR_exLOVD': '0.0182',
        'EAS_Allele_frequency_1000_Genomes': '-',
        'Ethnicity_BIC': 'Western-European,Western European,-,"Western European, Central/Eastern European"',
        'Variant_in_ExAC': True,
        'URL_ENIGMA': 'http://hci-exlovd.hci.utah.edu/variants.php?select_db=BRCA1&action=search_all&search_Variant%2FDNA=c.4955T>C',
        'Allele_Origin_ClinVar': 'germline,unknown',
        'Variant_in_1000_Genomes': False,
        'AFR_Allele_frequency_1000_Genomes': '-',
        'EUR_Allele_frequency_1000_Genomes': '-',
        'Source': 'ENIGMA,ClinVar,LOVD,ExAC,BIC,exLOVD',
        'Condition_ID_value_ENIGMA': 'BREAST-OVARIAN CANCER, FAMILIAL, SUSCEPTIBILITY TO, 1; BROVCA1 (604370)',
        'HGVS_Protein': 'NP_009225.1:p.(Met1652Thr)',
        'Ref': 'A',
        'Sift_Prediction': 'deleterious',
        'Gene_Symbol': 'BRCA1',
        'Comment_on_clinical_significance_ENIGMA': 'IARC class based on posterior probability from multifactorial likelihood analysis, thresholds for class as per Plon et al. 2008 (PMID: 18951446). Class 1 based on posterior probability = 0.00011',
        'Missense_analysis_prior_probability_exLOVD': '0.29',
        'Assertion_method_ENIGMA': 'ENIGMA BRCA1/2 Classification Criteria (2015)',
        'Posterior_probability_exLOVD': '0.00011',
        'Polyphen_Score': '0.546',
        'Hg38_End': 43070959,
        'HGVS_cDNA': 'NM_007294.3:c.4955T>C',
        'Functional_analysis_technique_LOVD': 'Structure-based prediction (crystallography etc),transcription activation/PS/BA/BS,-,Multifactorial likelihood-ratio model',
        'SAS_Allele_frequency_1000_Genomes': '-',
        'Max_Allele_Frequency': '-',
        'Combined_prior_probablility_exLOVD': '0.29',
        'IARC_class_exLOVD': '1 - Not pathogenic or of no clinical significance',
        'Allele_origin_ENIGMA': 'Germline',
        'Hg37_End': 41222976,
        'Date_Last_Updated_ClinVar': '2015-08-10,2014-11-18,2010-06-01,2014-10-01,2002-05-29,2015-04-16,2014-07-23',
        'Hg38_Start': 43070959,
        'Source_URL': 'http://hci-exlovd.hci.utah.edu/variants.php?select_db=BRCA1&action=search_all&search_Variant%2FDNA=c.4955T>C, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000053796, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000209981, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000220544, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000076721, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000213478, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000145221, http://www.ncbi.nlm.nih.gov/clinvar/?term=SCV000244373',
        'SCV_ClinVar': 'SCV000053796',
        'Pathogenicity_expert': 'Benign / Little Clinical Significance',
        'Allele_frequency_1000_Genomes': '-',
        'Functional_analysis_result_LOVD': 'predicted neutral,predicted deleterious,no functional effect,-',
        'AMR_Allele_frequency_1000_Genomes': '-',
        'Variant_in_ESP': False,
        'Variant_in_BIC': True,
        'Clinical_significance_ENIGMA': 'Benign',
        'Variant_in_ENIGMA': True,
        'Patient_nationality_BIC': 'Not Specified,Western Europe,-',
        'Genomic_Coordinate_hg37': 'chr17:g.41222976:A>G',
        'Number_of_family_member_carrying_mutation_BIC': '-',
        'Genomic_Coordinate_hg38': 'chr17:g.43070959:A>G',
        'Genomic_HGVS_38': 'NC_000017.11:g.43070959A>G',
        'Genomic_HGVS_37': 'NC_000017.10:g.41222976A>G',
        'Allele_frequency_ExAC': '1.647e-05',
        'Mutation_type_BIC': 'M',
        'Assertion_method_citation_ENIGMA': 'http://enigmaconsortium.org/documents/ENIGMA_Rules_2015-03-26.pdf',
        'Condition_ID_type_ENIGMA': 'OMIM',
        'Synonyms': '5074T>C,5074T>C,M1652T,NM_007294.2:c.4955T>C,NM_007300.3:c.5018T>C,NM_007299.3:c.1643T>C,NM_007298.3:c.1643T>C,NM_007297.3:c.4814T>C,U14680.1:c.5067T>C',
        'Variant_in_ClinVar': True,
        'Clinical_importance_BIC': 'unknown',
        'Discordant': 'Concordant',
        'Condition_category_ENIGMA': 'Disease',
        'Minor_allele_frequency_percent_ESP': '-',
        'Segregation_LR_exLOVD': '0.012',
        'Variant_in_exLOVD': True,
        'Clinical_Significance_ClinVar': 'Benign,Likely_benign,Uncertain_significance',
        'Protein_Change': 'M1652T',
        'HGVS_RNA': '-',
        'Literature_source_exLOVD': 'Easton DF et al., Am J Hum Genet, 81: 873-883, 2007.',
        'Polyphen_Prediction': 'possibly_damaging',
        'Data_Release_id': 1,
        'Hg37_Start': 41222976,
        'Literature_citation_BIC': '-',
        'Variant_haplotype_LOVD': '-',
        'Pos': '43070959',
        'Date_last_evaluated_ENIGMA': '8/10/15',
        'Sift_Score': '0',
        'Alt': 'G'
    }


def new_variant():
    v = existing_variant()
    v["Genomic_Coordinate_hg38"] = "chr17:g.999999:A>G"
    v['HGVS_cDNA'] = 'NM_007294.3:c.4955T>TC'
    v['BIC_Nomenclature'] = '5074T>TC'
    return v


def new_variant_no_source():
    v = existing_variant()
    v["Genomic_Coordinate_hg38"] = "chr17:g.000000:A>G"
    v['Variant_in_LOVD'] = False
    v['Variant_in_ExAC'] = False
    v['Variant_in_1000_Genomes'] = False
    v['Variant_in_ESP'] = False
    v['Variant_in_BIC'] = False
    v['Variant_in_ENIGMA'] = False
    v['Variant_in_ClinVar'] = False
    v['Variant_in_exLOVD'] = False
    return v


def new_variant_no_enigma_classification():
    v = existing_variant()
    v['Clinical_significance_ENIGMA'] = '-'
    return v

def existing_clinvar_report():
    return {
        "AA_Allele_Frequency_ESP": "-",
        "AFR_Allele_frequency_1000_Genomes": "-",
        "AMR_Allele_frequency_1000_Genomes": "-",
        "Abbrev_AA_change_ENIGMA": "-",
        "Allele_Frequency_ESP": "-",
        "Allele_Origin_ClinVar": "germline",
        "Allele_count_AFR_ExAC": "-",
        "Allele_count_AMR_ExAC": "-",
        "Allele_count_EAS_ExAC": "-",
        "Allele_count_FIN_ExAC": "-",
        "Allele_count_NFE_ExAC": "-",
        "Allele_count_OTH_ExAC": "-",
        "Allele_count_SAS_ExAC": "-",
        "Allele_frequency_1000_Genomes": "-",
        "Allele_frequency_AFR_ExAC": "-",
        "Allele_frequency_AMR_ExAC": "-",
        "Allele_frequency_EAS_ExAC": "-",
        "Allele_frequency_ExAC": "-",
        "Allele_frequency_FIN_ExAC": "-",
        "Allele_frequency_NFE_ExAC": "-",
        "Allele_frequency_OTH_ExAC": "-",
        "Allele_frequency_SAS_ExAC": "-",
        "Allele_number_AFR_ExAC": "-",
        "Allele_number_AMR_ExAC": "-",
        "Allele_number_EAS_ExAC": "-",
        "Allele_number_FIN_ExAC": "-",
        "Allele_number_NFE_ExAC": "-",
        "Allele_number_OTH_ExAC": "-",
        "Allele_number_SAS_ExAC": "-",
        "Allele_origin_ENIGMA": "-",
        "Alt": "G",
        "Assertion_method_ENIGMA": "-",
        "Assertion_method_citation_ENIGMA": "-",
        "BIC_Designation_BIC": "-",
        "BIC_Nomenclature_ENIGMA": "-",
        "BIC_Nomenclature_exLOVD": "-",
        "BX_ID_1000_Genomes": "-",
        "BX_ID_BIC": "-",
        "BX_ID_ClinVar": "38697",
        "BX_ID_ENIGMA": "-",
        "BX_ID_ESP": "-",
        "BX_ID_ExAC": "-",
        "BX_ID_LOVD": "-",
        "BX_ID_exLOVD": "-",
        'Change_Type_id': 1,
        "Chr": "17",
        "ClinVarAccession_ENIGMA": "-",
        "Clinical_Significance_ClinVar": "Likely_benign",
        "Clinical_classification_BIC": "-",
        "Clinical_importance_BIC": "-",
        "Clinical_significance_ENIGMA": "-",
        "Clinical_significance_citations_ENIGMA": "-",
        "Co_occurrence_LR_exLOVD": "-",
        "Collection_method_ENIGMA": "-",
        "Combined_prior_probablility_exLOVD": "-",
        "Comment_on_clinical_significance_ENIGMA": "-",
        "Condition_ID_type_ENIGMA": "-",
        "Condition_ID_value_ENIGMA": "-",
        "Condition_category_ENIGMA": "-",
        "Created_date_LOVD": "-",
        "DBID_LOVD": "-",
        "Data_Release_id": 1,
        "DateSignificanceLastEvaluated_ClinVar": "2014-12-15",
        "Date_Last_Updated_ClinVar": "2018-09-25",
        "Date_last_evaluated_ENIGMA": "-",
        "Description_ClinVar": "not_provided",
        "EAS_Allele_frequency_1000_Genomes": "-",
        "EA_Allele_Frequency_ESP": "-",
        "EUR_Allele_frequency_1000_Genomes": "-",
        "Edited_date_LOVD": "-",
        "Ethnicity_BIC": "-",
        "Functional_analysis_result_LOVD": "-",
        "Functional_analysis_technique_LOVD": "-",
        "Gene_symbol_ENIGMA": "BRCA1",
        "Genetic_origin_LOVD": "-",
        "Genomic_Coordinate": "chr17:g.43093883:T>G",
        "Germline_or_Somatic_BIC": "-",
        "HGVS_ClinVar": "NM_007294.3.c.1648A>C",
        "HGVS_cDNA_ENIGMA": "-",
        "HGVS_cDNA_LOVD": "-",
        "HGVS_cDNA_exLOVD": "-",
        "HGVS_protein_ENIGMA": "-",
        "HGVS_protein_LOVD": "-",
        "HGVS_protein_exLOVD": "-",
        "Homozygous_count_AFR_ExAC": "-",
        "Homozygous_count_AMR_ExAC": "-",
        "Homozygous_count_EAS_ExAC": "-",
        "Homozygous_count_FIN_ExAC": "-",
        "Homozygous_count_NFE_ExAC": "-",
        "Homozygous_count_OTH_ExAC": "-",
        "Homozygous_count_SAS_ExAC": "-",
        "IARC_class_exLOVD": "-",
        "Individuals_LOVD": "-",
        "Literature_citation_BIC": "-",
        "Literature_source_exLOVD": "-",
        "Method_ClinVar": "clinical_testing",
        "Minor_allele_frequency_percent_ESP": "-",
        "Missense_analysis_prior_probability_exLOVD": "-",
        "Mutation_type_BIC": "-",
        "Number_of_family_member_carrying_mutation_BIC": "-",
        "Patient_nationality_BIC": "-",
        "Pos": "43093883",
        "Posterior_probability_exLOVD": "-",
        "Protein_ClinVar": "NP_009231.2.p.Asn550His",
        "RNA_LOVD": "-",
        "Ref": "T",
        "Reference_sequence_ENIGMA": "-",
        "Review_Status_ClinVar": "criteria_provided,_single_submitter",
        "SAS_Allele_frequency_1000_Genomes": "-",
        "SCV_ClinVar": "SCV000682975",
        "SCV_Version_ClinVar": "1",
        "Segregation_LR_exLOVD": "-",
        "Source": "ClinVar",
        "Submission_ID_LOVD": "-",
        "Submitter_ClinVar": "Color",
        "Submitters_LOVD": "-",
        "Sum_family_LR_exLOVD": "-",
        "Summary_Evidence_ClinVar": "None",
        "Synonyms_ClinVar": "LRG_292t1.c.1648A>C,LRG_292.g.124101A>C,NG_005905.2.g.124101A>C,NC_000017.11.g.43093883T>G,NC_000017.10.g.41245900T>G,U14680.1.n.1767A>C,NR_027676.1.n.1784A>C,p.N550H,LRG_292p1.p.Asn550His,1767A>C,N550H,p.N550H.AAT>CAT,NM_007294.3.c.1648A>C",
        "URL_ENIGMA": "-",
        "Variant_effect_LOVD": "-",
        "Variant_frequency_LOVD": "-",
        "polyPhen2_result_ESP": "-"
    }

def second_version_clinvar_report():
    r = existing_clinvar_report()
    r["Date_Last_Updated_ClinVar"] = "2018-10-25"
    r["Data_Release_id"] = 2
    return r

def existing_lovd_report():
    return {
        "AA_Allele_Frequency_ESP": "-",
        "AFR_Allele_frequency_1000_Genomes": "-",
        "AMR_Allele_frequency_1000_Genomes": "-",
        "Abbrev_AA_change_ENIGMA": "-",
        "Allele_Frequency_ESP": "-",
        "Allele_Origin_ClinVar": "-",
        "Allele_count_AFR_ExAC": "-",
        "Allele_count_AMR_ExAC": "-",
        "Allele_count_EAS_ExAC": "-",
        "Allele_count_FIN_ExAC": "-",
        "Allele_count_NFE_ExAC": "-",
        "Allele_count_OTH_ExAC": "-",
        "Allele_count_SAS_ExAC": "-",
        "Allele_frequency_1000_Genomes": "-",
        "Allele_frequency_AFR_ExAC": "-",
        "Allele_frequency_AMR_ExAC": "-",
        "Allele_frequency_EAS_ExAC": "-",
        "Allele_frequency_ExAC": "-",
        "Allele_frequency_FIN_ExAC": "-",
        "Allele_frequency_NFE_ExAC": "-",
        "Allele_frequency_OTH_ExAC": "-",
        "Allele_frequency_SAS_ExAC": "-",
        "Allele_number_AFR_ExAC": "-",
        "Allele_number_AMR_ExAC": "-",
        "Allele_number_EAS_ExAC": "-",
        "Allele_number_FIN_ExAC": "-",
        "Allele_number_NFE_ExAC": "-",
        "Allele_number_OTH_ExAC": "-",
        "Allele_number_SAS_ExAC": "-",
        "Allele_origin_ENIGMA": "-",
        "Alt": "G",
        "Assertion_method_ENIGMA": "-",
        "Assertion_method_citation_ENIGMA": "-",
        "BIC_Designation_BIC": "-",
        "BIC_Nomenclature_ENIGMA": "-",
        "BIC_Nomenclature_exLOVD": "-",
        "BX_ID_1000_Genomes": "-",
        "BX_ID_BIC": "-",
        "BX_ID_ClinVar": "-",
        "BX_ID_ENIGMA": "-",
        "BX_ID_ESP": "-",
        "BX_ID_ExAC": "-",
        "BX_ID_LOVD": "17567",
        "BX_ID_exLOVD": "-",
        'Change_Type_id': 1,
        "Chr": "17",
        "ClinVarAccession_ENIGMA": "-",
        "Clinical_Significance_ClinVar": "-",
        "Clinical_classification_BIC": "-",
        "Clinical_importance_BIC": "-",
        "Clinical_significance_ENIGMA": "-",
        "Clinical_significance_citations_ENIGMA": "-",
        "Co_occurrence_LR_exLOVD": "-",
        "Collection_method_ENIGMA": "-",
        "Combined_prior_probablility_exLOVD": "-",
        "Comment_on_clinical_significance_ENIGMA": "-",
        "Condition_ID_type_ENIGMA": "-",
        "Condition_ID_value_ENIGMA": "-",
        "Condition_category_ENIGMA": "-",
        "Created_date_LOVD": "2015-07-03 21:52:27",
        "DBID_LOVD": "BRCA1_000160",
        "Data_Release_id": 1,
        "DateSignificanceLastEvaluated_ClinVar": "-",
        "Date_Last_Updated_ClinVar": "-",
        "Date_last_evaluated_ENIGMA": "-",
        "Description_ClinVar": "-",
        "EAS_Allele_frequency_1000_Genomes": "-",
        "EA_Allele_Frequency_ESP": "-",
        "EUR_Allele_frequency_1000_Genomes": "-",
        "Edited_date_LOVD": "2017-04-22 20:42:09",
        "Ethnicity_BIC": "-",
        "Functional_analysis_result_LOVD": "",
        "Functional_analysis_technique_LOVD": "",
        "Gene_symbol_ENIGMA": "BRCA1",
        "Genetic_origin_LOVD": "Germline",
        "Genomic_Coordinate": "chr17:g.43093883:T>G",
        "Germline_or_Somatic_BIC": "-",
        "HGVS_ClinVar": "-",
        "HGVS_cDNA_ENIGMA": "-",
        "HGVS_cDNA_LOVD": "NM_007294.3:c.1648A>C",
        "HGVS_cDNA_exLOVD": "-",
        "HGVS_protein_ENIGMA": "-",
        "HGVS_protein_LOVD": "p.(Asn550His)",
        "HGVS_protein_exLOVD": "-",
        "Homozygous_count_AFR_ExAC": "-",
        "Homozygous_count_AMR_ExAC": "-",
        "Homozygous_count_EAS_ExAC": "-",
        "Homozygous_count_FIN_ExAC": "-",
        "Homozygous_count_NFE_ExAC": "-",
        "Homozygous_count_OTH_ExAC": "-",
        "Homozygous_count_SAS_ExAC": "-",
        "IARC_class_exLOVD": "-",
        "Individuals_LOVD": "1",
        "Literature_citation_BIC": "-",
        "Literature_source_exLOVD": "-",
        "Method_ClinVar": "-",
        "Minor_allele_frequency_percent_ESP": "-",
        "Missense_analysis_prior_probability_exLOVD": "-",
        "Mutation_type_BIC": "-",
        "Number_of_family_member_carrying_mutation_BIC": "-",
        "Patient_nationality_BIC": "-",
        "Pos": "43093883",
        "Posterior_probability_exLOVD": "-",
        "Protein_ClinVar": "-",
        "RNA_LOVD": "r.(?)",
        "Ref": "T",
        "Reference_sequence_ENIGMA": "-",
        "Review_Status_ClinVar": "-",
        "SAS_Allele_frequency_1000_Genomes": "-",
        "SCV_ClinVar": "-",
        "SCV_Version_ClinVar": "-",
        "Segregation_LR_exLOVD": "-",
        "Source": "LOVD",
        "Submission_ID_LOVD": "NM_007294.3:c.1648A>CkConFab - Heather Thorne (Melbourne,AU)",
        "Submitter_ClinVar": "-",
        "Submitters_LOVD": "kConFab - Heather Thorne (Melbourne,AU)",
        "Sum_family_LR_exLOVD": "-",
        "Summary_Evidence_ClinVar": "-",
        "Synonyms_ClinVar": "-",
        "URL_ENIGMA": "-",
        "Variant_effect_LOVD": "-/-",
        "Variant_frequency_LOVD": "2/1658",
        "polyPhen2_result_ESP": "-"
    }

def second_version_lovd_report():
    r = existing_lovd_report()
    r["Edited_date_LOVD"] = "2018-10-20 17:12:14"
    r["Data_Release_id"] = 2
    return r

