Skip to content

Add MySQL Database for Storing Member Profiles and Data #5

@soni2261

Description

@soni2261

Description:

Add a MySQL database integration for storing user profile data. This will allow the BugTheDuck Discord bot to persist user profiles, including skills, portfolios, social media links, and previous work, across sessions. The database will ensure that user information is safely stored and retrievable upon request.

Acceptance Criteria:

  • Database Integration: Implement a MySQL database to store the profile data, including user's name, interests, biography, portfolio links and social media accounts
  • Profile Creation Command: The /create command saves the member's profile data into the MySQL database.
  • Profile Viewing: The /view and /view @username commands retrieve and display profile data from the database.
  • Profile Data Persistence: Profile data remains available after bot restarts, with no loss of information.
  • Error Handling: Ensure proper error messages are displayed if database connections fail or if user data cannot be saved or retrieved.

Risks:

  • Database Connection Issues: The bot might face issues connecting to the MySQL database if not configured correctly.
  • Data Loss or Corruption: Improper handling of database writes or queries might result in lost or corrupted profile data.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions