File size: 901 Bytes
b10d399 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | from __future__ import annotations
from sqlalchemy import Column, DateTime, Float, Integer, String
from sqlalchemy.orm import declarative_base
Base = declarative_base()
class Session(Base):
__tablename__ = "sessions"
session_key = Column(Integer, primary_key=True)
meeting_key = Column(Integer, index=True)
session_name = Column(String(64))
session_type = Column(String(32))
country_name = Column(String(64))
date_start = Column(DateTime(timezone=True))
date_end = Column(DateTime(timezone=True))
class CarData(Base):
__tablename__ = "car_data"
id = Column(Integer, primary_key=True, autoincrement=True)
session_key = Column(Integer, index=True)
driver_number = Column(Integer, index=True)
date = Column(DateTime(timezone=True))
speed = Column(Float)
throttle = Column(Float)
brake = Column(Float)
n_gear = Column(Integer)
|