Refactor: Move SQL Queries to a Separate File

manascb1344 / Online-Auction-System

The Online Auction System is a comprehensive platform designed to streamline online auctions for buyers, sellers, and admins. 🎉 With features like user management, item tracking, real-time bidding, and transaction processing, it creates a seamless auction experience. Built with React.js and Node.js, it offers a responsive interface and robust back

https://dbms-project-alpha.vercel.app

2 stars 9 forks source link

Refactor: Move SQL Queries to a Separate File #14

Open Zish303 opened 1 month ago

Zish303 commented 1 month ago

Description:

Currently, SQL queries are defined directly within the route files. To improve code modularity and maintainability, all SQL queries should be moved to a dedicated query file. This will separate query logic from business logic, making the code cleaner and easier to manage.

Tasks:

Create a dbQueries.js file to store SQL queries.
Move all SQL queries from the existing routes/controllers to the new queries file.
Use module.exports to export the queries and require/import them in the appropriate controllers.
Ensure that all affected routes/controllers work properly after the change.

Zish303 commented 1 month ago

Please 'hacktoberfest' label to this issue.

iamtehmooramjad commented 1 month ago

Hi, I want to work on this refactoring, Can you assign it to me?

manascb1344 commented 1 month ago

Make sure to add images of the newly updated API responses along with the PR

iamtehmooramjad commented 1 month ago

As we are moving queries to new file, do i need to attach screenshot of each API request with PR?

manascb1344 commented 1 month ago

Yeah you can do it in parts as both related issues are currently assigned to you

iamtehmooramjad commented 1 month ago

Yes, Sure.

Zish303 commented 4 weeks ago

@manascb1344 Can I work on this?

manascb1344 commented 4 weeks ago

@manascb1344 Can I work on this?

Yes sure!!