-
Notifications
You must be signed in to change notification settings - Fork 0
/
submission.py
38 lines (29 loc) · 1.02 KB
/
submission.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
from db import db
import datetime
from .team import Team
from .question import Question
class Submission(db.Model):
__tablename__ = 'Submissions'
id = db.Column(db.Integer, primary_key=True)
team_id = db.Column(db.Integer, db.ForeignKey(Team.id))
question_id = db.Column(db.Integer, db.ForeignKey(Question.id))
timestamp = db.Column(db.DateTime(), default=datetime.datetime.now)
team = db.relationship('Team')
question = db.relationship('Question')
def __init__(self, team_id, question_id):
self.team_id = team_id
self.question_id = question_id
def __repr__(self):
return f'({self.timestamp.strftime("%d/%m %H:%M")}): {self.team} -> {self.question}'
@classmethod
def get(cls, **kwargs):
if kwargs:
return cls.query.filter_by(**kwargs).first()
else:
return cls.query.all()
def save(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()