data.py

from flask import Flask, flash, redirect, render_template, request, session, abort
import os
from sqlalchemy.orm import sessionmaker
from table import *

# http://mindmapengineers.com/mmeblog/creating-web-app-scratch-using-python-flask-and-mysql-part-3

# implementing bucketList database
engine = create_engine('sqlite:///bucketlist.db', echo=True)

app = Flask(__name__)

# the start-up html page
@app.route('/')
def home():
    if not session.get('logged_in'):
        return render_template('signin.html')
    else:
        return "Hello User!"

# the page that is entered after signing in
@app.route('/showBucketList', methods=['POST'])
def do_admin_showBucketList():
    POST_USERNAME = str(request.form['username'])
    POST_PASSWORD = str(request.form['password'])
    print("POST_USERNAME: ", POST_USERNAME)
    print("POST_PASSWORD: ", POST_PASSWORD)


    Session = sessionmaker(bind=engine)
    s = Session()
    query = s.query(User).filter(User.username.in_([POST_USERNAME]), User.password.in_([POST_PASSWORD]))
    result = query.first()
    if result:
        session['logged_in'] = True
    else:
        flash('wrong password!')
    return home()

# the logout method
@app.route("/logout")
def logout():
    session['logged_in'] = False
    return home()

"""
 # calls to get a wish
@app.route('/getBucketList')
def getBucketList():
    try:
        if session.get('user'):
            _user = session.get('user')

            con = mysql.connect()
            cursor = con.cursor()
            cursor.callproc('sp_GetBucketListByUser', (_user,))
            bucketList = cursor.fetchall()

            wishes_dict = []
            for wish in bucketList:
                wish_dict = {
                    'Title': bucketList[1],
                    'Description': bucketList[2]
                wishes_dict.append(wish_dict)

            return json.dumps(wishes_dict)
        else:
            return render_template('/')
    except Exception as e:
        return render_template('/', error=str(e))

# calls to add to bucketList
@app.route('/addBucketList', methods=['POST'])
def addBucketList():
    try:
        if session.get('user'):
            _title = request.form['inputTitle']
            _description = request.form['inputDescription']
            _user = session.get('user')

            conn = mysql.connect()
            cursor = conn.cursor()
            cursor.callproc('sp_addBucketList', (_title, _description, _user))
            data = cursor.fetchall()

            if len(data) is 0:
                conn.commit()
                return redirect('/signin')
    finally:
        cursor.close()
        conn.close()
"""
# method to run application
if __name__ == "__main__":
    app.secret_key = os.urandom(12)
    app.run()