code-stats/Lobby

[discord] <Nicd> ```elixir
@spec update_aliases(t()) :: :ok
def update_aliases(user) do
alias_map = Language.get_alias_map(Repo)
user_aliases = user.aliases |> Enum.reduce(%{}, &Map.put(&2, &1.source_id, &1.target_id))
combined_aliases = Map.merge(alias_map, user_aliases)
IO.inspect(combined_aliases)
{originals, targets} = combined_aliases |> Map.to_list() |> Enum.unzip()

query =
  from(x in XP,
    join:
      m in fragment(
        "select * from unnest(?::integer[], ?::integer[]) as m(original_language_id, language_id)",
        ^originals,
        ^targets
      ),
    on: m.original_language_id == x.original_language_id,
    join: p in Pulse,
    on: x.pulse_id == p.id,
    where: p.user_id == ^user.id and x.language_id != m.language_id,
    select: {p.user_id, x.id, m.original_language_id, x.language_id, m.language_id}
    # update: [set: [language_id: m.language_id]]
  )

IO.inspect(query |> Repo.all())

:ok

end
```