23 replies

How to write complex query with fragments

I'm trying to write this query with Ash

select DATE(inserted_at), round(avg(percentage), 2)
from coverage
where "owner" = 'coverbot-io' and "repo" = 'coverbot' and is_for_default_branch
group by 1
order by 1;

select DATE(inserted_at), round(avg(percentage), 2)
from coverage
where "owner" = 'coverbot-io' and "repo" = 'coverbot' and is_for_default_branch
group by 1
order by 1;

I've gotten this far but I'm getting an error about fragment/1 being undefined and also not sure how to implement the group by.

Coverage
  |> Ash.Query.filter(owner == ^owner and repo == ^repo and is_for_default_branch)
  |> Ash.Query.select([fragment("DATE(inserted_at)"), fragment("ROUND(AVG(percentage), 2)")])
  |> Ash.Query.sort([1])
  |> Coverbot.Api.read!()

Coverage
  |> Ash.Query.filter(owner == ^owner and repo == ^repo and is_for_default_branch)
  |> Ash.Query.select([fragment("DATE(inserted_at)"), fragment("ROUND(AVG(percentage), 2)")])
  |> Ash.Query.sort([1])
  |> Coverbot.Api.read!()

Ash Framework•3y ago•

23 replies

michaelst

How to write complex query with fragments

I'm trying to write this query with Ash

select DATE(inserted_at), round(avg(percentage), 2)
from coverage
where "owner" = 'coverbot-io' and "repo" = 'coverbot' and is_for_default_branch
group by 1
order by 1;

select DATE(inserted_at), round(avg(percentage), 2)
from coverage
where "owner" = 'coverbot-io' and "repo" = 'coverbot' and is_for_default_branch
group by 1
order by 1;

I've gotten this far but I'm getting an error about fragment/1 being undefined and also not sure how to implement the group by.

Coverage
  |> Ash.Query.filter(owner == ^owner and repo == ^repo and is_for_default_branch)
  |> Ash.Query.select([fragment("DATE(inserted_at)"), fragment("ROUND(AVG(percentage), 2)")])
  |> Ash.Query.sort([1])
  |> Coverbot.Api.read!()

Coverage
  |> Ash.Query.filter(owner == ^owner and repo == ^repo and is_for_default_branch)
  |> Ash.Query.select([fragment("DATE(inserted_at)"), fragment("ROUND(AVG(percentage), 2)")])
  |> Ash.Query.sort([1])
  |> Coverbot.Api.read!()

How to write complex query with fragments

Similar Threads

How to write complex query with fragments

Similar Threads

Similar Threads

Similar Threads