models.py

from sqlalchemy import (
    Column,
    String,
    DateTime,
    Integer,
    Text,
    )
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()


class Log(Base):
    __tablename__ = 'log_file'
    id = Column(Integer, nullable=False, primary_key=True)
    tgl = Column(DateTime(timezone=True), nullable=False)
    line = Column(Text, nullable=False)
    # line_id berisi md5 dari line
    line_id = Column(String(32), nullable=False, unique=True)