1. from sqlalchemy import create_engine, MetaData, Table, Column, Integer, DateTime, Text
2. from sqlalchemy.ext.declarative import declarative_base
3. from sqlalchemy.orm import sessionmaker
4. import datetime
5.  
6. engine = create_engine("postgresql+psycopg2://postgres:[email protected]:5432/analysis", echo=True)
7. Base = declarative_base(engine)
8.  
9.  
10. class POSTS(Base):
11.     """"""
12.     __tablename__ = 'posts'
13.     id = Column(Integer, primary_key=True) ##Just för att denna måste anges
14.     post_date = Column(DateTime)
15.     author = Column(Text)
16.     text = Column(Text
17.  
18.  
19. def loadSession():
20.     """"""
21.     metadata = Base.metadata
22.     Session = sessionmaker(bind=engine)
23.     session = Session()
24.     return session
25.  
26.  
27. if __name__ == "__main__":
28.     session = loadSession()
29.     res = session.query(POSTS).all()
30.     new_post = POSTS(author='Joe Black12', text='Hey guys its mEEEEEE!')
31.     session.add(new_post)
32.     session.commit()
33.     print(res[1].author)
34.     print(len(res))