Job application tracker and AI-powered job search assistant. Helps job seekers manage their search journey with AI resume review, job matching, task logging, and application analytics, all while keeping your data private.
TypeScript ai-agentai-resume-analyzerapplication-trackerapplication-tracking-systematscareerjob-applicationjob-automationjob-huntingjob-searchjob-seeker-toolsjob-trackerjob-trackingjobsearchjobseekersmcpollamaresumeresume-reviewself-hosted
import { auth } from "@/auth";
import { NextRequest, NextResponse } from "next/server";
import prisma from "@/lib/db";
import { deleteResumeById } from "@/actions/profile.actions";
// Test-only endpoint used by e2e fixtures to tear down what a test created:
// job and resume rows, plus the Library items (job titles / companies /
// locations) their comboboxes persist independently. Disabled in production
// so it can never delete real data.
export async function POST(req: NextRequest) {
if (process.env.NODE_ENV === "production") {
return NextResponse.json({ error: "Not found" }, { status: 404 });
}
const session = await auth();
if (!session?.user?.id) {
return NextResponse.json({ error: "Not authenticated" }, { status: 401 });
}
const userId = session.user.id;
const {
jobIds = [],
resumes = [],
tasks = [],
questions = [],
titles = [],
companies = [],
locations = [],
activityTypes = [],
activities = [],
tags = [],
mcpTokens = [],
automations = [],
contacts = [],
contactRoles = [],
jobStageTypes = [],
}: {
jobIds?: string[];
resumes?: string[];
tasks?: string[];
questions?: string[];
titles?: string[];
companies?: string[];
locations?: string[];
activityTypes?: string[];
activities?: string[];
tags?: string[];
mcpTokens?: string[];
automations?: string[];
contacts?: string[];
contactRoles?: string[];
jobStageTypes?: string[];
} = await req.json();
// Delete automations before resumes: Automation.resumeId is a required FK, so
// a resume can't be removed while an automation references it. Deleting the
// automation cascades its runs and nulls discovered jobs' automationId.
if (automations.length > 0) {
await prisma.automation.deleteMany({
where: { name: { in: automations }, userId },
});
}
// Delete jobs, resumes and tasks first (they/their sections reference the
// Library items), so those items become unused and eligible for deletion.
for (const id of jobIds) {
await prisma.job.deleteMany({ where: { id, userId } });
}
for (const title of resumes) {
const rows = await prisma.resume.findMany({
where: { title, profile: { userId } },
select: { id: true },
});
// deleteResumeById cascades contact info / summary / experience /
// education / sections within a transaction.
for (const { id } of rows) {
await deleteResumeById(id);
}
}
for (const title of tasks) {
const rows = await prisma.task.findMany({
where: { title, userId },
select: { id: true },
});
for (const { id } of rows) {
// A task can't be deleted while an activity references it.
await prisma.activity.deleteMany({ where: { taskId: id, userId } });
await prisma.task.deleteMany({ where: { id, userId } });
}
}
// Delete standalone activities (created directly on the activities page, not
// through a task) by name before the Library teardown, so their activityType
// reference count drops to zero and the type becomes eligible for deletion.
// Starting an activity spawns a second running row with the same
// activityName, so matching on name removes both.
if (activities.length > 0) {
await prisma.activity.deleteMany({
where: { activityName: { in: activities }, userId },
});
}
// Delete questions before tags below — deleteTagsByName only removes a tag
// once its question/job/skill reference count is zero.
if (questions.length > 0) {
await prisma.question.deleteMany({
where: { question: { in: questions }, createdBy: userId },
});
}
// Delete contacts before the Library teardown: they reference companies,
// locations and roles. Their job links cascade with them.
if (contacts.length > 0) {
await prisma.contact.deleteMany({
where: { name: { in: contacts }, createdBy: userId },
});
}
// Sources are never created by the tests (they select the seeded "Indeed"),
// so they are intentionally not cleaned up here.
await deleteLibraryByName("jobTitle", titles, userId);
await deleteLibraryByName("company", companies, userId);
await deleteLibraryByName("location", locations, userId);
await deleteLibraryByName("activityType", activityTypes, userId);
await deleteLibraryByName("contactRole", contactRoles, userId);
// After the jobs above: a job's stages cascade with it, which is what frees
// a custom stage type. Seeded types are never registered by a test.
await deleteLibraryByName("jobStageType", jobStageTypes, userId);
await deleteTagsByName(tags, userId);
if (mcpTokens.length > 0) {
await prisma.mcpAccessToken.deleteMany({
where: { name: { in: mcpTokens }, userId },
});
}
return NextResponse.json({ success: true });
}
// Tags are shared across jobs/questions/skills (not a single ref model like
// the Library types above), so they get their own reference count + delete.
async function deleteTagsByName(names: string[], userId: string) {
for (const name of names) {
const value = name.trim().toLowerCase();
if (!value) continue;
const tag = await prisma.tag.findFirst({
where: { value, createdBy: userId },
select: {
id: true,
_count: { select: { jobs: true, questions: true, skills: true } },
},
});
if (!tag) continue;
const { jobs, questions, skills } = tag._count;
if (jobs + questions + skills > 0) continue;
await prisma.tag.delete({ where: { id: tag.id } });
}
}
type RefModel =
| "jobTitle"
| "company"
| "location"
| "activityType"
| "contactRole"
| "jobStageType";
// Count every place a Library row can still be referenced from, so we never
// delete one that another job or resume section still uses.
async function referenceCount(
model: RefModel,
refId: string,
): Promise<number> {
if (model === "jobTitle") {
return (
(await prisma.job.count({ where: { jobTitleId: refId } })) +
(await prisma.workExperience.count({ where: { jobTitleId: refId } }))
);
}
if (model === "company") {
return (
(await prisma.job.count({ where: { companyId: refId } })) +
(await prisma.workExperience.count({ where: { companyId: refId } })) +
(await prisma.contact.count({
where: { OR: [{ companyId: refId }, { workedAtCompanyId: refId }] },
}))
);
}
if (model === "activityType") {
return (
(await prisma.activity.count({ where: { activityTypeId: refId } })) +
(await prisma.task.count({ where: { activityTypeId: refId } }))
);
}
if (model === "contactRole") {
return (
(await prisma.jobContact.count({ where: { roleId: refId } })) +
(await prisma.contact.count({ where: { roleId: refId } }))
);
}
if (model === "jobStageType") {
return prisma.jobStage.count({ where: { stageTypeId: refId } });
}
return (
(await prisma.job.count({ where: { locationId: refId } })) +
(await prisma.workExperience.count({ where: { locationId: refId } })) +
(await prisma.education.count({ where: { locationId: refId } })) +
(await prisma.contact.count({ where: { locationId: refId } }))
);
}
// Delete each named Library row (matched the same way the create actions store
// it: value = label.trim().toLowerCase()), scoped to the user and only when
// nothing references it anymore.
async function deleteLibraryByName(
model: RefModel,
names: string[],
userId: string,
) {
for (const name of names) {
const value = name.trim().toLowerCase();
if (!value) continue;
const row = await (prisma[model] as any).findFirst({
where: { value, createdBy: userId },
select: { id: true },
});
if (!row) continue;
if ((await referenceCount(model, row.id)) > 0) continue;
await (prisma[model] as any).delete({ where: { id: row.id } });
}
}