def get_db(): db = None try: db = SessionLocal() yield db finally: db.close()
is_active = Column(Boolean, default=True) items = relationship('Item', back_populates='owner') class Item(Base): __tablename__ = 'item' id = Column(Integer, primary_key=True) title = Column(String, index=True) description = Column(String, index=True) owner_id = Column(Integer, ForeignKey('user.id')) owner = relationship('User', back_populates='items') # %% Create All Base.metadata.create_all(engine) db = SessionLocal() # %% Create User db_user = User(email='lee3sang', password='******') db.add(db_user) db.commit() db.refresh(db_user) # %% Create Item db_item = Item(title='speaker', description='food market', owner_id=1) db.add(db_item) db.commit() db.refresh(db_item) # %% Get User # db.rollback()