filehandler.py

# filehandler.py

import csv
import os
from result import Result


FILE_NAME = "students.csv"


# -----------------------------
# Create CSV File with Header
# -----------------------------
def create_file():

    if not os.path.exists(FILE_NAME):

        with open(FILE_NAME, "w", newline="") as file:

            writer = csv.writer(file)

            writer.writerow([
                "Roll Number",
                "Student Name",
                "English",
                "Maths",
                "Science",
                "Total",
                "Percentage",
                "Grade"
            ])


# -----------------------------
# Save Student
# -----------------------------
def save_student(student):

    create_file()

    total = Result.total(student)
    percentage = Result.percentage(student)
    grade = Result.grade(student)

    with open(FILE_NAME, "a", newline="") as file:

        writer = csv.writer(file)

        writer.writerow([
            student.roll_no,
            student.name,
            student.english,
            student.maths,
            student.science,
            total,
            f"{percentage:.2f}",
            grade
        ])

    print("\n✅ Student record saved successfully.")


# -----------------------------
# View All Students
# -----------------------------
def view_students():

    create_file()

    with open(FILE_NAME, "r", newline="") as file:

        reader = csv.reader(file)

        next(reader)

        students = list(reader)

        if len(students) == 0:

            print("\nNo Student Records Found.")
            return

        print("\n" + "=" * 80)
        print("                 ALL STUDENT RECORDS")
        print("=" * 80)

        for row in students:

            print(f"Roll Number : {row[0]}")
            print(f"Name        : {row[1]}")
            print(f"English     : {row[2]}")
            print(f"Maths       : {row[3]}")
            print(f"Science     : {row[4]}")
            print(f"Total       : {row[5]}")
            print(f"Percentage  : {row[6]}%")
            print(f"Grade       : {row[7]}")

            print("-" * 80)