search

manwar / theweeklychallenge

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

Create DBIC code #124

Open manwar opened 8 months ago

manwar commented 8 months ago

Assuming we have completed SQL for database creation.

Now is the time to create Perl code using DBIC to respect the table structure.

kemsguy7 commented 8 months ago

Hello @manwar, can you please assign this issue to me ? i'm working on it already

manwar commented 8 months ago

@kemsguy7 Do you know the table structure? How you started working already?

kemsguy7 commented 8 months ago

@manwar , i looked at the discussion from this issue : https://github.com/manwar/theweeklychallenge/issues/123

You mentioned something like a) users: user_id, user_type, user_password b) user_types: user_type_id, user_type_name c) languages: language_id, language_name d) user_contributions: user_id, language_id, week_id, count e) weeks: week_id, week_name

Do i go ahead with that or do you have any further information that could assist me?

manwar commented 8 months ago

@kemsguy7 it was just my initial thought. feel free to add anything you reckon is missing.

manwar commented 8 months ago

@kemsguy7 just realised profile_photo is missing?

kemsguy7 commented 8 months ago

@manwar okay, i've taken note of the profile_photo, I'll also work in sync with @NoubissiViany from issue issue #123 since this is more or less a continuation of that issue