| Server IP : 185.11.201.71 / Your IP : 192.168.7.18 Web Server : Apache/2.4.29 (Ubuntu) System : Linux tech-virtual-machine 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : tech ( 1000) PHP Version : 7.4.28 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /comunica/app_ojos_/app/ |
Upload File : |
"""
models.py
Description: SQLAlchemy ORM models for the database.
Last Updated: 2024-08-07
Version: 1.0.0
Copyright (c) 2024 Tech-Impulse, Gerard Lahuerta
License: MIT License (see LICENSE for more details)
"""
#################################################################################################################################
from sqlalchemy import Column, Integer, String, Float, ForeignKey, Date, Boolean
from sqlalchemy.orm import relationship
import sys
import os
sys.path.append(os.path.dirname(os.path.abspath(__file__)))
from database import Base
#################################################################################################################################
class Eye(Base):
__tablename__ = "eyes"
id = Column(Integer, primary_key=True, index=True)
eye = Column(Integer, index=False)
date = Column(Date, index=False)
mean_grade = Column(Integer, nullable=True)
mean_scale = Column(Integer, nullable=True)
mean_melanin_percentage = Column(Float, nullable=True)
profile_id = Column(Integer, ForeignKey('profiles.id'), nullable=False)
profile = relationship("Item", foreign_keys=[profile_id])
class Item(Base):
__tablename__ = "profiles"
id = Column(Integer, primary_key=True, index=True)
name = Column(String(50), index=True, nullable=False) # Especificar longitud
description = Column(String(100), nullable=True) # Especificar longitud
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True, index=True)
username = Column(String, unique=True, index=True)
hashed_password = Column(String)
admin = Column(Boolean, default=True)