I have created the following database but the following errors occur
when trying to execute the code.
html source:
<html>
<body>
Click here to display information from Chocolate menu:
<form action ="form.py/display" method="POST">
<p>
Press to view the display
<input type="submit">
</p>
</form>
<br>
Please provide data for chocolate to be added:
<p>
<form action ="form.py/addchocolate" method="POST">
<p>
Name: <input type="text" name="z_Name" maxlength="30"> <br>
Rating: <input type="text" name="z_rating" maxlength="3">< br>
Price : <input type="text" name="z_price" maxlength="5">< br>
<input type="submit">
</p>
</form>
</body>
</html>
form.py source
import MySQLdb
def addchocolate(z_ Name, z_rating, z_price):
# make sure the user provided all the parameters
if not (z_Name and z_rating and z_price):
return "A required parameter is missing, \
please go back and correct the error"
db =
MySQLdb.connect (host="localhos t",user="haywar d",passwd="hayw ard",db="haywar d")
cursor = db.cursor()
cursor.execute(
"""INSERT INTO InventoryList (artist, title, rating) VALUES (%s,
%s, %s)""", (z_Name, z_rating, z_price) )
db.commit()
cursor.close()
db.close()
def display(rating) :
db =
MySQLdb.connect (host="localhos t",user="haywar d",passwd="hayw ard",db="haywar d")
cursor = db.cursor()
cursor.execute( """SELECT * FROM InventoryList"" ")
result = cursor.fetchall ()
cursor.close()
db.close()
parsesongs(resu lt)
return
def parsesongs(raws tring):
print 'Chocolate Inventory'
print
'---------------------------------------------------------------'
print 'Name Rating
Price '
print
'---------------------------------------------------------------'
for i in range (0, len(rawstring)) :
table = ''
Name = rawstring[i][0]
table = table + Name
for j in range (0, (29 - len(Name))):
table = table + ' '
Rating = rawstring[i][1]
table = table + Rating
for k in range (0, (29 - len(Rating))):
table = table + ' '
Price = str(rawstring[i][2])
table = table + Price
print table
print
'---------------------------------------------------------------'
return
errors that occur
press display:
Mod_python error: "PythonHand ler mod_python.publ isher"
Traceback (most recent call last):
File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line
193, in Dispatch
result = object(req)
File "/usr/lib/python2.3/site-packages/mod_python/publisher.py", line
173, in handler
result = apply(object, (), args)
TypeError: display() takes exactly 1 argument (0 given)
press the addition of the items:
Mod_python error: "PythonHand ler mod_python.publ isher"
Traceback (most recent call last):
File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line
193, in Dispatch
result = object(req)
File "/usr/lib/python2.3/site-packages/mod_python/publisher.py", line
173, in handler
result = apply(object, (), args)
File
"/home/hayward/public_html/Homework/Python_Executab le_Publisher/form.py",
line 11, in addchocolate
cursor.execute(
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 137,
in execute
self.errorhandl er(self, exc, value)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py" , line
33, in defaulterrorhan dler
raise errorclass, errorvalue
OperationalErro r: (1054, "Unknown column 'artist' in 'field list'")
Thanks for the help
