| 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 : |
from sqlalchemy import Column, Integer, String, DateTime, ForeignKey, Float
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
from database import Base
from datetime import datetime
class Profile_2(Base):
__tablename__ = 'profiles_david' # Updated table name
id = Column(Integer, primary_key=True, index=True)
name = Column(String, index=True)
description = Column(String, index=True)
# Relationship to Eye_2 model
eyes = relationship("Eye_2", back_populates="profile")
class Eye_2(Base):
__tablename__ = 'eyes_david' # Updated table name
id = Column(Integer, primary_key=True, index=True)
eye = Column(Integer) # 0 for the first row, 1 for the second row
date = Column(String, server_default=datetime.now().strftime("%Y-%m-%d"))
mean_grade = Column(Integer, nullable=True)
mean_scale = Column(Integer, nullable=True)
mean_melanin_percentage = Column(Float, nullable=True)
# ForeignKey linking to Profile_2 table
profile_id = Column(Integer, ForeignKey('profiles_david.id'), nullable=False)
# Relationship back to Profile_2
profile = relationship("Profile_2", back_populates="eyes")