TODO.md

All Tasks

• SQL backing database:

  • structure:
    • Question: Index (INT NOT NULL PK), Leetcode (VARCHAR(2083)), Text Block (TEXT NOT NULL), Company (TEXT NOT NULL), Data Structure (TEXT), Last Date Asked (DATE)
    • Admin: Index (INT NOT NULL PK), User ID (VARCHAR(19))

• Commands:

  • Add Question: Add question to database
  • Remove Question: Remove from database
  • Force Question: force bot to push question to channel
  • Add Admin: add admin
  • Remove Adming: removes admin
  • List Questions: list questions by index and date
  • Re-open Connection: Re open connection to database server if closes

• Other:

  • Timer to know when to run question
  • Bot backend
    • Target channel
    • Communication with right people only
  • General SQL integration
  • Add SQL cache
  • Alter Dockerfile
    • include vim in base package (TODO: switch this to the psql base)
    • start psql automatically
    • add psql defaults in base package
    • go straight to vim .env
  • Change SQL
    • New Question model
    • Alter tests
    • Alter commands
    • Add leetcode link command
  • Un-screw the saving (the array in on_message is all kinds of messy inside)

Potential Order

1. Database Communication
2. Adding + Outputting Questions
3. Timer on Questions
4. Removing Questions from db
5. Caching
6. Improve SQL querying
7. [Really this is just running parallel] Security checks for users only adding valid inputs per role level.