/
models.py
50 lines (44 loc) · 1.91 KB
/
models.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
39
40
41
42
43
44
45
46
47
48
49
50
from datetime import datetime
from werkzeug.security import generate_password_hash, check_password_hash
from flask_login import UserMixin
from . import db
from . import login
@login.user_loader
def load_user(id):
return CopyrightHolder.query.get(int(id))
class CopyrightHolder(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(128), index=True, unique=True)
legal_name = db.Column(db.String(128), index=True)
password_hash = db.Column(db.String(128))
email = db.Column(db.String(128), index=True, unique=True)
website = db.Column(db.String(256), index=True, unique=True)
collections = db.relationship('Collection', backref='copyright_holder', lazy='dynamic')
def __repr__(self):
return f'<CopyrightHolder {self.username} ("{self.legal_name}" <{self.email}>)>'
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def is_admin(self):
return self.id == 1
class Collection(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128), index=True)
description = db.Column(db.String(256))
slug = db.Column(db.String(128), index=True)
copyright_holder_id = db.Column(db.Integer, db.ForeignKey('copyright_holder.id'))
pieces = db.relationship('Piece', backref='collection', lazy='dynamic')
def __repr__(self):
return f'<Collection {self.name}>'
class Piece(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128), index=True)
slug = db.Column(db.String(128), index=True)
description = db.Column(db.String(256))
url = db.Column(db.String(256))
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
type = db.Column(db.String(10), index=True)
collection_id = db.Column(db.Integer, db.ForeignKey('collection.id'))
def __repr__(self):
return f'<Piece {self.name}>'