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())