def postEscola(): form = RegistrationCurso(request.form) cpf = request.form.get('cpf') instituicao = request.form.get('instituicao') sql = str(cpf), form.curso.data, instituicao local = request.form.get('local') locais = request.form.get('locais') insti = request.form.get('insti') if locais: if insti: acessa_sql( 'INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + locais + '),' + insti + ');') print 1 else: print locais sql = 'INSERT INTO LOCAL (local) VALUES ("' + locais + '");' data = acessa_sql(sql) print data if insti: if not locais: print 3 acessa_sql( 'INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + local + '),' + insti + ');') acessa_proc('sp_insertInfo_escola', sql) return redirect('/admin')
def autocomplete(): search = request.args.get('term') app.logger.debug(search) curso = acessa_sql('select curso from CURSO') cursos = [] [cursos.append(x) for xs in curso for x in xs] return jsonify(json_list=cursos)
def setInstituicao(): local = request.args.get('local').encode('utf8') parametros = str(local,) data = acessa_sql('select instituicao from INSTITUICAO I, LOCAL L where L.ID_local=I.ID_local AND local=\'' + parametros + '\'') if data is None: return redirect('/escola') return jsonify(instituicao=data)
def signin(): form = SignIn(request.form) try: _username = request.form['user'] _password = form.password.data data = acessa_sql('SELECT PASSWD FROM PASS WHERE LOGIN="******";') if len(data) > 0: me = User(_username, _password) if me.verifica_password(str(data[0][0]), _password): session['user'] = _username return redirect('/admin') else: return render_template('signin.html', error='Email ou senha errados.', form=form) else: return render_template('signin.html', error='Email ou senha errados.', form=form) except: return render_template('signin.html', form=form)
def escola(cpf): if session.get('user'): name = session.get('user') local = acessa_sql('select local from LOCAL') form = RegistrationCurso(request.form) return render_template('escola.html', form=form, local=local, name=name, cpf=cpf) else: return redirect(url_for('signin'))
def admin(): if session.get('user'): name = session.get('user') bairro = acessa_sql('SELECT bairro FROM BAIRRO;') form = RegistrationForm(request.form) return render_template('cadastro.html', form=form, bairro=bairro, name=name) else: return redirect(url_for('signin'))
def setInstituicao(): local = request.args.get('local').encode('utf8') parametros = str(local, ) data = acessa_sql( 'select instituicao from INSTITUICAO I, LOCAL L where L.ID_local=I.ID_local AND local=\'' + parametros + '\'') if data is None: return redirect('/escola') return jsonify(instituicao=data)
def postEscola(): form = RegistrationCurso(request.form) cpf = request.form.get('cpf') instituicao = request.form.get('instituicao') sql = str(cpf), form.curso.data, instituicao local = request.form.get('local') locais = request.form.get('locais') insti = request.form.get('insti') if locais: if insti: acessa_sql('INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + locais + '),' + insti + ');') print 1 else: print locais sql = 'INSERT INTO LOCAL (local) VALUES ("' + locais + '");' data = acessa_sql(sql) print data if insti: if not locais: print 3 acessa_sql('INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + local + '),' + insti + ');') acessa_proc('sp_insertInfo_escola', sql) return redirect('/admin')