| 13 | } |
| 14 | |
| 15 | export async function deleteProjects(projectIds: string[]) { |
| 16 | const projects = await db.project.findMany({ |
| 17 | where: { |
| 18 | id: { |
| 19 | in: projectIds, |
| 20 | }, |
| 21 | }, |
| 22 | }); |
| 23 | |
| 24 | if (projects.length === 0) { |
| 25 | return; |
| 26 | } |
| 27 | |
| 28 | for (const project of projects) { |
| 29 | await db.project.delete({ |
| 30 | where: { |
| 31 | id: project.id, |
| 32 | }, |
| 33 | }); |
| 34 | } |
| 35 | |
| 36 | return projects; |
| 37 | } |
| 38 | |
| 39 | export async function deleteFromClickhouse(projectIds: string[]) { |
| 40 | const where = `project_id IN (${projectIds.map((projectId) => sqlstring.escape(projectId)).join(',')})`; |