Source code for uw.local.teaching.bin.send_instructor_setup_reminders

"""Termly course staff setup reminder sending process.

Implements the process to send email reminders to course staff to set up their
courses as early as possible if they want to use the examination management
system.
"""

from uw.sql.wrap import open_psycopg2_db_service_cursor

from ...outgoing.make_mail import mailout
from ...util.mail import odyssey_email

message_content = """
You are receiving this email because you, or a course you are teaching this
term, have recently used the examination management system to print examination
papers and/or individually assign candidates to specific seats.

Please note that automatic multiple choice marking is now supported via
integration with Markbox or Crowdmark at your choice.  Markbox is a system
developed within Science Computing while Crowdmark is the existing online
grading platform already in use.

If you wish to use the system this term, either for printing of papers or for
assigning of candidates to individual seats, please log in as soon as possible.
We encourage you to set up your midterms as soon as the information is
available to you.  This will benefit students because the midterms will then
appear on their examination schedules.  Final examinations will be
automatically imported from the schedule published by the Registrar.

The URL of the front page is:

https://odyssey.uwaterloo.ca/teaching/

(WatIAM/Quest userid and password required)

If your course has a single instructor or is in the Math Faculty, it should
already be set up for you to access it and set up examinations.  If your course
is a multi-instructor course outside of the Math Faculty, it should already be
set up for instructors to see it, but a course coordinator will likely need to
be authorized to set up examinations.  If you run into any problems or have any
questions, please do not hesitate to email odyssey@uwaterloo.ca.
"""

def main ():
    cursor = open_psycopg2_db_service_cursor ()

    for person_id in cursor.execute_values ("select notify_instruct_setup (uw_term_current ())"):
        msg = mailout (cursor, odyssey_email,
            'Examination Management Setup', message_content)
        msg.add_recipient_person ('To', person_id)
        msg.done ()

    cursor.connection.commit ()