feat: Email subscription for certain keywords or item type

[NwinNwin]

Proposed Solution:

• Create a keywords saved search email system notification
• Keyword Searches Database

To do:

POST /items:

• Incoming data:

  • name,
  • description,
  • type

• Process Data:

  • Set of keywords = {name + description + type}

• Search Data:

  • Search through to return all array of emails the keywords that match keyword in set
  • Return [[Emails], [emails]]

• Returning Data:

  • Combine arrays → {Emails} - set of arrays

• Send emails:

  • Use AWS_SES sendEmail()

POST /searches (Adding keywords)

• Incoming data:

  • Keywords
  • Email

• Store in DB:

  • In Searches table:
    • Look up keyword, add email to array if keyword exist:
    • If email already in keyword, ignore
    • If keyword not in table, add keyword + add email to new array

DELETE /searches (removing keywords):

• Incoming data:

  • Keywords
  • Email

• Remove from DB:

  • In Searches table:
    • Look up keyword, if it exists, look for the corresponding email and remove it from the array
    • If keyword not in table ⇒ do nothing

GET /searches/:email

• Incoming data:

  • email

• Search in DB:

  • In Searches table:
    • For each keyword, for each array in keyword, if email in array:
    • Return Keyword
  • Store all the returned keywords in an array
  • Return array of keywords