from sqlalchemy import create_engine, Column, Integer, String, select, Boolean
from sqlalchemy.orm import sessionmaker, declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    
    id = Column(Integer, primary_key=True)
    username = Column(String(40))
    email = Column(String(128))
    is_host = Column(Boolean, default=False)

# DB 연결
engine = create_engine('sqlite:///example.db')
Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

# 데이터 생성
new_user = User(username="hannal", email="hannal@puddingcamp.com")
session.add(new_user)
session.commit()

# 데이터 조회
stmt = select(User).where(User.id == 1)
result = session.execute(stmt)
user = result.scalar_one()

print(user.username, user.email)