Related to gitlab:fedora/websites-apps&5 and #11323.
The Fedora Badges team is working on a progressive rewrite of the existing Badges stack. We are tracking this work transparently in a series of GitLab epics. One of the next major steps is database-related work with the old system, so developers on the new system can use it as a reference implementation.
After we have optimized database schema available from #11323, next we need to coordinate a snapshot of the existing Badges database in line with that schema. This will form the basis of a test database that we can share with developers so that we can begin building out a new backend for Badges. Since we do intend to import data from the old system into the new system, it is important that we use the old data as a reference so we can make for a clean migration later down the line.
@t0xic0der could suggest on what the final deliverable for this task should be, whether that is a downloadable dump for offline development or hosted in a test environment that a developer could connect to from their local environment.
The next Fedora Badges roundtable meeting is on 21 June. It would be great if this could be done by then, so we can move forward with our next steps in our project timeline.
db dump is already available at https://infrastructure.fedoraproject.org/infra/db-dumps/tahrir.dump.xz
Does that give you what you need?
Metadata Update from @kevin: - Issue priority set to: Waiting on Assignee (was: Needs Review) - Issue tagged with: low-gain, low-trouble, ops
@kevin, this dump needs to be processed in the updated schema so that we can drop the unnecessary columns that we previously planned on making use of. The updated schema that I talk about has been mentioned at https://pagure.io/fedora-infrastructure/issue/11323.
But yeah, that data dump does give us a head start. How does it feel to shoot an arrow in less visibility and still do a bullseye? ;P
@kevin, correct me if I am mistaken but apparently, this dump does not seem to have the information about which user has what badges and when it was awarded to them. Do you have any more dumps related to Fedora Badges that I can take a look at?
Thats the only database I am aware of. I don't see it configured to talk to any others... so I would expect that information to be in that dump somewhere.
@kevin, alright - I will take a look at it again and report back.
@t0xic0der Is there any updates here?
Hello,
Please refer to https://pagure.io/fedora-infrastructure/issue/11323#comment-870730.
Thanks and regards, Akashdeep Dhar Red Hat Community Platform Engineering t0xic0der@fedoraproject.org akashdeep@redhat.com
On Thu, Aug 24, 2023 at 10:14=E2=80=AFPM Patrick Creech pagure@pagure.io = wrote:
pcreech17 added a new comment to an issue you are following: @t0xic0der Is there any updates here? To reply, visit the link below or just reply to this email https://pagure.io/fedora-infrastructure/issue/11324
pcreech17 added a new comment to an issue you are following: @t0xic0der Is there any updates here?
To reply, visit the link below or just reply to this email https://pagure.io/fedora-infrastructure/issue/11324
[backlog_refinement] Closing as fixed, as there isn't anything else requested from Fedora Infrastructure and the https://pagure.io/fedora-infrastructure/issue/11323 is already closed.
Feel free to reopen it if anything is needed from Fedora Infrastructure team.
Metadata Update from @zlopez: - Issue close_status updated to: Fixed - Issue status updated to: Closed (was: Open)
Log in to comment on this ticket.