imcompiling/agon
1
0
Fork 0
Code Issues 17 Pull Requests 4 Actions Packages Activity

Use database to track submissions #57

New Issue
Closed
opened 2023-03-07 14:14:41 -05:00 by imcompiling · 3 comments
imcompiling commented 2023-03-07 14:14:41 -05:00
Owner
Copy Link
Copy Source

Currently have submissions being tracked by local memory and also by embedding the data into the verification message. Should remove that and create a new table in the database that handles submission tracking. This way information is presented more cleanly and also can survive the bot restarting.

Currently have submissions being tracked by local memory and also by embedding the data into the verification message. Should remove that and create a new table in the database that handles submission tracking. This way information is presented more cleanly and also can survive the bot restarting.
imcompiling added the enhancement label 2023-03-07 14:14:41 -05:00
imcompiling added this to the Agon Development project 2023-03-07 14:14:41 -05:00
imcompiling commented 2023-03-29 16:52:31 -04:00
Author
Owner
Copy Link
Copy Source

Makes #11 easier to do.

Makes #11 easier to do.
imcompiling added a new dependency 2023-03-29 19:29:28 -04:00
#11 Submission feedback to user. Accepted or denied.
imcompiling added reference 57-submission-table 2023-03-29 20:30:50 -04:00
imcompiling commented 2023-03-29 20:38:47 -04:00
Author
Owner
Copy Link
Copy Source

Want columns for: submission message id, group id, category id, username, score, verification message id.

primary key is a combination of group id, category id, and username. this is to prevent a user from having more than 1 active submission per category.

The VMId is to be able to map the results to each database entry.

SMId is used to update the submission message after accept/deny.

Want columns for: submission message id, group id, category id, username, score, verification message id. primary key is a combination of group id, category id, and username. this is to prevent a user from having more than 1 active submission per category. The VMId is to be able to map the results to each database entry. SMId is used to update the submission message after accept/deny.
imcompiling commented 2025-02-20 17:05:12 -05:00
Author
Owner
Copy Link
Copy Source

Completed in #69

Completed in #69
Sign in to join this conversation.
57-submission-table
Branches Tags
Labels
Clear labels
bug
Something isn't working
 documentation
Improvements or additions to documentation
 duplicate
This issue or pull request already exists
 enhancement
New feature or request
 good first issue
Good for newcomers
 help wanted
Extra attention is needed
 invalid
This doesn't seem right
 question
Further information is requested
 wontfix
This will not be worked on
No labels enhancement
Milestone
No items
No Milestone
Assignees
Clear assignees
renovate-bot imcompiling
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Blocks
#11 Submission feedback to user. Accepted or denied.
imcompiling/agon
Reference: imcompiling/agon#57