[dev-jenni-brain] Give Jenni an SQLite DB

[kaneda]

• Used persisting warnings for banned_words.py as the proof of concept
• If a database isn't present or the driver isn't available then the module will continue to only put warnings in memory, otherwise it persists them to the DB
• Tested to work across reloads!
• Database path can be set per config file and has a default set in bot.py

[kaneda]

@myano

[MAGICCC]

Or do a selection of none, sqlite and mysql. I prefer MySQL, because then I have almost every service I run, saved at one point and not somewhere across folders

[kaneda]

@MAGICCC I have no problem with that, we could make the DB engine / connect options another config option. For the sake of a starting point I'd say let's start with this and then add onto it in dev-mysql feature branch.

For MySQL we'd need to update the connect mechanism (to take auth and use mysql or mysql connector), the missing table method to look at information.schema instead of using pragma, and make a method for creating db con that maintains the context manager approach I took.

[MAGICCC]

@kaneda Yup, that's possible as well. Some plugins could get some database as well, like the uno one for the players <-> scores. Currently it's saved into some shady .txt

[kaneda]

@MAGICCC true that. I'd like to move everything that's saved into a .txt file into the brain over time. If we need more functionality than executing statements and ensuring tables exist I may turn the DB connection into a library for jenni to use.

[MAGICCC]

Sure, then I gonna wait for the dev-mysql branch :)

[kaneda]

@myano

[kaneda]

@myano

[kaneda]

@myano yanooooooooooo

[kaneda]

@myano yanooooooooooo