sqlalchemy 中 flush()和commit()

# flush()和commit()的异同：：：
# flush和commit后都会在数据库中站一位id会后延
# 但flush后可以rollback(),commit()后回滚不生效

flush() 会将session中的数据刷到数据库中，使数据库主键自增；但不会写到磁盘里。当别的session查询时并不会查到flush的数据；插入数据时，session1 flush()一条, session2 commit()一条，session2插入的主键会跳过session1  flush()产生的主键；

# coding=utf8
import time
import traceback

from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker


engine = create_engine('mysql+pymysql://root:@127.0.0.1/db', echo=False)
Base = declarative_base()
Session = sessionmaker(bind=engine)

session1 = Session()
session2 = Session()

class Person(Base):
    __tablename__ = "PERSON"

    GUID = Column(Integer, primary_key=True, nullable=False)
    name = Column(String(64), default='')         # 姓名

    def __init__(self,
                 GUID,
                 name
                 ):
        self.GUID = GUID
        self.name = name

    def json_obj(self):
        obj = {
            "GUID": self.GUID,
            "name": self.name
        }
        return obj


obj = Person(None, 'ggg')
obj1 = Person(None, 'ggg1')
try:
    session1.add(obj)
    session1.flush()
    print('session1:', obj.GUID)
    time.sleep(1)
    all = session2.query(Person).all()
    print("len", len(all))
    session2.add(obj1)
    session2.flush()
    print('session2:', obj1.GUID)
    session2.commit()
except Exception as e:
    traceback.print_exc()
finally:
    print("------end-----")
    session1.close()
    session2.close()