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.

Sign up for GitHub

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

Jump to bottom

Seed script for bid_status_histories table🌱 #53

Open
4 tasks
DiegoB1911 opened this issue Dec 12, 2024 · 6 comments · May be fixed by #61
Open
4 tasks

Seed script for bid_status_histories table🌱 #53

DiegoB1911 opened this issue Dec 12, 2024 · 6 comments · May be fixed by #61
Assignees
@ikezuby2012
Labels
External contributors good first issue Good for newcomers Maintainer - Josué Soto ODHack11 Unpaid/Not Rewarded

Comments

@DiegoB1911
Copy link
Contributor

Objective

Create a comprehensive seed script for the bid_status_histories with realistic data.

Requirements

  • Link to existing bid requests

Implementation Checklist

  • Write SQL seed script
  • Include proper status
  • Add meaningful notes for each status change
  • Test data consistency and relationships

Considerations

  • Use uuid_generate_v4() for ID generation

SQL Table

CREATE TABLE bid_status_histories (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    bid_request_id UUID REFERENCES bid_requests(id) ON DELETE CASCADE,
    status TEXT NOT NULL,
    notes TEXT,
    changed_by TEXT REFERENCES users(id) ON DELETE SET NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

Acceptance Criteria

A complete SQL seed script for bid_status_histories table
@DiegoB1911 DiegoB1911 changed the title Create Seed Script for Bid Status History table🌱 Create Seed Script for bid_status_histories table🌱 Dec 12, 2024
@DiegoB1911 DiegoB1911 changed the title Create Seed Script for bid_status_histories table🌱 Create Seed script for bid_status_histories table🌱 Dec 12, 2024
@DiegoB1911 DiegoB1911 changed the title Create Seed script for bid_status_histories table🌱 Seed script for bid_status_histories table🌱 Dec 12, 2024
@ShantelPeters
Copy link

Can I take care of this issue?

@mimisavage
Copy link

Would love to tackle this!

@salazarsebas
Copy link

Hi safetrustcr,

My background

I'm Sebastian, software engineer 👨🏻‍💻 and part of the Dojo Coding ⛩️ community, and I would like to contribute to this issue. I have experience with different technologies and I have worked on some projects through OnlyDust and I like to contribute to help the projects.

How I plan on tackling this issue

To solve this issue, I will perform the following steps:

  • Write realistic data for the seed script.
  • Follow all the requirements described in the issue.
  • Write the SQL seed script.
  • Test the SQL seed script.
  • Perform all tests and send the pr waiting for feedback.

@Jagadeeshftw
Copy link

Hi,
I’d love to work on this issue as I have strong experience in building and managing APIs, handling server-side operations, and ensuring robust back-end performance.
Please assign this to me, and I’ll deliver a secure and high-quality PR within 12-24 hours.

@Nityam573
Copy link

Could I take a shot at this?

@ikezuby2012
Copy link

Hello, my name is nnubia nzube, I'm a full-stack developer with nearly 4 years of experience working with JavaScript, TypeScript, Express.js, C#, Cairo, as well as non-relational databases like MongoDB and relational databases such as MSSQL and Oracle.

For this issue, my approach is to:

Examine the schema/Model and write corresponding seed scripts.

my ETA is 2days

@ikezuby2012 ikezuby2012 linked a pull request Dec 17, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ikezuby2012 ikezuby2012

Labels
External contributors good first issue Good for newcomers Maintainer - Josué Soto ODHack11 Unpaid/Not Rewarded
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: added seed file for bid_status_histories ikezuby2012/safetrustcr-Backend
8 participants
@ikezuby2012 @Jagadeeshftw @sotoJ24 @Nityam573 @salazarsebas @ShantelPeters @DiegoB1911 @mimisavage