Usuwanie danych z bazy danych

Wprowadzenie do baz danych w Pythonie

Jason Myers

Co-Author of Essential SQLAlchemy and Software Engineer

Usuwanie danych z tabeli

from sqlalchemy import delete

stmt = select([func.count(extra_employees.columns.id)])

connection.execute(stmt).scalar()

delete_stmt = delete(extra_employees)

result_proxy = connection.execute(delete_stmt)
result_proxy.rowcount

stmt = delete(employees).where(employees.columns.id == 3)

result_proxy = connection.execute(stmt)
result_proxy.rowcount

extra_employees.drop(engine)

print(extra_employees.exists(engine))

False

metadata.drop_all(engine)

engine.table_names()

[]

Wprowadzenie do baz danych w Pythonie