import sqlalchemy
from sqlalchemy.types import INTEGER, VARCHAR, DATETIME, TEXT
from sqlalchemy.ext.declarative import declarative_base

engine = sqlalchemy.create_engine('sqlite:///blog.db', echo=True)
# engine.execute('CREATE TABLE IF NOT EXISTS authors (id integer primary key, name varchar(20) unique not null)')
# engine.execute('INSERT INTO authors (name) VALUES ("megaadmin")')
# d = engine.execute('SELECT * FROM authors')
# print(d.fetchall())

Base = declarative_base(bind=engine)

class Author(Base):
    __tablename__ = 'authors'

    id = sqlalchemy.Column(INTEGER, primary_key=True)
    name = sqlalchemy.Column(VARCHAR(20), unique=True, nullable=False)
    updated_on = sqlalchemy.Column(DATETIME, nullable=False)

class Post(Base):
    __tablename__ = 'posts'

    id = sqlalchemy.Column(INTEGER, primary_key=True)
    title = sqlalchemy.Column(VARCHAR(50), unique=True, nullable=False)
    content = sqlalchemy.Column(TEXT, unique=True, nullable=False)
    author_id = sqlalchemy.Column(INTEGER, nullable=False)
    published_on = sqlalchemy.Column(DATETIME, nullable=False)

Base.metadata.create_all()