API: Add pagination metadata to Integration module

[rajdip-b]

Description

Refer to #336

Scope of change

• keyshade/apps/api/src/integration/service/integration.service.ts

  Lines 227 to 306 in bc15ead

  	async getAllIntegrationsOfWorkspace(
  	user: User,
  	workspaceId: Workspace['id'],
  	page: number,
  	limit: number,
  	sort: string,
  	order: string,
  	search: string
  	) {
  	// Check if the user has READ authority over the workspace
  	await this.authorityCheckerService.checkAuthorityOverWorkspace({
  	userId: user.id,
  	entity: { id: workspaceId },
  	authority: Authority.READ_INTEGRATION,
  	prisma: this.prisma
  	})
  	// We need to return only those integrations that have the following properties:
  	// - belong to the workspace
  	// - does not belong to any project
  	// - does not belong to any project where the user does not have READ authority
  	// Get the projects the user has READ authority over
  	const membership = await this.prisma.workspaceMember.findUnique({
  	where: {
  	workspaceId_userId: {
  	userId: user.id,
  	workspaceId
  	}
  	}
  	})
  	const workspaceRoles = await this.prisma.workspaceRole.findMany({
  	where: {
  	workspaceId,
  	workspaceMembers: {
  	some: {
  	workspaceMemberId: membership.id
  	}
  	}
  	},
  	include: {
  	projects: {
  	include: {
  	project: true
  	}
  	}
  	}
  	})
  	const projectIds =
  	workspaceRoles
  	.map((role) => role.projects.map((p) => p.projectId))
  	.flat() || []
  	// Get all integrations in the workspace
  	const integrations = await this.prisma.integration.findMany({
  	where: {
  	name: {
  	contains: search
  	},
  	workspaceId,
  	OR: [
  	{
  	projectId: null
  	},
  	{
  	projectId: {
  	in: projectIds
  	}
  	}
  	]
  	},
  	skip: page * limit,
  	take: limit,
  	orderBy: {
  	[sort]: order
  	}
  	})
  	return integrations
  	}

[muntaxir4]

/attempt i am assigned the parent issue #336

[github-actions]

Assigned the issue to @muntaxir4!