log_models.py

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


Base = declarative_base()


class LogFile(Base):
    __tablename__ = 'log_file'
    id = Column(Integer, primary_key=True)
    line_id = Column(String(64), nullable=False, unique=True)
    line = Column(Text, nullable=False)
    filename = Column(String(32), nullable=False)