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!")