crud.py

"""File to handle interactions to the database"""

from database_model import Education, Experience, Skill, User, db


def create_user(name, phone, email, resume_order):
    """Create and return an user"""
    user = User(name=name, phone=phone, email=email, resume_order=resume_order)
    return user


def create_skill(name, proficiency, logo):
    """Create and return a skill"""
    skill = Skill(name=name, proficiency=proficiency, logo=logo)
    return skill


def create_experience(title, company, start_date, end_date, description, logo):
    """Create an return an experience"""
    experience = Experience(
        title=title,
        company=company,
        start_date=start_date,
        end_date=end_date,
        description=description,
        logo=logo,
    )
    return experience


def create_education(course, school, start_date, end_date, grade, logo):
    """Create and return an education"""
    education = Education(
        course=course,
        school=school,
        start_date=start_date,
        end_date=end_date,
        grade=grade,
        logo=logo,
    )
    return education


def get_all_education():
    """Return all educations"""
    return Education.query.all()


def get_education_by_id(id):
    """Return an education based on id"""
    return Education.query.filter(Education.id == id).first()