def stats():
um = UsersModel(db.get_connection())
users_list = um.get_all()
nm = NewsModel(db.get_connection())
news_list = nm.get_all()
stats_list = []
for item in users_list:
hobosti = list(
filter(lambda x: x == item[0], map(lambda x: x[3], news_list)))
stats_list.append([item[1], len(hobosti)])
return render_template('stats.html', stats_list=stats_list)
def sign_up():
if request.method == 'GET':
return render_template(
'sign_up.html',
title='Please fill in this form to create an account:')
elif request.method == 'POST':
um = UsersModel(db.get_connection())
um.init_table()
um.insert(request.form['email'], request.form['uname'],
request.form['pswd'])
session['username'] = request.form['uname']
print(um.get_all())
return redirect('/main')
def login():
if request.method == 'GET':
return render_template(
'login.html',
title='Please fill in this form to sign in an account:')
elif request.method == 'POST':
um = UsersModel(db.get_connection())
um.init_table()
print(um.get_all())
if um.exists(request.form['email'], request.form['pswd']):
username = um.get_username(request.form['email'])
session['username'] = username
return redirect('/main')
else:
return render_template('login.html',
title='Wrong email or password')
def site_users():
if 'username' not in session:
return redirect('/login')
if session['username'] not in admins:
return redirect('/')
user_model = UsersModel(db.get_connection())
num = user_model.get_all()
all_users = []
for i in num:
id = i[0]
username = i[1]
password = i[2]
k = user_model.count(id)
all_users.append((id, username, password, k))
return render_template('site_users.html',
users=all_users,
admins=admins,
username=session['username'])
def index():
if request.method == 'GET':
form = cgi.FieldStorage()
if 'username' not in session or not flag_perm and not session.permanent:
if "username" in session:
return redirect("/logout")
return redirect('/login')
news = NewsModel(db.get_connection()).get_all(session['user_id'])
user_model = UsersModel(db.get_connection())
all_news = NewsModel(db.get_connection()).get_all()
all_users = user_model.get_all()
if session['username'] in admins:
return render_template('index.html',
news=reversed(all_news),
admins=admins,
username=session['username'],
all_users=all_users,
adm_n=news)
return render_template('index.html',
username=session['username'],
news=reversed(news),
admins=admins)
def users():
users = UsersModel(db.get_connection())
return render_template('users.html', users=users.get_all(
)) # users db has get_all method to get list of all the users
