# coding: utf-8
from sqlalchemy import (
    BigInteger, Column, DateTime, Enum, Float, Integer, String, Text)

from fpcapture.connectors.mysql import FpcBaseModel


class TrackFp(FpcBaseModel):
    __tablename__ = 'track_fp'

    id = Column(Integer, primary_key=True)
    tuid = Column(Integer, nullable=False)
    upc = Column(BigInteger, nullable=False)
    sample_rate_hertz = Column(Integer, nullable=False)
    duration_seconds = Column(Integer, nullable=False)
    filename = Column(String(255), nullable=False)
    samples_decoded = Column(Integer, nullable=False)
    given_duration_seconds = Column(Integer, nullable=False)
    start_offset_seconds = Column(Integer, nullable=False)
    codegen_version = Column(String(10), nullable=False)
    codegen_time_seconds = Column(Float(10), nullable=False)
    decode_time_seconds = Column(Float(10), nullable=False)
    code_count = Column(Integer, nullable=False)
    fingerprint = Column(Text, nullable=False)
    datetime_added_utc = Column(DateTime, nullable=False)
    created_by = Column(String(100), nullable=False)
    datetime_updated_utc = Column(DateTime, nullable=False)
    updated_by = Column(String(100), nullable=False)
    file_upload_time_utc = Column(DateTime, nullable=False)
    correlation_id = Column(String(100), nullable=False)
    track_source = Column(Enum('backfill', 'direct_delivery', 'sweeper'))