def update_basicmodel(old_column_1_value, new_column_1_value):
try:
ol_baicmodel_object = Session.query(BasicModel).filter_by(
column_1=old_column_1_value).first()
ol_baicmodel_object.column_1 = new_column_1_value
Session.commit()
return "Sucessfully updated"
except:
Session.rollback()
return "Something unexpected happened, rolledback operation"
def add_to_basicmodel(column_1_value, column_2_value, column_3_value):
try:
new_basicmodel_object = BasicModel(column_1=column_1_value,
column_2=column_2_value,
column_3=column_3_value)
Session.add(new_basicmodel_object)
Session.commit()
return "Sucessfully added"
except:
Session.rollback()
return "Something unexpected happened, rolledback operation"
def create_account_by_chat_id(self, chat_id: str, username: str):
session = Session()
instance = session.query(AccountModel).filter_by(
chat_id=chat_id, ).one_or_none()
if instance:
return
account_model = AccountModel(chat_id=chat_id, username=username)
try:
session.add(account_model)
session.commit()
except Exception:
session.rollback()
from datafetching.prereqs import get_prereqs_for_course, get_subject_codes, get_last_three_terms
import json
from db.connection import Session
from db.models import Course
import logging
logging.basicConfig(filename='prereq.log', level=logging.DEBUG)
# Get all courses in the database
session = Session()
all_courses = session.query(Course).all()
# Get term codes for Fall, Spring, and Summer
terms = get_last_three_terms()
# Fetch prereqs for each course
for course in all_courses:
try:
prereqs = get_prereqs_for_course(course.subject, course.num, terms)
course.prereqs = prereqs
except Exception as e:
logging.error(e)
session.commit()