exam_show

#coding: utf_8

import sqlite3
from flask import Flask, request, session, g, redirect, url_for, \
       abort, render_template, flash
import pdb

#configuration
DATABASE = 'exam.db'
DEBUG = True
SECRET_KEY = 'development key'
USERNAME = 'admin'
PASSWORD = 'default'

#create our little application
app = Flask(__name__)
app.config.from_object(__name__)

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

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

@app.after_request
def after_request(response):
    g.db.close()
    return response

@app.route('/')
def index():
    cur = g.db.execute('select * from exam where difficult = ? order by no asc', ["none"])
    items = [dict(no=row[0], question=row[1], answer=row[2], difficult=row[3], catalog=row[4]) for row in cur.fetchall()]
    return render_template('index.html', items=items)

@app.route('/admin')
def index():
    cur = g.db.execute('select * from exam order by no asc')
    pdb.set_trace()
    items = [dict(no=row[0], question=row[1], answer=row[2], difficult=row[3], catalog=row[4]) for row in cur.fetchall()]
    return render_template('admin.html', items=items)

@app.route('/add', methods=['POST'])
def add_item():
    for key, value in request.form.items():
        g.db.execute('update exam set difficult=? where no=?', (value, int(key)))
    g.db.commit()
    return redirect('/')


if __name__ == '__main__':
    app.run()