def remove_client(self): """ Remove a client from the event's subscriptions. """ # If there is a client selected, removes it. # If there is not, shows up an error message. try: current_subscription = self.subscriptionList.currentRow() subscription_id = self.clients[current_subscription][0] # Asks if the user really wants to remove the client choice = QtGui.QMessageBox.question( self, u"Apagar inscrição", u"Tem certeza que deseja apagar esta inscrição?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No ) if choice == QtGui.QMessageBox.Yes: cursor.execute( "DELETE FROM subscriptions WHERE id=?", (str(subscription_id),) ) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText(u"Selecione um cliente existente!")
def remove_event(self): """ Delete an existing event. """ # Verifies if there is a selected event try: # Gets the event id r = self.eventsTable.currentRow() event_id = self.eventsTable.item(r, 0).text() # Asks if the user really wants to remove the event choice = QtGui.QMessageBox.question( self, u"Apagar evento", u"Tem certeza que deseja apagar este evento?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM events WHERE id=?", (str(event_id), )) conn.commit() else: pass # Updates the events table self.load_table() except AttributeError: self.errorMsg.setText(u"Selecione um registro existente!")
def remove_client(self): """ Remove a client from the event's subscriptions. """ # If there is a client selected, removes it. # If there is not, shows up an error message. try: current_subscription = self.subscriptionList.currentRow() subscription_id = self.clients[current_subscription][0] # Asks if the user really wants to remove the client choice = QtGui.QMessageBox.question( self, u"Apagar inscrição", u"Tem certeza que deseja apagar esta inscrição?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No ) if choice == QtGui.QMessageBox.Yes: cursor.execute( "DELETE FROM subscriptions WHERE id=?", str(subscription_id) ) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText(u"Selecione um cliente existente!")
def remove_signature(self): """ Delete an existing signature. """ # Verifies if there is a selected signature try: # Gets the selected signature id sig_id = self.signatures[self.signaturesList.currentRow()][0] # Asks if the user really wants to delete the signature choice = QtGui.QMessageBox.question( self, u"Apagar assinatura", u"Tem certeza que deseja apagar esta assinatura?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No ) if choice == QtGui.QMessageBox.Yes: os.remove(os.path.join(app_dir, "signatures", "{0}.png".format(str(sig_id)))) cursor.execute( "DELETE FROM signatures WHERE id=?", (str(sig_id),) ) conn.commit() else: pass # Updates the signatures list self.load_list() except IndexError: self.errorMsg.setText(u"Selecione um registro existente!")
def remove_event(self): """ Delete an existing event. """ # Verifies if there is a selected event try: # Gets the event id r = self.eventsTable.currentRow() event_id = self.eventsTable.item(r, 0).text() # Asks if the user really wants to remove the event choice = QtGui.QMessageBox.question( self, u"Apagar evento", u"Tem certeza que deseja apagar este evento?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No ) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM events WHERE id=?", str(event_id)) conn.commit() else: pass # Updates the events table self.load_table() except AttributeError: self.errorMsg.setText(u"Selecione um registro existente!")
def add_client(self): cursor.execute("INSERT INTO subscriptions VALUES (NULL,?,?)", (str(self.event_id), str(self.clients[self.clientsList.currentIndex()][0]))) conn.commit() self.certificates_instance.load_list() self.hide()
def save_data(self): if self.clientNameLineEdit.text() == "": self.errorMsg.setText("O nome precisa estar preenchido!") elif self.clientEmailLineEdit.text() == "": self.errorMsg.setText("O email precisa estar preenchido!") elif validar_cpf(self.clientRegisterLineEdit.text()) == False: self.errorMsg.setText(u"O CPF é inválido!") else: if self.client_id: cursor.execute( """ UPDATE clients SET name=?, email=?, register=? WHERE id=? """, (str(self.clientNameLineEdit.text()), str(self.clientEmailLineEdit.text()), str(self.clientRegisterLineEdit.text()), str(self.client_id))) else: cursor.execute("INSERT INTO clients VALUES (NULL,?,?,?)", (str(self.clientNameLineEdit.text()), str(self.clientEmailLineEdit.text()), str(self.clientRegisterLineEdit.text()))) conn.commit() self.clients_list_instance.load_table() self.hide()
def remove_signature(self): """ Delete an existing signature. """ # Verifies if there is a selected signature try: # Gets the selected signature id sig_id = self.signatures[self.signaturesList.currentRow()][0] # Asks if the user really wants to delete the signature choice = QtGui.QMessageBox.question( self, u"Apagar assinatura", u"Tem certeza que deseja apagar esta assinatura?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: os.remove( os.path.join(app_dir, "signatures", "{0}.png".format(str(sig_id)))) cursor.execute("DELETE FROM signatures WHERE id=?", (str(sig_id), )) conn.commit() else: pass # Updates the signatures list self.load_list() except IndexError: self.errorMsg.setText(u"Selecione um registro existente!")
def add_client(self): cursor.execute("INSERT INTO subscriptions VALUES (NULL,?,?)", ( str(self.event_id), str(self.clients[self.clientsList.currentIndex()][0]) )) conn.commit() self.certificates_instance.load_list() self.hide()
def executeSQL(sql): try: print('executeSQL = {}'.format(sql)) curs = conn.cursor() curs.execute(sql) conn.commit() return True except IntegrityError: return False
def save_data(self): """ Saves the client data. """ # Verifies if all fields are filled if unicode(self.clientNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.clientEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(validar_cpf(self.clientRegisterLineEdit.text())) is False: self.errorMsg.setText(u"O CPF é inválido!") else: if self.client_id: # Updates the record if it is an existing client cursor.execute( "UPDATE clients SET name=?, email=?, register=? \ WHERE id=?", (unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()), str(self.client_id))) conn.commit() # Updates the table self.clients_list_instance.load_table() # Hide the dialog self.hide() else: # Verifies if the user is trying to # register an existent client cursor.execute("SELECT id FROM clients WHERE register=?", (str(self.clientRegisterLineEdit.text()), )) existing_user = cursor.fetchone() if existing_user: # Shows up an error message error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"O cliente já está cadastrado!") error.setInformativeText(u"Já existe um cliente \ com este CPF cadastrado \ no programa.") error.setWindowTitle(u"Cliente já cadastrado!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: # Register the client cursor.execute( "INSERT INTO clients VALUES (NULL,?,?,?)", (unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()))) conn.commit() # Updates the table self.clients_list_instance.load_table() # Hide the dialog self.hide()
def remove_signature(self): try: sig_id = self.signatures[self.signaturesList.currentRow()][0] choice = QtGui.QMessageBox.question(self, "Apagar assinatura", "Tem certeza que deseja apagar esta assinatura?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM signatures WHERE id=?", str(sig_id)) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText("Selecione um registro existente!")
def save_data(self): if unicode(self.clientNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.clientEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(validar_cpf(self.clientRegisterLineEdit.text())) == False: self.errorMsg.setText(u"O CPF é inválido!") else: if self.client_id: cursor.execute( """ UPDATE clients SET name=?, email=?, register=? WHERE id=? """, (unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()), str(self.client_id))) conn.commit() self.clients_list_instance.load_table() self.hide() else: cursor.execute("SELECT id FROM clients WHERE register=?", [str(self.clientRegisterLineEdit.text())]) existing_user = cursor.fetchone() if existing_user: error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"O cliente já está cadastrado!") error.setInformativeText( u"Já existe um cliente com este CPF cadastrado no programa." ) error.setWindowTitle(u"Cliente já cadastrado!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: cursor.execute( "INSERT INTO clients VALUES (NULL,?,?,?)", (unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()))) conn.commit() self.clients_list_instance.load_table() self.hide()
def remove_client(self): try: subscription_id = self.clients[self.subscriptionList.currentRow()][0] choice = QtGui.QMessageBox.question(self, u"Apagar inscrição", u"Tem certeza que deseja apagar esta inscrição?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM subscriptions WHERE id=?", str(subscription_id)) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText(u"Selecione um cliente existente!")
def remove_client(self): try: r = self.clientsTable.currentRow() client_id = self.clientsTable.item(r,0).text() choice = QtGui.QMessageBox.question(self, u"Apagar cliente", u"Tem certeza que deseja apagar este cliente?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM clients WHERE id=?", str(client_id)) conn.commit() else: pass self.load_table() except AttributeError: self.errorMsg.setText(u"Selecione um registro existente!")
def remove_event(self): try: r = self.eventsTable.currentRow() event_id = self.eventsTable.item(r,0).text() choice = QtGui.QMessageBox.question(self, "Apagar evento", "Tem certeza que deseja apagar este evento?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM events WHERE id=?", str(event_id)) conn.commit() else: pass self.load_table() except AttributeError: self.errorMsg.setText("Selecione um registro existente!")
def remove_signature(self): try: sig_id = self.signatures[self.signaturesList.currentRow()][0] choice = QtGui.QMessageBox.question( self, "Apagar assinatura", "Tem certeza que deseja apagar esta assinatura?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM signatures WHERE id=?", str(sig_id)) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText("Selecione um registro existente!")
def save_data(self): if unicode(self.clientNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.clientEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(validar_cpf(self.clientRegisterLineEdit.text())) == False: self.errorMsg.setText(u"O CPF é inválido!") else: if self.client_id: cursor.execute(""" UPDATE clients SET name=?, email=?, register=? WHERE id=? """,( unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()), str(self.client_id) )) conn.commit() self.clients_list_instance.load_table() self.hide() else: cursor.execute("SELECT id FROM clients WHERE register=?", [str(self.clientRegisterLineEdit.text())]) existing_user = cursor.fetchone() if existing_user: error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"O cliente já está cadastrado!") error.setInformativeText(u"Já existe um cliente com este CPF cadastrado no programa.") error.setWindowTitle(u"Cliente já cadastrado!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: cursor.execute("INSERT INTO clients VALUES (NULL,?,?,?)", ( unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()) )) conn.commit() self.clients_list_instance.load_table() self.hide()
def save_data(self): """ Saves the event data. """ # Verifies if all fields are filled if unicode(self.eventTitleLineEdit.text()) == "": self.errorMsg.setText(u"O título precisa ser preenchido!") elif len(unicode(self.eventStartDateLineEdit.text())) < 10 or \ len(unicode(self.eventEndDateLineEdit.text())) < 10: self.errorMsg.setText(u"As datas precisam estar \ em um formato xx/xx/xxxx!") elif unicode(self.eventHoursLineEdit.text()) == "": self.errorMsg.setText(u"As horas precisam ser um inteiro!") else: if self.event_id: # Updates the record if it is an existing event cursor.execute( "UPDATE events SET title=?, start_date=?, end_date=?, \ hours=?, content=? WHERE id=?", ( unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()), str(self.event_id) ) ) else: # Register the event cursor.execute( "INSERT INTO events VALUES (NULL,?,?,?,?,?)", ( unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()) ) ) # Saves the database conn.commit() # Update the table self.events_list_instance.load_table() # Hide the dialog self.hide()
def remove_client(self): try: subscription_id = self.clients[ self.subscriptionList.currentRow()][0] choice = QtGui.QMessageBox.question( self, u"Apagar inscrição", u"Tem certeza que deseja apagar esta inscrição?", QtGui.QMessageBox.Yes | QtGui.QMessageBox.No) if choice == QtGui.QMessageBox.Yes: cursor.execute("DELETE FROM subscriptions WHERE id=?", str(subscription_id)) conn.commit() else: pass self.load_list() except IndexError: self.errorMsg.setText("Selecione um cliente existente!")
def save_data(self): if self.sigNameLineEdit.text() == "": self.errorMsg.setText("O nome precisa estar preenchido!") elif self.sigRoleLineEdit.text() == "": self.errorMsg.setText("O cargo precisa estar preenchido!") elif self.sigEmailLineEdit.text() == "": self.errorMsg.setText("O email precisa estar preenchido!") elif self.sigUploadName.text() == u"Faça o upload da assinatura": self.errorMsg.setText(u"É necessário fazer upload da assinatura em .png!") else: if self.sig_id: cursor.execute(""" UPDATE signatures SET name=?, role=?, email=?, register=? WHERE id=? """,( str(self.sigNameLineEdit.text()), str(self.sigRoleLineEdit.text()), str(self.sigEmailLineEdit.text()), str(self.sigRegisterLineEdit.text()), str(self.sig_id) )) else: cursor.execute("INSERT INTO signatures VALUES (NULL,?,?,?,?)", ( str(self.sigNameLineEdit.text()), str(self.sigRoleLineEdit.text()), str(self.sigEmailLineEdit.text()), str(self.sigRegisterLineEdit.text()) )) self.sig_id = cursor.lastrowid if self.filename: new_filename = "signatures/"+str(self.sig_id)+".png" copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide()
def save_data(self): """ Saves the event data. """ # Verifies if all fields are filled if unicode(self.eventTitleLineEdit.text()) == "": self.errorMsg.setText(u"O título precisa ser preenchido!") elif len(unicode(self.eventStartDateLineEdit.text())) < 10 or \ len(unicode(self.eventEndDateLineEdit.text())) < 10: self.errorMsg.setText(u"As datas precisam estar \ em um formato xx/xx/xxxx!") elif unicode(self.eventHoursLineEdit.text()) == "": self.errorMsg.setText(u"As horas precisam ser um inteiro!") else: if self.event_id: # Updates the record if it is an existing event cursor.execute( "UPDATE events SET title=?, start_date=?, end_date=?, \ hours=?, content=? WHERE id=?", (unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()), str(self.event_id))) else: # Register the event cursor.execute( "INSERT INTO events VALUES (NULL,?,?,?,?,?)", (unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()))) # Saves the database conn.commit() # Update the table self.events_list_instance.load_table() # Hide the dialog self.hide()
def save_data(self): if self.sigNameLineEdit.text() == "": self.errorMsg.setText("O nome precisa estar preenchido!") elif self.sigRoleLineEdit.text() == "": self.errorMsg.setText("O cargo precisa estar preenchido!") elif self.sigEmailLineEdit.text() == "": self.errorMsg.setText("O email precisa estar preenchido!") elif self.sigUploadName.text() == u"Faça o upload da assinatura": self.errorMsg.setText( u"É necessário fazer upload da assinatura em .png!") else: if self.sig_id: cursor.execute( """ UPDATE signatures SET name=?, role=?, email=?, register=? WHERE id=? """, (str(self.sigNameLineEdit.text()), str(self.sigRoleLineEdit.text()), str(self.sigEmailLineEdit.text()), str(self.sigRegisterLineEdit.text()), str(self.sig_id))) else: cursor.execute("INSERT INTO signatures VALUES (NULL,?,?,?,?)", (str(self.sigNameLineEdit.text()), str(self.sigRoleLineEdit.text()), str(self.sigEmailLineEdit.text()), str(self.sigRegisterLineEdit.text()))) self.sig_id = cursor.lastrowid if self.filename: new_filename = "signatures/" + str(self.sig_id) + ".png" copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide()
def add_client(self): """ Inserts the selected user into the database as a subscription to the selected event. """ # Inserts data into the database cursor.execute( "INSERT INTO subscriptions VALUES (NULL,?,?)", ( str(self.event_id), str(self.clients[self.clientsList.currentIndex()][0]) ) ) conn.commit() # Update the listwidget that contains # the subscripted clients self.certificates_instance.load_list() # Hide the dialog self.hide()
def save_data(self): if self.eventTitleLineEdit.text() == "": self.errorMsg.setText("O titulo precisa ser preenchido!") elif len(self.eventStartDateLineEdit.text()) < 10 or \ len(self.eventEndDateLineEdit.text()) < 10: self.errorMsg.setText("As datas precisam estar em um formato xx/xx/xxxx!") elif self.eventHoursLineEdit.text() == "": self.errorMsg.setText("As horas precisam ser um inteiro!") else: if self.event_id: cursor.execute(""" UPDATE events SET title=?, start_date=?, end_date=?, hours=?, content=? WHERE id=? """, ( str(self.eventTitleLineEdit.text()), str(self.eventStartDateLineEdit.text()), str(self.eventEndDateLineEdit.text()), str(self.eventHoursLineEdit.text()), str(self.eventContentTextEdit.toPlainText()), str(self.event_id) )) else: cursor.execute("INSERT INTO events VALUES (NULL,?,?,?,?,?)", ( str(self.eventTitleLineEdit.text()), str(self.eventStartDateLineEdit.text()), str(self.eventEndDateLineEdit.text()), str(self.eventHoursLineEdit.text()), str(self.eventContentTextEdit.toPlainText()) )) conn.commit() self.events_list_instance.load_table() self.hide()
def save_data(self): if unicode(self.eventTitleLineEdit.text()) == "": self.errorMsg.setText(u"O título precisa ser preenchido!") elif len(unicode(self.eventStartDateLineEdit.text())) < 10 or \ len(unicode(self.eventEndDateLineEdit.text())) < 10: self.errorMsg.setText(u"As datas precisam estar em um formato xx/xx/xxxx!") elif unicode(self.eventHoursLineEdit.text()) == "": self.errorMsg.setText(u"As horas precisam ser um inteiro!") else: if self.event_id: cursor.execute(""" UPDATE events SET title=?, start_date=?, end_date=?, hours=?, content=? WHERE id=? """, ( unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()), str(self.event_id) )) else: cursor.execute("INSERT INTO events VALUES (NULL,?,?,?,?,?)", ( unicode(self.eventTitleLineEdit.text()), unicode(self.eventStartDateLineEdit.text()), unicode(self.eventEndDateLineEdit.text()), unicode(self.eventHoursLineEdit.text()), unicode(self.eventContentTextEdit.toPlainText()) )) conn.commit() self.events_list_instance.load_table() self.hide()
def profile(page_num): profile = db.session.query( USERGAMESPLAYED.ID_USER, USERGAMESPLAYED.NM_GAME, V_GAMES.DT_YEAROFRELEASE, V_GAMES.NM_GENRE, V_GAMES.NR_CRITICSCORE).select_from(USERGAMESPLAYED).join( V_GAMES, V_GAMES.ID_GAME == USERGAMESPLAYED.ID_GAME).filter( USERGAMESPLAYED.ID_USER == current_user.id).paginate( per_page=len(qtd_rows), page=page_num, error_out=True) df_profile = db.session.query( USERGAMESPLAYED.ID_USER, USERGAMESPLAYED.NM_GAME, V_GAMES.DT_YEAROFRELEASE, V_GAMES.NM_GENRE, V_GAMES.NR_CRITICSCORE).select_from(USERGAMESPLAYED).join( V_GAMES, V_GAMES.ID_GAME == USERGAMESPLAYED.ID_GAME).filter( USERGAMESPLAYED.ID_USER == current_user.id).count() if " " not in current_user.name: first_name = current_user.name.rsplit(' ', 1)[0] last_name = " " else: first_name = current_user.name.rsplit(' ', 1)[0] last_name = current_user.name.rsplit(' ', 1)[1] df_checkgamesplayed = check_gamesplayed() if df_checkgamesplayed is None or df_profile == 0: recommendations_df = pd.DataFrame() recommendations_df[[ "ID_USER", "ID_GAME", "NM_GAME", "NM_PUBLISHER", "NM_GENRE", "QT_GAMES", "NR_CRITICSCORE", "DT_YEAROFRELEASE", "IC_PLAYED", "Score" ]] = "" disable = True else: disable = False recommendations_df = get_recommendation() if request.method == 'POST': if request.form.getlist('delete_checkbox'): for id in request.form.getlist('delete_checkbox'): # Delete the games that were checked and commit in the database #USERGAMESPLAYED.query.filter_by(NM_GAME=id, ID_USER=current_user.id).delete(synchronize_session='fetch') cursor = conn.cursor() cursor.execute( 'DELETE FROM "USERGAMESPLAYED" WHERE "NM_GAME" = %s AND "ID_USER" = %s', (id, current_user.id)) conn.commit() #db.session.commit() recommendations_df = get_recommendation() profile = db.session.query( USERGAMESPLAYED.ID_USER, USERGAMESPLAYED.NM_GAME, V_GAMES.DT_YEAROFRELEASE, V_GAMES.NM_GENRE, V_GAMES.NR_CRITICSCORE).select_from(USERGAMESPLAYED).join( V_GAMES, V_GAMES.ID_GAME == USERGAMESPLAYED.ID_GAME).filter( USERGAMESPLAYED.ID_USER == current_user.id).paginate( per_page=len(qtd_rows), page=page_num, error_out=True) flash('Games have been successfully deleted from your profile.') return render_template('profile.html', name=current_user.name, profile=profile, first_name=first_name, last_name=last_name, len=len(recommendations_df), recommendations_profile=recommendations_df, disable=disable) if not request.form.getlist('delete_checkbox'): flash( 'You have to check at least one game to delete from your profile!' ) return render_template('profile.html', name=current_user.name, profile=profile, first_name=first_name, last_name=last_name, len=len(recommendations_df), recommendations_profile=recommendations_df, disable=disable) return render_template('profile.html', name=current_user.name, profile=profile, first_name=first_name, last_name=last_name, len=len(recommendations_df), recommendations_profile=recommendations_df, disable=disable)
def save_data(self): if unicode(self.sigNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.sigRoleLineEdit.text()) == "": self.errorMsg.setText(u"O cargo precisa estar preenchido!") elif unicode(self.sigEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(self.sigUploadName.text()) == u"Faça o upload da assinatura": self.errorMsg.setText(u"É necessário fazer upload da assinatura em .png!") else: if self.sig_id: cursor.execute(""" UPDATE signatures SET name=?, role=?, email=?, register=? WHERE id=? """,( unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()), unicode(self.sig_id) )) if self.filename: new_filename = os.path.join(app_dir,"signatures","{0}.png".format(str(self.sig_id))) copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide() else: cursor.execute("SELECT id FROM signatures WHERE register=?", [str(self.sigRegisterLineEdit.text())]) existing_user = cursor.fetchone() if existing_user: error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"A assinatura já está cadastrada!") error.setInformativeText(u"Já existe uma assinatura com este CPF cadastrada no programa.") error.setWindowTitle(u"Assinatura já cadastrada!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: cursor.execute("INSERT INTO signatures VALUES (NULL,?,?,?,?)", ( unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()) )) self.sig_id = cursor.lastrowid if self.filename: new_filename = os.path.join(app_dir,"signatures","{0}.png".format(str(self.sig_id))) copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide()
def save_data(self): """ Saves the client data. """ # Verifies if all fields are filled if unicode(self.clientNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.clientEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(validar_cpf(self.clientRegisterLineEdit.text())) is False: self.errorMsg.setText(u"O CPF é inválido!") else: if self.client_id: # Updates the record if it is an existing client cursor.execute( "UPDATE clients SET name=?, email=?, register=? \ WHERE id=?", ( unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()), str(self.client_id) ) ) conn.commit() # Updates the table self.clients_list_instance.load_table() # Hide the dialog self.hide() else: # Verifies if the user is trying to # register an existent client cursor.execute( "SELECT id FROM clients WHERE register=?", [str(self.clientRegisterLineEdit.text())] ) existing_user = cursor.fetchone() if existing_user: # Shows up an error message error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"O cliente já está cadastrado!") error.setInformativeText(u"Já existe um cliente \ com este CPF cadastrado \ no programa.") error.setWindowTitle(u"Cliente já cadastrado!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: # Register the client cursor.execute( "INSERT INTO clients VALUES (NULL,?,?,?)", ( unicode(self.clientNameLineEdit.text()), unicode(self.clientEmailLineEdit.text()), unicode(self.clientRegisterLineEdit.text()) ) ) conn.commit() # Updates the table self.clients_list_instance.load_table() # Hide the dialog self.hide()
def save_data(self): """ Save the signature data. """ # Verifies if all fields are filled if unicode(self.sigNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.sigRoleLineEdit.text()) == "": self.errorMsg.setText(u"O cargo precisa estar preenchido!") elif unicode(self.sigEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(self.sigUploadName.text()) == \ u"Faça o upload da assinatura": self.errorMsg.setText(u"É necessário fazer upload " u"da assinatura em .png!") else: # Verifies if creating or updating the signature if self.sig_id: # Updates the signature in the database cursor.execute( "UPDATE signatures SET name=?, role=?, email=?, \ register=? WHERE id=?", ( unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()), unicode(self.sig_id) ) ) # Replace signature image for the new one if self.filename: new_filename = os.path.join( app_dir, "signatures", "{0}.png".format(str(self.sig_id)) ) copyfile(self.filename, new_filename) # Save changes to the database conn.commit() # Updates the signatures list self.sig_list_instance.load_list() # Hide the dialog self.hide() else: # Verifies if the signature already exists cursor.execute( "SELECT id FROM signatures WHERE register=?", (str(self.sigRegisterLineEdit.text()),) ) existing_user = cursor.fetchone() if existing_user: # If the signature exists, show an error message error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"A assinatura já está cadastrada!") error.setInformativeText(u"Já existe uma assinatura " u"com este CPF cadastrada " u"no programa.") error.setWindowTitle(u"Assinatura já cadastrada!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: # Else, insert data in the database cursor.execute( "INSERT INTO signatures VALUES (NULL,?,?,?,?)", ( unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()) ) ) self.sig_id = cursor.lastrowid # Create the new signature file if self.filename: new_filename = os.path.join( app_dir, "signatures", "{0}.png".format(str(self.sig_id)) ) copyfile(self.filename, new_filename) # Save changes to the database conn.commit() # Updates the signatures list self.sig_list_instance.load_list() # Hide the dialog self.hide()
def save_data(self): if unicode(self.sigNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.sigRoleLineEdit.text()) == "": self.errorMsg.setText(u"O cargo precisa estar preenchido!") elif unicode(self.sigEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode( self.sigUploadName.text()) == u"Faça o upload da assinatura": self.errorMsg.setText( u"É necessário fazer upload da assinatura em .png!") else: if self.sig_id: cursor.execute( """ UPDATE signatures SET name=?, role=?, email=?, register=? WHERE id=? """, (unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()), unicode(self.sig_id))) if self.filename: new_filename = "signatures/" + str(self.sig_id) + ".png" copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide() else: cursor.execute("SELECT id FROM signatures WHERE register=?", [str(self.sigRegisterLineEdit.text())]) existing_user = cursor.fetchone() if existing_user: error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"A assinatura já está cadastrada!") error.setInformativeText( u"Já existe uma assinatura com este CPF cadastrada no programa." ) error.setWindowTitle(u"Assinatura já cadastrada!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: cursor.execute( "INSERT INTO signatures VALUES (NULL,?,?,?,?)", (unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()))) self.sig_id = cursor.lastrowid if self.filename: new_filename = "signatures/" + str( self.sig_id) + ".png" copyfile(self.filename, new_filename) conn.commit() self.sig_list_instance.load_list() self.hide()
def save_data(self): """ Save the signature data. """ # Verifies if all fields are filled if unicode(self.sigNameLineEdit.text()) == "": self.errorMsg.setText(u"O nome precisa estar preenchido!") elif unicode(self.sigRoleLineEdit.text()) == "": self.errorMsg.setText(u"O cargo precisa estar preenchido!") elif unicode(self.sigEmailLineEdit.text()) == "": self.errorMsg.setText(u"O email precisa estar preenchido!") elif unicode(self.sigUploadName.text()) == \ u"Faça o upload da assinatura": self.errorMsg.setText(u"É necessário fazer upload " u"da assinatura em .png!") else: # Verifies if creating or updating the signature if self.sig_id: # Updates the signature in the database cursor.execute( "UPDATE signatures SET name=?, role=?, email=?, \ register=? WHERE id=?", (unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()), unicode(self.sig_id))) # Replace signature image for the new one if self.filename: new_filename = os.path.join( app_dir, "signatures", "{0}.png".format(str(self.sig_id))) copyfile(self.filename, new_filename) # Save changes to the database conn.commit() # Updates the signatures list self.sig_list_instance.load_list() # Hide the dialog self.hide() else: # Verifies if the signature already exists cursor.execute("SELECT id FROM signatures WHERE register=?", (str(self.sigRegisterLineEdit.text()), )) existing_user = cursor.fetchone() if existing_user: # If the signature exists, show an error message error = QtGui.QMessageBox() error.setIcon(QtGui.QMessageBox.Critical) error.setText(u"A assinatura já está cadastrada!") error.setInformativeText(u"Já existe uma assinatura " u"com este CPF cadastrada " u"no programa.") error.setWindowTitle(u"Assinatura já cadastrada!") error.setStandardButtons(QtGui.QMessageBox.Ok) error.exec_() else: # Else, insert data in the database cursor.execute( "INSERT INTO signatures VALUES (NULL,?,?,?,?)", (unicode(self.sigNameLineEdit.text()), unicode(self.sigRoleLineEdit.text()), unicode(self.sigEmailLineEdit.text()), unicode(self.sigRegisterLineEdit.text()))) self.sig_id = cursor.lastrowid # Create the new signature file if self.filename: new_filename = os.path.join( app_dir, "signatures", "{0}.png".format(str(self.sig_id))) copyfile(self.filename, new_filename) # Save changes to the database conn.commit() # Updates the signatures list self.sig_list_instance.load_list() # Hide the dialog self.hide()