API: Swap the testing db with SQLite

[rajdip-b]

Description

We want to swap out our Postgres database in docker compose file to SQLite. This will improve the E2E execution speed

keyshade/docker-compose-test.yml

Lines 3 to 14 in b29ac91

	db:
	image: postgres:13
	restart: always
	container_name: integration-tests-prisma
	ports:
	- '5432:5432'
	environment:
	POSTGRES_USER: prisma
	POSTGRES_PASSWORD: prisma
	POSTGRES_DB: tests
	networks:
	- keyshade-test

Solution

• Remove the db service in docker-compose-test.yml
• Update schema.prisma to be compatible with Prisma SQLite

[vr-varad]

/attempt

[github-actions]

Assigned the issue to @vr-varad!

[MelloB1989]

/attempt

[github-actions]

Assigned the issue to @MelloB1989!

[rajdip-b]

Hey @MelloB1989! Unfortunately I can't assign this issue to you since @vr-varad has already been assigned to this. Only if @vr-varad thinks that he wants to drop his attempt, can I assign you.

[vr-varad]

Sorry I haven't made a pr but has worked on it. @rajdip-b thought would make in fosshack weekend.
Should I make a pr?

[rajdip-b]

No, hold on to that. Otherwise it won't be considered for the hackathon.