from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Column, String, Integer, DateTime

from datetime import datetime


engine = create_engine('sqlite:////home/kosieh/db.sqlite')
Session = sessionmaker(bind = engine)

class Blog(Base := declarative_base()):
    __tablename__ = 'bb_blog'
    id: int = Column(Integer, primary_key=True)
    author_id: int = Column(Integer)
    blogdate: DateTime = Column(DateTime)
    content: str = Column(String)

    def __init__(self, author_id: int, content: str):
        self.author_id = author_id
        self.blogdate = datetime.now()
        self.content = content


session = Session()
blogs = session.query(Blog).all()

for blog in blogs:
    print('#' * 80)
    print(f"ID: {blog.id}\nAuthor ID: {blog.author_id}\n\n{blog.content}\n\nPublished: {blog.blogdate}")


new_blog: Blog = Blog(author_id=1, content='Some content goes here.')
session.add(new_blog)
session.commit()