def overwrite_youtube_video(appArg, projectId):
with appArg.app_context():
try:
project = database.getProjectById(projectId)
database.updateProject(project.id, {
"youtubeUploadStatus": "deleting current"
})
deleteVideoResult, deleteVideoInfo = youtubeUpload.deleteVideo(project.youtubeVideo)
if (deleteVideoResult == "success") or (deleteVideoResult == "failure" and deleteVideoInfo == "videoNotFound"):
database.updateProject(project.id, {
"youtubeVideo": "",
})
database.updateProjectStatus(project.id, {
"projectDoc": False
})
upload_video_to_youtube(appArg, projectId)
else:
database.updateProject(project.id, {
"youtubeUploadStatus": "failed"
})
except Exception as e:
app.logger.error('Error is: {}\n{}'.format(e, traceback.format_exc()))
database.updateProject(project.id, {
"youtubeUploadStatus": "failed"
})
def upload_video_to_youtube(appArg, projectId):
with appArg.app_context():
try:
project = database.getProjectById(projectId)
database.updateProject(project.id, {
"youtubeUploadStatus": "uploading"
})
videoPath = os.path.join(appArg.root_path, "static", "project_doc", "video", project.localVideo)
success = youtubeUpload.uploadVideo(
videoPath=videoPath,
title=project.title,
description=project.abstract,
keywords="technion, technion avr, technion project, virtual reality lab, augmented reality lab"
)
if success:
deleteLocalFile(videoPath)
app.logger.info(f"Local video: {videoPath} was deleted")
database.updateProject(project.id, {
"localVideo": "",
"youtubeVideo": success,
"youtubeUploadStatus": "completed"
})
update_youtube_video_processing_details(projectId)
else:
database.updateProject(project.id, {
"youtubeUploadStatus": "failed"
})
except Exception as e:
app.logger.error('Error is: {}\n{}'.format(e, traceback.format_exc()))
database.updateProject(project.id, {
"youtubeUploadStatus": "failed"
})
def set_youtube_video_public(appArg, projectId):
with appArg.app_context():
try:
project = database.getProjectById(projectId)
success = youtubeUpload.setVideoToPublic(project.youtubeVideo)
if success:
database.updateProject(project.id, {
"youtubeVideoPublicStatus": "success",
"projectDocApproved": True,
"projectDocEditableByStudents": False
})
database.updateProjectStatus(project.id, {
"projectDoc": True
})
else:
database.updateProject(project.id, {
"youtubeVideoPublicStatus": "failed"
})
except Exception as e:
app.logger.error('Error is: {}\n{}'.format(e, traceback.format_exc()))
database.updateProject(project.id, {
"youtubeVideoPublicStatus": "failed"
})
def manageProjects():
if not utils.check_user_lab_admin():
return redirect(url_for('login'))
try:
admin = utils.check_user_admin()
lab = None if not utils.check_user_lab() else database.getLabByAcronym(
flask_login.current_user.userId)
courses = database.getAllCourses()
addForm = addProjectForm()
editForm = editProjectForm()
deleteForm = deleteProjectForm()
addFormErrors = False
editFormErrorProjectId = ''
edit_studentForm = editStudentForm()
currentSemester = utils.getRegistrationSemester()
currentYear = utils.getRegistrationYear()
semesterChoices = [("Winter", "Winter"), ("Spring", "Spring")]
if currentSemester == "Spring":
semesterChoices.reverse()
addForm.new_title.choices = [
(str(s.id), s.title) for s in database.getAllProposedProjects()
]
addForm.new_year.choices = [
(currentYear, currentYear),
(str(int(currentYear) + 1), str(int(currentYear) + 1)),
(str(int(currentYear) + 2), str(int(currentYear) + 2))
]
addForm.new_semester.choices = semesterChoices
allSupervisors = database.getAllSupervisors()
supervisorsChoices = [(str(s.id), s.firstNameEng + " " + s.lastNameEng)
for s in allSupervisors]
supervisorsChoices.insert(0, ('', ''))
addForm.new_supervisor1.choices = supervisorsChoices
addForm.new_supervisor2.choices = supervisorsChoices
addForm.new_supervisor3.choices = supervisorsChoices
editForm.year.choices = [
(currentYear, currentYear),
(str(int(currentYear) + 1), str(int(currentYear) + 1)),
(str(int(currentYear) + 2), str(int(currentYear) + 2))
]
editForm.semester.choices = semesterChoices
editForm.supervisor1.choices = supervisorsChoices
editForm.supervisor2.choices = supervisorsChoices
editForm.supervisor3.choices = supervisorsChoices
# get Labs
allLabs = database.getAllLabs()
allLabsChoices = [(str(l.id), l.acronym) for l in allLabs]
editForm.lab.choices = allLabsChoices
addForm.new_lab.choices = allLabsChoices
if (request.method == 'POST'):
formName = request.form['sentFormName']
if formName == 'editProjectForm':
project = database.getProjectById(editForm.projectId.data)
if not project:
app.logger.error(
'In manageProjects, in editForm, tried to edit a project with id {} that does not exist in the db'
.format(editForm.projectId.data))
flash(
"Error: project with id {} is not in the db.".format(
editForm.projectId.data), 'danger')
return redirect(url_for('manageProjects'))
app.logger.error("this is the students: {}".format(
request.form))
if editForm.validate_on_submit():
studentsIds = request.form.getlist("students")
studentsCoursesIds = request.form.getlist(
"studentsCoursesIds")
if studentsIds and not studentsCoursesIds:
flash(
"Error: students can't be added to a project without a course number.",
'danger')
return redirect(url_for('manageProjects'))
projectImage = project.image
if editForm.image.data:
# delete old image if exists
app.logger.info(
'In manageProjects, in editForm, deleting old project image'
)
utils.delete_project_image(projectImage)
projectImage = utils.save_form_image(
editForm.image.data, "projects")
database.updateProject(
project.id, {
"title": editForm.title.data,
"year": editForm.year.data,
"semester": editForm.semester.data,
"comments": editForm.comments.data,
"grade": editForm.grade.data,
"image": projectImage,
"lab": editForm.lab.data
})
# update students in project
studentsInProject = []
for i in range(len(studentsIds)):
studentsInProject.append({
"id":
studentsIds[i],
"courseId":
studentsCoursesIds[i]
})
database.updateProjectStudents(project.id,
studentsInProject)
# update supervisors in project
supervisorsIds = set()
if editForm.supervisor1.data:
supervisorsIds.add(editForm.supervisor1.data)
if editForm.supervisor2.data:
supervisorsIds.add(editForm.supervisor2.data)
if editForm.supervisor3.data:
supervisorsIds.add(editForm.supervisor3.data)
database.updateProjectSupervisors(project.id,
supervisorsIds)
# update status
database.updateProjectStatus(
project.id, {
"requirementsDoc": editForm.requirementsDoc.data,
"firstMeeting": editForm.firstMeeting.data,
"halfwayPresentation":
editForm.halfwayPresentation.data,
"finalMeeting": editForm.finalMeeting.data,
"projectReport": editForm.projectReport.data,
"equipmentReturned":
editForm.equipmentReturned.data,
"projectDoc": editForm.projectDoc.data,
"gradeStatus": editForm.gradeStatus.data
})
flash('Project was updated successfully!', 'success')
if request.form.get('studentsReferrer'):
return redirect(url_for('manageStudents'))
else:
return redirect(url_for('manageProjects'))
else:
app.logger.info(
'In manageProjects, editForm is NOT valid. editForm.errors: {}'
.format(editForm.errors))
editFormErrorProjectId = editForm.projectId.data
if 'csrf_token' in editForm.errors:
flash(
'Error: csrf token expired, please re-send the form.',
'danger')
else:
flash('There was an error, see details below.',
'danger')
if request.form.get('studentsReferrer'):
edit_StudentForm = editStudentForm()
delete_StudentForm = deleteStudentForm()
editFormErrorStudentId = ''
return render_template(
'/admin/students.html',
title="Manage Students",
editForm=edit_StudentForm,
editProjectForm=editForm,
courses=courses,
deleteForm=delete_StudentForm,
editFormErrorStudentId=editFormErrorStudentId,
editProjectErrorId=editFormErrorProjectId)
elif formName == 'addProjectForm':
if addForm.validate_on_submit():
studentsIds = request.form.getlist("students")
studentsCoursesIds = request.form.getlist(
"studentsCoursesIds")
if studentsIds and not studentsCoursesIds:
flash(
"Error: students can't be added to a project without a course number.",
'danger')
return redirect(url_for('manageProjects'))
# add new project
projectTitle = dict(addForm.new_title.choices).get(
addForm.new_title.data)
newImageName = None
# save project image
matchingProposedProject = database.getProposedProjectByTitle(
projectTitle)
if matchingProposedProject:
matchingImageName = matchingProposedProject.image
if matchingImageName:
newImageName = utils.copy_project_image_from_proposed_project(
matchingImageName)
newProject = {
"title": projectTitle,
"year": addForm.new_year.data,
"semester": addForm.new_semester.data,
"grade": addForm.new_grade.data,
"comments": addForm.new_comments.data,
"image": newImageName,
"requirementsDoc": addForm.new_requirementsDoc.data,
"firstMeeting": addForm.new_firstMeeting.data,
"halfwayPresentation":
addForm.new_halfwayPresentation.data,
"finalMeeting": addForm.new_finalMeeting.data,
"projectReport": addForm.new_projectReport.data,
"equipmentReturned":
addForm.new_equipmentReturned.data,
"projectDoc": addForm.new_projectDoc.data,
"gradeStatus": addForm.new_gradeStatus.data,
"status": "הרשמה",
"lab": addForm.new_lab.data
}
newProjectId = database.addProject(newProject)
# add students to project
studentsInProject = []
for i in range(len(studentsIds)):
studentsInProject.append({
"id":
studentsIds[i],
"courseId":
studentsCoursesIds[i]
})
database.updateProjectStudents(newProjectId,
studentsInProject)
# add supervisors to project
supervisorsIds = set()
if addForm.new_supervisor1.data:
supervisorsIds.add(addForm.new_supervisor1.data)
if addForm.new_supervisor2.data:
supervisorsIds.add(addForm.new_supervisor2.data)
if addForm.new_supervisor3.data:
supervisorsIds.add(addForm.new_supervisor3.data)
database.updateProjectSupervisors(newProjectId,
supervisorsIds)
flash('Project was created successfully!', 'success')
return redirect(url_for('manageProjects'))
else:
addFormErrors = True
app.logger.info(
'In manageProjects, addForm is NOT valid. addForm.errors:{}'
.format(addForm.errors))
if 'csrf_token' in addForm.errors:
flash(
'Error: csrf token expired, please re-send the form.',
'danger')
else:
flash('There was an error, see details below.',
'danger')
return render_template('/admin/projects.html',
title="Manage Projects",
courses=courses,
addForm=addForm,
editForm=editForm,
deleteForm=deleteForm,
addFormErrors=addFormErrors,
editFormErrorProjectId=editFormErrorProjectId,
editStudentForm=edit_studentForm,
admin=admin,
lab=lab)
except Exception as e:
app.logger.error('In manageProjects, Error is: {}\n{}'.format(
e, traceback.format_exc()))
return redirect(url_for('errorPage'))
def update_youtube_video_processing_details(projectId):
while True:
try:
project = database.getProjectById(projectId)
database.updateProject(project.id, {
"youtubeProcessingStatus": "checking"
})
result = youtubeUpload.getProcessingDetails(videoId=project.youtubeVideo)
if result:
if result["pageInfo"]["totalResults"] != 0:
failedStatus = {"deleted", "failed", "rejected"}
if result["items"][0]["status"]["uploadStatus"] in failedStatus:
database.updateProject(project.id, {
"youtubeVideo": "", # to avoid trying to delete this video next time bacause it won't succeed
"youtubeProcessingFailureReason": "",
"youtubeProcessingStatus": "terminated",
"youtubeProcessingEstimatedTimeLeft": ""
})
break
elif result["items"][0]["status"]["uploadStatus"] == "uploaded":
youtubeVideo = project.youtubeVideo
youtubeProcessingStatus = ""
processingFailureReason = ""
youtubeProcessingEstimatedTimeLeft = project.youtubeProcessingEstimatedTimeLeft
if not "processingDetails" in result["items"][0]: # processing failed for some reason, no info given
youtubeVideo = ""
youtubeProcessingStatus = "terminated"
else:
if result["items"][0]["processingDetails"]["processingStatus"] == "failed":
youtubeProcessingStatus = "failed"
processingFailureReason = result["items"][0]["processingDetails"]["processingFailureReason"]
elif result["items"][0]["processingDetails"]["processingStatus"] == "terminated":
youtubeProcessingStatus = "terminated"
youtubeVideo = ""
elif result["items"][0]["processingDetails"]["processingStatus"] == "processing":
youtubeProcessingStatus = "processing"
if "processingProgress" in result["items"][0]["processingDetails"]:
youtubeProcessingEstimatedTimeLeft = result["items"][0]["processingDetails"]["processingProgress"]["timeLeftMs"]
database.updateProject(project.id, {
"youtubeVideo": youtubeVideo,
"youtubeProcessingStatus": youtubeProcessingStatus,
"youtubeProcessingFailureReason": processingFailureReason,
"youtubeProcessingEstimatedTimeLeft": youtubeProcessingEstimatedTimeLeft
})
if youtubeProcessingStatus != "processing":
break
elif result["items"][0]["status"]["uploadStatus"] == "processed":
database.updateProject(project.id, {
"youtubeProcessingStatus": "processed",
"youtubeProcessingEstimatedTimeLeft": "",
"youtubeProcessingFailureReason": "",
"status": "דף פרויקט - טיוטה"
})
break
else: # video processing failed because something was wrong with the video file or it was a duplicate of a video already uploaded
database.updateProject(project.id, {
"youtubeVideo": "", # to avoid trying to delete this video next time bacause it won't succeed
"youtubeProcessingFailureReason": "",
"youtubeProcessingStatus": "terminated",
"youtubeProcessingEstimatedTimeLeft": ""
})
break
else:
database.updateProject(project.id, {
"youtubeProcessingStatus": ""
})
except Exception as e:
app.logger.error('Error is: {}\n{}'.format(e, traceback.format_exc()))
time.sleep(3.0)