from sqlalchemy import create_engine, MetaData, Table, Column, Integer, DateTime, Text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import datetime

engine = create_engine("postgresql+psycopg2://postgres:RANDOMPASSWORD@127.0.0.1:5432/analysis", echo=True)
Base = declarative_base(engine)


class POSTS(Base):
    """"""
    __tablename__ = 'posts'
    id = Column(Integer, primary_key=True) ##Just för att denna måste anges
    post_date = Column(DateTime)
    author = Column(Text)
    text = Column(Text


def loadSession():
    """"""
    metadata = Base.metadata
    Session = sessionmaker(bind=engine)
    session = Session()
    return session


if __name__ == "__main__":
    session = loadSession()
    res = session.query(POSTS).all()
    new_post = POSTS(author='Joe Black12', text='Hey guys its mEEEEEE!')
    session.add(new_post)
    session.commit()
    print(res[1].author)
    print(len(res))