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