class Key(db.Model):
__tablename__ = 'keys'
uuid = db.Column(db.String(), primary_key=True)
did = db.Column(db.Integer, db.ForeignKey('domains.did'), nullable=False)
email = db.Column(db.String(),
db.ForeignKey('users.email'),
nullable=False)
def __repr__(self):
return '<uuid {}>'.format(self.uuid)
class Clap(db.Model):
__tablename__ = 'claps'
pid = db.Column(db.Integer, db.ForeignKey('pages.pid'), primary_key=True)
ip = db.Column(db.String(), primary_key=True)
num_claps = db.Column(db.Integer, default=1, nullable=False)
def __repr__(self):
return '<pid {} ip {}>'.format(self.pid, self.ip)
class PageView(db.Model):
__tablename__ = 'pageviews'
pvid = db.Column(db.Integer, primary_key=True)
pid = db.Column(db.Integer, db.ForeignKey('pages.pid'), nullable=False)
ip = db.Column(db.String(), nullable=False)
referrer = db.Column(db.String(), nullable=True)
time = db.Column(db.DateTime,
default=datetime.datetime.utcnow,
nullable=False)
class Page(db.Model):
__tablename__ = 'pages'
__table_args__ = (db.UniqueConstraint('did',
'path',
name='unique_path_and_did'), )
pid = db.Column(db.Integer, primary_key=True)
did = db.Column(db.Integer, db.ForeignKey('domains.did'), nullable=False)
path = db.Column(db.String(), nullable=False)
claps = db.relationship('Clap', backref='page', lazy='dynamic')
pageViews = db.relationship('PageView', backref='page', lazy='dynamic')
def __repr__(self):
return '<pid {}>'.format(self.pid)
class Domain(db.Model):
__tablename__ = 'domains'
__table_args__ = (db.UniqueConstraint('domain_name',
'email',
name='unique_email_and_domain'), )
did = db.Column(db.Integer, primary_key=True)
domain_name = db.Column(db.String(), nullable=False)
email = db.Column(db.String(),
db.ForeignKey('users.email'),
nullable=False)
pages = db.relationship('Page', backref='domain', lazy='dynamic')
keys = db.relationship('Key', backref='domain', lazy=True)
def __repr__(self):
return '<did {}>'.format(self.did)