class BlockingLog(BaseTable):
__tablename__ = 'blocking_log'
id = db.Column(db.Integer, primary_key=True)
blacklist_id = db.Column(db.Integer, db.ForeignKey('blacklist.id'))
remote_addr = db.Column(db.String(255))
tests = db.Column(db.Integer)
success = db.Column(db.Integer)
class User(BaseTable):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
roles = relationship("Role",
secondary=user_role_association_table,
back_populates="users")
def set_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
def is_active(self):
return True
def is_authenticated(self):
return True
def is_anonymous(self):
return False
def get_id(self):
try:
if isinstance(self.id, str):
return self.id
elif isinstance(self.id, int):
return self.id
else:
return self.id
except AttributeError:
raise NotImplementedError('No `id` attribute - override `get_id`')
def __eq__(self, other):
"""
Checks the equality of two `UserMixin` objects using `get_id`.
"""
if isinstance(other, User):
return self.get_id() == other.get_id()
return NotImplemented
def __ne__(self, other):
"""
Checks the inequality of two `UserMixin` objects using `get_id`.
"""
equal = self.__eq__(other)
if equal is NotImplemented:
return NotImplemented
return not equal
if sys.version_info[0] != 2: # pragma: no cover
# Python 3 implicitly set __hash__ to None if we override __eq__
# We set it back to its default implementation
__hash__ = object.__hash__
class Role(BaseTable):
GUEST = 1
ADMIN = 2
CUSTOMER = 3
MAINTENANCE = 4
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), unique=True)
users = relationship("User",
secondary=user_role_association_table,
back_populates="roles")
def __repr__(self) -> str:
return self.name
class Pdf(BaseTable):
__tablename__ = 'pdf'
id = db.Column(db.Integer, primary_key=True)
sum = db.Column(db.String(64))
name = db.Column(db.Text)
signed = db.Column(db.Boolean)
ssl = db.Column(db.Boolean)
parsed = db.Column(db.Text)
size = db.Column(db.Integer)
title = db.Column(db.Text)
author = db.Column(db.Text)
creator = db.Column(db.Text)
format = db.Column(db.String(255))
pages = db.Column(db.Integer)
version = db.Column(db.Integer)
blacklist = relationship("Blacklist",
lazy="dynamic",
secondary=blacklist_pdf_association_table,
back_populates="pdfs")
class ApiLog(BaseTable):
__tablename__ = 'api_log'
id = db.Column(db.Integer, primary_key=True)
remote_addr = db.Column(db.String(255))
requests = db.Column(db.Integer)
date = db.Column(db.Date)
class Blacklist(BaseTable):
__tablename__ = 'blacklist'
id = db.Column(db.Integer, primary_key=True)
dns = db.Column(db.String(255), unique=True)
bank_account = db.Column(db.String(255))
thumbnail = db.Column(db.Boolean)
dns_date_published = db.Column(db.DateTime)
dns_date_removed = db.Column(db.DateTime)
bank_account_date_published = db.Column(db.DateTime)
bank_account_date_removed = db.Column(db.DateTime)
last_crawl = db.Column(db.DateTime)
note = db.Column(db.String(255))
redirects_to = db.Column(db.String(255), nullable=True)
a = db.Column(db.String(255), nullable=True)
aaaa = db.Column(db.String(255), nullable=True)
pdfs = relationship("Pdf",
order_by="Pdf.updated.desc()",
lazy="dynamic",
secondary=blacklist_pdf_association_table,
back_populates="blacklist")
class BaseTable(db.Model):
__abstract__ = True
updated = db.Column(db.DateTime,
default=func.now(),
onupdate=func.current_timestamp())
created = db.Column(db.DateTime, default=func.now())
__author__ = "Adam Schubert"
__date__ = "$26.7.2017 19:33:05$"
class BaseTable(db.Model):
__abstract__ = True
updated = db.Column(db.DateTime,
default=func.now(),
onupdate=func.current_timestamp())
created = db.Column(db.DateTime, default=func.now())
user_role_association_table = db.Table(
'user_role_association', BaseTable.metadata,
db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
db.Column('role_id', db.Integer, db.ForeignKey('role.id')))
blacklist_pdf_association_table = db.Table(
'blacklist_pdf_association', BaseTable.metadata,
db.Column('blacklist_id', db.Integer, db.ForeignKey('blacklist.id')),
db.Column('pdf_id', db.Integer, db.ForeignKey('pdf.id')))
class User(BaseTable):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
roles = relationship("Role",
secondary=user_role_association_table,