Tammet – 16. aprill 2009, kell 15:12

2009-04-16T15:12:36Z

←Vanem redaktsioon		Redaktsioon: 16. aprill 2009, kell 17:12
1. rida:		1. rida:
			<pre>
	#!/usr/bin/python		#!/usr/bin/python
	import sys		import sys
56. rida:		57. rida:
	#print e # uncommment for debugging		#print e # uncommment for debugging
	print "0"		print "0"
			</pre>

Tammet – 16. aprill 2009, kell 15:12

2009-04-16T15:12:14Z

Uus lehekülg

#!/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"

Uuenda.py - Redigeerimiste ajalugu

Tammet – 16. aprill 2009, kell 15:12

Tammet – 16. aprill 2009, kell 15:12