kosieh
35 lines
1023 B
Python
35 lines
1023 B
Python
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() |