Split World Location News out of World Locations
The WorldLocation model currently contains the data for two published pages: the World Location itself and the World Location News page.
This has led to some unusual code needing to be written specifically for the news page as publishing the WorldLocation model using PublishesToPublishingApi and Searchable will lead to only the World Location page being published.
By splitting the model into two parts, we will be able to remove this custom code and re-use existing methods for publishing the news page.
We are using raw SQL in the migrations as these tables are translatable, meaning Rails will return only some translations and not others if we refer to the model by it's name. Using a SELECT statement will ensure we get all translations.
⚠️ This repo is Continuously Deployed: make sure you follow the guidance ⚠️