Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Program Dashboard] New Column in DB #69

Closed
MohitNSamagra opened this issue Jul 1, 2024 · 5 comments
Closed

[Program Dashboard] New Column in DB #69

MohitNSamagra opened this issue Jul 1, 2024 · 5 comments
Assignees

Comments

@MohitNSamagra
Copy link

MohitNSamagra commented Jul 1, 2024

Problem: The program dashboard currently uses db tables which have a cumulative list of users who have joined discord, github, etc. The requirement is to also have a live user dashboard so there is no discrepancy of data.

Goal: A new column has to be added to the table which using which a new current users dashboard can be made. This can be done using the same script that Kanav had made earlier except now this can be run using a cron every day.

Additonally, SQL queries need to be changed to remove the 6 month decay clauses - to be scoped by PM and done by PT

@MohitNSamagra MohitNSamagra changed the title [Program Dashboard] [Program Dashboard] New Column Jul 1, 2024
@MohitNSamagra MohitNSamagra changed the title [Program Dashboard] New Column [Program Dashboard] New Column in DB Jul 1, 2024
@karntrehan
Copy link
Contributor

KDwevedi added a commit that referenced this issue Jul 19, 2024
[Feature] Mark users as inactive instead of deleting them while syncing discord to database via the bot
@MohitNSamagra
Copy link
Author

MohitNSamagra commented Jul 22, 2024

!updateServerData to be sent to c4gt discord bot to update column
@MohitNSamagra to test and close

@MohitNSamagra
Copy link
Author

  • Tested - discrepancy between users on discord and in supabase

@MohitNSamagra
Copy link
Author

@karntrehan to update

@karntrehan
Copy link
Contributor

Numbers are matching now.

Image

Image

Discord is showing 2 members less. But bot is giving same numbers

Image

I have also added some comments to the bot itself. It will tell you what it is processing.

Image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants