from sqlalchemy import create_engine, Column, Integer, String from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker Base = declarative_base() engine = create_engine('sqlite:///example.db') Session = sessionmaker(bind=engine) session_1 = Session() session_2 = Session() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) age = Column(Integer) user_1 = session_1.query(User).get(1) user_2 = session_2.query(User).get(1)
session_1.merge(user_2)After the merge operation, user_1 and user_2 instances will share the same persistent state in session_1. The SQLAlchemy package library provides the sqlalchemy.orm.session module.