search

PenguinCloud / WaddleBot-Core

MenialBot is a security engineer's run with Matterbridge based bot designed to route chat prompts to serverless scripts (Lambda / OpenWhisk)! It applies a common profile to a user and allows for points, reputation, etc. to follow that user everywhere! It also allows for community / team based events, currency, etc.
1 stars 0 forks source link

Database Manager #26

Open ArcherPTG opened 1 month ago

ArcherPTG commented 1 month ago

Utilize PyDAL from Web2Py

The bot will predominantly be designed for MariaDB Galera and Redis but should be able to use any PyDAL full supported DB.

thysw95 commented 1 month ago

Basic implementation of PyDAL has been implemented under the folder "WaddleBot-DB-Manager". The script allows the matterbdridge connection to accept commands from a user and do some basic functions with PyDAL, such as adding a user to a users table and creating a community through a command.

This is still WIP, but a starting point.

The folder includes its own README.md file with instructions to setup the script and get it running.

thysw95 commented 1 month ago

Implemented table creation in the DB manager for the following tables:

Community Members Community Modules Discord Twitch Identity (formerly users) Roles Marketplace

thysw95 commented 1 month ago

After some additional thought processing, i realized that i was building the basic functionality of Router module within the DB manager. The idea is to still keep the DB manager as its own module, so the next step is to recreate the DB manager as a Flask REST application.

thysw95 commented 1 month ago

The DB Manager has been completely reworked into a Flask REST API to allow for basic CRUD operations via API calls. This will make it more organized and allow external systems to communicate with it.

The original files of the DB manager will then be reworked into a new command manager component component of the waddlebot system to handle incoming commands and requests from matterbridge.