[1]SQLite Where kullanımı-PyQt5

projectModel = QSqlQueryModel()

projectModel.setQuery("select * from patient where pid=2,db) //idsi 2 olan hastayı getir 

projectView = QTableView()

projectView.setModel(projectModel)

projectView.show()

veya 

tableView = QtWidgets.QTableView()

query = QtSql.QSqlQuery()

result = query.exec_("select * from patient where pid=2")

if result:

model = QtSql.QSqlTableModel(db=db)

model.setQuery(query)

tableView.setModel(model)

tableView.show()