Ouverture d'une fenetre à l'aide d'un QAction

Version imprimable

joyeux noel à tous. je rencontre un problème pour ouvrir une fenetre avec un QAction d'un QMenubar d'un QMainindow.
dans mon code simplifié ci dessous, quand je clique sur l'action inscription une fenetre instance de MySavingForm devrait s'ouvrir
mais c'est pas le cas.
La fenetre apparait puis disparait très rapidement sans qu'on ne puisse voir quelque chose. Quelqu'un pourrait il m'aider à comprendre ce qui se passe ? merci

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from phonebook_class import Ui_MainWindow
from centralwidget_class import Ui_centralWidgetForm
from savings_class import Ui_savingForm
import os.path
import sqlite3
from PyQt5.QtWidgets import QMessageBox
#############################################################################################"
 
class MySavingForm(QtWidgets.QWidget, Ui_savingForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        self.show()
 
class MyCentralWidget(QtWidgets.QWidget, Ui_centralWidgetForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        #self.table.resize(1500, 500)
 
class MyMainWindow(QtWidgets.QMainWindow, Ui_MainWindow):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
 
        central_widget = MyCentralWidget(self)
        self.setCentralWidget(central_widget)
 
        self.actionInscription.triggered.connect(self.showSavingForm)
 
    def showSavingForm(self):
        MySavingForm()
 
if __name__=="__main__":
 
 app = QtWidgets.QApplication(sys.argv)
 fen = MyMainWindow()
 fen.show()
 app.exec()

reponse

Salut je viens de résoudre le probleme. il suffisait d'avoir ce code

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from phonebook_class import Ui_MainWindow
from centralwidget_class import Ui_centralWidgetForm
from savings_class import Ui_savingForm
import os.path
import sqlite3
from PyQt5.QtWidgets import QMessageBox
#############################################################################################"
 
class MySavingForm(QtWidgets.QWidget, Ui_savingForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        self.setWindowTitle("Enregistrement des contacts")
 
class MyCentralWidget(QtWidgets.QWidget, Ui_centralWidgetForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        #self.table.resize(1500, 500)
 
class MyMainWindow(QtWidgets.QMainWindow, Ui_MainWindow):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
 
        central_widget = MyCentralWidget(self)
        self.setCentralWidget(central_widget)
 
        self.actionInscription.triggered.connect(self.showSavingForm)
 
    def showSavingForm(self):
        self.sWindow = MySavingForm()
        self.sWindow.show()
 
if __name__=="__main__":
 
 app = QtWidgets.QApplication(sys.argv)
 fen = MyMainWindow()
 fen.show()
 app.exec()

Mais ici j'ai une autre préocupation: Lorsque je clique sur l'action inscription la 2e fenetre s'affiche maintenant bien sur la fenetre principale (qui est MyMainwindow) et lorsque je ferme la fenetre principale elle se ferme et laisse la 2e fentre qui dépendait d'elle affichée. pourtant ce que je veux c'est que tant que la 2e fenetre n'est pas fermée , la fenetre principale ne doit accepter aucune modification ou fermerture.
Si quelqu'un sait ce qu'il faut faire je suis à l'écoute. merci

26/12/2020, 07h45
VinsS

Salut,

Tu dois la rendre modale pour cela en y ajoutant self.setModal(True)Mais je pense que ça ne se fait pas pour un QWidget, tu devras probablement changer cet héritage pour un QDialog.

reponse

Merci vins. J'ai résolu le problème avec setWindowModality(). Mais sans toute fois en abuser voici un autre souci dont je sollicite de l'aide.je veux transferer les données saisies sur la fenetre instance de MySavingForm dans le QTableWidget (nommé table) contenu dans MyCentralWidget qui lui meme est le widget central de mon QMainWindow.
Voici mon code simplifié

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from phonebook_class import Ui_MainWindow
from centralwidget_class import Ui_centralWidgetForm
from savings_class import Ui_savingForm
import os.path
import sqlite3
from PyQt5.QtWidgets import QMessageBox
#############################################################################################"
 
class MySavingForm(QtWidgets.QWidget, Ui_savingForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        self.setWindowTitle("Enregistrement des contacts")
 
        self.btnvalider.clicked.connect(self.validate)
 
    def validate(self):
        # Transfer of datas from entries to QTableWidget
        #self.principalWindow = MyMainWindow()
        self.central = MyCentralWidget()
 
        i = self.central.table.rowCount()
        self.central.table.setRowCount(i + 1)
        print(i)
        self.central.table.setitem(i + 1, 0, QtWidgets.QTableWidgetItem("hello"))
        self.central.table.setitem(i + 1, 1, QtWidgets.QTableWidgetItem(self.textboxnom.text()))
        self.central.table.setitem(i + 1, 2, QtWidgets.QTableWidgetItem(self.textboxprenom.text()))
        self.central.table.setitem(i + 1, 3, QtWidgets.QTableWidgetItem(rbtnsexe))
        self.central.table.setitem(i + 1, 4, QtWidgets.QTableWidgetItem(self.textboxmetier.text()))
        self.central.table.setitem(i + 1, 5, QtWidgets.QTableWidgetItem(self.textboxpays.text()))
        self.central.table.setitem(i + 1, 6, QtWidgets.QTableWidgetItem(self.textboxcontact.text()))
        self.central.table.setitem(i + 1, 7, QtWidgets.QTableWidgetItem(self.textadresse.document().toPlainText()))
 
 
class MyCentralWidget(QtWidgets.QWidget, Ui_centralWidgetForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        #self.table.resize(1500, 500)
 
class MyMainWindow(QtWidgets.QMainWindow, Ui_MainWindow):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
 
        central_widget = MyCentralWidget(self)
        self.setCentralWidget(central_widget)
 
        self.actionInscription.triggered.connect(self.showSavingForm)
 
    def showSavingForm(self):
        self.sWindow = MySavingForm()
        self.sWindow.show()
 
if __name__=="__main__":
 
 app = QtWidgets.QApplication(sys.argv)
 fen = MyMainWindow()
 fen.show()
 app.exec()

Et le problème survient surement ici

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 def validate(self):
        # Transfer of datas from entries to QTableWidget
        #self.principalWindow = MyMainWindow()
        self.central = MyCentralWidget()
 
        i = self.central.table.rowCount()
        self.central.table.setRowCount(i + 1)
        print(i)
        self.central.table.setitem(i + 1, 0, QtWidgets.QTableWidgetItem("hello"))
        self.central.table.setitem(i + 1, 1, QtWidgets.QTableWidgetItem(self.textboxnom.text()))
        self.central.table.setitem(i + 1, 2, QtWidgets.QTableWidgetItem(self.textboxprenom.text()))
        self.central.table.setitem(i + 1, 3, QtWidgets.QTableWidgetItem(rbtnsexe))
        self.central.table.setitem(i + 1, 4, QtWidgets.QTableWidgetItem(self.textboxmetier.text()))
        self.central.table.setitem(i + 1, 5, QtWidgets.QTableWidgetItem(self.textboxpays.text()))
        self.central.table.setitem(i + 1, 6, QtWidgets.QTableWidgetItem(self.textboxcontact.text()))
        self.central.table.setitem(i + 1, 7, QtWidgets.QTableWidgetItem(self.textadresse.document().toPlainText()))

Au niveau de print(i) ca marche mais apres le reste ne fonctionne pas.
Comment procéder alors pour transferer les données d'une fenetre dans un widget d'une autre fenetre. Mon cas en particulier.
merci

Lorsque tu fais self.central = MyCentralWidget() tu crées une nouvelle instance de ta MainWindow, alors que tu devrais plutôt utiliser celle qui existe.

Pour cela il te faut récupérer son instance.
Comme ceci:

Code:

1
2
3
4
 
    def showSavingForm(self):
        self.sWindow = MySavingForm(parent=self)
        self.sWindow.show()

et dans ton dialogue:

Code:

1
2
3
4
5
6
7
8
9
 
    def validate(self):
        # Transfer of datas from entries to QTableWidget
        table = self.parent().table     # ou self.parent().centralWidget().table au vu
                                        # de ta construction exotique.
        i = table.rowCount()
        table.setRowCount(i + 1)
        print(i)
        table.setitem(i + 1, 0, QtWidgets.QTableWidgetItem("hello"))

27/12/2020, 09h44
Rolph237

Merci vins je vais essayer et te revenir. Merci

reponse

Je viens d'apporter les modifications que tu as indiquées mais ca ne marche pas.
En utilisant meme les 2 cas ci dessous ca marche pas toujours

Code:

1
2
3
4
5
 # Transfer of datas from entries to QTableWidget
            vTable = self.parent().centralWidget().table  # Acces of QtableWidget of centralwidget of my mainwindow
            i = vTable.rowCount()
            vTable.setRowCount(i+1)
            print(i)

Code:

1
2
3
4
5
 # Transfer of datas from entries to QTableWidget
            vTable = self.parent().table  # Acces of QtableWidget of centralwidget of my mainwindow
            i = vTable.rowCount()
            vTable.setRowCount(i+1)
            print(i)

et avec cette modification aussi

Code:

1
2
3
4
    def showSavingForm(self):
        # Pour afficher la fenetre des enregistrements
        self.sWindow = MySavingForm(parent = self)
        self.sWindow.show()

Je ne comprends toujours pas pourquoi.
Je préfere mettre tout mon code que voici pour jeter un coup d'oeil

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from phonebook_class import Ui_MainWindow
from centralwidget_class import Ui_centralWidgetForm
from savings_class import Ui_savingForm
import os.path
import sqlite3
from PyQt5.QtWidgets import QMessageBox
#############################################################################################"
 
class MySavingForm(QtWidgets.QWidget, Ui_savingForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        #self.parent = parent
        self.setupUi(self)
        self.setWindowTitle("Enregistrement des contacts dans la base de données")
        self.setFixedSize(700, 700)
        self.setWindowModality(2)
        self.move(600, 50)
 
        self.btneffacer.clicked.connect(self.delete)
        self.btnvalider.clicked.connect(self.validate)
 
        self.rbtnmale.toggled.connect(self.onClicked)
        self.rbtnfemale.toggled.connect(self.onClicked)
 
        list_controls = [self.textboxnom, self.textboxprenom, self.textboxmetier, self.textboxpays, self.textboxcontact]
        for item in list_controls:
            item.textChanged.connect(self.onChanged)
 
    def onChanged(self):
        list_controls = [self.textboxnom, self.textboxprenom, self.textboxmetier, self.textboxpays, self.textboxcontact]
        for item in list_controls:
            myText = item.text()
            myNewText = myText.title()
            item.setText(myNewText)
 
    def onClicked(self):
        global rbtnsexe
        radiobutton = self.sender()
        if radiobutton.isChecked():
            rbtnsexe = radiobutton.text()
 
    def delete(self):
        # Deleting of all input controls
        list_controls = [self.textboxnom,self.textboxprenom, self.textboxmetier, \
                         self.textboxpays, self.textboxcontact, self.textadresse]
        for item in list_controls:
            item.clear()
 
    def validate(self):
        if (self.textboxnom.text(), self.textboxprenom.text(), self.textboxmetier.text(), \
            self.textboxpays.text(), self.textboxcontact.text(), self.textadresse.document().toPlainText()) \
                != ("", "", "", "", "", "") and (self.rbtnmale.isChecked() or self.rbtnfemale.isChecked()):
 
            # Transfer of datas from entries to sqlite3 database named "my_database"
            connexion = sqlite3.connect("phonebook_Database.db")
            cur = connexion.cursor()
            datas = [ self.textboxnom.text(), self.textboxprenom.text(), rbtnsexe, \
                      self.textboxmetier.text(), self.textboxpays.text(), self.textboxcontact.text(), \
                      self.textadresse.document().toPlainText()]
            req = "INSERT INTO Annuaire(Noms, Prenoms, Sexe, Metier, Pays, Contact, Adresse) VALUES(?,?,?,?,?,?,?)"
            cur.execute(req, datas)
            connexion.commit()
 
            # Transfer of datas from entries to QTableWidget
            vTable = self.parent().table  # Acces of QtableWidget of centralwidget of my mainwindow
            i = vTable.rowCount()
            vTable.setRowCount(i+1)
            print(i)
            vTable.setitem(i + 1, 0, QtWidgets.QTableWidgetItem("merci"))
            vTable.setitem(i + 1, 1, QtWidgets.QTableWidgetItem(self.textboxnom.text()))
            vTable.setitem(i + 1, 2, QtWidgets.QTableWidgetItem(self.textboxprenom.text()))
            vTable.setitem(i + 1, 3, QtWidgets.QTableWidgetItem(rbtnsexe))
            vTable.setitem(i + 1, 4, QtWidgets.QTableWidgetItem(self.textboxmetier.text()))
            vTable.setitem(i + 1, 5, QtWidgets.QTableWidgetItem(self.textboxpays.text()))
            vTable.setitem(i + 1, 6, QtWidgets.QTableWidgetItem(self.textboxcontact.text()))
            vTable.setitem(i + 1, 7, QtWidgets.QTableWidgetItem(self.textadresse.document().toPlainText()))
 
            # Deleting of entries
            self.delete()
        else:
            msg = QMessageBox()
            msg.setWindowTitle("Attention")
            msg.setIcon(QMessageBox.Warning)
            msg.setText("Veuillez remplir tous les champs et cocher la case du sexe avant la validation")
            msg.setDetailedText("Pour pouvoir enregistrer les données dans la base vous etes obligé \n de saisir tous les \
                                         champs. Aucun champs de saisie ne doit etre vide. Cordialement")
            msg.setStandardButtons(QMessageBox.Yes)
            msg.exec_()
 
class MyCentralWidget(QtWidgets.QWidget, Ui_centralWidgetForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        # Definition of the columns width
        self.table.setColumnWidth(0, 10)
        self.table.setColumnWidth(1, 300)
        self.table.setColumnWidth(2, 300)
        self.table.setColumnWidth(3, 100)
        self.table.setColumnWidth(4, 300)
        self.table.setColumnWidth(5, 300)
        self.table.setColumnWidth(6, 200)
        self.table.setColumnWidth(7, 300)
 
        self.btnreinitialize.clicked.connect(self.showDialog)
 
        # Updating QTableWidget with the database after validate entries
        database_creation()
        connexion = sqlite3.connect("phonebook_Database.db")
        cur = connexion.cursor()
        result = cur.execute("SELECT* FROM Annuaire")
        self.table.setRowCount(0)
        for i, row_data in enumerate(result):
            self.table.insertRow(i)
            for j, data in enumerate(row_data):
                self.table.setItem(i, j, QtWidgets.QTableWidgetItem(str(data)))
 
    def showDialog(self):
        # pour reinitialiser et mettre à jour la tablewidget
        text, ok = QtWidgets.QInputDialog.getText(self, "input dialog", "Enter password", QtWidgets.QLineEdit.Password,"")
        if ok and text == "364301":
            # Opening connexion of database and executing query
            connexion = sqlite3.connect("phonebook_Database.db")
            cur = connexion.cursor()
            query = "DELETE FROM Annuaire"  # deleting all from table annuaire
            cur.execute(query)
            connexion.commit()
 
            # Updating QTableWidget after validate entries
            result = cur.execute("SELECT* FROM Annuaire")
            self.table.setRowCount(0)
            for i, row_data in enumerate(result):
                self.table.insertRow(i)
                for j, data in enumerate(row_data):
                    self.table.setItem(i, j, QtWidgets.QTableWidgetItem(str(data)))
 
 
class MyMainWindow(QtWidgets.QMainWindow, Ui_MainWindow):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        self.setWindowTitle("Logiciel d'enregistrement crée par Jules BETFIEN")
        central_widget = MyCentralWidget(self)
        self.setCentralWidget(central_widget)
 
        self.actionInscription.triggered.connect(self.showSavingForm)
        self.actionQuitter.triggered.connect(app.quit)  # To close the MainWindow
 
    def showSavingForm(self):
        # Pour afficher la fenetre des enregistrements
        self.sWindow = MySavingForm(parent = self)
        self.sWindow.show()
 
def database_creation():
    # Create connexion
    connexion = sqlite3.connect("phonebook_Database.db")
    cur = connexion.cursor()
    # Creation of table
    query = "CREATE TABLE IF NOT EXISTS Annuaire(id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL, \
                                                 Noms TEXT OT NULL, \
                                                 Prenoms TEXT NOT NULL, \
                                                 Sexe TEXT NOT NULL, \
                                                 Metier TEXT NOT NULL, \
                                                 Pays TEXT NOT NULL, \
                                                 Contact REAL NOT NULL, \
                                                 Adresse TEXT NOT NULL)"
    cur.execute(query)
 
def database_closing():
    connexion = sqlite3.connect("phonebook_Database.db")
    cur = connexion.cursor()
    # Closing of connexion
    cur.close()
    connexion.close()
 
if __name__=="__main__":
 
 #Openning application and main window
 app = QtWidgets.QApplication(sys.argv)
 fen = MyMainWindow()
 
 database_creation()
 fen.show()
 
 
 app.exec()
 database_closing()

27/12/2020, 12h22
VinsS
Pourquoi as-tu commenté la quatrième ligne:
Code:

1 2 3 4 class MySavingForm(QtWidgets.QWidget, Ui_savingForm): def __init__(self,*args,parent = None, **kwargs): super().__init__(*args,**kwargs) #self.parent = parent
Dire ça ne marche pas ça n'aide pas, qu'est-ce qui ne va pas , Un message d'erreur ? Si oui, alors il faut le copier-coller ici dans son entièreté.
27/12/2020, 12h45
Rolph237

reponse
Vins je travaille dans pycharm et voici le message que jai dans la console en plus du message qui apprait (python a cessé de fonctionner...)

Code:

Process finished with exit code -1073740791 (0xC0000409)

2. j'ai commenter self.parent la parceque avec lce que tu m'as proposeé, le self.parent de cette partie ci dessous restait en surbrillance
Code:

1 2 vTable = self.parent().centralWidget().table # Acces of QtableWidget of centralwidget of my mainwindow i = vTable.rowCount()
Et meme lorsque je ne commente pas la compilation me donne toujours le message (python a cessé de fonctionner..)
Je ne sais pas s'il existe une autre méthode permettant de communiquer entre 2 ou plusieurs fenetres? ceci me casse depuis une semaine

Mon application consiste à créer un formulaire de saisie derivant d'un QWidget qui doit transferer les données saisies (à l'aide du click sur le bouton valider) dans un QTableWidget se trouvant sur mon centralwidget personnalisé de mon MainWindow.
Voici les codes générés avec Qt designer qui ne doivent pas etre modifiés.

1. Code du MainWindow dérivant d'un QMainWindow

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
# -*- coding: utf-8 -*-
 
# Form implementation generated from reading ui file 'phonebook.ui'
#
# Created by: PyQt5 UI code generator 5.15.1
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again.  Do not edit this file unless you know what you are doing.
 
 
from PyQt5 import QtCore, QtGui, QtWidgets
 
 
class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.resize(582, 148)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 582, 28))
        font = QtGui.QFont()
        font.setPointSize(12)
        self.menubar.setFont(font)
        self.menubar.setStyleSheet("")
        self.menubar.setObjectName("menubar")
        self.menuFichier = QtWidgets.QMenu(self.menubar)
        self.menuFichier.setObjectName("menuFichier")
        self.menuRecherchedans_la_base_de_donn_es = QtWidgets.QMenu(self.menubar)
        self.menuRecherchedans_la_base_de_donn_es.setObjectName("menuRecherchedans_la_base_de_donn_es")
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)
        self.actionOuvrir_la_base = QtWidgets.QAction(MainWindow)
        self.actionOuvrir_la_base.setObjectName("actionOuvrir_la_base")
        self.actionEnregistrer = QtWidgets.QAction(MainWindow)
        self.actionEnregistrer.setObjectName("actionEnregistrer")
        self.actionInscription = QtWidgets.QAction(MainWindow)
        self.actionInscription.setObjectName("actionInscription")
        self.actionQuitter = QtWidgets.QAction(MainWindow)
        self.actionQuitter.setObjectName("actionQuitter")
        self.menuFichier.addAction(self.actionOuvrir_la_base)
        self.menuFichier.addAction(self.actionEnregistrer)
        self.menuFichier.addAction(self.actionInscription)
        self.menuFichier.addAction(self.actionQuitter)
        self.menubar.addAction(self.menuFichier.menuAction())
        self.menubar.addAction(self.menuRecherchedans_la_base_de_donn_es.menuAction())
 
        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)
 
    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
        self.menuFichier.setTitle(_translate("MainWindow", "Fichier"))
        self.menuRecherchedans_la_base_de_donn_es.setTitle(_translate("MainWindow", "Recherchedans la base de données"))
        self.actionOuvrir_la_base.setText(_translate("MainWindow", "Ouvrir la base"))
        self.actionEnregistrer.setText(_translate("MainWindow", "Enregistrer "))
        self.actionInscription.setText(_translate("MainWindow", "Inscription"))
        self.actionQuitter.setText(_translate("MainWindow", "Quit"))

2. Code du centralwidget personnalisé

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
# -*- coding: utf-8 -*-
 
# Form implementation generated from reading ui file 'centralwidget.ui'
#
# Created by: PyQt5 UI code generator 5.15.1
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again.  Do not edit this file unless you know what you are doing.
 
 
from PyQt5 import QtCore, QtGui, QtWidgets
 
 
class Ui_centralWidgetForm(object):
    def setupUi(self, centralWidgetForm):
        centralWidgetForm.setObjectName("centralWidgetForm")
        centralWidgetForm.resize(635, 381)
        self.gridLayout = QtWidgets.QGridLayout(centralWidgetForm)
        self.gridLayout.setObjectName("gridLayout")
        self.label = QtWidgets.QLabel(centralWidgetForm)
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        self.label.setFont(font)
        self.label.setStyleSheet("color: rgb(0, 0, 255);")
        self.label.setAlignment(QtCore.Qt.AlignCenter)
        self.label.setObjectName("label")
        self.gridLayout.addWidget(self.label, 0, 0, 1, 2)
        self.groupBox = QtWidgets.QGroupBox(centralWidgetForm)
        self.groupBox.setStyleSheet("background-color: rgb(0, 255, 127);")
        self.groupBox.setObjectName("groupBox")
        self.formLayout = QtWidgets.QFormLayout(self.groupBox)
        self.formLayout.setObjectName("formLayout")
        self.label_3 = QtWidgets.QLabel(self.groupBox)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.label_3.setFont(font)
        self.label_3.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.label_3.setObjectName("label_3")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.LabelRole, self.label_3)
        self.cborecherche = QtWidgets.QComboBox(self.groupBox)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.cborecherche.setFont(font)
        self.cborecherche.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.cborecherche.setCurrentText("Noms")
        self.cborecherche.setObjectName("cborecherche")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.cborecherche.addItem("")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.FieldRole, self.cborecherche)
        self.label_4 = QtWidgets.QLabel(self.groupBox)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.label_4.setFont(font)
        self.label_4.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.label_4.setObjectName("label_4")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.LabelRole, self.label_4)
        self.textboxrecherche = QtWidgets.QLineEdit(self.groupBox)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxrecherche.setFont(font)
        self.textboxrecherche.setStyleSheet("background-color: rgb(255, 255, 255);\n"
"color: rgb(0, 0, 255);")
        self.textboxrecherche.setObjectName("textboxrecherche")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.FieldRole, self.textboxrecherche)
        self.gridLayout.addWidget(self.groupBox, 1, 0, 1, 1)
        self.pushButton = QtWidgets.QPushButton(centralWidgetForm)
        font = QtGui.QFont()
        font.setFamily("MS Shell Dlg 2")
        font.setPointSize(18)
        font.setBold(False)
        font.setItalic(False)
        font.setWeight(9)
        self.pushButton.setFont(font)
        self.pushButton.setStyleSheet("background-color: rgb(0, 170, 255);\n"
"font: 75 18pt \"MS Shell Dlg 2\";\n"
"border-color: rgb(0, 85, 0);")
        self.pushButton.setObjectName("pushButton")
        self.gridLayout.addWidget(self.pushButton, 1, 1, 1, 1)
        self.table = QtWidgets.QTableWidget(centralWidgetForm)
        font = QtGui.QFont()
        font.setFamily("MS Shell Dlg 2")
        font.setPointSize(11)
        font.setBold(False)
        font.setItalic(False)
        font.setWeight(9)
        self.table.setFont(font)
        self.table.setStyleSheet("background-color: rgb(85, 255, 255);\n"
"font: 75 11pt \"MS Shell Dlg 2\";\n"
"color: rgb(0, 0, 0);")
        self.table.setLineWidth(25)
        self.table.setMidLineWidth(50)
        self.table.setEditTriggers(QtWidgets.QAbstractItemView.NoEditTriggers)
        self.table.setSelectionMode(QtWidgets.QAbstractItemView.SingleSelection)
        self.table.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
        self.table.setTextElideMode(QtCore.Qt.ElideLeft)
        self.table.setVerticalScrollMode(QtWidgets.QAbstractItemView.ScrollPerPixel)
        self.table.setHorizontalScrollMode(QtWidgets.QAbstractItemView.ScrollPerPixel)
        self.table.setShowGrid(True)
        self.table.setObjectName("table")
        self.table.setColumnCount(8)
        self.table.setRowCount(0)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(0, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(1, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(2, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(3, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(4, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(5, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(6, item)
        item = QtWidgets.QTableWidgetItem()
        font = QtGui.QFont()
        font.setPointSize(14)
        font.setBold(True)
        font.setWeight(75)
        item.setFont(font)
        self.table.setHorizontalHeaderItem(7, item)
        self.gridLayout.addWidget(self.table, 2, 0, 1, 2)
        self.btnreinitialize = QtWidgets.QPushButton(centralWidgetForm)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.btnreinitialize.setFont(font)
        self.btnreinitialize.setStyleSheet("background-color: rgb(0, 255, 127);\n"
"color: rgb(0, 0, 255);")
        self.btnreinitialize.setObjectName("btnreinitialize")
        self.gridLayout.addWidget(self.btnreinitialize, 3, 0, 1, 2)
 
        self.retranslateUi(centralWidgetForm)
        QtCore.QMetaObject.connectSlotsByName(centralWidgetForm)
 
    def retranslateUi(self, centralWidgetForm):
        _translate = QtCore.QCoreApplication.translate
        centralWidgetForm.setWindowTitle(_translate("centralWidgetForm", "Form"))
        self.label.setText(_translate("centralWidgetForm", "Base de données des contacts"))
        self.groupBox.setTitle(_translate("centralWidgetForm", "Recherche"))
        self.label_3.setText(_translate("centralWidgetForm", "Critère de recherche"))
        self.cborecherche.setItemText(0, _translate("centralWidgetForm", "Noms"))
        self.cborecherche.setItemText(1, _translate("centralWidgetForm", "Prénoms"))
        self.cborecherche.setItemText(2, _translate("centralWidgetForm", "Sexe"))
        self.cborecherche.setItemText(3, _translate("centralWidgetForm", "Metier"))
        self.cborecherche.setItemText(4, _translate("centralWidgetForm", "Pays"))
        self.cborecherche.setItemText(5, _translate("centralWidgetForm", "Contact"))
        self.cborecherche.setItemText(6, _translate("centralWidgetForm", "Adresse"))
        self.label_4.setText(_translate("centralWidgetForm", "Valeur du critère"))
        self.pushButton.setText(_translate("centralWidgetForm", "Imprimer"))
        item = self.table.horizontalHeaderItem(0)
        item.setText(_translate("centralWidgetForm", "ID"))
        item = self.table.horizontalHeaderItem(1)
        item.setText(_translate("centralWidgetForm", "Noms"))
        item = self.table.horizontalHeaderItem(2)
        item.setText(_translate("centralWidgetForm", "Prénoms"))
        item = self.table.horizontalHeaderItem(3)
        item.setText(_translate("centralWidgetForm", "Sexe"))
        item = self.table.horizontalHeaderItem(4)
        item.setText(_translate("centralWidgetForm", "Metier"))
        item = self.table.horizontalHeaderItem(5)
        item.setText(_translate("centralWidgetForm", "Pays"))
        item = self.table.horizontalHeaderItem(6)
        item.setText(_translate("centralWidgetForm", "Contact"))
        item = self.table.horizontalHeaderItem(7)
        item.setText(_translate("centralWidgetForm", "Adresse"))
        self.btnreinitialize.setText(_translate("centralWidgetForm", "Reinitialize"))

3. Code du formulaire de saisie

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
# -*- coding: utf-8 -*-
 
# Form implementation generated from reading ui file 'savings.ui'
#
# Created by: PyQt5 UI code generator 5.15.1
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again.  Do not edit this file unless you know what you are doing.
 
 
from PyQt5 import QtCore, QtGui, QtWidgets
 
 
class Ui_savingForm(object):
    def setupUi(self, savingForm):
        savingForm.setObjectName("savingForm")
        savingForm.resize(400, 475)
        self.gridLayout = QtWidgets.QGridLayout(savingForm)
        self.gridLayout.setObjectName("gridLayout")
        self.label = QtWidgets.QLabel(savingForm)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.label.setFont(font)
        self.label.setAlignment(QtCore.Qt.AlignCenter)
        self.label.setObjectName("label")
        self.gridLayout.addWidget(self.label, 0, 0, 1, 2)
        self.frame = QtWidgets.QFrame(savingForm)
        self.frame.setStyleSheet("background-color: rgb(190, 190, 190);")
        self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame.setObjectName("frame")
        self.formLayout = QtWidgets.QFormLayout(self.frame)
        self.formLayout.setObjectName("formLayout")
        self.label_2 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_2.setFont(font)
        self.label_2.setObjectName("label_2")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.LabelRole, self.label_2)
        self.textboxnom = QtWidgets.QLineEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxnom.setFont(font)
        self.textboxnom.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textboxnom.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.textboxnom.setObjectName("textboxnom")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.FieldRole, self.textboxnom)
        self.label_3 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_3.setFont(font)
        self.label_3.setObjectName("label_3")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.LabelRole, self.label_3)
        self.textboxprenom = QtWidgets.QLineEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxprenom.setFont(font)
        self.textboxprenom.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textboxprenom.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.textboxprenom.setObjectName("textboxprenom")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.FieldRole, self.textboxprenom)
        self.label_8 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_8.setFont(font)
        self.label_8.setObjectName("label_8")
        self.formLayout.setWidget(2, QtWidgets.QFormLayout.LabelRole, self.label_8)
        self.rbtnmale = QtWidgets.QRadioButton(self.frame)
        font = QtGui.QFont()
        font.setPointSize(10)
        font.setBold(False)
        font.setWeight(50)
        self.rbtnmale.setFont(font)
        self.rbtnmale.setObjectName("rbtnmale")
        self.formLayout.setWidget(2, QtWidgets.QFormLayout.FieldRole, self.rbtnmale)
        self.label_4 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_4.setFont(font)
        self.label_4.setObjectName("label_4")
        self.formLayout.setWidget(5, QtWidgets.QFormLayout.LabelRole, self.label_4)
        self.textboxmetier = QtWidgets.QLineEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxmetier.setFont(font)
        self.textboxmetier.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textboxmetier.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.textboxmetier.setObjectName("textboxmetier")
        self.formLayout.setWidget(5, QtWidgets.QFormLayout.FieldRole, self.textboxmetier)
        self.label_5 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_5.setFont(font)
        self.label_5.setObjectName("label_5")
        self.formLayout.setWidget(6, QtWidgets.QFormLayout.LabelRole, self.label_5)
        self.textboxpays = QtWidgets.QLineEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxpays.setFont(font)
        self.textboxpays.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textboxpays.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.textboxpays.setObjectName("textboxpays")
        self.formLayout.setWidget(6, QtWidgets.QFormLayout.FieldRole, self.textboxpays)
        self.label_6 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_6.setFont(font)
        self.label_6.setObjectName("label_6")
        self.formLayout.setWidget(7, QtWidgets.QFormLayout.LabelRole, self.label_6)
        self.textboxcontact = QtWidgets.QLineEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textboxcontact.setFont(font)
        self.textboxcontact.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textboxcontact.setAlignment(QtCore.Qt.AlignRight|QtCore.Qt.AlignTrailing|QtCore.Qt.AlignVCenter)
        self.textboxcontact.setObjectName("textboxcontact")
        self.formLayout.setWidget(7, QtWidgets.QFormLayout.FieldRole, self.textboxcontact)
        self.label_7 = QtWidgets.QLabel(self.frame)
        font = QtGui.QFont()
        font.setPointSize(11)
        self.label_7.setFont(font)
        self.label_7.setObjectName("label_7")
        self.formLayout.setWidget(8, QtWidgets.QFormLayout.LabelRole, self.label_7)
        self.textadresse = QtWidgets.QTextEdit(self.frame)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.textadresse.setFont(font)
        self.textadresse.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.textadresse.setObjectName("textadresse")
        self.formLayout.setWidget(8, QtWidgets.QFormLayout.FieldRole, self.textadresse)
        self.rbtnfemale = QtWidgets.QRadioButton(self.frame)
        font = QtGui.QFont()
        font.setPointSize(10)
        self.rbtnfemale.setFont(font)
        self.rbtnfemale.setObjectName("rbtnfemale")
        self.formLayout.setWidget(4, QtWidgets.QFormLayout.FieldRole, self.rbtnfemale)
        self.gridLayout.addWidget(self.frame, 1, 0, 1, 2)
        self.btneffacer = QtWidgets.QPushButton(savingForm)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.btneffacer.setFont(font)
        self.btneffacer.setStyleSheet("background-color: rgb(0, 255, 127);")
        self.btneffacer.setObjectName("btneffacer")
        self.gridLayout.addWidget(self.btneffacer, 2, 0, 1, 1)
        self.btnvalider = QtWidgets.QPushButton(savingForm)
        font = QtGui.QFont()
        font.setPointSize(12)
        font.setBold(True)
        font.setWeight(75)
        self.btnvalider.setFont(font)
        self.btnvalider.setStyleSheet("background-color: rgb(193, 193, 193);")
        self.btnvalider.setObjectName("btnvalider")
        self.gridLayout.addWidget(self.btnvalider, 2, 1, 1, 1)
 
        self.retranslateUi(savingForm)
        QtCore.QMetaObject.connectSlotsByName(savingForm)
 
    def retranslateUi(self, savingForm):
        _translate = QtCore.QCoreApplication.translate
        savingForm.setWindowTitle(_translate("savingForm", "Form"))
        self.label.setText(_translate("savingForm", "Inscription"))
        self.label_2.setText(_translate("savingForm", "Noms"))
        self.label_3.setText(_translate("savingForm", "Prénoms"))
        self.label_8.setText(_translate("savingForm", "Sexe"))
        self.rbtnmale.setText(_translate("savingForm", "Male"))
        self.label_4.setText(_translate("savingForm", "Metier"))
        self.label_5.setText(_translate("savingForm", "Pays"))
        self.label_6.setText(_translate("savingForm", "Contact"))
        self.label_7.setText(_translate("savingForm", "Asresse"))
        self.rbtnfemale.setText(_translate("savingForm", "Female"))
        self.btneffacer.setText(_translate("savingForm", "Effacer"))
        self.btnvalider.setText(_translate("savingForm", "Valider"))

Voici maintenant le code ou j'ai tout importé pour travailler

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from phonebook_class import Ui_MainWindow
from centralwidget_class import Ui_centralWidgetForm
from savings_class import Ui_savingForm
import os.path
import sqlite3
from PyQt5.QtWidgets import QMessageBox
#############################################################################################"
 
class MySavingForm(QtWidgets.QWidget, Ui_savingForm):
    def __init__(self,*args, parent = None, **kwargs):
        super().__init__(*args, **kwargs)
        self.parent = parent
        self.setupUi(self)
        self.setWindowTitle("Enregistrement des contacts dans la base de données")
        self.setFixedSize(700, 700)
        self.setWindowModality(2)
        self.move(600, 50)
 
        self.btneffacer.clicked.connect(self.delete)
        self.btnvalider.clicked.connect(self.validate)
 
        self.rbtnmale.toggled.connect(self.onClicked)
        self.rbtnfemale.toggled.connect(self.onClicked)
 
        list_controls = [self.textboxnom, self.textboxprenom, self.textboxmetier, self.textboxpays, self.textboxcontact]
        for item in list_controls:
            item.textChanged.connect(self.onChanged)
 
    def onChanged(self):
        list_controls = [self.textboxnom, self.textboxprenom, self.textboxmetier, self.textboxpays, self.textboxcontact]
        for item in list_controls:
            myText = item.text()
            myNewText = myText.title()
            item.setText(myNewText)
 
    def onClicked(self):
        global rbtnsexe
        radiobutton = self.sender()
        if radiobutton.isChecked():
            rbtnsexe = radiobutton.text()
 
    def delete(self):
        # Deleting of all input controls
        list_controls = [self.textboxnom,self.textboxprenom, self.textboxmetier, \
                         self.textboxpays, self.textboxcontact, self.textadresse]
        for item in list_controls:
            item.clear()
 
    def validate(self):
        if (self.textboxnom.text(), self.textboxprenom.text(), self.textboxmetier.text(), \
            self.textboxpays.text(), self.textboxcontact.text(), self.textadresse.document().toPlainText()) \
                != ("", "", "", "", "", "") and (self.rbtnmale.isChecked() or self.rbtnfemale.isChecked()):
 
            # Transfer of datas from entries to sqlite3 database named "my_database"
            connexion = sqlite3.connect("phonebook_Database.db")
            cur = connexion.cursor()
            datas = [ self.textboxnom.text(), self.textboxprenom.text(), rbtnsexe, \
                      self.textboxmetier.text(), self.textboxpays.text(), self.textboxcontact.text(), \
                      self.textadresse.document().toPlainText()]
            req = "INSERT INTO Annuaire(Noms, Prenoms, Sexe, Metier, Pays, Contact, Adresse) VALUES(?,?,?,?,?,?,?)"
            cur.execute(req, datas)
            connexion.commit()
 
            # Transfer of datas from entries to QTableWidget
            vTable = self.parent().centralWidget().table  # Acces of QtableWidget of centralwidget of my mainwindow
            i = vTable.rowCount()
            vTable.setRowCount(i+1)
            print(i)
            vTable.setitem(i + 1, 0, QtWidgets.QTableWidgetItem("merci"))
            vTable.setitem(i + 1, 1, QtWidgets.QTableWidgetItem(self.textboxnom.text()))
            vTable.setitem(i + 1, 2, QtWidgets.QTableWidgetItem(self.textboxprenom.text()))
            vTable.setitem(i + 1, 3, QtWidgets.QTableWidgetItem(rbtnsexe))
            vTable.setitem(i + 1, 4, QtWidgets.QTableWidgetItem(self.textboxmetier.text()))
            vTable.setitem(i + 1, 5, QtWidgets.QTableWidgetItem(self.textboxpays.text()))
            vTable.setitem(i + 1, 6, QtWidgets.QTableWidgetItem(self.textboxcontact.text()))
            vTable.setitem(i + 1, 7, QtWidgets.QTableWidgetItem(self.textadresse.document().toPlainText()))
 
            # Deleting of entries
            self.delete()
        else:
            msg = QMessageBox()
            msg.setWindowTitle("Attention")
            msg.setIcon(QMessageBox.Warning)
            msg.setText("Veuillez remplir tous les champs et cocher la case du sexe avant la validation")
            msg.setDetailedText("Pour pouvoir enregistrer les données dans la base vous etes obligé \n de saisir tous les \
                                         champs. Aucun champs de saisie ne doit etre vide. Cordialement")
            msg.setStandardButtons(QMessageBox.Yes)
            msg.exec_()
 
class MyCentralWidget(QtWidgets.QWidget, Ui_centralWidgetForm):
    def __init__(self,*args,parent = None, **kwargs):
        super().__init__(*args,**kwargs)
        self.parent = parent
        self.setupUi(self)
        # Definition of the columns width
        self.table.setColumnWidth(0, 10)
        self.table.setColumnWidth(1, 300)
        self.table.setColumnWidth(2, 300)
        self.table.setColumnWidth(3, 100)
        self.table.setColumnWidth(4, 300)
        self.table.setColumnWidth(5, 300)
        self.table.setColumnWidth(6, 200)
        self.table.setColumnWidth(7, 300)
 
        self.btnreinitialize.clicked.connect(self.showDialog)
 
        # Updating QTableWidget with the database after validate entries
        database_creation()
        connexion = sqlite3.connect("phonebook_Database.db")
        cur = connexion.cursor()
        result = cur.execute("SELECT* FROM Annuaire")
        self.table.setRowCount(0)
        for i, row_data in enumerate(result):
            self.table.insertRow(i)
            for j, data in enumerate(row_data):
                self.table.setItem(i, j, QtWidgets.QTableWidgetItem(str(data)))
 
    def showDialog(self):
        # pour reinitialiser et mettre à jour la tablewidget
        text, ok = QtWidgets.QInputDialog.getText(self, "input dialog", "Enter password", QtWidgets.QLineEdit.Password,"")
        if ok and text == "364301":
            # Opening connexion of database and executing query
            connexion = sqlite3.connect("phonebook_Database.db")
            cur = connexion.cursor()
            query = "DELETE FROM Annuaire"  # deleting all from table annuaire
            cur.execute(query)
            connexion.commit()
 
            # Updating QTableWidget after validate entries
            result = cur.execute("SELECT* FROM Annuaire")
            self.table.setRowCount(0)
            for i, row_data in enumerate(result):
                self.table.insertRow(i)
                for j, data in enumerate(row_data):
                    self.table.setItem(i, j, QtWidgets.QTableWidgetItem(str(data)))
 
 
class MyMainWindow(QtWidgets.QMainWindow, Ui_MainWindow):
    def __init__(self,*args, **kwargs):
        super().__init__(*args,**kwargs)
        self.setupUi(self)
        self.setWindowTitle("Logiciel d'enregistrement crée par Jules BETFIEN")
        central_widget = MyCentralWidget(self)
        self.setCentralWidget(central_widget)
 
        self.actionInscription.triggered.connect(self.showSavingForm)
        self.actionQuitter.triggered.connect(app.quit)  # To close the MainWindow
 
    def showSavingForm(self):
        # Pour afficher la fenetre des enregistrements
        self.sWindow = MySavingForm(parent = self)
        self.sWindow.show()
 
def database_creation():
    # Create connexion
    connexion = sqlite3.connect("phonebook_Database.db")
    cur = connexion.cursor()
    # Creation of table
    query = "CREATE TABLE IF NOT EXISTS Annuaire(id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL, \
                                                 Noms TEXT OT NULL, \
                                                 Prenoms TEXT NOT NULL, \
                                                 Sexe TEXT NOT NULL, \
                                                 Metier TEXT NOT NULL, \
                                                 Pays TEXT NOT NULL, \
                                                 Contact REAL NOT NULL, \
                                                 Adresse TEXT NOT NULL)"
    cur.execute(query)
 
def database_closing():
    connexion = sqlite3.connect("phonebook_Database.db")
    cur = connexion.cursor()
    # Closing of connexion
    cur.close()
    connexion.close()
 
if __name__=="__main__":
 
 #Openning application and main window
 app = QtWidgets.QApplication(sys.argv)
 fen = MyMainWindow()
 
 database_creation()
 fen.show()
 
 
 app.exec()
 database_closing()

Merci pour tout aide me permettant de resoudre ce pb de transfert des données saisies sur mon formulaire vers le tablewidget

28/12/2020, 10h11
VinsS
Si tu l'avais lancé dans un terminal, tu aurais pu voir deux soucis:
Enlève les parenthèses ligne 67
Code:

1 2 vTable = self.parent.centralWidget().table
et pour toute la série à partir de la ligne 71, remplace setitem par setItem
28/12/2020, 11h22
Rolph237

Merci infiniment vins. Cela marche bien maintenant.
J'ai commencé à programmer directement dans Pycharm. Quand tu parles de lancer dans un terminal tu veux dire lancer en ligne de commande ? Et les codes générés par Qt là ? Peux-tu me dire comment on lance tout ça dans un terminal ?