psewar / Raidfelden.Discord.Bot

A Discord Bot built to add Crowd Sourced raids and pokemon to Monocle maps
MIT License
1 stars 1 forks source link

Raid submission does not update the LastModified column in the forts_sightings table #4

Closed bjmnbraun closed 6 years ago

bjmnbraun commented 6 years ago

Currently raid submission through the bot does not modify the LastModified column in the forts sightings table, therefore the map (say, PMSF) does not update properly.

On saving a Raids entity, the monocle database handler should also generate an event to update the LastModified column of the forts_sighting for the fort that the Raid corresponds to. Otherwise PMSF does not update the icon for the gym.

Arguably, this takes a bit of work to set up, in the current codebase.

bjmnbraun commented 6 years ago

Wrote up a patch that fixes this. It turns out that novabot notifications don't work properly either unless you do this because of the sql query used in novabot so fixing this was a priority for us.

I learned entity framework, yay!

patch.tar.gz

psewar commented 6 years ago

Perfect that was also an issue on my personal todo-list, thank you for fixing it :)