Uuenda.py

1. !/usr/bin/python

import sys import cgi import sqlite3 as sqlite

databasefile = 'data.db' tables = ['t0','t1','t2','t3','t4'] fields = ['f0','f1','f2','f3','f4','f5','f6','f7','f8','f9','f10','f11','f12','f13','f14','f15','f16','f17','f18','f19']

print 'Content-type: text/plain' print

try:

 form = cgi.FieldStorage()

 if form.has_key('table') and form['table'].value in tables:
   tablename=form['table'].value
 else:
   print "0"
   sys.exit(0)

 if form.has_key('salvestaja'):
   salvestaja=form['salvestaja'].value
 else:
   print "0"
   sys.exit(0)

 if form.has_key('id'):
   id=form['id'].value
 else:
   print "0"
   sys.exit(0)

 query="update %s set " % tablename

 updstr=""
 for el in fields:
   if form.has_key(el):
     updstr=updstr+" "+el+"='"
     updstr=updstr+form[el].value.replace('"', ' ').replace("'", " ")+"',"
 if not updstr:
   print "0"
 else:
   if updstr[len(updstr)-1]==",":
     updstr=updstr[0:len(updstr)-1]
   query=query+updstr+" where salvestaja='%s' and id='%s'" %  (salvestaja,id)

   #print query # uncomment for debugging

   con = sqlite.connect(databasefile)
   cur = con.cursor()
   cur.execute(query)
   con.commit()
   print "1"

except Exception, e:

 #print e # uncommment for debugging
 print "0"