class Login(QWidget, Ui_Login): def __init__(self): super(Login, self).__init__() self.setupUi(self) self.model = QtSql.QSqlRelationalTableModel() self.model.setTable('utilisateur') self.model.select() print(self.model.select) print(self.model.rowCount) self.login.clicked.connect(self.submit) def submit(self): user_code = self.user.text() passwd = self.password.text() critere = "" if not len(user_code) == 0: critere += " code_util = '%s'" % user_code if not len(passwd) == 0: critere += " AND mot_de_passe = '%s'" % passwd print(critere) print(self.model.select()) self.model.setFilter(critere) self.model.select() print(self.model.rowCount()) if (self.model.rowCount() == 1): print('ok') self.Main = MyApp() self.close() self.Main.show() session = Session() session.set_session(user_code, passwd) #print("login: "******"ERROR", "Code utilisateur ou Mot de passe non valide") self.user.clear() self.password.clear()
def main(): app = QApplication(sys.argv) w = MyApp() w.show() app.exec_()