Tenant metadata missing from struct when retrieved inside Repo.transaction

[jessestimpson]

In second result, tenant metadata is missing

iex(42)> LiveSecret.Repo.get(LiveSecret.Secret, "DBtd7pJhjbBhhPF", prefix: tenant)
#LiveSecret.Secret<
  __meta__: #Ecto.Schema.Metadata<:loaded, #EctoFoundationDB.Tenant<
    id: "localhost",
    ref: #Reference<0.2260347373.649068545.57280>,
    ...
  >, "secrets">,
  id: "DBtd7pJhjbBhhPF",
  burned_at: nil,
  live?: true,
  expires_at: ~N[2025-03-02 01:17:11],
  inserted_at: ~N[2025-03-02 00:17:11],
  updated_at: ~N[2025-03-02 00:17:11],
  ...
>
iex(43)> LiveSecret.Repo.transaction(fn -> LiveSecret.Repo.get(LiveSecret.Secret, "DBtd7pJhjbBhhPF") end, prefix: tenant)
#LiveSecret.Secret<
  __meta__: #Ecto.Schema.Metadata<:loaded, "secrets">,
  id: "DBtd7pJhjbBhhPF",
  burned_at: nil,
  live?: true,
  expires_at: ~N[2025-03-02 01:17:11],
  inserted_at: ~N[2025-03-02 00:17:11],
  updated_at: ~N[2025-03-02 00:17:11],
  ...
>

[jessestimpson]

Current options (unless I can think of something better)

1. Require prefix: tenant on all calls to Repo. Cons: more burden on the developer, higher risk of accidental nested transactions
2. Attempt to traverse the output of Repo.transaction/2 and attach the prefix there. Cons: potentially expensive, complicated, and sensitive to bugs because the output can be any data structure.
3. Lobby for a new callback in Ecto that allows the adapter to attach metadata in the postprocessing step.