Initialize Backend Database Configuration and Environment

[Jeffrey0522]

Initialize NestJS Database Integration

• Name / Title: Initialize Backend Database Configuration and Environment
• Complexity: Medium
• Task Type: Backend
• Description: The backend already has TypeORM configured in app.module.ts. This task involves generating and running the database migrations for the new fields added in Task 03 (e.g., walletAddress in User). Also, ensure the local Docker/Postgres environment is fully documented in .env.example.
• Technical Requirement: Node.js, NestJS, TypeScript, TypeORM Migrations, PostgreSQL.
• Estimated time to deliver: 4 hours
• Acceptance criteria:
  • Database migrations are successfully generated and run without error.
  • The User and Course tables in the local Postgres DB reflect the new Web3-aware columns.
  • .env.example specifies the correct DB connection variables for a local Postgres instance.
• MUST DOs:
  • Use TypeORM CLI to generate the migration file (npm run typeorm migration:generate).
  • Do not use synchronize: true in production configuration.
  • Enforce strict typing on entity properties.
• References:
  • Repo: skillcert-backend-server
  • Files:
    • src/app.module.ts
    • src/users/entities/user.entity.ts
    • package.json

[gelluisaac]

I’m interested in tackling this! I have a strong background in smart contract development and full-stack systems, so I'm well-equipped to handle the requirements here. Could you please assign this to me?

[Opeyemi0001]

Hi, I would like to apply for this task, As a backend Developer, I have hands-on experience with NestJS, TypeORM migrations, and PostgreSQL-backed applications, including Web3-aware schema updates.