Python program to retrieve table information from database

Last update on April 24 2025 12:40:00 (UTC/GMT +8 hours)

3. Retrieve Student by ID

Write a Python program that retrieves a student's information from the `students` table using 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 get_student_info(student_id):
    student = session.query(Student).filter_by(id=student_id).first()
    return student
# Retrieve a user's information using their ID
student_id = 22  # Replace with the desired student ID
student = get_student_info(student_id)
if student:
    print(f"Student ID: {student.id}")
    print(f"Student Name: {student.studentname}")
    print(f"Email: {student.email}")
else:
    print(f"Student with ID {student_id} not found")
# Close the session
session.close()

Output:

Student ID: 22
Student Name: Hughie Glauco
Email: hughie@example.com

Flowchart:

For more Practice: Solve these Related Problems:

Write a Python program to query the 'students' table by a given student id and print the student's name and email.
Write a Python function that takes a student id as input, retrieves the corresponding student record using SQLAlchemy, and returns the record.
Write a Python script to prompt the user for a student id, fetch the student's details, and handle the case where the id does not exist.
Write a Python program that retrieves a student's information by id and formats the output in a neat table using string formatting.

Go to:

Previous: Python Program: Add new records to database table.
Next: Python program to update a table field.

Python Code Editor :