| 1234567891011121314 |
- from sqlalchemy import Column, Integer, String, DateTime, create_engine
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy.orm import sessionmaker
- import datetime
- Base = declarative_base()
- class DeviceData(Base):
- __tablename__ = "device_data"
- id = Column(Integer, primary_key=True)
- dtu_id = Column(String)
- device_id = Column(String)
- status = Column(String)
- timestamp = Column(DateTime, default=datetime.datetime.utcnow)
|
