def get_homework(self):
from models import Homework
homework = Homework.query(Homework.schedule_id == self.id).fetch(100)
if homework:
homework = [
work for work in homework if work.due_date >= date.today()
]
return homework if homework else []
def upload_homework(message):
chat_id = message.chat.id
homework_id = message.document.file_id
homework = Homework(file_telegram_id=homework_id,
deadline="",
group=message.current_group)
session.add(homework)
session.commit()
bot.send_message(chat_id, "Файл загружен!")
def homework_controller(id):
subject_id = request.values.get('subject_id')
title = request.values.get('title')
due_date = request.values.get('due_date')
description = request.values.get('description')
schedule_id = request.values.get('schedule_id')
if id:
homework = Homework.query(Homework.id==id).get()
if homework:
if request.method == 'GET':
if request.values.get('json'):
return json.dumps(dict(homework=homework.json))
return render_template('homework_view.html',homework = homework, title = "Homework List")
elif request.method == 'PUT':
homework = edit_parser(homework,request)
homework.put()
return 'Value Updated', 204
elif request.method == 'DELETE':
homework.key.delete()
return 'Item deleted', 204
else:
return 'Method Not Allowed'
else:
if request.method == 'GET':
homework_list = Homework.query().fetch(1000)
entries=None
if homework_list:
entries = [homework.json() for homework in homework_list]
if request.values.get('json'):
return json.dumps(dict(homework=entries))
return render_template('homework.html',homework_entries = entries, title = "Homework List")
elif request.method == 'POST':
homework = Homework()
homework = new_parser(homework,request)
homework.put()
url = '/homework/'
if request.values.get('json'):
url = '/homework/json=true'
return redirect(url)
else:
return abort(405)
def addHomework(classId=None):
if classId is None:
abort(404)
klass = Class.query.filter_by(id=classId).first_or_404()
if klass.user_id != g.user.id:
#Access Denied
abort(401)
form = HomeworkForm()
if form.validate_on_submit():
name = form.name.data
homework = Homework(name=name, class_id=classId)
db.session.add(homework)
db.session.commit()
flash('addHomework success')
return redirect(url_for('viewClass', classId=classId))
return render_template('addHomework.html', form=form, klass=klass)
def homework(id):
course = Course.query.get(id)
homeworks = course.homeworks.all()
form = NoticeForm()
#：如果当前登录的教师没有教授这门课程，则禁止访问
if current_user.id != course.teacher.id:
abort(403)
if form.validate_on_submit():
homework = Homework(title=form.title.data,
content=form.content.data,
course_id=id)
db.session.add(homework)
db.session.commit()
flash(u'发布作业成功！')
return redirect(url_for('homework', id=id))
return render_template('teacherHomework.html',
form=form,
course=course,
homeworks=homeworks)
def homework_controller(id):
subject_id = request.values.get('subject_id')
title = request.values.get('title')
due_date = request.values.get('due_date')
description = request.values.get('description')
schedule_id = request.values.get('schedule_id')
if id:
homework = Homework.query(Homework.id == id).get()
if homework:
if request.method == 'GET':
if request.values.get('json'):
return json.dumps(dict(homework=homework.json))
return render_template('homework_view.html',
homework=homework,
title="Homework List")
elif request.method == 'PUT':
homework = edit_parser(homework, request)
homework.put()
return 'Value Updated', 204
elif request.method == 'DELETE':
homework.key.delete()
return 'Item deleted', 204
else:
return 'Method Not Allowed'
else:
if request.method == 'GET':
homework_list = Homework.query().fetch(1000)
entries = None
if homework_list:
entries = [homework.json() for homework in homework_list]
if request.values.get('json'):
return json.dumps(dict(homework=entries))
return render_template('homework.html',
homework_entries=entries,
title="Homework List")
elif request.method == 'POST':
homework = Homework()
homework = new_parser(homework, request)
homework.put()
url = '/homework/'
if request.values.get('json'):
url = '/homework/json=true'
return redirect(url)
else:
return abort(405)
def count_csv_rows(filename):
with open(filename, "r", encoding="utf-8") as file:
file_reader = file.readlines()
return len(file_reader)
LEN_1 = count_csv_rows(filename)
with session_scope() as session:
some_teacher = Teacher(name="Ivan", last_name="Ivanov")
some_student = Student(name="Nikolay", last_name="Nikolaev")
exp_hw_1 = Homework(text="first expired homework",
deadline=-10,
teacher=some_teacher)
exp_hw_2 = Homework(text="another expired homework",
deadline=-1,
teacher=some_teacher)
exp_hw_3 = Homework(text="one more!", deadline=-100, teacher=some_teacher)
exp_hw_4 = Homework(text="and another one!",
deadline=0,
teacher=some_teacher)
exp_hw_5 = Homework(text="aah .... he we go again",
deadline=-777,
teacher=some_teacher)
hw_res_expired_1 = HomeworkResult(solution="one",
student=some_student,
homework=exp_hw_1)
def homework_edit_controller(id):
#this is the controller to edit model entries
homework_item = Homework.query(Homework.id == id).get()
return render_template('homework_edit.html',
homework_item=homework_item,
title="Edit Entries")
# A test for homework12 models
# For all Homework instances 'created' attr was created manually because it
# wont be generated automatically until instances aren't committed to a Session
from datetime import datetime
from models import Homework, HomeworkResult, Student, Teacher
opp_teacher = Teacher(name="Daniil", last_name="Shadrin")
advanced_python_teacher = Teacher(name="Aleksandr", last_name="Smetanin")
lazy_student = Student(name="Roman", last_name="Petrov")
good_student = Student(name="Lev", last_name="Sokolov")
oop_hw = Homework(text="Learn OOP",
deadline=1,
teacher=opp_teacher,
created=datetime.today())
docs_hw = Homework(text="Read docs",
deadline=5,
teacher=opp_teacher,
created=datetime.today())
expired_hw = Homework(
text="Make migrations",
deadline=0,
teacher=advanced_python_teacher,
created=datetime.today(),
)
result_1 = HomeworkResult(student=good_student,
homework=oop_hw,
solution="I have done this hw")
def homework_edit_controller(id):
#this is the controller to edit model entries
homework_item = Homework.query(Homework.id==id).get()
return render_template('homework_edit.html', homework_item = homework_item, title = "Edit Entries")
def get_homework(self): from models import Homework homework = Homework.query(Homework.schedule_id == self.id).fetch(100) if homework: homework = [work for work in homework if work.due_date >= date.today()] return homework if homework else []
