search

manwar / theweeklychallenge

The Weekly Challenge - Perl & Raku. You do not have to be an expert. https://theweeklychallenge.org
Artistic License 2.0
11 stars 18 forks source link

Database initialization #143

Open manwar opened 4 months ago

manwar commented 4 months ago

This is core and critical work.

In this we are looking to pull data from JSON /Mardown files and populate the relevant tables.

For example, we have members.json and this populate the "users" table. https://github.com/manwar/perlweeklychallenge-club/blob/master/members.json

Similary we have guests.json and this would also populate the same "users" table with flag to identify it is guest. https://github.com/manwar/perlweeklychallenge-club/blob/master/guests.json

Also pull past challenges and populate the relevant table. It would need some clever data handling.

I am happy to discuss in details if you need further information.

baimamboukar commented 3 months ago

This is cool. I want to work on this too.... I would like to get assigned this @manwar 👋

baimamboukar commented 3 months ago

Do we already have the ERD or something similar for the MySQL database...?

What I have in mind is actually creating a MySQL database in my local setup, then write a Python script to parse the json data, extract and clean the information, and then populate the database.

Does it makes sense @manwar ?

manwar commented 3 months ago

@baimamboukar We have new task for ERD #148

I liked the idea but using Python for parsing would be difficult from the maintenance point of view. Ideally I want Perl script to do all the parsing and populating the database.

If you need any help I am always there to assist you.

baimamboukar commented 3 months ago

There we go 🚀. I will be using Perl then. 🙏

I would like to be assigned this task please @manwar

baimamboukar commented 3 months ago

Hello @manwar There is an update on this task. Kindly check https://github.com/ChallengeForge/TheWeeklyChallenge/pull/23