EPIC: GraphQL query for orgs by category

[eemshi]

Stories

Backend

• Every 30 minutes, Redis gets data from Airtable and caches it. The data comes in 5 different tables that reference each other's records by ID

• Right after Redis gets the data from Airtable, call a function to merge the 5 tables into one complete map that contains the full details of each organization, and save it in an atom. A single item (organization) in the map looks something like this:

{:name "Organization Name"
 :status "Active"
 :categories [...]
 :services [...]
 :type "..."
 :tags [...]
 :purpose-mission "..."
 :target-population "..."
 :area-served "..."
 :website "..."
 :contact-name "..."
 :email-address "..."
 :phone-number "..."
 :address-street "..."
 :address-city "..."
 :address-state "..."
 :address-zip-code "..."
}

• Write a GraphQL schema + resolver that takes a category parameter and returns organizations that have a category match

Frontend

• When a category link is clicked, make a query to the backend GraphQL server that returns only the organizations that belong to that category, and store them in the frontend app-db under that category key