Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

Windows : QtSql.setDatabaseName not allow to connect to my SQLITE database



  • Hi geeks!
    wonder why this piece of code does not work when a correct DB path is set to connect to my existing database. when no parameter is passed by it works fine but not the goal for me.

    from PySide2 import QtCore, QtWidgets, QtSql
    import os

    def createConnection(path=None):

    db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
    if path is None:
    
            db.setDatabaseName(":memory:")
    else:
        if os.path.exists(path) == False:
            raise(' file to connect to db does not exist')
        else:
            db.setDatabaseName(path)
    if not db.open():
        print('Connection failed')
        return False
    else:
        return True
    

    mypath = r"Qt_Pricers/IRS/NEWirsDB.db"
    path = os.path.join(os.getcwd(), mypath)
    print(createConnection())



  • sorry miss part of my code please ignore