I have a site relating to gas prices, which allows visitors to search for recent gas prices by zip code. The structure is already in place, but I need to change source of the data. Right now, the data is being shown from my DB, which is outdated. I have a new source, which is gas buddy, and need to utilize their feed. The current structure is basically this:
$zip = 123456
if record for $zip exists in DB
compare date of record with current date_time
if difference > $specified_time, update DB using feed, show result
if difference < $specified_time, show result from DB, no feed usage
if no record for $zip in DB
insert record in DB using feed data, show result
The job is basically to understand the gas buddy feed, pull data based on zip, convert as necessary to store in DB in current format and make sure all existing functionality remain functional (like the map function). Some cleanup of existing code may be necessary.
REQUIREMENTS:
-must have feedback
-must be knowledgeable about gas buddy feed
I need to make sure that this is even possible to do before getting started.