国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

# 初始化數(shù)據(jù)庫連接:
engine = create_engine("xxxxx")
# 創(chuàng)建DBSession類型:
DBSession = sessionmaker(bind=engine)
session = DBSession()
# 測試沒有問題的數(shù)據(jù)
rows_ok = [
    {"name":"aaa","otherdata":"exist_col_aaa"},
    {"name":"bbb","otherdata":"exist_col"},
]
# 測試出問題的數(shù)據(jù)
rows = [
    {"name":"aaa"},
    {"name":"bbb","otherdata":"exist_col"},
]
# User中有name,otherdata字段
session.execute(User.__table__.insert(),rows)
session.commit()
session.close()

如果批次插入資料中所有字典的key一致,則資料能保存

只要List中字典缺少一個(gè)key,會導(dǎo)致整個(gè)列被忽略

真實(shí)的情況列數(shù)很多,而且缺失資料也很多.有沒有解決辦法,或者使用其它方法?

或?qū)?/p>

rows = [
    {"name":"aaa"},
    {"name":"aaa"},
    {"name":"aaa"},
    {"name":"aaa"},
    {"name":"bbb","otherdata":"exist_col",....},
]

轉(zhuǎn)化為

rows = [
    {"name":"aaa","otherdata":"",....},
    {"name":"aaa","otherdata":"",....},
    {"name":"aaa","otherdata":"",....},
    {"name":"aaa","otherdata":"",....},
    {"name":"bbb","otherdata":"exist_col",....},
]