search_GeneSymbol.cgi

#!/usr/local/bin/python3

import cgi, json
import os
import mysql.connector

def main():
    print("Content-Type: application/json\n\n")
    form = cgi.FieldStorage()
    term = form.getvalue('search_term')
    termType = form.getvalue('search_type')
        
    conn = mysql.connector.connect(user='ppireku1', password='Changedman12!*', host='localhost', database='ppireku1')
    cursor = conn.cursor()
    if  termType == "genetype":
        qry = """
          SELECT GeneSymbol, Chromosome, Start, Stop, ClinicalSignificance, PhenotypeList, RCVaccession 
            FROM variant_data
           WHERE GeneSymbol LIKE %s
        """
    elif termType == "start":
        qry = """
          SELECT GeneSymbol, Chromosome, Start, Stop, ClinicalSignificance, PhenotypeList, RCVaccession 
            FROM variant_data
           WHERE Start LIKE %s
        """
    elif termType == "end":
        qry = """
          SELECT GeneSymbol, Chromosome, Start, Stop, ClinicalSignificance, PhenotypeList, RCVaccession 
            FROM variant_data
           WHERE Stop LIKE %s
        """
    
    cursor.execute(qry, ('%' + term + '%', ))

    results = { 'match_count': 0, 'matches': list() }
    count = 0
    for (GeneSymbol, Chromosome, Start, Stop, ClinicalSignificance, PhenotypeList, RCVaccession ) in cursor:
    #for result in cursor:
        result= {"GeneSymbol":GeneSymbol,
                 "Chromosome":Chromosome,
                 "Start":Start,
                 "Stop":Stop,
                 "ClinicalSignificance":ClinicalSignificance,
                 "PhenotypeList":PhenotypeList,
                 "RCVaccession":RCVaccession
                }
        count = count +1
        results['matches'].append(result)
        results['match_count'] += 1
        if (count >=1000000 ):
            break
    conn.close()

    print(json.dumps(results))


if __name__ == '__main__':
    main()