def __init__(self, id_oi, parent=None):
super(busca_oi2, self).__init__()
self.ui = Ui_Form()
self.ui.setupUi(self)
self.connect_signals()
cmd = "SELECT credencial, nome FROM profissional_imprensa "
cmd += "WHERE orgao_imprensa = " + id_oi + ";"
pis = executa_select(cmd)
cmd = "SELECT tipo_credencial, quantidade FROM limites_oi "
cmd += "WHERE orgao_imprensa = " + id_oi + ";"
limites = executa_select(cmd)
self.fill_table(pis, self.ui.qpi)
self.fill_table(limites, self.ui.qlimites)
class busca_oi2(QtWidgets.QWidget):
def __init__(self, id_oi, parent=None):
super(busca_oi2, self).__init__()
self.ui = Ui_Form()
self.ui.setupUi(self)
self.connect_signals()
cmd = "SELECT credencial, nome FROM profissional_imprensa "
cmd += "WHERE orgao_imprensa = " + id_oi + ";"
pis = executa_select(cmd)
cmd = "SELECT tipo_credencial, quantidade FROM limites_oi "
cmd += "WHERE orgao_imprensa = " + id_oi + ";"
limites = executa_select(cmd)
self.fill_table(pis, self.ui.qpi)
self.fill_table(limites, self.ui.qlimites)
def connect_signals(self):
pass
def item_click(self):
pass
def fill_table(self, lista, table):
while table.rowCount():
table.removeRow(0)
row = 0
for item0, item1 in lista:
table.insertRow(row)
item_0 = QtWidgets.QTableWidgetItem(str(item0))
item_1 = QtWidgets.QTableWidgetItem(str(item1))
flags = QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled
item_0.setFlags(flags)
item_1.setFlags(flags)
table.setItem(row, 0, item_0)
table.setItem(row, 1, item_1)
row += 1
