Convert Codebase to Prisma ORM

[manascb1344]

Convert Codebase to Prisma ORM

• Description: The current codebase uses raw SQL queries, which can be error-prone and less maintainable. Converting to Prisma ORM would provide type safety, auto-completion, and easier database migrations.
• Solution:
  1. Install Prisma in the project.
  2. Define the database schema using Prisma's schema language.
  3. Generate the Prisma client.
  4. Replace existing database queries with Prisma client operations.
  5. Update the connection logic to use Prisma instead of the current pool.
• Benefits:
  • Improved type safety and auto-completion in IDE.
  • Easier database migrations and schema management.
  • More maintainable and readable database interaction code.
  • Potential performance improvements through Prisma's query optimization.
• Steps:
  1. Install Prisma: npm install prisma --save-dev
  2. Initialize Prisma: npx prisma init
  3. Define your schema in prisma/schema.prisma
  4. Generate Prisma Client: npx prisma generate
  5. Update database connection logic and queries in your codebase.
• Example Conversion: Before:

  const { rows } = await pool.query('SELECT * FROM Buyers WHERE Buyer_ID = $1', [buyerId]);

  After:

  const buyer = await prisma.buyer.findUnique({
  where: { Buyer_ID: buyerId }
  });

• Note: This conversion will require significant changes across the codebase, but will result in more robust and maintainable database interactions.