w3resource

Python program to delete a record from a table

Python SQLAlchemy: Exercise-5 with Solution

Write a Python program that deletes a student from the 'students' table by their id.

Sample Solution:

Code:

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
# Create a SQLite database named students.db
engine = create_engine('sqlite:///testdatabase.db', echo=False)
# Create a base class for declarative models
Base = declarative_base()
# Define the Student model
class Student(Base):
    __tablename__ = 'students'    
    id = Column(Integer, primary_key=True)
    studentname = Column(String, nullable=False)
    email = Column(String, nullable=False)
# Create a session to interact with the database
Session = sessionmaker(bind=engine)
session = Session()
def delete_student_by_id(student_id):
    student = session.query(Student).filter_by(id=student_id).first()
    if student:
        session.delete(student)
        session.commit()
        print("Student deleted successfully")
    else:
        print(f"Student with ID {student_id} not found")
# Delete a student from the students table by their ID
student_id = 22  # Replace with the desired student ID
delete_student_by_id(student_id)
# Close the session
session.close()

Output:

Student deleted successfully

Flowchart:

Flowchart: Delaying Print Output with asyncio Coroutines in Python.

Previous: Python program to update a table field.
Next: Create SQLAlchemy models and populating tables.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/python-exercises/sqlalchemy/python-sqlalchemy-exercise-5.php