API: Add pagination metadata to Variable module

[rajdip-b]

Description

Refer to #336

Scope of change

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

  Lines 490 to 605 in bc15ead

  	async getAllVariablesOfProject(
  	user: User,
  	projectId: Project['id'],
  	page: number,
  	limit: number,
  	sort: string,
  	order: string,
  	search: string
  	) {
  	// Check if the user has the required authorities in the project
  	await this.authorityCheckerService.checkAuthorityOverProject({
  	userId: user.id,
  	entity: { id: projectId },
  	authority: Authority.READ_VARIABLE,
  	prisma: this.prisma
  	})
  	const variables = await this.prisma.variable.findMany({
  	where: {
  	projectId,
  	name: {
  	contains: search
  	}
  	},
  	include: {
  	lastUpdatedBy: {
  	select: {
  	id: true,
  	name: true
  	}
  	}
  	},
  	skip: page * limit,
  	take: limit,
  	orderBy: {
  	[sort]: order
  	}
  	})
  	const variablesWithEnvironmentalValues = new Map<
  	Variable['id'],
  	{
  	variable: Variable
  	values: {
  	environment: {
  	name: Environment['name']
  	id: Environment['id']
  	}
  	value: VariableVersion['value']
  	version: VariableVersion['version']
  	}[]
  	}
  	>()
  	// Find all the environments for this project
  	const environments = await this.prisma.environment.findMany({
  	where: {
  	projectId
  	}
  	})
  	const environmentIds = new Map(
  	environments.map((env) => [env.id, env.name])
  	)
  	for (const variable of variables) {
  	// Make a copy of the environment IDs
  	const envIds = new Map(environmentIds)
  	let iterations = envIds.size
  	// Find the latest version for each environment
  	while (iterations--) {
  	const latestVersion = await this.prisma.variableVersion.findFirst({
  	where: {
  	variableId: variable.id,
  	environmentId: {
  	in: Array.from(envIds.keys())
  	}
  	},
  	orderBy: {
  	version: 'desc'
  	}
  	})
  	if (!latestVersion) continue
  	if (variablesWithEnvironmentalValues.has(variable.id)) {
  	variablesWithEnvironmentalValues.get(variable.id).values.push({
  	environment: {
  	id: latestVersion.environmentId,
  	name: envIds.get(latestVersion.environmentId)
  	},
  	value: latestVersion.value,
  	version: latestVersion.version
  	})
  	} else {
  	variablesWithEnvironmentalValues.set(variable.id, {
  	variable,
  	values: [
  	{
  	environment: {
  	id: latestVersion.environmentId,
  	name: envIds.get(latestVersion.environmentId)
  	},
  	value: latestVersion.value,
  	version: latestVersion.version
  	}
  	]
  	})
  	}
  	envIds.delete(latestVersion.environmentId)
  	}
  	}
  	return Array.from(variablesWithEnvironmentalValues.values())
  	}

[muntaxir4]

/attempt i am assigned the parent issue #336

[github-actions]

Assigned the issue to @muntaxir4!