Advertisement
Guest User

Untitled

a guest
May 24th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.46 KB | None | 0 0
  1. self.workCombo.setEditable(True)
  2.         pFilterModel=QSortFilterProxyModel(self.workCombo)
  3.         pFilterModel.setFilterCaseSensitivity( Qt.CaseInsensitive )
  4.         pFilterModel.setSourceModel(self.workCombo.model())
  5.         AutoComboCompleter=QCompleter(self.workCombo)
  6.         AutoComboCompleter.setModel(pFilterModel)
  7.         AutoComboCompleter.setCompletionMode(QCompleter.PopupCompletion)
  8.         self.workCombo.setCompleter( AutoComboCompleter )
  9.         self.workCombo.lineEdit().textEdited[unicode].connect(self.filtro)
  10. sql = "select * from T1 where rownum<201"
  11.  
  12.            self.workCombo.addItem(label,-1 )
  13.        
  14.         qry = QSqlQuery(myDB())
  15.         if qry.exec_(sql):
  16.  
  17.            while qry.next():
  18.              k, v = qry.value(1), qry.value(2)
  19.              self.workCombo.addItem(v, k)
  20.  
  21. def filtro(self,text):
  22.         logMessage("text {} ".format(text))
  23.         model = QSqlTableModel(self,self.plugin.gridDb())
  24.         model.setTable("table(F_GETLISTOPTIONFORMI('P_CS_WORK',NULL))")
  25.         stringa = "\"p_description\" like \'%"+text+"%'"
  26.         #QtCore.QString("\"p_description\" like \"%%1%\"").arg(text)
  27.         logMessage(" filtro {} ".format(stringa))
  28.         model.setFilter(stringa)
  29.         model.select()
  30.         AutoComboCompleter=QCompleter(self.workCombo)
  31.         AutoComboCompleter.setModel(model)
  32.         AutoComboCompleter.setCompletionMode(QCompleter.PopupCompletion)
  33.         self.workCombo.setCompleter( AutoComboCompleter )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement