from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, DateTime, Float

Base = declarative_base()
class Lag(Base):
    __tablename__ = 'lags'

    id = Column(Integer, primary_key=True)
    url = Column(String)
    start_time = Column(DateTime)
    duration_msec = Column(Float)
    status = Column(Integer)
    content_length = Column(Integer)

    def __init__(self, url, start_time, duration_msec, status, content_length=None):
        self.url = url
        self.start_time = start_time
        self.duration_msec = duration_msec
        self.status = status
        self.content_length = content_length

    def __repr__(self):
        return "<Lag(%r,%r,%r,%r,%r)>" % (self.url, self.start_time, self.duration_msec, self.status, self.content_length)