def login():
error = None
if request.method == 'POST':
user = User.get_user(request.form['username'])
if bcrypt.check_password_hash(user.password, request.form['password']) and \
request.form['username'] == user.username:
login_user(user)
return redirect(url_for('config'))
else:
error = ' Usuário ou senha inválidos'
return render_template('login.html', error=error)
def setup():
''' Gerar databases e dados do sistema '''
from config import DATABASE_DIR, MIGRATE_DIR
os.system('clear')
print('''
Databases:
1) Aplicativo
2) Arbovírus
3) BIS Abbott
4) Geoprocessamento
5) Repositório
6) Tuberculose
7) Tuberculose 2015
8) Tuberculose 2016
9) Usuário
10) Todos os bancos
''')
file = input(" Selecione a opção: ")
if file == '1':
from database.sqconfig import init_app
from models.biologia_medica import ExameStatus
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/datagal.db')
init_app()
print(' Banco GAL criado com sucesso \n')
#os.system('python ' + MIGRATE_DIR + 'datagal.py')
#os.system('python ' + MIGRATE_DIR + 'bmh.py')
os.system('python ' + MIGRATE_DIR + 'biologia_medica.py')
print('*' * 50 + '\n')
elif file == '2':
from database.sqconfig import init_db_av
os.system('clear')
print('*' * 50)
os.system ('rm ' + DATABASE_DIR + 'data/arbovirus.db')
init_db_av()
print(' Banco de Arbovírus criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'arbovirus.py')
print('*' * 50 + '\n')
elif file == '3':
from database.sqconfig import init_abt
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/abbott.db')
init_abt()
print(' Banco do BI Abbott criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'abbott.py')
print('*' * 50 + '\n')
elif file == '4':
from database.pgconfig import init_datagis
os.system('clear')
print('*' * 50)
init_datagis()
print(' Banco de geoprocessamento criado com sucesso! \n')
os.system('python ' + MIGRATE_DIR + 'datageo.py')
print('*' * 50 + '\n')
elif file == '5':
from database.sqconfig import init_repo
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/repositorio.db')
init_repo()
print(' Banco do Repositório criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'repositorio.py')
print('*' * 50 + '\n')
elif file == '6':
from database.sqconfig import init_tub
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/tuberculose.db')
init_tub()
print(' Banco de Tuberculose criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'tuberculose.py')
print('*' * 50 + '\n')
elif file == '7':
from database.sqconfig import init_tb15
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/tuberculose_2015.db')
init_tb15()
print(' Banco de Tuberculose de 2015 criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'tuberculose_2015.py')
print('*' * 50 + '\n')
elif file == '8':
from database.sqconfig import init_tb16
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/tuberculose_2016.db')
init_tb16()
print(' Banco de Tuberculose de 2016 criado com sucesso \n')
os.system('python ' + MIGRATE_DIR + 'tuberculose_2016.py')
print('*' * 50 + '\n')
elif file == '9':
from database.sqconfig import init_user
from models.usuario import User
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/usuario.db')
init_user()
User.save('admin', 'admin@localhost', '123456')
print(' Banco de Usuários criado com sucesso \n')
#os.system('python ' + MIGRATE_DIR + 'usuario.py')
print('*' * 50 + '\n')
elif file == '10':
os.system('clear')
print('*' * 50)
os.system('rm ' + DATABASE_DIR + 'data/*.db')
print(' Gerando DATABASES do sistema.')
from database.sqconfig import init_app
from models.usuario import User
init_app()
User.save('admin', 'admin@localhost', '123456')
from database.sqconfig import init_db_av
from models.arbovirus import Arbovirus, Dengue
init_db_av()
from database.sqconfig import init_abt
from models.abbott import Bis
init_abt()
from database.pgconfig import init_datagis
from models.datageo import Municipio
init_datagis()
from database.sqconfig import init_tub
init_tub()
from database.sqconfig import init_tb15
init_tb15()
from database.sqconfig import init_tb16
init_tb16()
print(' Bancos gerados com sucesso. \n')
print(' Recuperando dados:')
print(' Aguarde, isso vai demorar MUITO...\n')
#os.system('python ' + MIGRATE_DIR + 'adm.py')
#os.system('python ' + MIGRATE_DIR + 'bmh.py')
#os.system('python ' + MIGRATE_DIR + 'arbovirus.py')
#os.system('python ' + MIGRATE_DIR + 'abbott.py')
#os.system('python ' + MIGRATE_DIR + 'datageo.py')
#os.system('python ' + MIGRATE_DIR + 'tuberculose.py')
#os.system('python ' + MIGRATE_DIR + 'tub_2015.py')
print('')
print(' Feito!!')
print('*' * 50 + '\n')
else:
print('')
print("Opção inválida! \n")
def config_user():
user = User.get()
return render_template('config/usuario.html',
user=user)
