complete_mentorship_cron_job.py

from datetime import datetime


def complete_overdue_mentorship_relations_job():
    """
    This function iterates of all the mentorship requests and
    checks if the end date of the relation has passed the current date
    and is in the ACCEPTED state
    if True then marks the relation as COMPLETED, if False does nothing
    """
    from run import application

    with application.app_context():
        from app.database.models.mentorship_relation import MentorshipRelationModel
        from app.utils.enum_utils import MentorshipRelationState

        all_relations = filter(
            lambda relation: relation.state == MentorshipRelationState.ACCEPTED
            and relation.end_date < current_date_timestamp,
            MentorshipRelationModel.query.all(),
        )

        current_date_timestamp = datetime.utcnow().timestamp()

        for relation in all_relations:
            relation.state = MentorshipRelationState.COMPLETED
            relation.save_to_db()