Method: Valkyrie::Persistence::Postgres::QueryService#find_members_with_type_query

Defined in:

lib/valkyrie/persistence/postgres/query_service.rb

#find_members_with_type_query ⇒ String

Note:

this uses a CROSS JOIN for all combinations of member IDs with the IDs of their parents

Generate the SQL query for retrieving member resources in PostgreSQL using a

resource ID and resource type as arguments.

This also uses JSON functions in order to retrieve JSON property values

Returns:

• (String)

See Also:

• https://guides.rubyonrails.org/active_record_querying.html#array-conditions
• https://www.postgresql.org/docs/current/static/queries-table-expressions.html#QUERIES-FROM
• https://www.postgresql.org/docs/current/static/functions-json.html

# File 'lib/valkyrie/persistence/postgres/query_service.rb', line 165

def find_members_with_type_query
  <<-SQL
    SELECT member.* FROM orm_resources a,
    jsonb_array_elements(a.metadata->'member_ids') WITH ORDINALITY AS b(member, member_pos)
    JOIN orm_resources member ON (b.member->>'id')::#{id_type} = member.id WHERE a.id = ?
    AND member.internal_resource = ?
    ORDER BY b.member_pos
  SQL
end