db.py

from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String, ForeignKey, LargeBinary
from sqlalchemy.orm import relationship, sessionmaker, scoped_session
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_fulltext import FullText

with open('mysqlstring.txt', 'r') as f:
    engine = create_engine(f.read().strip(), pool_recycle=3600)

Base = declarative_base()


class Person(FullText, Base):
    __tablename__ = 'people'
    __fulltext_columns__ = ('name',)
    id = Column(Integer, primary_key=True)
    name = Column(String(300))

    sources = relationship("Source", back_populates='person',
                          cascade="all, delete, delete-orphan")
    quotes = relationship("Quote", back_populates='person',
                         cascade="all, delete, delete-orphan")

    def __repr__(self):
        return "<Person(name='{}')>".format(self.name)


class Source(FullText, Base):
    __tablename__ = 'sources'
    __fulltext_columns__ = ('source',)
    id = Column(Integer, primary_key=True)
    source = Column(String(5000))
    person_id = Column(Integer, ForeignKey('people.id'))

    person = relationship("Person", back_populates='sources')
    quotes = relationship("Quote", back_populates='source')

    def __repr__(self):
        if len(self.source)>50:
            return "<Source(source='{}')".format(self.source[:50])
        else:
            return "<Source(source='{}')".format(self.source)


class Quote(FullText, Base):
    __tablename__ = 'quotes'
    __fulltext_columns__ = ('quote',)
    id = Column(Integer, primary_key=True)
    quote = Column(String(20000))
    person_id = Column(Integer, ForeignKey('people.id'))
    source_id = Column(Integer, ForeignKey('sources.id'), nullable=True)

    person = relationship("Person", back_populates='quotes')
    source = relationship("Source", back_populates='quotes')

    def __repr__(self):
        if len(self.quote) > 50:
            return"<Quote(quote='{}')".format(self.quote[:50])
        else:
            return"<Quote(quote='{}')".format(self.quote)

class Keyword(Base):
    __tablename__ = 'keywords'
    id = Column(Integer, primary_key=True)
    quotes = Column(LargeBinary)

class QuoteVec(Base):
    __tablename__ = 'quotevecs'
    id = Column(Integer, primary_key=True)
    vec = Column(LargeBinary)



Session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=engine))