Seed for user_wallets table 🌱

[diegoTech14]

Objective

Create a comprehensive seed script for the user_walltes table with realistic test data.

Requirements

• Generate seed data that covers various scenarios
• Reference existing users

Implementation Checklist

• Write SQL seed script
• Verify foreign key constraints
• Ensure data diversity
• Test seed script for consistency

Considerations

1. Use uuid_generate_v4() for ID generation
2. Reference existing users ID
3. Populate all relevant columns

SQL Table

user_wallets (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    user_id TEXT REFERENCES users(id) ON DELETE CASCADE,
    wallet_address TEXT NOT NULL,
    chain_type TEXT NOT NULL,
    is_primary BOOLEAN DEFAULT false,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    CONSTRAINT unique_wallet_address UNIQUE (wallet_address),
    CONSTRAINT valid_chain_type CHECK (chain_type IN ('ETH', 'STELLAR', 'BSC'))
);

Acceptance criteria

A complete SQL seed script for user_wallets table

[LuisChiej]

I'm open to working on this?

[mimisavage]

May I try my hand at this?

[gadyrcdz]

Let me try this one! Also, I'm a member of the community of Dojo Coding

[abdegenius]

Can I work on this, please?

[ikemHood]

May I take care of this?
I am Ikem Peter, a software developer with 3+ years of experience, I would love to take care of this

EDT: 24hrs

[BrunoAmbricca]

I would like to work on this issue

[Jagadeeshftw]

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.

[coxmars]

Hi @diegoTech14, I'm a software developer with 2+ years of experience, proficient in backend technologies such as PostgreSQL, Supabase, Cairo, Java, and C#, as well as frontend with React, NextJS, and TypeScript. I am an active member of the Dojo Coding community and have contributed to projects like Cairo VM Go, Cairo VM TS, and Cairo Lints. Currently, I'm part of ByteBuildersLabs, working on on-chain games using the Dojo framework.

This is my approach for this issue:

• I will analyze the current project structure to ensure the seed script aligns with the database schema and follows any established patterns.
• I will generate diverse and realistic test data for the user_wallets table, covering different edge cases or scenarios.
• I'm going to implement the SQL seed script using uuid_generate_v4() for unique ID generation and referencing existing users IDs.
• Validate foreign key constraints and ensure adherence to constraints like unique_wallet_address and valid_chain_type.
• I'll test the seed script for consistency by running it in a local environment and verifying data integrity.

ET: 3 days

[aniruddhaaps]

To address this issue, I would create a SQL seed script for the user_wallets table using uuid_generate_v4() for IDs and referencing valid user IDs. Use it to generate diverse data with unique wallet addresses, different chain types, and realistic primary wallet configurations. Test constraints and ensure that the script is consistent before submission.

[Kachimercy1]

Can I contribute to this one?

[GideonBature]

I'd be happy to do this.

My name is Gideon Bature, a Software Engineer, I have experience working with JavaScript/TypeScript as well as working with SQL databases, writing robust SQL Queries. If given the opportunity, I will send my first PR within 48 hours.

Thank you!

[kallis312]

Could I take a shot at this?

[ShantelPeters]

Would love to tackle this!

[Amarjeet325]

Can I take care of this issue?

[Nityam573]

Can I handle this task?

[TheSQLguy]

I am new to open source.
To address this issue, I would create a SQL seed script for the user_wallets table using uuid_generate_v4() for IDs and referencing valid user IDs. Use it to generate diverse data with unique wallet addresses, different chain types, and realistic primary wallet configurations. Test constraints and ensure that the script is consistent before submission.

[Kom02]

Hi, I’m Kevin Obando Molina, a full-stack software developer with 2 years of experience. I have worked with languages such as Java, JavaScript, TypeScript, MySQL, C#, and Python. I’m very interested in working on and learning more about this topic.

[diegoTech14]

Hi @coxmars just assigned to you, don't hesitate if you have any question! 🚀