def login(): error = None aUser = None sql = None if request.method == 'POST': input = str(request.form['username']) sql = "select * from aUserTable where uLoginID = %s" aUser = lm.dbconnect(sql, input) if request.method == 'POST': if (request.form['username'] != aUser[0]['uLoginID']) \ or request.form['password'] != aUser[0]['uHash']: error = 'Invalid Credentials. Please try again.' else: session['logged_in'] = True if session['logged_in'] == True: authSkaterUUID = aUser asUUID = (authSkaterUUID[0]['uSkaterUUID']) aSkater = 'select * from uSkaterConfig where uSkaterUUID = %s' aUserInfo = lm.dbconnect(aSkater, asUUID) print(aUserInfo) session['username'] = aUser[0]['uLoginID'] session['sUUID'] = aUser[0]['uSkaterUUID'] session['username'] = aUser[0]['uLoginID'] session['sUUID'] = aUser[0]['uSkaterUUID'] session['fName'] = aUserInfo[0]['uSkaterFname'] session['lName'] = aUserInfo[0]['uSkaterLname'] session['uSkaterUUID'] = aUserInfo[0]['uSkaterUUID'] g.sessID = session.get('uSkaterUUID') else: pass flash('You were logged in.') return redirect(url_for('dashboard')) return render_template('unauth_login.html', error=error)
def studentVideos(uSkaterUUID=None): vTUP = (uSkaterUUID) if uSkaterUUID == 0: print('welp. its empty') else: vTUP = (uSkaterUUID) sql = "SELECT * FROM j_videos WHERE uSkaterUUID = %s ORDER BY date desc" results = st.dbconnect(sql, vTUP) return results
def index(): sql = "select * from uSkaterConfig where uSkaterUUID = %s" subUserUUID = session['sUUID'] results = lm.dbconnect(sql, subUserUUID) return render_template('etemp_dashboard.html', skatertype=g.skatertype, ses=session, costs=g.costs, hours=g.mHours, maint=g.maint, chart_body=g.sessions, thour=g.hours[2], modal1=g.modalSessions, calDate=g.now) # render a template
def uCoachInfo(AuthSkaterUUID): vTUP = (AuthSkaterUUID) #sql = 'select * from uSkaterConfig where uSkaterUUID = %s' sql = 'select * from uSkaterConfig where uSkaterConfig.uSkaterUUID = %s' results = st.dbconnect(sql, vTUP) return results
def coachStudentHours(uSkaterUUID=None): vTUP = uSkaterUUID, 1 sql = 'select * from uSkaterConfig where activeCoach = %s and uSkaterType = %s' results = st.dbconnect(sql, vTUP) return results