def changepassword(self): sec_ans = self.parent.sec_a_lineedit.text() user = dbHelper().get_user_by_uid(dbHelper().get_user_by_username( self.username)[0]) print(user) password = self.parent._new_password_lineedit.text() if sec_ans == "" or password == "": self.parent.empty_error() return if user is not None: if user[3] == sec_ans: dbHelper().update_password(user[0], password) self.parent._password_changed_()
def __init__(self, parent,username) -> None: super().__init__(parent=parent) self._parent = parent self.username = username self.rowid = dbHelper().get_user_by_username(self.username) self.init() self.addComponnent() self.setData() self.setDataToComponnents()
def save(self): _book_name = self.parent._book_name_lineedit.text() _book_author_name = self.parent._book_author_lineedit.text() _book_pages = self.parent._book_pages_lineedit.text() _book_edition = self.parent._book_edition_lineedit.text() _book_isbn = self.parent._book_isbn_lineedit.text() _book_publisher = self.parent._book_publisher_lineedit.text() _book_language = self.parent._book_language_lineedit.text() _book_translator = self.parent._book_translate_lineedit.text() _book_uploader = self.parent._parent.username _book_release_date = self.parent._book_firstpublishdate_lineedit.text() _book_editionpublishdate = self.parent._book_editionpublishdate_lineedit.text( ) _book_desc = self.parent._book_desc_textedit.toPlainText() _book_image = None if _book_isbn == "" or _book_name == "" or _book_pages == "" or _book_author_name == "": #TODO add error label return if self.parent._book_image_label.pixmap() is not None: if self.parent.fileaddress is not None: with open(self.parent.fileaddress, 'rb') as file: _book_image = file.read() else: _book_image = self.parent._book_image_label.pixmap() if self.parent.mode == 1: from datetime import datetime _book_uploaddate = datetime.now() dbHelper().add_book(_book_name, _book_author_name, _book_pages, _book_isbn, _book_edition, _book_publisher, _book_language, _book_translator, _book_uploader, _book_uploaddate, _book_release_date, _book_editionpublishdate, _book_desc, _book_image) self.parent.close() else: #edit book info dbHelper().editbook(_book_name, _book_author_name, _book_pages, _book_edition, _book_isbn, _book_publisher, _book_language, _book_translator, _book_release_date, _book_editionpublishdate, _book_desc, _book_image, self.parent._uid) self.parent.close()
def search(self, text): self.clear() books = dbHelper().search(text) for i in books: book = bookPreviewWidget(i[0], self._book_list_widget) book.setMinimumSize(300, 100) book.setMaximumSize(300, 200) self.items.append(book) self._book_list_widget.addWidget(book)
def __init__(self, parent,uniqueId=None) -> None: # self._event = bookPreviewEvent(self) self._parent = parent self.mode =1 super().__init__() self._uid = uniqueId self._dbHelper:dbHelper = dbHelper() self.init() self.init_data() self._event = event(self) self.setAttribute(QtCore.Qt.WA_StyledBackground, True) self.setStyleSheet(parser(CSS_LOGIN))
def login(self): username = self.parent._username_lineedit.text() passwors = self.parent._password_lineedit_.text() if username=="" or passwors =="": self.parent.empty_error() return user = dbHelper().get_user(username= username,password= passwors) if user is not None: if user[4]==1: self.parent._parent.open(user[0]) return self.parent.wrongpassword()
def signup(self): username = self.parent._username_lineedit.text() passwors = self.parent._password_lineedit_.text() sec_q = self.parent.sec_q.text() sec_a = self.parent.sec_p.text() if username == "" or passwors == "" or sec_a == "" or sec_q == "": self.parent.empty_error() return user = dbHelper().add_user(username, passwors, sec_q, sec_a) if user is None: self.parent._username_exist() return self.parent.wait()
def __init__(self, uniqueId:str ,parent ): """ :param uniqueId: book unique id :param parent: parent widget obj """ self._event = bookPreviewEvent(self) self._parent = parent super().__init__( event_=self._event) self._uid = uniqueId self._dbHelper:dbHelper = dbHelper() self.init() self.init_data() self.setAutoFillBackground(True) self.setAttribute(QtCore.Qt.WA_StyledBackground, True) self.setAccessibleNames() self.setStyleSheet(parser(CSS_BOOKPREVIEW))
def addItems(self): users = dbHelper().get_users() itemflags = QtCore.Qt.ItemFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) for i in users: row_number: int = self.__tablewidget_admins_.rowCount() self.__tablewidget_admins_.setRowCount(row_number + 1) username = i[0] row_item1: cQTableWidgetItem = cQTableWidgetItem( userid=username, type_=1, event_=self.event_) row_item1.setFlags(itemflags) row_item2: cQTableWidgetItem = cQTableWidgetItem( userid=username, type_=0, event_=self.event_) row_item2.setFlags(itemflags) self.__tablewidget_admins_.setItem(row_number, 0, row_item1) self.__tablewidget_admins_.setItem(row_number, 1, row_item2) self.__tablewidget_admins_.setVerticalHeaderItem( row_number, QTableWidgetItem(str(row_number)))
def update(self): self._search_lineedit.setHidden(False) self._add_book_button.setHidden(False) self._books_label.setAccessibleName("sidebar_clicked") self._admin_label.setAccessibleName("transparent") self._mybooks_label.setAccessibleName("transparent") self._setting_label.setAccessibleName("transparent") self.setStyleSheets() self._setting_widget.setHidden(True) self._admins_widget.setHidden(True) self._book_list_widget.setHidden(False) self.clear() books = dbHelper().get_books() for i in books: book = bookPreviewWidget(i[0], self) book.setMinimumSize(300, 100) book.setMaximumSize(300, 200) self.items.append(book) self._book_list_widget.addWidget(book)
def update(self): if self.username_lineedit.text() =="" or self.s_q_.text() == "" or self.s_a_.text() == "": if self.username_lineedit.text() =="": self.username_lineedit.setPlaceholderText("[this field is empty]") if self.s_q_.text() == "" : self.s_q_.setPlaceholderText("[this field is empty]") if self.s_a_.text() == "": self.s_a_.setPlaceholderText("[this field is empty]") return if dbHelper().update_user(self.c_username,self.username_lineedit.text(),self.password_lineedit.text(),self.s_q_.text(),self.s_a_.text()) == -1: self.username_lineedit.setText("") self.username_lineedit.setPlaceholderText("This User Name Exist") self.username_lineedit.setAccessibleName("error") return self.setData()
def setdata(self): if (dbHelper().get_user_by_username(self.username) != None): user_seq = dbHelper().get_user_by_uid( dbHelper().get_user_by_username(self.username)[0])[2] self.__sec_q_label.setText(user_seq)
def setData(self): user = dbHelper().get_user_by_uid( self.rowid) self.c_username ,self.c_password , self.c_sec_q , self.c_sec_a ,_=user
def deactive(self): self.activated = False if self.type_ == 0: self.setText("DEACTIVATED") dbHelper().deactive_user(dbHelper().get_user_by_username(self.username))
def active(self): self.activated = True if self.type_ == 0: self.setText("ACTIVATED") dbHelper().active_user(dbHelper().get_user_by_username(self.username))
def init(self): self.username,_,_,_,self.activated = dbHelper().get_user_by_uid( dbHelper().get_user_by_username(self.username))