search

bahnzumberg / zuugle-api

Public repositority for backend components of www.zuugle.at
https://www.zuugle.at
GNU General Public License v3.0
2 stars 3 forks source link

Store always all tours in PostgreSQL for permanent urls #118

Open martinheppner opened 2 weeks ago

martinheppner commented 2 weeks ago

When we want other websites to be able to link to Zuugle, we have to come up with a strategy, when the hike is not reachable at the moment. This can happen for example in winter, when the bus lines are reduced. In spring the tour will be reachable again.

In the meanwhile we have to provide the tour information - without information in the table fahrplan and show on the page instead of the itinerary a message, which informs (in all languages), that there is no connection at this point in time (from the given city).

martinheppner commented 2 weeks ago

On UAT there is a new table now, which holds old tours, which have no itinerary at the moment. If the called id can not be found in the tour table, we should look into tour_inactive and show the page with the hint, that this tour is not active at the moment. We can show when it was active last.

SELECT * FROM tour_inactive