app.py

from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow 
#import flask_whooshalchemy as wa
import os

app = Flask(__name__)

basedir = os.path.abspath(os.path.dirname(__file__))

#database
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join(basedir, 'cedict.db')
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False 
#init db
db = SQLAlchemy(app)
#init ma
ma = Marshmallow(app)
#init whoosh
#wa.whoost_index(app, post)

#dict entry class/model
class Entries(db.Model):
    __searchable__ = ['pinyin', 'char_simp', 'char_trad']

    id = db.Column(db.Integer, primary_key=True)
    char_simp = db.Column(db.String(200))
    char_trad = db.Column(db.String(100), unique=True)
    pinyin = db.Column(db.String(100))
    definition = db.Column(db.String(500))

    def __init__(self, char_trad, char_simp, pinyin, definition):
        self.char_simp = char_simp
        self.char_trad = char_trad
        self.pinyin = pinyin
        self.definition = definition

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

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

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

@app.route('/search', methods=['GET', 'POST'])
def search():
    query_parameters = request.args
    entry = query_parameters.get('query')
    results = Entries.query.filter_by(char_simp=entry)
    count = results.count()

    # if result was found return it, else check traditional forms
    if count > 0:
        return render_template('search_results.html', results=results, count=count, entry=entry)
    else:
        results = Entries.query.filter_by(char_trad=entry)
        count = results.count()
        return render_template('search_results.html', results=results, count=count, entry=entry)

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