Bot state machine on Azure

[melvintzw]

Context:

Every user's interaction with a bot can be modeled by a finite state machine. A database is used to keep track of the bot's state everytime a user sends some input to the bot. The database is also used to store memory about datetimes and interval trees specific to each user and each event.

Mission:

Set up a DB that the bot can securely access and modify. Design and implement the state machine and DB.

• Set up a DB on Azure and get bot to connect to it. We can start by trying any random one first; just to get some experience connecting to a DB from a python script.
• Design state machine of user interactions with the bot
• Design DB based on state machine
• Implement Python code that transitions the bot's state (modifies the DB) based on user input.