import { sql } from "drizzle-orm";
import { clientSchema } from "~/server/schemas/clientSchema";
import { projectSchema } from "~/server/schemas/projectSchema";
import { drizzle } from "~/server/services/drizzle";
import { eq } from "drizzle-orm/expressions";
export default defineEventHandler(async () => {
const projects = await drizzle
.select({
id: projectSchema.id,
name: projectSchema.name,
tariff: projectSchema.tariff,
client: {
id: clientSchema.id,
name: clientSchema.name,
},
})
.from(projectSchema)
.leftJoin(clientSchema, eq(clientSchema.id, projectSchema.clientId))
.where(sql`${projectSchema.deletedAt} IS NULL`);
return projects;
});
import { sql } from "drizzle-orm";
import { clientSchema } from "~/server/schemas/clientSchema";
import { projectSchema } from "~/server/schemas/projectSchema";
import { drizzle } from "~/server/services/drizzle";
import { eq } from "drizzle-orm/expressions";
export default defineEventHandler(async () => {
const projects = await drizzle
.select({
id: projectSchema.id,
name: projectSchema.name,
tariff: projectSchema.tariff,
client: {
id: clientSchema.id,
name: clientSchema.name,
},
})
.from(projectSchema)
.leftJoin(clientSchema, eq(clientSchema.id, projectSchema.clientId))
.where(sql`${projectSchema.deletedAt} IS NULL`);
return projects;
});