def obter_curso(sigla='', id=''):
if sigla:
curso = g.query_db('SELECT * FROM cursos WHERE sigla = ?', [sigla],
one=True)
else:
curso = g.query_db('SELECT * FROM cursos WHERE id = ?', [id], one=True)
curso['grade'] = listar_disciplinas_curso(curso['id'])
return curso
def _get_command_name_by_id(self, dev_id, cmd_id):
name = g.query_db('SELECT name FROM commands WHERE dev_id=? AND cmd_id = ?', [dev_id, cmd_id], one=True)
if name == None:
return cmd_id
return name[0]
def _get_device_name_by_id(self, dev_id):
name = g.query_db('SELECT name FROM devices WHERE dev_id=?', [dev_id], one=True)
if name == None:
return dev_id
return name[0]
def listar_resultados():
partidas = g.query_db('SELECT * FROM partidas')
times = []
for p in partidas:
visitante = next(
filter(lambda x: x['id'] == p['time_visitante_id'], times), None)
if not visitante:
visitante = obter_time(p['time_visitante_id'])
visitante['vitorias'] = 0
visitante['empates'] = 0
visitante['derrotas'] = 0
times.append(visitante)
dono = next(filter(lambda x: x['id'] == p['time_dono_id'], times),
None)
if not dono:
dono = obter_time(p['time_dono_id'])
dono['vitorias'] = 0
dono['empates'] = 0
dono['derrotas'] = 0
times.append(dono)
if p['pontos_dono'] > p['pontos_visitante']:
dono['vitorias'] += 1
visitante['derrotas'] += 1
elif p['pontos_dono'] < p['pontos_visitante']:
dono['derrotas'] += 1
visitante['vitorias'] += 1
else:
dono['empates'] += 1
visitante['empates'] += 1
times.sort(key=lambda x: x['vitorias'], reverse=True)
return times
def listar_partidas(time_id):
return g.query_db(
'''
SELECT *
FROM partidas
WHERE time_dono_id = ?
OR time_visitante_id = ?
''', [time_id, time_id])
def listar_disciplinas_curso(curso_id):
disciplinas = g.query_db(
'''
SELECT c.semestre, d.*
FROM disciplinas d
JOIN curriculo c ON c.disciplina_id = d.id
WHERE c.curso_id = ?
''', [curso_id])
grade = {}
for d in disciplinas:
semestre = d['semestre']
if semestre not in grade:
grade[semestre] = [d]
else:
grade[semestre].append(d)
return grade
def obter_partida(partida_id):
return g.query_db('SELECT * FROM partidas WHERE id = ?', [partida_id],
one=True)
def listar_times():
return g.query_db('SELECT * FROM times')
def debug():
print g.query_db('select * from messages ')
return 'hi'
def check_messages(last_id):
'''get all messages after a sent 'id'.'''
q = 'select id, color, speaker, message from messages where id > ?'
messages = g.query_db(q, (last_id,))
return jsonify({'messages': messages})
def name_available(name):
'''Checks to see if no one active is using the name.'''
user = g.query_db('select id from active_users where name = ?', (name,), True)
return user is None
def login():
user = g.query_db(
'select id from admins where name = ? and password = ?',
(request.form['username'], g.sha1(request.form['password'])), True)
suc = user is not None
return jsonify({'success': suc})
def login():
user = g.query_db('select id from admins where name = ? and password = ?',
(request.form['username'], g.sha1(request.form['password'])), True)
return jsonify({'success': (user is not None)})
def get_commands():
# Note: jsonify() does not allow top-level arrays due to
# a security risk.
commands = g.query_db('select id, name from commands')
return jsonify({'commands': commands})
def obter_time(time_id):
return g.query_db('SELECT * FROM times WHERE id = ?', [time_id], one=True)
def listar_membros(time_id):
return g.query_db('SELECT * FROM membros WHERE id = ?', [time_id])
def listar_todos_cursos():
rv = g.query_db('SELECT * FROM cursos')
return rv
def listar_disciplinas():
rv = g.query_db('SELECT * FROM disciplinas')
return rv
def get_commands():
# Note: jsonify() does not allow top-level arrays due to
# a security risk.
commands = g.query_db('select id, name from commands')
return jsonify({'commands': commands})
