student_class.py

#REcords for 2021 entrants
from sqlalchemy import create_engine, Column, String, REAL, desc
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from subject_class import *

Base = declarative_base()

class Student(Base):
    __tablename__ = "student_records"

    regno = Column("regno" , String, primary_key = True, nullable=False, unique=True)
    fullname = Column("fullname", String, nullable=False)
    tcur = Column('tcur', REAL)
    tcue = Column('tcue', REAL)
    cgpa = Column('cgpa', REAL)
    remarks = Column('remarks', String)
    
    """defines instances of students"""
    def __init__(self, std_full_name, reg_no):
        self.fullname = std_full_name.upper()
        self.regno = reg_no.upper()
        self.tcur = 0
        self.tcue = 0
        self.cgpa = 0
        self.remarks = ''
    def calculate_cgpa(self, subject, score):
        self.tcur += subject.credit_unit
      
        if score >= 70:
            grade_point = 4.00
            if subject.course_code in self.remarks:
                update = self.remarks.replace(subject.course_code, '')
                self.remarks = update
        elif score >= 65:
            grade_point = 3.50
            if subject.course_code in self.remarks:
                update = self.remarks.replace(subject.course_code, '')
                self.remarks = update
        elif score >= 60:
            grade_point = 3.00
            if subject.course_code in self.remarks:
                update = self.remarks.replace(subject.course_code, '')
                self.remarks = update
        elif score >= 55:
            grade_point = 2.50
            if subject.course_code in self.remarks:
                update = self.remarks.replace(subject.course_code, '')
                self.remarks = update
        elif score >= 50:
            grade_point = 2.00
            if subject.course_code in self.remarks:
                update = self.remarks.replace(subject.course_code, '')
                self.remarks = update
        else:
            grade_point = 0.00
            self.remarks += subject.course_code
        
        cue = float(grade_point * subject.credit_unit)
        self.tcue += cue
        self.cgpa = round(self.tcue/self.tcur, 2)
    def __repr__(self):
        return f"""
            NAME:       {self.fullname}
            REG NO:     {self.regno}
            TCUR:       {self.tcur} 
            TCUE:       {self.tcue} 
            CGPA:       {self.cgpa}
            REMARKS:    {self.remarks}"""
    
    def test_print(self):
        return f"""
            NAME:       {self.fullname}
            REG NO:     {self.regno}
            TCUR:       {self.tcur} 
            TCUE:       {self.tcue} 
            CGPA:       {self.cgpa}
            REMARKS:    {self.remarks}\n\n"""
        

engine = create_engine("sqlite:///2021_admission_pharm_tech_results.db", echo = True)
Base.metadata.create_all(bind=engine)
Session = sessionmaker(bind=engine)
session = Session()



# student_14 = Student('Zainab Dauda', 'cchstz/pt/105/21')
# student_14.calculate_cgpa(ctz_101, 64)
# student_14.calculate_cgpa(eng_101, 18)
# student_14.calculate_cgpa(ict_101, 40)
# student_14.calculate_cgpa(ptp_111, 50)
# student_14.calculate_cgpa(phy_111, 55)
# student_14.calculate_cgpa(chm_111, 41)
# student_14.calculate_cgpa(bio_111, 50)
# student_14.calculate_cgpa(etp_101, 50)
# student_14.calculate_cgpa(bdt_151, 62)
# student_14.calculate_cgpa(mth_111, 62)
# student_14.calculate_cgpa(bio_112, 60)
# student_14.calculate_cgpa(chm_112, 55)
# student_14.calculate_cgpa(phy_112, 47)
# student_14.calculate_cgpa(mth_112, 0)
# student_14.calculate_cgpa(eng_102, 37)
# student_14.calculate_cgpa(bdt_152, 33)
# student_14.calculate_cgpa(mcb_112, 34)
# student_14.calculate_cgpa(aum_122, 40)


# session.add(student_14)
# session.commit()

# with open('new', 'a') as f:
#     test = session.query(Student).order_by(Student.regno).all()
#     for student in test:
#         f.write(student.test_print())



test = session.query(Student).order_by(desc(Student.cgpa)).all()
print(test)

#query and then update student
# update_record = session.query(Student).filter(Student.regno == 'cchstz/pt/104/21'.upper()).first()
# update_record.calculate_cgpa(hcp_361, 90)
# session.commit()


# DELETING DATA
# query = session.query(Student)
# query = query.filter(Student.regno == "cchstz/pt/105/21".upper())
# dcc_cookie = query.first()
# session.delete(dcc_cookie)
# session.commit()
# dcc_cookie = query.first()
# print(dcc_cookie)


#trying get method
# student = session.query(Student).get('cchstz/pt/107/21'.upper())
# print(student)

#how many students are above 2.0 cgpa
# student_2_0 = session.query(Student).filter(Student.cgpa >= 1.5).all()
# total_students = session.query(Student).all()
# print(f'{len(student_2_0)} students have above 1.5 cgpa out of {len(total_students)} students')