class TipoDoc(db.Model):
__tablename__ = 'tipo_doc'
id_tipo = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('tipo_doc_id_tipo_seq'::regclass)"))
tipo_documento = db.Column(db.String(50))
def __init__(self, id_tipo, documento):
self.id_tipo = id_tipo
self.tipo_documento = tipo_documento
class Email(db.Model):
__tablename__ = 'email'
id_email = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('email_id_email_seq'::regclass)"))
indirizzo = db.Column(db.String(50), unique=True, nullable=False)
def __init__(self, id_email, indirizzo):
self.id_email = id_email
self.indirizzo = indirizzo
class Persona(UserMixin, db.Model):
__tablename__ = 'persona'
__table_args__ = (db.CheckConstraint(
"(cf)::text ~ '^[A-Z]{6}\\d{2}[A-Z]\\d{2}[A-Z]\\d{3}[A-Z]$'::text"), )
id_persona = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('persona_id_persona_seq'::regclass)"))
nome = db.Column(db.String(50), nullable=False)
cognome = db.Column(db.String(50), nullable=False)
username = db.Column(db.String(50), nullable=False)
password = db.Column(db.String(50), nullable=False)
cf = db.Column(db.String(16), nullable=False, unique=True)
id_indirizzo = db.Column(db.Integer,
db.ForeignKey('indirizzo.id_indirizzo'),
nullable=False,
unique=True)
id_email = db.Column(db.Integer,
db.ForeignKey('email.id_email'),
nullable=False,
unique=True)
id_documento = db.Column(db.Integer,
db.ForeignKey('documento.id_documento'),
nullable=False,
unique=True)
id_telefono = db.Column(db.Integer,
db.ForeignKey('telefono.id_telefono'),
nullable=False,
unique=True)
luogo_nascita = db.Column(db.String(50), nullable=False)
data_nascita = db.Column(db.Date, nullable=False)
indirizzo = db.relationship('Indirizzo',
foreign_keys=[id_indirizzo],
uselist=False)
email = db.relationship('Email', foreign_keys=[id_email])
documento = db.relationship('Documento', foreign_keys=[id_documento])
telefono = db.relationship('Telefono', foreign_keys=[id_telefono])
def get_id(self):
return self.id_persona
def set_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
@login_manager.user_loader
def load_user(id_persona):
return Persona.query.get(int(id_persona))
class Telefono(db.Model):
__tablename__ = 'telefono'
id_telefono = db.Column(
db.Integer,
primary_key=True,
server_default=db.text(
"nextval('telefono_id_telefono_seq'::regclass)"))
numero = db.Column(db.String(11), unique=True, nullable=False)
def __init__(self, id_telefono, numero):
self.id_telefono = id_telefono
self.numero = numero
class Ricetta(db.Model):
__tablename__ = 'ricetta'
id_ricetta = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('ricetta_id_ricetta_seq'::regclass)"))
id_paziente = db.Column(db.Integer, db.ForeignKey('paziente.id_paziente'))
id_medico = db.Column(db.Integer, db.ForeignKey('medico.id_medico'))
campo = db.Column(db.String(300), nullable=False)
data_emissione = db.Column(db.Date, nullable=False)
medico = db.relationship('Medico')
paziente = db.relationship('Paziente')
class Indirizzo(db.Model):
__tablename__ = 'indirizzo'
id_indirizzo = db.Column(
db.Integer,
primary_key=True,
server_default=db.text(
"nextval('indirizzo_id_indirizzo_seq'::regclass)"))
cap = db.Column(db.Integer, nullable=False)
strada = db.Column(db.String(100), nullable=False)
def __init__(self, id_indirizzo, cap, strada):
self.id_indirizzo = id_indirizzo
self.cap = cap
self.strada = strada
class Documento(db.Model):
__tablename__ = 'documento'
id_documento = db.Column(
db.Integer,
primary_key=True,
server_default=db.text(
"nextval('documento_id_documento_seq'::regclass)"))
codice = db.Column(db.String(50), unique=True, nullable=False)
id_tipo = db.Column(db.Integer, db.ForeignKey('tipo_doc.id_tipo'))
tipo_doc = db.relationship('TipoDoc', foreign_keys=[id_tipo])
def __init__(self, id_documento, codice, id_tipo):
self.id_documento = id_documento
self.codice = codice
self.id_tipo = id_tipo
class StudLeg(db.Model):
__tablename__ = 'stud_leg'
id_studio = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('stud_leg_id_studio_seq'::regclass)"))
id_indirizzo = db.Column(db.Integer,
db.ForeignKey('indirizzo.id_indirizzo'))
orario_inizio = db.Column(db.Time, nullable=False)
orario_fine = db.Column(db.Time, nullable=False)
da_giorno = db.Column(db.String(20), nullable=False)
a_giorno = db.Column(db.String(20), nullable=False)
indirizzo = db.relationship('Indirizzo', foreign_keys=[id_indirizzo])
def __init__(self, id_studio, id_indirizzo, orario_inizio, orario_fine,
da_giorno, a_giorno):
self.id_studio = id_studio
self.id_indirizzo = id_indirizzo
self.orario_inizio = orario_inizio
self.orario_fine = orario_fine
self.da_giorno = da_giorno
self.a_giorno = a_giorno
class Persona(UserMixin, db.Model):
__tablename__ = 'persona'
__table_args__ = (db.CheckConstraint(
"(cf)::text ~ '^[A-Z]{6}\\d{2}[A-Z]\\d{2}[A-Z]\\d{3}[A-Z]$'::text"), )
id_persona = db.Column(
db.Integer,
primary_key=True,
server_default=db.text("nextval('persona_id_persona_seq'::regclass)"))
nome = db.Column(db.String(50), nullable=False)
cognome = db.Column(db.String(50), nullable=False)
username = db.Column(db.String(50), nullable=False)
password = db.Column(db.String(50), nullable=False)
cf = db.Column(db.String(16), nullable=False, unique=True)
id_indirizzo = db.Column(db.Integer,
db.ForeignKey('indirizzo.id_indirizzo'),
nullable=False,
unique=True)
id_email = db.Column(db.Integer,
db.ForeignKey('email.id_email'),
nullable=False,
unique=True)
id_documento = db.Column(db.Integer,
db.ForeignKey('documento.id_documento'),
nullable=False,
unique=True)
id_telefono = db.Column(db.Integer,
db.ForeignKey('telefono.id_telefono'),
nullable=False,
unique=True)
luogo_nascita = db.Column(db.String(50), nullable=False)
data_nascita = db.Column(db.Date, nullable=False)
indirizzo = db.relationship('Indirizzo',
foreign_keys=[id_indirizzo],
uselist=False)
email = db.relationship('Email', foreign_keys=[id_email])
documento = db.relationship('Documento', foreign_keys=[id_documento])
telefono = db.relationship('Telefono', foreign_keys=[id_telefono])
def get_id(self):
return self.id_persona
def set_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
'''
@login_manager.user_loader
def load_user(id_persona):
return Persona.query.get(int(id_persona))
'''
@login_manager.request_loader
def load_user_from_request(request):
token = request.headers.get('token')
if token is not "" or token is not None:
s = Serializer(app.config['SECRET_KEY'])
try:
data = s.loads(token)
except SignatureExpired:
return None # valid token, but expired
except BadSignature:
return None # invalid token
if data:
user = Persona.query.get(data['id'])
return user
return None
def generate_auth_token(self, expiration=600):
s = Serializer(app.config['SECRET_KEY'], expires_in=expiration)
return s.dumps({'id': self.id_persona})