#!c:\Python\python.exe
# Fig. 27.23: fig27_23.py
# A program to illustrate Python's database connectivity.

import cgi

def printContent():
   print "Content-type: text/html"
   print

def getConnection( databaseType, databaseName ):
   connection = None

   if databaseType == 'MySQL':
      import MySQLdb
      connection = MySQLdb.connect( db = databaseName )
   elif databaseType == 'Access':
      import odbc
      connection = odbc.odbc( databaseName )

   return connection        

# get results from form
form = cgi.FieldStorage()

printContent()                       # print HTML header

try:
   queryString = form[ "search" ].value
   database = form[ "database" ].value
except:
   print """<font color = "red" size = "+2">
   FORM ERROR</font><br>
   You did not enter a query string.<br>
   <font color = "blue"> Click the Back button, 
   fill out the form and resubmit.<br><br>
   Thank You.</font>"""
else:
   
   # connect to database and get cursor
   connection = getConnection( database, "Deitel" )
   cursor = connection.cursor()           

   try:
      cursor.execute( queryString )   # execute user's query
   except:
      print """An error occurred in your query statement.""" 
   else:
      results = cursor.fetchall()     # store results in list

      # display results
      print """Database used: <font color = "blue">
      %s</font><br>""" % database
      print """<table border = "1" cellpadding = "3">"""

      for row in results:
         print "<tr>"
      
         for entry in row: 
            print "<td>%s</td>" % entry

      print """</table>"""

   cursor.close()                  # close cursor
   cursor = None
   connection.close()              # close connection
   connection = None

########################################################################## 
# (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     #
# All Rights Reserved.                                                   #
#                                                                        #
# DISCLAIMER: The authors and publisher of this book have used their     #
# best efforts in preparing the book. These efforts include the          #
# development, research, and testing of the theories and programs        #
# to determine their effectiveness. The authors and publisher make       #
# no warranty of any kind, expressed or implied, with regard to these    #
# programs or to the documentation contained in these books. The authors #
# and publisher shall not be liable in any event for incidental or       #
# consequential damages in connection with, or arising out of, the       #
# furnishing, performance, or use of these programs.                     #
##########################################################################