平平都是 joinedload - 仝款kāng-khuán，無仝bô kāng師傅sai-hū

直覺上應該都會覺得 from sqlalchemy.orm import joinedload 跟 from sqlalchemy.orm.strategy_options import joinedload 是一樣的東西吧！
前者應該是後者的語法糖，這樣就可以少打一些字

但昨天在重構 Allow generating human-in-the-loop links that can be redirected to the corresponding page and perform action #53907 並實作哲佑大大給我的 joinedload 建議時
就一切都炸掉了

  File "/opt/airflow/airflow-core/src/airflow/api_fastapi/core_api/services/public/hitl.py", line 59, in get_task_instnace
    query = query.options(joinedload(TI.hitl_detail))
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/strategy_options.py", line 1219, in __call__
    self.name = name = fn.__name__
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 334, in __getattr__
    util.raise_(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
AttributeError: Neither 'InstrumentedAttribute' object nor 'Comparator' object associated with TaskInstance.hitl_detail has an attribute '__name
__'. Did you mean: '__ne__'?

jotaro-nani

而且還不是很好除錯
我複製了其他段已經驗證過、可以跑的程式碼來執行

測試了半小時後才回去懷疑該不會是引入 joinedload 的地方出問題吧
還真的改回 from sqlalchemy.orm import joinedload 就沒事了

回去查了一下 Airflow 使用的 SQLAlchemy 1.4.54 的原始碼
sqlalchemy.orm.joinedload 跟 sqlalchemy.orm.strategy_options.joinedload 還真的有點微妙的不同

joinedload = strategy_options.joinedload._unbound_fn

mygo-it-is-but-it-is-not

至於 from sqlalchemy.orm.strategy_options import joinedload 是怎麼來的
這是 neovim 中的 LSP 建議的，然後又是來自 SQLAlchemy
應該不會這麼剛好有一樣的變數名稱吧，不會吧不會吧
所以我就隨意選了一個
仝款kāng-khuán，無仝bô kāng師傅sai-hū
（為了想正確的寫出這句話，還去查了一下芋圓字典，確實蠻好用的）

然而實際上它們到底差在哪，就不是這篇文章的重點了
畢竟我就只是想隨筆寫下踩到的 Gotcha

平平都是 joinedload
仝款kāng-khuán，無仝bô kāng師傅sai-hū

Wei Lee