def login(): """Renders the login page. Recieves register page info and sends to sql db""" error = None if request.method == 'POST': cursor = connsql.initCursor() if request.form['userStatus'] == "Business": userList = connsql.validateBusiness(cursor, request.form['username'], request.form['password']) if userList[0]: """Store Session variables here""" session['business_id'] = userList[1] session['userStatus'] = 'B' return redirect(url_for("businesses")) else: error = 'Invalid Credentials. Please try again.' elif request.form['userStatus'] == "Individual": userList = connsql.validateIndividual(cursor, request.form['username'], request.form['password']) if userList[0]: """Store Session variables here""" session['individual_id'] = userList[1] session['userStatus'] = 'I' return redirect(url_for("individuals")) else: error = 'Invalid Credentials. Please try again.' return render_template('login.html', error=error)
def individuals(): """Renders the about page.""" cursor = connsql.initCursor() connsql.updateCoinsIndividual(cursor) return render_template('individuals.html', title='Individual', year=datetime.now().year, message='Your application description page.')
def item(itemid): """Renders the item page.""" cursor = connsql.initCursor() cursor.execute("Select * from Items where item_id = ?", itemid) return render_template('item.html', title='Market Item', year=datetime.now().year, item=cursor)
def joinEvents(eventid): cursor = connsql.initCursor() connsql.joinEvent(cursor, eventid, session['individual_id']) if (session['userStatus'] == 'I'): connsql.updateCoinsIndividual(cursor) else: connsql.updateCoinsBusiness(cursor) return redirect(url_for('events'))
def businesses(): """Renders the about page.""" cursor = connsql.initCursor() connsql.updateCoinsBusiness(cursor) return render_template('businesses.html', title='Businesses', year=datetime.now().year, message='Your application description page.')
def marketplace(): """Renders the marketplace page.""" cursor = connsql.initCursor() cursor.execute("Select * from Items") return render_template('marketplace.html', title='marketplace', year=datetime.now().year, items=cursor, columncount=0)
def purchase(itemid): cursor = connsql.initCursor() if (session['userStatus'] == 'I'): connsql.purchaseIndiv(cursor, itemid, session['individual_id']) connsql.updateCoinsIndividual(cursor) else: connsql.purchaseBus(cursor, itemid, session['business_id']) connsql.updateCoinsBusiness(cursor) return redirect(url_for('marketplace'))
def events(): cursor = connsql.initCursor() if (session['userStatus'] == 'I'): connsql.updateCoinsIndividual(cursor) else: connsql.updateCoinsBusiness(cursor) cursor.execute("Select * from Events") return render_template('events.html', title='Events', year=datetime.now().year, events=cursor, intohtml=intohtml)
def createEvent(): """Renders the register page. Recieves register page and sends to sql db""" form = EventRegistrationForm(request.form) if request.method == 'POST' and form.validate(): cursor = connsql.initCursor() connsql.insertEvent(cursor, form.eventName.data, form.eventDescription.data, form.eventCoins.data, form.eventDate.data, session['business_id'], form.eventLength.data) connsql.updateCoinsBusiness(cursor) return redirect(url_for('home')) return render_template('createevents.html', form=form)
def register(): """Renders the register page. Recieves register page and sends to sql db""" form = RegistrationForm(request.form) if request.method == 'POST' and form.validate(): user = User(form.username.data, form.email.data, form.password.data, form.userStatus.data) cursor = connsql.initCursor() if (user.userStatus == "Business"): error = connsql.insertBusiness(cursor, user.username, user.password, 900, user.email) elif (user.userStatus == "Individual"): error = connsql.insertIndividuals(cursor, user.username, user.password, user.email) if (error == None): return redirect(url_for('login')) return render_template('register.html', form=form)