from app.database import SessionLocal
from app.models.article import Article
from app.models.categorie import Categorie
db = SessionLocal()
deleted = db.query(Article).filter(Article.categorie_id == 7).delete()
print(str(deleted) + ' articles supprimés')
cat = db.query(Categorie).filter(Categorie.id == 7).first()
if cat:
    db.delete(cat)
    print('Categorie Beton supprimee')
db.commit()
db.close()