Python Forum
PyQt5 form not displaying my data from SQLite3 Database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PyQt5 form not displaying my data from SQLite3 Database
#1
Good afternoon;
I am fairly new to Python. I am attempting to make a personal classic Movie database. I am using PyQt5, Python 3.7 and Sqlite3. My form will display but there is not any data showing. My .db is in the same directory of my .ui and .py file. Thank you for any help that can be provided. Here is the coding.

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'Classic.ui'
#
# Created by: PyQt5 UI code generator 5.13.0
#
# WARNING! All changes made in this file will be lost!


from PyQt5 import QtCore, QtGui, QtWidgets


class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.resize(800, 600)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.Title = QtWidgets.QLabel(self.centralwidget)
        self.Title.setGeometry(QtCore.QRect(10, 10, 31, 16))
        self.Title.setObjectName("Title")
        self.Year = QtWidgets.QLabel(self.centralwidget)
        self.Year.setGeometry(QtCore.QRect(500, 10, 31, 16))
        self.Year.setObjectName("Year")
        self.Rating = QtWidgets.QLabel(self.centralwidget)
        self.Rating.setGeometry(QtCore.QRect(10, 60, 31, 16))
        self.Rating.setObjectName("Rating")
        self.Length = QtWidgets.QLabel(self.centralwidget)
        self.Length.setGeometry(QtCore.QRect(130, 60, 41, 16))
        self.Length.setObjectName("Length")
        self.Genre = QtWidgets.QLabel(self.centralwidget)
        self.Genre.setGeometry(QtCore.QRect(260, 60, 47, 13))
        self.Genre.setObjectName("Genre")
        self.Summary = QtWidgets.QLabel(self.centralwidget)
        self.Summary.setGeometry(QtCore.QRect(10, 150, 47, 13))
        self.Summary.setObjectName("Summary")
        self.Directors = QtWidgets.QLabel(self.centralwidget)
        self.Directors.setGeometry(QtCore.QRect(10, 270, 47, 13))
        self.Directors.setObjectName("Directors")
        self.Actors = QtWidgets.QLabel(self.centralwidget)
        self.Actors.setGeometry(QtCore.QRect(10, 310, 47, 13))
        self.Actors.setObjectName("Actors")
        self.Title_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Title_2.setGeometry(QtCore.QRect(40, 10, 451, 20))
        self.Title_2.setObjectName("Title_2")
        self.Year_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Year_2.setGeometry(QtCore.QRect(540, 10, 91, 20))
        self.Year_2.setObjectName("Year_2")
        self.Rating_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Rating_2.setGeometry(QtCore.QRect(50, 60, 71, 20))
        self.Rating_2.setObjectName("Rating_2")
        self.Length_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Length_2.setGeometry(QtCore.QRect(170, 60, 71, 20))
        self.Length_2.setObjectName("Length_2")
        self.Genre_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Genre_2.setGeometry(QtCore.QRect(300, 60, 361, 20))
        self.Genre_2.setObjectName("Genre_2")
        self.Summary_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Summary_2.setGeometry(QtCore.QRect(70, 150, 591, 101))
        self.Summary_2.setObjectName("Summary_2")
        self.Directors_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Directors_2.setGeometry(QtCore.QRect(70, 270, 591, 20))
        self.Directors_2.setObjectName("Directors_2")
        self.Actors_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.Actors_2.setGeometry(QtCore.QRect(70, 310, 591, 20))
        self.Actors_2.setObjectName("Actors_2")
        self.Quit = QtWidgets.QPushButton(self.centralwidget)
        self.Quit.setGeometry(QtCore.QRect(660, 400, 75, 23))
        self.Quit.setObjectName("Quit")
        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 21))
        self.menubar.setObjectName("menubar")
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)

        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)

    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "Classics"))
        self.Title.setText(_translate("MainWindow", "Title"))
        self.Year.setText(_translate("MainWindow", "Year"))
        self.Rating.setText(_translate("MainWindow", "Rating"))
        self.Length.setText(_translate("MainWindow", "Length"))
        self.Genre.setText(_translate("MainWindow", "Genre"))
        self.Summary.setText(_translate("MainWindow", "Summary"))
        self.Directors.setText(_translate("MainWindow", "Directors"))
        self.Actors.setText(_translate("MainWindow", "Actors"))
        self.Quit.setText(_translate("MainWindow", "Quit"))


if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    MainWindow = QtWidgets.QMainWindow()
    ui = Ui_MainWindow()
    ui.setupUi(MainWindow)
    MainWindow.show()
    sys.exit(app.exec_())

    import _sqlite3
    from _sqlite3 import Error

    # Connecting to the database file
    def create_connection(patrick):
        conn = None
        try:
            conn = _sqlite3.connect('patrick.db')
        except Error as e:
            print(e)
        return conn

    def select_all_Films(conn):
        cur = conn.cursor()
        cur.execute("SELECT * FROM Film")

        rows = cur.fetchall()

        for row in rows:
            print(row)

    if __name__ == '__main__':
        main()
Reply


Messages In This Thread
PyQt5 form not displaying my data from SQLite3 Database - by Linuxdesire - Dec-05-2019, 10:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [Tkinter] Error verify data in database TomasSanchexx 2 1,915 Aug-11-2023, 12:37 PM
Last Post: TomasSanchexx
  PyQt5, QtSql: connection to database does not work gradlon93 4 3,802 Jan-12-2023, 05:26 PM
Last Post: deanhystad
  [PyQt] [Solved]Help displaying SQLite Database Extra 9 4,999 May-21-2022, 08:03 PM
Last Post: Extra
Question [Tkinter] data enterred through gui is not storing in sqlite3 database Hilal 21 12,561 Dec-15-2021, 08:48 PM
Last Post: Hilal
  [Tkinter] TKINTER quiz using sqlite3 database hezza_23 45 29,157 Nov-29-2021, 09:42 PM
Last Post: Hilal
  [Tkinter] load sqlite3 data into pdf rwahdan 5 6,587 Nov-29-2021, 07:58 PM
Last Post: Hilal
  [PyQt] How to update selected data in combobox displaying DB data? JokerSob 3 4,804 Aug-02-2021, 04:39 AM
Last Post: JokerSob
  Displaying database info in QTableWidget thewolf 6 8,929 Apr-03-2021, 02:49 PM
Last Post: thewolf
  Button to add data to database and listbox SalsaBeanDip 1 4,191 Dec-06-2020, 10:13 PM
Last Post: Larz60+
  Help with PySimpleGUI INSERT INTO sqlite3 database jrbond 5 8,897 Jul-20-2020, 01:24 PM
Last Post: jrbond

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020