[Tutor] Please advice me this code

Wed Sep 29 14:09:26 CEST 2004

Hi,

Can someone please scan thru the attached code and tell me how should I code it in order to include more than one qtype?

Any help is greatly appreciated.

p/s: Lee Harr, Thanks so much for you help. You helped me to start up the whole thing. Thanks again

Cheers,
Shufen
-------------- next part --------------
#!/usr/bin/env python
#Created on: 29/09/04
#Help from Lee Harr - Python Tutor

import sys, os
import cgi
import cgitb; cgitb.enable()
import pg

def form():
    print """<form method="post" action="">
             <p>
	     <input type=checkbox name="qtype" value="all" checked />
             All<br />
             <input type=checkbox name="qtype" value="project" />
             Project<br />
             <input type=checkbox name="qtype" value="date_string" />
             Date<br />
             <input type=checkbox name="qtype" value="blame" />
             Blame<br />
             <input type=checkbox name="qtype" value="notes" />
             Notes<br /></p>

             <p>Search by shot number:<br>
             <input type=text name="qtext" value="" />
             <input type="submit" value="SEARCH"><br>
             </form>"""

print "Content-Type: text/html\n\n"
print '<head><title>Searching by using Shot Number</title></head><body>'

if __name__ == "__main__":

    data = cgi.FieldStorage()

    if data:
        qtype = data['qtype'].value
        try:
            qtext = data['qtext'].value
        except KeyError:
            qtext = ''

        if qtype=="project":
            print "Shot Number:", qtext

            # Take care of the security problems after finishing the code.
            username = os.environ.get('USER')
            if username == None:
                username = 'apache'

            # Now, we can get to the database...    
            db = pg.connect("moncdata", user=username, passwd=None)
            query = "select project from shot_descriptions where shot_number=%(qtext)s"  % {'qtext': qtext}
            qresult = db.query(query)

            listOfResults = qresult.dictresult()

            print """<p>Example of pulling the list of dictionary results apart.</p>"""

            for record in listOfResults:
                print "<p><table>"
                for k in record.keys():
                    print '<tr>'
                    print '<td>key:</td> <td>', k, '</td>'
                    print '<td>value:</td><td>', record[k], '</td>'
                    print '</tr>'
                print '</table></p>'

            db.close()

	#How should I code it, in order to get more than one qtype?
        elif qtype=="project" and "date_string":
            print "Shot Number:", qtext

            # Now, we can get to the database...
            username = os.environ.get('USER')
            if username == None:
                username = 'apache'

            db = pg.connect("moncdata", user=username, passwd=None)
            query = "select project, date_string from shot_descriptions where shot_number=%(qtext)s"  % {'qtext': qtext}
            qresult = db.query(query)

            listOfResults = qresult.dictresult()

            print """<p>Example of pulling the list of dictionary results apart.</p>"""

            for record in listOfResults:
                print "<p><table>"
                for k in record.keys():
                    print '<tr>'
                    print '<td>key:</td> <td>', k, '</td>'
                    print '<td>value:</td><td>', record[k], '</td>'
                    print '</tr>'
                print '</table></p>'

            db.close()

	elif qtype=="all":
            print "Shot Number:", qtext

            # Now, we can get to the database...
            username = os.environ.get('USER')
            if username == None:
                username = 'apache'

            db = pg.connect("moncdata", user=username, passwd=None)
            query = "select * from shot_descriptions where shot_number=%(qtext)s"  % {'qtext': qtext}
            qresult = db.query(query)

            listOfResults = qresult.dictresult()

            print """<p>Example of pulling the list of dictionary results apart.</p>"""

            for record in listOfResults:
                print "<p><table>"
                for k in record.keys():
                    print '<tr>'
                    print '<td>key:</td> <td>', k, '</td>'
                    print '<td>value:</td><td>', record[k], '</td>'
                    print '</tr>'
                print '</table></p>'

            db.close()	    

        elif not qtext:
            print 'Please type in shot number in order to perform a search!'

    else:
        form()

print '<body></html>'