def ok(self):
try:
numCartao = int(self.lineNumCartao.text())
except:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Dados informados incorretamente!")
self.window.show()
return
temp = banco.Banco().buscarCartao(numCartao)
if temp:
self.msgBemVindo.setText("Bem Vindo, " + str(temp[1]))
if temp[2] > 0:
self.numFichas.setText(str(temp[2] - 1))
self.numAcesso.setText(str(temp[3] + 1))
banco.Banco().atualizarNumDeFichas(temp[0], (temp[2] - 1),
(temp[3] + 1))
else:
self.numFichas.setText(str(temp[2]))
self.numAcesso.setText(str(temp[3]))
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Número de fichas insuficiente!")
self.window.show()
else:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Usuário não encontrado!")
self.window.show()
def recupera(self, id):
self.bd = banco.Banco()
caminho = ".\\log" + str(self.id)
caminhoSnap = caminho + "\\snap." + str(self.versao)
if self.versao > 0:
try:
snap = open(caminhoSnap, "r")
except:
print("ERRO AO ABRIR SNAPSHOT")
return None
try:
for linha in snap:
aux = linha.split(' ')
self.bd.create(int(aux[0]), aux[1].strip("\n"))
except:
print("ERRO AO RECUPERAR SNAPSHOT")
return None
try:
caminho = ".\\log" + str(self.id)
caminhoLog = caminho + "\\log." + str(self.versao)
arquivoLog = open(caminhoLog, "r")
if arquivoLog is not None:
for linha in arquivoLog:
aux = linha.split(' ', 2)
if int(aux[0]) == 1:
self.bd.create(int(aux[1]), aux[2].strip("\n"))
elif int(aux[0]) == 3:
self.bd.update(int(aux[1]), aux[2].strip("\n"))
elif int(aux[0]) == 4:
self.bd.delete(int(aux[1]))
arquivoLog.close()
except:
print("ERRO AO RECUPERAR LOG")
return self.bd
def escreve_snapshot(self, bnc, versao):
self.versao = versao
caminho = ".\\log" + str(self.id)
nomeSnap = caminho + "\\snap." + str(self.versao)
nomeLog = caminho + "\\log." + str(self.versao)
snap = open(nomeSnap, "a")
open(nomeLog, "a")
bd = banco.Banco()
bd = bnc
for k, v in bd.mapa.items():
try:
snap.write(str(k) + " " + str(v) + "\n")
snap.flush()
except:
print("ERRO")
if (self.versao > 2):
try:
os.remove(caminho + "\\log." + str(self.versao - 3))
except:
pass
if (self.versao > 3):
try:
os.remove(caminho + "\\snap." + str(self.versao - 3))
except:
pass
def cadastrar(self):
temp = []
temp.append(self.lineEditNome.text())
temp.append(self.lineEditSobrenome.text())
temp.append(self.lineEditCPF.text())
temp.append(self.lineEditCurso.text())
temp.append(self.lineEditCampus.text())
if self.senha.text() == self.confirmarSenha.text():
h = hashlib.sha1()
h.update((self.senha.text()).encode('utf-8'))
temp.append(h.hexdigest())
else:
print('Senha incorretas')
return
temp.append(self.usuario.text())
try:
temp.append(int(self.lineEdit.text()))
except:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Dados informados incorretamente!")
self.window.show()
return
banco.Banco().cadastrar(self.idUsuario, temp)
self.tela.close()
self.window = QtWidgets.QMainWindow()
self.ui = admin.Ui_Home()
self.ui.setupUi(self.window)
self.window.show()
def btnLogar(self):
h = hashlib.sha1()
h.update((self.lineEdit_2.text()).encode('utf-8'))
temp = banco.Banco().logar(self.lineEdit.text(), h.hexdigest())
if temp:
solic = banco.Banco().solicitou(temp[0])
self.tela.close()
self.window = QtWidgets.QMainWindow()
self.ui = solicitarCartao.Ui_solicitarCartao(temp, solic)
self.ui.setupUi(self.window)
self.window.show()
else:
self.window = QtWidgets.QMainWindow()
self.ui = loginError.Ui_loginInvalido()
self.ui.setupUi(self.window)
self.window.show()
def procurarDados(self):
try:
matricula = (int(self.lineEditMatricula.text()))
except:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Dados informados incorretamente!")
self.window.show()
return
temp = banco.Banco().dadosUsuario(matricula)
idCartao = banco.Banco().buscaIdCartao()
if idCartao:
if temp:
self.idUsuario = temp[0]
self.lineEditMatricula.setEnabled(False)
self.lineEditNome.setText(temp[1])
self.lineEditSobrenome.setText(temp[2])
self.lineEditCPF.setText(temp[3])
self.lineEditCurso.setText(temp[4])
self.lineEditCampus.setText(temp[5])
self.usuario.setText(
(str(temp[1]) + '.' + str(temp[2])).lower().replace(
' ', ''))
self.lineEdit.setText(idCartao)
self.usuario.setEnabled(True)
self.senha.setEnabled(True)
self.confirmarSenha.setEnabled(True)
self.btnOk.hide()
self.btnCadastrar.show()
else:
self.idUsuario = -1
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Usuário não encontrado!")
self.window.show()
else:
self.idUsuario = -1
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window,
"Não existem mais cartões disponiveis!")
self.window.show()
def comprarFichas(self):
try:
fichas = int(self.inputFichas.text())
except:
print('Erro2')
return
if fichas >= 0 and fichas <= 100:
self.cliente.qtdFichas = banco.Banco().comprarFichas(
self.cliente.qtdFichas + int(self.inputFichas.text()),
self.cliente.id)
self.numFichas.setText(
QtCore.QCoreApplication.translate("solicitarCartao",
str(self.cliente.qtdFichas)))
else:
print('Erro1')
def btnLogarAdm(self):
h = hashlib.sha1()
h.update((self.lineEdit_2.text()).encode('utf-8'))
temp = banco.Banco().logarAdm(self.lineEdit.text(), h.hexdigest())
if temp:
self.tela.close()
self.window = QtWidgets.QMainWindow()
self.ui = admin.Ui_Home()
self.ui.setupUi(self.window)
self.window.show()
else:
self.window = QtWidgets.QMainWindow()
self.ui = loginError.Ui_loginInvalido()
self.ui.setupUi(self.window)
self.window.show()
def setupUi(self, Solicitacao):
self.tela = Solicitacao
Solicitacao.setObjectName("Solicitacao")
Solicitacao.resize(800, 600)
Solicitacao.setStyleSheet("background-color: rgb(247, 247, 247);")
self.listWidget = QtWidgets.QListWidget(Solicitacao)
self.listWidget.setGeometry(QtCore.QRect(25, 60, 750, 480))
self.listWidget.setObjectName("listWidget")
item = QtWidgets.QListWidgetItem()
font = QtGui.QFont()
font.setUnderline(False)
item.setFont(font)
self.itens = banco.Banco().buscarSolicitacoes()
if self.itens:
cont = 0
for i in self.itens:
self.listWidget.addItem(item)
item = QtWidgets.QListWidgetItem()
texto = self.listWidget.item(cont)
texto.setText(QtCore.QCoreApplication.translate("Solicitacao", "ID Usuario: " + str(i[2]) + " \t\t\tData de Solicitação: " + str(i[1])))
cont += 1
self.delete_2 = QtWidgets.QPushButton(Solicitacao)
self.delete_2.setGeometry(QtCore.QRect(40, 545, 160, 25))
self.delete_2.setObjectName("delete_2")
self.delete_2.clicked.connect(self.excluirSolicitacao)
self.cancel = QtWidgets.QPushButton(Solicitacao)
self.cancel.setGeometry(QtCore.QRect(565, 545, 160, 25))
self.cancel.setObjectName("cancel")
self.cancel.clicked.connect(self.voltar)
self.label_5 = QtWidgets.QLabel(Solicitacao)
self.label_5.setGeometry(QtCore.QRect(40, 20, 301, 20))
font = QtGui.QFont()
font.setFamily("Roboto Light")
font.setPointSize(13)
font.setBold(False)
font.setWeight(50)
self.label_5.setFont(font)
self.label_5.setObjectName("label_5")
self.retranslateUi(Solicitacao)
QtCore.QMetaObject.connectSlotsByName(Solicitacao)
def comprarFichas(self):
try:
fichas = int(self.inputFichas.text())
self.inputFichas.setText('')
except:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Dados informados incorretamente!")
self.window.show()
return
if fichas > 0 and fichas <= 100:
self.cliente.qtdFichas = banco.Banco().comprarFichas(
self.cliente.qtdFichas + fichas, self.cliente.id)
self.numFichas.setText(
QtCore.QCoreApplication.translate("solicitarCartao",
str(self.cliente.qtdFichas)))
else:
self.window = QtWidgets.QMainWindow()
self.ui = erro.Ui_cadastroJaExiste()
self.ui.setupUi(self.window, "Informe um número entre 1 e 100!")
self.window.show()
def __init__(self, bits, srv, cAnt, cAtu, cSuc, pAnt, pAtu, pSuc, tsnap):
self.port = pAtu
self.bits = bits
self.srv = srv
self.cAnt = cAnt
self.cAtu = cAtu
self.cSuc = cSuc
self.pAnt = pAnt
self.pAtu = pAtu
self.pSuc = pSuc
self.time_snap = tsnap
self.chaves = []
self.f1 = fila.Fila()
self.f2 = fila.Fila()
self.f3 = fila.Fila()
self.f4 = fila.Fila()
self.fresp = fila.Fila()
self.bd = banco.Banco()
self.log = log.Log(self.time_snap, self.cAtu)
self.cfg = config.Config()
self.host = self.cfg.getHost().strip("\n")
self.visitado = False
self.versao_snap = 0
def excluirSolicitacao(self):
temp = self.listWidget.currentRow()
if temp >= 0:
item = self.listWidget.takeItem(self.listWidget.currentRow())
banco.Banco().excluirSolicitacao(self.itens[temp][0])
import banco as b banco = b.Banco()
# _loggerIP.setLevel(logging.DEBUG)
# loggerIPch = logging.StreamHandler()
# loggerIPch.setLevel(logging.DEBUG)
# loggerFormatter = logging.Formatter("%(asctime)s;%(levelname)s;%(message)s","%Y-%m-%d %H:%M:%S")
# loggerIPch.setFormatter(loggerFormatter)
# _loggerIP.addHandler(loggerIPch)
# _loggerIP.debug('Teste')
ServerFactory = BroadcastServerFactory
factory = ServerFactory("ws://localhost:{}".format(args.websocket),
debug=debug,
debugCodePaths=debug)
print('Servido websocket iniciado na porta {}.'.format(args.websocket))
factory.protocol = BroadcastServerProtocol
factory.setProtocolOptions()
listenWS(factory)
_gerenciadorPrincipal = gerenciador.GerenciadorPrincipal()
_banco = banco.Banco()
webdir = File("./webdir")
web = Site(webdir)
reactor.listenTCP(int(args.server), web)
print('Servido web iniciado na porta {}.'.format(args.server))
reactor.run()
signal.signal(signal.SIGINT, signal_handler)
import banco
import cuenta
import os
tit = os.sys.argv[1]
ban = os.sys.argv[2]
b = banco.Banco(ban, "Av. Las Rosas", "41 %", 2451, "Si")
c = cuenta.Cuenta("Ahorros", "Interbank", tit, 2092, 478563214587452)
print(c.ahorrar())
import servicos_pb2
import servicos_pb2_grpc
import threading
import fila
import banco
import time
import os
import config
import random
_ONE_DAY_IN_SECONDS = 60 * 60 * 24
f1 = fila.Fila()
f2 = fila.Fila()
f3 = fila.Fila()
f4 = fila.Fila()
bd = banco.Banco()
class Requisicao(servicos_pb2_grpc.RequisicaoServicer):
def Create(self,request,context):
requisicao = "1 " + request.chave + " " + request.valor
#tratar responsabilidade
f1.insere(requisicao)
def Read(self, request, context):
requisicao = "2 " + request.chave
f1.insere(requisicao)
def Update(self, request, context):
requisicao = "3 " + request.chave + " " + request.valor
def solicCartao(self):
self.cliente.solcitou = True
self.msgNovoCart.hide()
self.solicitarCartao.hide()
self.msgSolCart.show()
banco.Banco().inserirSolicitacao(self.cliente.id)
if "-d" in sys.argv or "--debug" in sys.argv or True:
loglevel = logging.DEBUG
logging.basicConfig(format="[%(asctime)s] [%(levelname)s] %(message)s",
datefmt="%d/%m/%Y %H:%M:%S",
level=loglevel)
# temos falcon?
try:
import falcon
except:
logging.critical("Instale Falcon!")
sys.exit(1)
# gerar a API
import handlers, banco
db = banco.Banco("banco.db")
api = falcon.API()
instances = {}
for subname in dir(handlers):
member = getattr(handlers, subname)
if not inspect.isclass(member) or handlers.Handler not in member.mro():
continue
handler = member(db)
print(f"{handler.__class__.__name__} tá on")
instances[subname] = handler
api.add_route(handler.route, handler)
for name, handler in instances.items():
instances["Help"].add_handler(name, handler)
logging.info("API online!")
