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