Refactor: Database Schema

[SocksTheWolf]

This requires tweaking the database to migrated to one that has better typing/formatting rules. Right now, it's kind of a mess, and even worse if we ever have to upgrade the server.

Look into ways to potentially make this easier to work with that can also build queries. There are a few python libraries that can help.

[SocksTheWolf]

Dropping original above comment. I was under the impression Railways pricing worked on the same system as Digital Ocean, and it does not. It’s actually potentially more expensive.

[SocksTheWolf]

I’m wondering if this ticket should be blocked on having the unit testing solidified first #19

[SocksTheWolf]

Look into sqlalchemy:

• https://docs.sqlalchemy.org/en/20/dialects/sqlite.html
• https://realpython.com/python-sqlite-sqlalchemy/#working-with-sqlalchemy-and-python-objects

[user4752]

Partially implemented conversion to sqlalchemy here: https://github.com/SocksTheWolf/AntiScamBot/compare/main...user4752:AntiScamBot:db-refactor

Just need to update Discord.py to accept the new data format being returned

Will make future pull request when complete

[SocksTheWolf]

@user4752 skimmed this so far, lots of progress here. Looking forward to reviewing the pr!