def register():
form = Signupform()
if request.method == 'POST':
if form.validate_on_submit():
obj = Hssh(form.password.data)
password = obj.hashpassword()
day = request.form['day']
mon = request.form['mon']
year = request.form['year']
dob = day+'/'+mon+'/'+year
user = Table('users', metadata, autoload=True)
user.insert().execute({'uname':form.uname.data,'password':password,'fname':form.fname.data, 'lname':form.lname.data, 'email':form.email.data,
'gender':request.form['gender'], 'address':form.address.data,'dob':dob})
table = Table('users', metadata, autoload=True)
rs = select([func.max(table.c.id)]).execute()
for row in rs:
id = row[0]
user_id = 'green'+str(id)
#create post table
post = PostTable()
table = post.posttable(user_id)
table.create()
flash('you have successfully registered as '+ form.uname.data)
return redirect('')
else:
flash('please fill up the form correctly')
return render_template('register.html', form=form)
def log():
if 'logged_in' in session:
return redirect(url_for('hello'))
if request.cookies.get('auth') is not None:
session['logged_in'] = True
session['auth'] = request.cookies.get('auth')
return redirect(url_for('hello'))
else:
form = LoginForm()
name = None
if request.method == 'POST':
if form.validate_on_submit():
obj = Hssh(form.password.data)
table = Table('users', metadata, autoload=True)
rs = select([table.c.id, table.c.uname, table.c.password],
table.c.uname == form.username.data).execute()
for row in rs:
id = row[0]
name = row[1]
password = row[2]
if name != None:
if obj.chkpassword(password) is True:
session['logged_in'] = True
session['name'] = name
author = 'green' + str(id)
session['auth'] = author
if request.form.get("remember") == '1':
rsp = make_response(redirect(url_for('hello')))
rsp.set_cookie('auth',
session['auth'],
expires=datetime.now() +
timedelta(days=10))
return rsp
flash('you are successfully logged in')
return redirect(url_for('hello'))
else:
flash('username or password is incorrect')
return render_template('log.html', form=form)
else:
flash('username or password is incorrect')
return render_template('log.html', form=form)
return render_template('log.html', form=form)
def log():
if 'logged_in' in session:
return redirect(url_for('hello'))
if request.cookies.get('auth') is not None:
session['logged_in']=True
session['auth']=request.cookies.get('auth')
return redirect(url_for('hello'))
else:
form = LoginForm()
name = None
if request.method == 'POST':
if form.validate_on_submit():
obj = Hssh(form.password.data)
table = Table('users', metadata, autoload=True)
rs = select([table.c.id,table.c.uname,table.c.password],table.c.uname==form.username.data).execute()
for row in rs:
id = row[0]
name = row[1]
password = row[2]
if name != None:
if obj.chkpassword(password) is True:
session['logged_in'] = True
session['name'] = name
author = 'green'+str(id)
session['auth'] = author
if request.form.get("remember")=='1':
rsp = make_response(redirect(url_for('hello')))
rsp.set_cookie('auth',session['auth'],expires=datetime.now()+timedelta(days=10))
return rsp
flash('you are successfully logged in')
return redirect(url_for('hello'))
else:
flash('username or password is incorrect')
return render_template('log.html',form=form)
else:
flash('username or password is incorrect')
return render_template('log.html',form=form)
return render_template('log.html', form=form)
def register():
form = Signupform()
if request.method == 'POST':
if form.validate_on_submit():
obj = Hssh(form.password.data)
password = obj.hashpassword()
day = request.form['day']
mon = request.form['mon']
year = request.form['year']
dob = day + '/' + mon + '/' + year
user = Table('users', metadata, autoload=True)
user.insert().execute({
'uname': form.uname.data,
'password': password,
'fname': form.fname.data,
'lname': form.lname.data,
'email': form.email.data,
'gender': request.form['gender'],
'address': form.address.data,
'dob': dob
})
table = Table('users', metadata, autoload=True)
rs = select([func.max(table.c.id)]).execute()
for row in rs:
id = row[0]
user_id = 'green' + str(id)
#create post table
post = PostTable()
table = post.posttable(user_id)
table.create()
flash('you have successfully registered as ' + form.uname.data)
return redirect('')
else:
flash('please fill up the form correctly')
return render_template('register.html', form=form)
