def get_csv_statistics_export(statistics_info, current_user: User) -> Export:
current_date = get_current_date()
filename = ('statystykiCSV' + get_formatted_date(current_date) +
'.csv').replace(" ", "_")
with open(os.path.join(current_user.get_directory(), filename),
'w',
newline='') as csv_file:
csv_writer = csv.writer(csv_file,
delimiter='|',
quoting=csv.QUOTE_MINIMAL)
statistics: List[Statistics] = Statistics.get_statistics_by_ids(
statistics_info)
for statistic in statistics:
csv_writer.writerow([statistic.university_id] +
[statistic.course_name] +
[statistic.user_points] +
[statistic.course_points] +
[str(statistic.get_percent_value()) + '%'])
for student_exercise in statistic.student_exercises:
csv_writer.writerow(
[student_exercise.exercise.lesson.name] +
[student_exercise.exercise.name] +
[student_exercise.points] + [student_exercise.max_points] +
[str(student_exercise.get_percent_value()) + '%'])
csv_writer.writerow('')
export = Export(user_id=current_user.id,
file_name=filename,
generation_date=current_date,
type=Export.types['CSV'],
format=Export.formats['STATISTICS'])
db.session.add(export)
db.session.commit()
return export
def get_csv_solution_export(solutions: List[Solution],
current_user: User) -> Export:
current_date = get_current_date()
filename = ('rozwiazaniaCSV' + get_formatted_date(current_date) +
'.csv').replace(" ", "_")
with open(os.path.join(current_user.get_directory(), filename),
'w',
newline='') as csv_file:
csv_writer = csv.writer(csv_file,
delimiter='|',
quoting=csv.QUOTE_MINIMAL)
for solution in solutions:
csv_writer.writerow([solution.author.university_id] +
[solution.get_course().name] +
[solution.get_lesson().name] +
[solution.exercise.name] +
[solution.get_str_send_date()] +
[solution.points] + [solution.status])
export = Export(user_id=current_user.id,
file_name=filename,
generation_date=current_date,
type=Export.types['CSV'],
format=Export.formats['SOLUTION'])
db.session.add(export)
db.session.commit()
return export
def get_pdf_statistics_export(statistics_info,
current_user: Teacher) -> Export:
current_date = get_current_date()
filename = ('statystykiPDF' + get_formatted_date(current_date) +
'.pdf').replace(" ", "_")
global_filename = os.path.join(current_user.get_directory(), filename)
create_statistic_pdf(statistics_info, global_filename)
export = Export(user_id=current_user.id,
file_name=filename,
generation_date=current_date,
type=Export.types['PDF'],
format=Export.formats['STATISTICS'])
db.session.add(export)
db.session.commit()
return export
def get_pdf_solution_export(solutions: List[Solution],
current_user: User) -> Export:
current_date = get_current_date()
filename = ('rozwiazaniaPDF' + get_formatted_date(current_date) +
'.pdf').replace(" ", "_")
global_filename = os.path.join(current_user.get_directory(), filename)
create_solutions_pdf(solutions, global_filename)
export = Export(user_id=current_user.id,
file_name=filename,
generation_date=current_date,
type=Export.types['PDF'],
format=Export.formats['SOLUTION'])
db.session.add(export)
db.session.commit()
return export
def get_str_login_date(self):
return get_formatted_date(self.login_date)
def get_str_generation_date(self):
return get_formatted_date(self.generation_date)
def get_str_send_date(self):
return get_formatted_date(self.send_date)