Files

40 lines
1.8 KiB
Python

from sqlalchemy import Column, Integer, String, ForeignKey, DateTime, JSON, Boolean
from sqlalchemy.orm import relationship
from datetime import datetime
from database import Base
class Device(Base):
__tablename__ = "devices"
id = Column(Integer, primary_key=True, index=True)
name = Column(String, nullable=False)
code = Column(String, nullable=False, unique=True)
device_address = Column(Integer, nullable=False)
device_type_id = Column(Integer, ForeignKey("device_types.id"), nullable=True)
interface_id = Column(Integer, ForeignKey("interfaces.id"), nullable=True)
enabled = Column(Boolean, nullable=False, default=True)
status = Column(JSON, nullable=True, default=dict)
last_update = Column(DateTime, nullable=True)
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
# 关系
device_type = relationship("DeviceType", back_populates="devices")
interface = relationship("Interface", back_populates="devices")
def to_dict(self):
return {
"id": self.id,
"name": self.name,
"code": self.code,
"device_address": self.device_address,
"device_type_id": self.device_type_id,
"interface_id": self.interface_id,
"enabled": self.enabled,
"status": self.status,
"last_update": self.last_update.isoformat() if self.last_update else None,
"created_at": self.created_at.isoformat(),
"updated_at": self.updated_at.isoformat(),
"device_type": self.device_type.to_dict() if self.device_type else None,
"interface": self.interface.to_dict() if self.interface else None
}