Missing Drizzle Client in Codebase of develop-postgres branch

[sancheet230]

Describe the bug
The codebase defines database schemas using Drizzle ORM, but it lacks a proper Drizzle client instance to interact with the database. This prevents the execution of queries, migrations, and other database operations.

To Reproduce
NA

Screenshots

Additional details
This issue affects the ability to run migrations and database queries. A fix should be implemented to ensure seamless ORM functionality.

Proposed Fix
Implement a Drizzle client instance for PostgreSQL and update Documentation

Potential internship candidates

Please read this if you are planning to apply for a Palisadoes Foundation internship

• Student Internship Programs talawa#359

[sancheet230]

@palisadoes This needs to be fixed ASAP cause many queries will fail due to absence of DRIZZLE CLIENT my new test cases for PR #3176 is failing multiple times due to the same. I can work on this

[Piyushk8]

Isn't it defined already inside the Graphql context ? might as well explain in detail as if it was not defined queries working in Api wouldn't work as expected right ?

[sancheet230]

@Piyushk8 i checked codebase it's not defined and if it's not defined than all drizzle orm queries will fail and drizzle migrations required a database connection which will fail as well and backend depends on database queries due to which API's will break due to failed requests

[palisadoes]

@xoldd PTAL

[PurnenduMIshra129th]

@palisadoes @sancheet230 please assign.

[dhanagopu]

@PurnenduMIshra129th Our policy is to assign no more than two issues to each contributor across all repositories. This way everyone gets a chance to participate in the projects. You have reached your limit, please wait until your existing issues are closed before requesting more issues. You could unassign yourself from one of the other issues too.

[sancheet230]

@palisadoes please assign sir

[bandhan-majumder]

It's already working fine. It interacts with the database properly.

[sancheet230]

@palisadoes Should I keep this issue open

[palisadoes]

Closing. There aren't reports of this failing.