Esempio n. 1
0
def main(familyid) :
    #file = open("./output.csv",'w')

    conn = db.Conn("localhost")

    # Get Affected and Parents
    (affecteds, parents) = getPatientData(conn, familyid)
    q = TWO_PARENT_SHARED_HOM_QUERY % (parents[0], parents[1], affecteds[0])
    queries.makeReport( q, "1=1", "cp_report.csv" )
            affecteds.append( eyed )
        elif affected == 0 and generation == mingen :
            parents.append( eyed )

    #sanity check
    if len(affecteds) != 1 :
        raise Exception("There are %d != 1 affecteds for family %s." % \
                        (len(affecteds), familyid))
    elif len(parents) != 2 :
        raise Exception("There are %d != 2 parents for family %s" % \
                        (len(parents), familyid))
    return affecteds, parents
# END getPatientData

try :

    conn = db.Conn("localhost")

    familyid = fields.getvalue("family_id")
    filename = fields.getvalue("filename")
    (affecteds, parents) = getPatientData(conn, familyid)
    q = TWO_PARENT_SHARED_HOM_QUERY % (parents[0], parents[1], affecteds[0])
    queries.makeReport( q, "1=1", filename )
    printToServer( '<a href="../reports/%s.tsv">Report Ready</a>' % filename )

except KeyError, (e) :
    printToServer( "You most likely left %s blank." % str(e) )

except Exception, (e) :
    printToServer( str(e) )
#!/usr/bin/python2.4

import cgi
import sys
sys.path.append('/home/Gleeson/database/src')
from web_utils import *
from queries import makeReport

printHeader()

fields = cgi.FieldStorage()

try :
    names = ["variant_sql","call_where","filename"]
    values = [fields[name].value for name in names]

    sys.stdout = open("debug/custom_out.txt",'w')
    sys.stderr = open("debug/custom_err.txt",'w')

    makeReport( values[0], values[1], values[2] )
    printToServer( '<a href="../reports/%s.tsv">report generated</a>' % values[2] )

except KeyError, (e) :
    printToServer( "You most likely left %s blank." % str(e) )

except Exception, (e) :
    printToServer( str(e) )