def maps():
from wsw import query_db
query = "SELECT * FROM MAPS"
maps = query_db(query)
form = NewMapForm(request.form)
return render_template("admin/maps.html", maps=maps, form=form)
def get_signups(season_id):
query = """
SELECT id, username FROM signups
LEFT JOIN users ON id = user_id
WHERE season_id = ?
AND division IS NULL
"""
return query_db(query, [season_id])
def get_map_pool(self):
from wsw import query_db
query = """
SELECT id, name FROM season_maps
LEFT JOIN maps ON maps.id = map_id
WHERE season_id = ?
"""
return query_db(query, (self.id))
def get_signups(self):
from wsw import query_db
query = """
SELECT users.id, username, division FROM signups
LEFT JOIN users ON users.id = user_id
WHERE season_id = ?
"""
return query_db(query, (self.id))
def get_waiting_list(self):
from wsw import query_db
query = """
SELECT users.id, users.username, signups.division
FROM signups
LEFT JOIN users ON users.id = signups.user_id
WHERE signups.season_id = ? AND signups.division IS NULL
"""
return query_db(query, (self.id))
def load(self, id=None):
from wsw import query_db
if not id:
if not self.id:
return
id = self.id
query = 'SELECT * FROM seasons WHERE id = ?'
data = query_db(query, (id), True)
self.signup_limit = data['signup_limit']
self.signups_open = data['signups_open']
def get_division(self, division):
from wsw import query_db
query = """
SELECT users.id, username, division FROM signups
LEFT JOIN users ON users.id = user_id
WHERE season_id = ?
AND division = ?
"""
values = (self.id, division)
return query_db(query, values)
def get_division_numbers(self):
from wsw import query_db
query = """
SELECT MAX(division) as max FROM signups
WHERE season_id = ? ORDER BY division ASC
"""
max = query_db(query, (self.id), True)['max']
if max:
return range(1, max+1)
return None
def signups():
season_id = Season.get_current_season_id()
user_id = current_user.get_id()
signups = get_signups(season_id)
query = """
SELECT COUNT(*) as count FROM signups
WHERE season_id = ?
AND user_id = ?
"""
signedup = query_db(query, [season_id, user_id], True)['count']
return render_template('signups.html', signups=signups, signedup=signedup,
divisions=get_divisions(season_id))
def login():
form = LoginForm(request.form, prefix='login_')
if request.method == 'POST':
if form.validate_on_submit():
query = """
SELECT id, username, password, is_admin, is_active FROM users
WHERE username LIKE ?
"""
values = [form.username.data]
result = query_db(query, values, one=True)
if result and bcrypt.check_password_hash(result['password'],
form.password.data):
user = User(result['username'], result['id'],
result['is_admin'], result['is_active'])
if login_user(user, form.remember.data):
flash("Welcome back, %s" % (result['username']))
return redirect(url_for("index"))
else:
flash("Could not login") # better message?
else:
flash("Invalid username or password")
return render_template("login.html", form=form)
def users():
query = 'SELECT id, username, email, is_active, is_admin FROM users'
from wsw import query_db
return render_template("admin/users.html", users=query_db(query))
def get_users():
query = """
SELECT id, username, email, password, is_admin FROM users
WHERE is_active = 1
"""
return query_db(query)
def get_seasons_list():
from wsw import query_db
query = 'SELECT id FROM seasons'
return query_db(query)
