#!/usr/bin/env python2
# (C) 2003 Ben Collins-Sussman under the GNU General Public License.
# See the file COPYING for details.
# Edit a "Unit" record.
import MySQLdb, cgi
# enable debugging: displays detailed exceptions in web browser.
import cgitb; cgitb.enable()
# temporary: eventually put 'effrecipes.py' into a standard PYTHONPATH
# location, like /usr/lib/python2.3/site-pacakages/
import sys
sys.path.append('/home/sussman/projects/effrecipes/objects')
import effrecipes
# -----------------------------------------------------------------
def save_record(form, conn):
"""Write record in FORM to database, overwriting unit with
matching Id field.. If FORM has no Id field, a new record is
created in database."""
name = form["ingredient_name"].value
if form.has_key("ingredient_id"):
id = int(form["ingredient_id"].value)
else:
id = None
# This will either read an existing record (if id is an integer),
# or create a new record (if id is None)
ingredient_object = effrecipes.Ingredient(id, name)
ingredient_object.save(conn)
if id is None:
print "New record created.
"
else:
print "Record with Id ", form["ingredient_id"].value, \
"has been saved.
\n"
def delete_record(form, conn):
"Delete record that matches FORM's Id."
name = form["ingredient_name"].value
id = int(form["ingredient_id"].value)
ingredient_object = effrecipes.Ingredient(id, name)
ingredient_object.delete(conn)
print "Record deleted.
"
# -----------------------------------------------------------------
# Initialize database connection
conn = MySQLdb.connect(user='effuser', passwd='effuser', db='effrecipes')
# Initial generic HTML 'header' output
print "Content-type: text/html\n\n";
print "Effrecipes - record has changed\n"
# Use the CGI form values to create a new object and save it.
form = cgi.FieldStorage()
if form.has_key("save_button"):
save_record(form, conn)
elif form.has_key("delete_button"):
delete_record(form, conn)
else:
print "Unknown action -- no button recognized"
print 'Go back to the '\
+ 'list of all Ingredients..\n'
# Cleanup and exit
print ""
conn.close()