def __delete(self): pdt = ProductDao() selectionIdxs = self.ui.tableWidget.selectedIndexes()[0] code = self.ui.tableWidget.item(selectionIdxs.row(), 0).text() self.ui.tableWidget.removeRow(selectionIdxs.row()) pdt.delete_product(code) QMessageBox.information(self, 'Delete', '확인', QMessageBox.Ok)
def product_dao_test(): global pdt pdt = ProductDao() [print(row) for row in pdt.select_product()] [ print(row) for row in pdt.select_product( sql="select * from product where code like %s", code='A%') ] sdt = SaleDao() [print(row) for row in sdt.select_item()] # sdt.insert_item(code='A001', price=5000, saleCnt=10, marginRate=10) [print(row) for row in sdt.select_item(no=1)] select_product() pdt.insert_product("Insert into product values(%s, %s)", 'C001', '라떼') select_product() pdt.update_product("update product set name = %s where code = %s", '라떼수정', 'C001') select_product() pdt.delete_product("delete from product where code = %s", 'C001') select_product()
def del_item(self): pdt = ProductDao() selectionIdxs = self.ui.tableWidget.selectedIndexes()[0] code = self.ui.tableWidget.item(selectionIdxs.row(), 0).text() pdt.delete_product(code) self.ui.tableWidget.removeRow(selectionIdxs.row())