City城市創(chuàng)建失敗問題
def?create_city(db:?Session,?city:?schemas.CreateCity):
????db_city?=?models.City(**city.dict())
????print("*"?*?50)
????print("start")
????print(db_city)
????db.add(db_city)
????print("add")
????db.commit()
????print("commit")
????db.refresh(db_city)
????print("refresh")
????print(db_city)
????print("end")
????print("*"?*?50)
????return?db_city經(jīng)常會出現(xiàn)卡在commit不動的問題
**************************************************startNone:string_11111add2021-06-24?19:21:35,499?INFO?sqlalchemy.engine.Engine?INSERT?INTO?city?(province,?country,?country_code,?country_population)?VALUES?(?,??,??,??)2021-06-24?19:21:35,500?INFO?sqlalchemy.engine.Engine?[generated?in?0.00055s]?('11111',?'string',?'string',?0)2021-06-24?19:21:35,556?INFO?sqlalchemy.engine.Engine?COMMITWARNING:??WatchGodReload?detected?file?change?in?'['E:\\MyCode\\Python\\FastAPITest\\coronavirus.sqlite3-journal']'.?Reloading...WARNING:??WatchGodReload?detected?file?change?in?'['E:\\MyCode\\Python\\FastAPITest\\coronavirus.sqlite3-journal']'.?Reloading...2021-06-24?19:21:40,088?INFO?sqlalchemy.engine.Engine?BEGIN?(implicit)2021-06-24?19:21:40,088?INFO?sqlalchemy.engine.Engine?PRAGMA?main.table_info("city")2021-06-24?19:21:40,088?INFO?sqlalchemy.engine.Engine?[raw?sql]?()2021-06-24?19:21:40,095?INFO?sqlalchemy.engine.Engine?PRAGMA?main.table_info("data")2021-06-24?19:21:40,095?INFO?sqlalchemy.engine.Engine?[raw?sql]?()2021-06-24?19:21:40,099?INFO?sqlalchemy.engine.Engine?COMMITINFO:?????Started?server?process?[12736]INFO:?????Waiting?for?application?startup.INFO:?????Application?startup?complete.
2021-10-04
可以貼一下 database.py, models - > City 類, schema -> CreatedCity 類, curd -> create_city 函數(shù)
這四個部分的代碼, 感覺可能是哪個環(huán)節(jié)沒有對上. 另外 sqlalchemy 版本是? 我這里比較新的 1.14 版本和教程里的一些操作不兼容