class DmcaHistory(db.Model):
__tablename__ = "dmca_history"
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
internal_user_id = db.Column('internal_user_id', db.Integer,
db.ForeignKey('user.id'))
date_posted = db.Column('date_posted',
db.DateTime,
default=datetime.utcnow)
offender_ip = db.Column('offender_ip', db.String)
offender_mac = db.Column('offender_mac', db.String)
action = db.Column('action', db.String)
classification = db.Column('classification', db.String)
case_id = db.Column('case_id', db.String)
evidence = db.deferred(db.Column('evidence', db.Text))
offender_userid = db.Column('offender_userid', db.String)
date_closed = db.Column('date_closed', db.DateTime)
comments = db.deferred(db.Column('comments', db.Text))
user = db.relationship('User', foreign_keys=internal_user_id)
def save(self):
db.session.add(self)
db.session.commit()
def __str__(self):
return f"DMCA_History({self.id}, {self.internal_user_id}, {self.date_posted}, {self.offender_ip}, {self.offender_mac}, " \
f"{self.action}, {self.classification}, {self.case_id}, {self.evidence}, " \
f"{self.offender_userid}, {self.date_closed}, {self.comments})"
class FoodList(db.Model):
__tablename__ = "food_list"
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
internal_user_id = db.Column('internal_user_id', db.Integer,
db.ForeignKey('user.id'))
restaurant = db.deferred(db.Column('restaurant', db.Text))
food_type = db.Column('food_type', db.String)
user = db.relationship('User', foreign_keys=internal_user_id)
def save(self):
db.session.add(self)
db.session.commit()
def __repr__(self):
return f"Food('{self.id}', '{self.internal_user_id}', '{self.restaurant}', '{self.food_type}')"
class Pastebin(db.Model):
__tablename__ = "pastebin"
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
internal_user_id = db.Column('internal_user_id', db.Integer,
db.ForeignKey('user.id'))
date = db.Column('date', db.DateTime, default=datetime.utcnow)
status = db.deferred(db.Column('status', db.Text))
comp_user = db.deferred(db.Column('comp_user', db.Text))
data = db.deferred(db.Column('data', db.Text))
user = db.relationship('User', foreign_keys=internal_user_id)
def save(self):
db.session.add(self)
db.session.commit()
def __repr__(self):
return f"Pastebin('{self.id}', '{self.date}', '{self.internal_user_id}', '{self.comp_users}')"