Saltar a contenido

app.models.connection

Modelo de base de datos para Perfiles de Conexión Oracle (sin columna de contraseña).

ConnectionProfile

Bases: Base

id = Column(Integer, primary_key=True, index=True) class-attribute instance-attribute

project_id = Column(Integer, ForeignKey('projects.id'), nullable=False) class-attribute instance-attribute

name = Column(String, index=True, nullable=False) class-attribute instance-attribute

engine = Column(String, default='ORACLE', nullable=False) class-attribute instance-attribute

host = Column(String, nullable=False) class-attribute instance-attribute

port = Column(Integer, default=1521, nullable=False) class-attribute instance-attribute

service_name = Column(String, nullable=False) class-attribute instance-attribute

username = Column(String, nullable=False) class-attribute instance-attribute

environment_type = Column(String, default='TEST', nullable=False) class-attribute instance-attribute

created_at = Column(DateTime(timezone=True), default=get_utc_now) class-attribute instance-attribute

updated_at = Column(DateTime(timezone=True), default=get_utc_now, onupdate=get_utc_now) class-attribute instance-attribute

project = relationship('Project', back_populates='connection_profiles') class-attribute instance-attribute

execution_histories = relationship('ExecutionHistory', back_populates='connection_profile', passive_deletes='all') class-attribute instance-attribute

get_utc_now()