utils/scripts/lti_assignment_gradeimport.py [4:132]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
fireo.connection(from_file="./prod_sa.json")
import os
import csv
import copy
import json
import asyncio
from pathlib import Path
from common.models import User, CourseEnrollmentMapping, LTIAssignment
from google.oauth2 import service_account
from googleapiclient.discovery import build
from concurrent.futures import ThreadPoolExecutor

CLASSROOM_ADMIN_EMAIL = "studyhallregistrar@asu.edu"
SCOPES = [
    "https://www.googleapis.com/auth/classroom.courses",
    "https://www.googleapis.com/auth/classroom.rosters",
    "https://www.googleapis.com/auth/classroom.topics",
    "https://www.googleapis.com/auth/classroom.coursework.students",
    "https://www.googleapis.com/auth/classroom.coursework.me",
    "https://www.googleapis.com/auth/drive",
    "https://www.googleapis.com/auth/forms.body.readonly",
    "https://www.googleapis.com/auth/classroom.profile.photos",
    "https://www.googleapis.com/auth/classroom.courseworkmaterials",
    "https://www.googleapis.com/auth/classroom.courseworkmaterials.readonly",
    "https://www.googleapis.com/auth/classroom.push-notifications",
    "https://www.googleapis.com/auth/classroom.student-submissions." +
    "students.readonly",
    "https://www.googleapis.com/auth/classroom.rosters.readonly"
]
EMAILS_TO_BE_REPLACED = [{
    "zybooks_email": "simoneadgers@icloud.com",
    "clp_email": "moniesan715@gmail.com"
}, {
    "zybooks_email": "kaylamccloy@live.com",
    "clp_email": "kaylajmccloy@gmail.com"
}, {
    "zybooks_email": "loganash@outlook.com",
    "clp_email": "xioxio255@gmail.com"
}, {
    "zybooks_email": "bcamarda18@gmail.com",
    "clp_email": "katherineblocher93@gmail.com"
}, {
    "zybooks_email": "chloecampos15@yahoo.com",
    "clp_email": "chloecampos15@gmail.com"
}, {
    "zybooks_email": "imperfect.circle@yahoo.com",
    "clp_email": "imperfectcircle0@gmail.com"
}, {
    "zybooks_email": "psdragon4444@comcast.net",
    "clp_email": "dipasquap4444@gmail.com"
}, {
    "zybooks_email": "hbreannne00@gmail.com",
    "clp_email": "hbreanne00@gmail.com"
}, {
    "zybooks_email": "supremeezy@aim.com",
    "clp_email": "prich9600@gmail.com"
}, {
    "zybooks_email": "nr165@duke.edu",
    "clp_email": "nirvika98@gmail.com"
}, {
    "zybooks_email": "rehm.jeffrey@yahoo.com",
    "clp_email": "rehm.jeffrey@gmail.com"
}, {
    "zybooks_email": "robrenfrow911@gmail.com",
    "clp_email": "renfrowr88@gmail.com"
}, {
    "zybooks_email": "nyeerussell@icloud.com",
    "clp_email": "nyeerussell@gmail.com"
}, {
    "zybooks_email": "sandovalmichael003@yahoo.com",
    "clp_email": "msands0426@gmail.com"
}, {
    "zybooks_email": "nils@a-2.be",
    "clp_email": "nilssep04@gmail.com"
}, {
    "zybooks_email": "camsoz2000@yahoo.com",
    "clp_email": "cameronsozio@gmail.com"
}, {
    "zybooks_email": "vazquezgabriel425@yahoo.com",
    "clp_email": "igvasq21@gmail.com"
}]

SKIP_EMAILS = [
    "sbdeshazo@gmail.com", "emmaleesadle@gmail.com", "jchasteen0117@gmail.com",
    "krymgonz@gmail.com", "lillywallace01@gmail.com", "eanvanvliet@gmail.com",
    "rancepledgerjr8801@gmail.com", "hernandeztifany364@gmail.com",
    "gabrielle.brett26@gmail.com", "lenapena7512@gmail.com",
    "mia.buer94@gmail.com", "nathanneu97@gmail.com",
    "angela.capistran@gmail.com", "bankyalade1@gmail.com",
    "chris.iannotti64@gmail.com", "samuel.ray@slr.family",
    "victorialovejo@gmail.com", "sadermin@gmail.com",
    "angeloruiz1012@gmail.com", "nathanielbman87@gmail.com",
    "katie.bunn996@gmail.com", "layton.and.natasha@gmail.com",
    "simon.school001@gmail.com", "jwfreeman99@gmail.com",
    "missjuliaberry@gmail.com", "natashamachado16@gmail.com",
    "cass.hemby@gmail.com", "heyitsrigo1@gmail.com", "heyitsrigo1@gmail.com",
    "rosawilliam602@gmail.com", "trarevol21@gmail.com",
    "nathanielcorson@gmail.com", "samuel.ray@slr.family",
    "ihaveapig11@gmail.com", "adreana.i.aquino5@gmail.com",
    "nguyennoah04@gmail.com", "clrowlett@gmail.com",
    "mario.robles.93@gmail.com", "harryhartono1997@gmail.com",
    "meredithspencer04@gmail.com", "bridgetdotjones@gmail.com",
    "jwimberly616@gmail.com", "jrmiller9559@gmail.com",
    "uhringanalise@gmail.com", "zarragama1@gmail.com",
    "pomaitollefsen@gmail.com", "cheyenneleelarson@gmail.com",
    "sharonchen200574@gmail.com", "dawn.hinerth@gmail.com",
    "plokommb@gmail.com", "spooky.tabor@gmail.com", "hayleybredt@gmail.com",
    "arielwhysper@gmail.com", "hernandeztifany364@gmail.com",
    "emryhrobinson@gmail.com", "arielwhysper@gmail.com", "hncasey7@gmail.com",
    "dvwhippl@gmail.com", "isabelag62702@gmail.com", "tylertodd6153@gmail.com",
    "seth.callis.e@gmail.com", "gcmaloney4@gmail.com",
    "hernandeztifany364@gmail.com", "menakeshishzadeh@gmail.com",
    "macyproctor98@gmail.com", "dianal.martin@yahoo.com",
    "cassiopeiafitzsimmons@gmail.com", "hoanghchristine@gmail.com",
    "kmbaldw2@asu.edu", "hannah.marie.mudge@gmail.com",
    "cynthiaamorette@gmail.com", "mitch.accounts@gmail.com",
    "owenfox066@gmail.com", "rosaamilee@gmail.com", "jenny.cas0206@gmail.com",
    "brycelcarpenter@gmail.com", "berg.c.09@gmail.com",
    "amberly.smith805@gmail.com", "siancmorris@gmail.com",
    "jcernoch25@gmail.com", "ajmassock@gmail.com", "naomirivera15@gmail.com",
    "sevillethorpe@gmail.com", "jjcm1994@gmail.com", "bgleason09@gmail.com",
    "melissa.hammon42@gmail.com", "wyatt.olson97@gmail.com",
    "dbenef25@gmail.com", "chris99thomson@gmail.com", "deleted@deleted.com",
    "elizabeth.zukowski@gmail.com", "gstridsigne915@gmail.com",
    "abbyhering45@gmail.com", "pomaitollefsen@gmail.com",
    "pomaitollefsen@gmail.com", "foleytho@gmail.com", "oapietrib@gmail.com",
    "oapietrib@gmail.com", "oapietrib@gmail.com", "charity.mcnally@gmail.com",
    "quillmccrory@gmail.com", "steviepenn@gmail.com", "alxrd6@gmail.com",
    "zforten1404@gmail.com", "m.raha1988m@gmail.com", "zforten1404@gmail.com",
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



utils/scripts/zybooks_finals_grade_import.py [4:133]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
fireo.connection(from_file="./prod_sa.json")

import os
import csv
import copy
import json
import asyncio
from pathlib import Path
from common.models import User, CourseEnrollmentMapping, LTIAssignment
from google.oauth2 import service_account
from googleapiclient.discovery import build
from concurrent.futures import ThreadPoolExecutor

CLASSROOM_ADMIN_EMAIL = "studyhallregistrar@asu.edu"
SCOPES = [
    "https://www.googleapis.com/auth/classroom.courses",
    "https://www.googleapis.com/auth/classroom.rosters",
    "https://www.googleapis.com/auth/classroom.topics",
    "https://www.googleapis.com/auth/classroom.coursework.students",
    "https://www.googleapis.com/auth/classroom.coursework.me",
    "https://www.googleapis.com/auth/drive",
    "https://www.googleapis.com/auth/forms.body.readonly",
    "https://www.googleapis.com/auth/classroom.profile.photos",
    "https://www.googleapis.com/auth/classroom.courseworkmaterials",
    "https://www.googleapis.com/auth/classroom.courseworkmaterials.readonly",
    "https://www.googleapis.com/auth/classroom.push-notifications",
    "https://www.googleapis.com/auth/classroom.student-submissions." +
    "students.readonly",
    "https://www.googleapis.com/auth/classroom.rosters.readonly"
]
EMAILS_TO_BE_REPLACED = [{
    "zybooks_email": "simoneadgers@icloud.com",
    "clp_email": "moniesan715@gmail.com"
}, {
    "zybooks_email": "kaylamccloy@live.com",
    "clp_email": "kaylajmccloy@gmail.com"
}, {
    "zybooks_email": "loganash@outlook.com",
    "clp_email": "xioxio255@gmail.com"
}, {
    "zybooks_email": "bcamarda18@gmail.com",
    "clp_email": "katherineblocher93@gmail.com"
}, {
    "zybooks_email": "chloecampos15@yahoo.com",
    "clp_email": "chloecampos15@gmail.com"
}, {
    "zybooks_email": "imperfect.circle@yahoo.com",
    "clp_email": "imperfectcircle0@gmail.com"
}, {
    "zybooks_email": "psdragon4444@comcast.net",
    "clp_email": "dipasquap4444@gmail.com"
}, {
    "zybooks_email": "hbreannne00@gmail.com",
    "clp_email": "hbreanne00@gmail.com"
}, {
    "zybooks_email": "supremeezy@aim.com",
    "clp_email": "prich9600@gmail.com"
}, {
    "zybooks_email": "nr165@duke.edu",
    "clp_email": "nirvika98@gmail.com"
}, {
    "zybooks_email": "rehm.jeffrey@yahoo.com",
    "clp_email": "rehm.jeffrey@gmail.com"
}, {
    "zybooks_email": "robrenfrow911@gmail.com",
    "clp_email": "renfrowr88@gmail.com"
}, {
    "zybooks_email": "nyeerussell@icloud.com",
    "clp_email": "nyeerussell@gmail.com"
}, {
    "zybooks_email": "sandovalmichael003@yahoo.com",
    "clp_email": "msands0426@gmail.com"
}, {
    "zybooks_email": "nils@a-2.be",
    "clp_email": "nilssep04@gmail.com"
}, {
    "zybooks_email": "camsoz2000@yahoo.com",
    "clp_email": "cameronsozio@gmail.com"
}, {
    "zybooks_email": "vazquezgabriel425@yahoo.com",
    "clp_email": "igvasq21@gmail.com"
}]

SKIP_EMAILS = [
    "sbdeshazo@gmail.com", "emmaleesadle@gmail.com", "jchasteen0117@gmail.com",
    "krymgonz@gmail.com", "lillywallace01@gmail.com", "eanvanvliet@gmail.com",
    "rancepledgerjr8801@gmail.com", "hernandeztifany364@gmail.com",
    "gabrielle.brett26@gmail.com", "lenapena7512@gmail.com",
    "mia.buer94@gmail.com", "nathanneu97@gmail.com",
    "angela.capistran@gmail.com", "bankyalade1@gmail.com",
    "chris.iannotti64@gmail.com", "samuel.ray@slr.family",
    "victorialovejo@gmail.com", "sadermin@gmail.com",
    "angeloruiz1012@gmail.com", "nathanielbman87@gmail.com",
    "katie.bunn996@gmail.com", "layton.and.natasha@gmail.com",
    "simon.school001@gmail.com", "jwfreeman99@gmail.com",
    "missjuliaberry@gmail.com", "natashamachado16@gmail.com",
    "cass.hemby@gmail.com", "heyitsrigo1@gmail.com", "heyitsrigo1@gmail.com",
    "rosawilliam602@gmail.com", "trarevol21@gmail.com",
    "nathanielcorson@gmail.com", "samuel.ray@slr.family",
    "ihaveapig11@gmail.com", "adreana.i.aquino5@gmail.com",
    "nguyennoah04@gmail.com", "clrowlett@gmail.com",
    "mario.robles.93@gmail.com", "harryhartono1997@gmail.com",
    "meredithspencer04@gmail.com", "bridgetdotjones@gmail.com",
    "jwimberly616@gmail.com", "jrmiller9559@gmail.com",
    "uhringanalise@gmail.com", "zarragama1@gmail.com",
    "pomaitollefsen@gmail.com", "cheyenneleelarson@gmail.com",
    "sharonchen200574@gmail.com", "dawn.hinerth@gmail.com",
    "plokommb@gmail.com", "spooky.tabor@gmail.com", "hayleybredt@gmail.com",
    "arielwhysper@gmail.com", "hernandeztifany364@gmail.com",
    "emryhrobinson@gmail.com", "arielwhysper@gmail.com", "hncasey7@gmail.com",
    "dvwhippl@gmail.com", "isabelag62702@gmail.com", "tylertodd6153@gmail.com",
    "seth.callis.e@gmail.com", "gcmaloney4@gmail.com",
    "hernandeztifany364@gmail.com", "menakeshishzadeh@gmail.com",
    "macyproctor98@gmail.com", "dianal.martin@yahoo.com",
    "cassiopeiafitzsimmons@gmail.com", "hoanghchristine@gmail.com",
    "kmbaldw2@asu.edu", "hannah.marie.mudge@gmail.com",
    "cynthiaamorette@gmail.com", "mitch.accounts@gmail.com",
    "owenfox066@gmail.com", "rosaamilee@gmail.com", "jenny.cas0206@gmail.com",
    "brycelcarpenter@gmail.com", "berg.c.09@gmail.com",
    "amberly.smith805@gmail.com", "siancmorris@gmail.com",
    "jcernoch25@gmail.com", "ajmassock@gmail.com", "naomirivera15@gmail.com",
    "sevillethorpe@gmail.com", "jjcm1994@gmail.com", "bgleason09@gmail.com",
    "melissa.hammon42@gmail.com", "wyatt.olson97@gmail.com",
    "dbenef25@gmail.com", "chris99thomson@gmail.com", "deleted@deleted.com",
    "elizabeth.zukowski@gmail.com", "gstridsigne915@gmail.com",
    "abbyhering45@gmail.com", "pomaitollefsen@gmail.com",
    "pomaitollefsen@gmail.com", "foleytho@gmail.com", "oapietrib@gmail.com",
    "oapietrib@gmail.com", "oapietrib@gmail.com", "charity.mcnally@gmail.com",
    "quillmccrory@gmail.com", "steviepenn@gmail.com", "alxrd6@gmail.com",
    "zforten1404@gmail.com", "m.raha1988m@gmail.com", "zforten1404@gmail.com",
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -