i made a ui , and converted it into code and add two lines , it worked untill i want to use a variable , see the code below :
from PyQt5 import QtCore, QtGui, QtWidgets from PyQt5.QtWidgets import QMainWindow, QApplication,QFileDialog class Ui_MainWindow(object): #################################################### my code begins def get_file_name(self): fname = QFileDialog.getOpenFileName() fname2 = fname[0] fname3 = '"' + fname2 + '"' return fname3 def sqlite_connect(self): conn = sqlite3.connect(get_file_name())#### this variable dosent work for some reason c = conn.cursor() c.execute("select * from verses where book_number = 10 and chapter = 1 and verse = 1") text = c.fetchmany(1) print(text) ########################################################## my code ends def setupUi(self, MainWindow): MainWindow.setObjectName("MainWindow") MainWindow.resize(532, 563) self.centralwidget = QtWidgets.QWidget(MainWindow) self.centralwidget.setObjectName("centralwidget") MainWindow.setCentralWidget(self.centralwidget) self.statusbar = QtWidgets.QStatusBar(MainWindow) self.statusbar.setObjectName("statusbar") MainWindow.setStatusBar(self.statusbar) self.menuBar = QtWidgets.QMenuBar(MainWindow) self.menuBar.setGeometry(QtCore.QRect(0, 0, 532, 21)) self.menuBar.setObjectName("menuBar") self.menuopen = QtWidgets.QMenu(self.menuBar) self.menuopen.setObjectName("menuopen") MainWindow.setMenuBar(self.menuBar) self.actionopen_a_sqlite_file = QtWidgets.QAction(MainWindow) self.actionopen_a_sqlite_file.setObjectName("actionopen_a_sqlite_file") self.actionopen_a_sqlite_file.triggered.connect(self.get_file_name)#################### my code self.menuopen.addAction(self.actionopen_a_sqlite_file) self.menuBar.addAction(self.menuopen.menuAction()) self.retranslateUi(MainWindow) QtCore.QMetaObject.connectSlotsByName(MainWindow) def retranslateUi(self, MainWindow): _translate = QtCore.QCoreApplication.translate MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow")) self.menuopen.setTitle(_translate("MainWindow", "open")) self.actionopen_a_sqlite_file.setText(_translate("MainWindow", "open a sqlite file")) 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_())ui will quit itself