from sqlalchemy import Column, Integer,\
        DECIMAL, Text,\
        VARCHAR, TIMESTAMP, Date
from datetime import datetime
from app.database import  Base


class Printer_jobs(Base):
    __tablename__ = "printer_jobs"

    id = Column(Integer,
                   primary_key=True,
                   autoincrement=True,
                   unique=False)
    
    delivery_id = Column(Integer)
    date_added = Column(Date(), default=datetime.utcnow())
    date_completed = Column(Date(), default=datetime.utcnow())
    employee_id = Column(Integer)
    #0 = waiting
    #1 = file made..read to print
    #2 = printing
    #3 = printed
    #4 = error
    status = Column(Integer)