How do i fetching list of records in QCombo BOX from Sqlite3 database in PYQT5 Python using QSQL

Asked May 16 '18 at 13:50

Active May 16 '18 at 18:21

Viewed 682 times

I want to get list of records from database table. These are the values of two column name "id" and "lable" inserted into database.

INSERT INTO "phone_number_type" VALUES(1,'Home');
INSERT INTO "phone_number_type" VALUES(2,'Work');
INSERT INTO "phone_number_type" VALUES(3,'Mobile');
INSERT INTO "phone_number_type" VALUES(4,'Mistress');
INSERT INTO "phone_number_type" VALUES(5,'Meth Dealer');

I want to get only column name "lable" into QComboBox. here is my code:

import sys
import sqlite3

from PyQt5 import QtSql
from PyQt5.QtSql import QSqlDatabase
from PyQt5.QtWidgets import QMainWindow, QApplication
from combobox import Ui_MainWindow


class fetchrec(QMainWindow, Ui_MainWindow):
    def __init__(self):
        QMainWindow.__init__(self)
        self.setupUi(self)
        db = QSqlDatabase.addDatabase("QSQLITE")
        db.setDatabaseName("ttest.db")
        self.model = QtSql.QSqlTableModel(self)
        self.model.setTable("phone_number_type")
        self.comboBox.setModelColumn(self.model.fieldIndex("lable"))
        self.comboBox.setModel(self.model)


if __name__ == "__main__":
    import sys

    app = QApplication(sys.argv)
    userins = fetchrec()
    userins.show()
    sys.exit(app.exec_())

edited May 16 '18 at 18:21

asked May 16 '18 at 13:50

ndj

`self.model.select()`. – ekhumoro May 16 '18 at 16:04
but i am only getting one row "home".how do i get all list? – ndj May 16 '18 at 18:20
@user3135049 Have you checked that your database has that data? That is the method that I commonly use to fill a QComboBox and I have never had problems, obviously you should use what ekhumuro mentions. – eyllanesc May 16 '18 at 18:31
you could share your .db – eyllanesc May 16 '18 at 18:31
https://drive.google.com/drive/folders/15kie4cTPe-G0NdVYysKMHjU8PRaLShs1?usp=sharing – ndj May 16 '18 at 18:40
above is shared link to my project – ndj May 16 '18 at 18:40
1

@user3135049. Set the model ***before*** setting the model column. – ekhumoro May 16 '18 at 20:54
Thanks its working.Though the first field in combo box in blank why is that? – ndj May 17 '18 at 04:15

How do i fetching list of records in QCombo BOX from Sqlite3 database in PYQT5 Python using QSQL

0 Answers0