webapp.py

#!/usr/bin/env python
#coding=utf-8

# imports
import sqlite3
from flask import Flask,render_template,request,url_for,g,redirect
from contextlib import closing

# configuration
DATABASE = 'paper.db'


# application initialize
app = Flask(__name__)
app.config.from_object(__name__)

# database
def connect_db():
	return sqlite3.connect(app.config['DATABASE'])

# database initialize for CLI
# Usage: 
# >>> import webapp.py
# >>> webapp.init_db()

def init_db():
	with closing(connect_db()) as db:
		with app.open_resource('schema.sql',mode='r') as f:
			db.cursor().executescript(f.read())
		db.commit()

@app.before_request
def before_request():
    g.db = connect_db()

@app.teardown_request
def teardown_request(exception):
    db = getattr(g, 'db', None)
    if db is not None:
        db.close()

# application
@app.route('/')
def hello():
	return render_template('main.html')

@app.route('/<alias>/<paper>')
def generate(alias,paper):
	# 从服务器生成数据
	sql = 'select * from paper where alias="'+alias+'" and papername="'+paper+'" order by number'
	cur = g.db.cursor().execute(sql)
	data = [dict(alias=row[0], papername=row[1], number=row[2], type=row[3], content=row[4], optiona=row[5], optionb=row[6], optionc=row[7], optiond=row[8]) for row in cur.fetchall()]
	return render_template('paper.html',data = data)

@app.route('/add',methods=['POST','GET'])
def add():
	if request.method == 'GET':
		return render_template('newpaper.html')
	else:
		sql = 'insert into paper values(?,?,?,?,?,?,?,?,?,?)'
		data = [request.form['alias'], request.form['papername'], request.form['number'], request.form['type'], request.form['content'], request.form['optiona'], request.form['optionb'], request.form['optionc'], request.form['optiond'], request.form['answer']]
		g.db.cursor().execute(sql,data)
		# 题目信息计入数据库
		g.db.commit()
		# 重定向 新增页面
		# return redirect(url_for('add'))
		return "success"
	
@app.route('/result', methods=['POST'])
def result():
	papername = request.form['papername']
	alias = request.form['alias']
	sql = 'select number,answer,type from paper where alias="'+alias+'" and papername="'+papername+'" order by number'
	cur = g.db.cursor().execute(sql)
	num = 1
	right = 0
	for row in cur.fetchall():
		num = num + 1
		# row[0] --> number  row[1] --> answer row[2] --> 
		if row[2] == 1:
			# 有关简答题的评判标准，请在下面书写
			if request.form[row[0].__str__()].__len__() != 0:
				right = right + 1
		else:
			if request.form[row[0].__str__()] == row[1]:
				right = right + 1
	score = right * 100.0 / num
	return alias+":"+score.__str__()+"%"

@app.route('/admin')
def admin():
	return render_template('admin.html')

if __name__=="__main__":
	app.debug = True
	app.run()