Spaces:

amer003100
/

ERP_Sysyem

Running

ERP_Sysyem / delete_zero_items.py

AI Assistant

feat: add advanced filtering, sorting, and balance calculations for customers and products api endpoints

17a7cdf 15 days ago

304 Bytes

from app.core.database import SessionLocal
from app.models.domain import InvoiceItem

db = SessionLocal()
items = db.query(InvoiceItem).filter(InvoiceItem.quantity <= 0).all()
deleted = 0
for i in items:
    db.delete(i)
    deleted += 1

db.commit()
print(f"Deleted {deleted} items with quantity <= 0")

	from app.core.database import SessionLocal
	from app.models.domain import InvoiceItem

	db = SessionLocal()
	items = db.query(InvoiceItem).filter(InvoiceItem.quantity <= 0).all()
	deleted = 0
	for i in items:
	db.delete(i)
	deleted += 1

	db.commit()
	print(f"Deleted {deleted} items with quantity <= 0")