4 replies

get_path in expressions

Postgres

Hi,

I am using AshTranslate and need a calculation for a translated field because I need to sort on it. The sort needs to default to the base value if no locale is given or a translation is missing.

So far I tried this expression but it returns a strange error

if is_nil(^arg(:locale)) or is_nil(get_path(translations, [^arg(:locale), ^field])) do
   ^ref(field)
else
   type(get_path(translations, [^arg(:locale), ^field]), :string)
end

if is_nil(^arg(:locale)) or is_nil(get_path(translations, [^arg(:locale), ^field])) do
   ^ref(field)
else
   type(get_path(translations, [^arg(:locale), ^field]), :string)
end

Unknown Error

* ** (CaseClauseError) no case clause matching: {:bracket, [:fi], Eravuokraamo.Inventory.Product.Translations.Fields, [on_update: :update_on_match]}
(ash_sql 0.4.2) lib/expr.ex:3058: AshSql.Expr.split_at_paths/4
(ash_sql 0.4.2) lib/expr.ex:554: AshSql.Expr.default_dynamic_expr/6
(ash_sql 0.4.2) lib/expr.ex:2065: AshSql.Expr.default_dynamic_expr/6

If I just use

get_path(translations, ^arg(:locale))

get_path(translations, ^arg(:locale))

it returns the correct translations map with the right keys "{"name": "Teltta", "slug": "teltta", "description": null}".

I managed to get it to work with

    expr(
      if is_nil(fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)) do
        ^ref(field)
      else
        fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)
      end
    )

    expr(
      if is_nil(fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)) do
        ^ref(field)
      else
        fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)
      end
    )

but I would like to understand what is going on with get_path and how to write this properly.

- Toni

Ash Framework•4w ago•

4 replies

tjtuom

get_path in expressions

Postgres

if is_nil(^arg(:locale)) or is_nil(get_path(translations, [^arg(:locale), ^field])) do
   ^ref(field)
else
   type(get_path(translations, [^arg(:locale), ^field]), :string)
end

if is_nil(^arg(:locale)) or is_nil(get_path(translations, [^arg(:locale), ^field])) do
   ^ref(field)
else
   type(get_path(translations, [^arg(:locale), ^field]), :string)
end

get_path(translations, ^arg(:locale))

get_path(translations, ^arg(:locale))

it returns the correct translations map with the right keys "{"name": "Teltta", "slug": "teltta", "description": null}".

I managed to get it to work with

    expr(
      if is_nil(fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)) do
        ^ref(field)
      else
        fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)
      end
    )

    expr(
      if is_nil(fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)) do
        ^ref(field)
      else
        fragment("((? -> ? ) ->> ?)", translations, ^arg(:locale), ^field)
      end
    )

but I would like to understand what is going on with get_path and how to write this properly.

- Toni

get_path in expressions

Similar Threads

get_path in expressions

Similar Threads

Similar Threads

Similar Threads