Octopus-updates

An update mechanism for the Octopus

Project goal

Your goal is to implement a mechanism for transmitting a database table update to one or more web clients at the same time.

The chain should look like this:

MySQL db table is updated ➜ a trigger is activated ➜ python script is launched➜ an SSE is sent ➜ the SSE is received be the web clients ➜ some control is updated

Implementation tasks: (Mark completed)

• Set up a mysql database - Local (with MySQL community edition) or remote on some host (Heroku/pythonanywhere)
• Create some simple db table
• Set up a simple web sever with the FLASK python framework - Local or remote
• Server sends a simple HTML with a table representing the table you created
• Whenever the db table is updated the mechanism will transmit the changes to the HTML table

Requirements:

• Python
• Flask framework
• MySQL db
• SSE (Server Sent Events)
• Transmitted data format will be JSON