export async function getAllCompletedLessons(
userId: string,
): Promise<boolean[]> {
const result = await db.execute(sql`
SELECT
EXISTS (SELECT user FROM ${lesson1Table} WHERE user = ${userId}) AS lesson1,
EXISTS (SELECT user FROM ${lesson2Table} WHERE user = ${userId}) AS lesson2,
EXISTS (SELECT user FROM ${lesson3Table} WHERE user = ${userId}) AS lesson3,
EXISTS (SELECT user FROM ${lesson4Table} WHERE user = ${userId}) AS lesson4
`);
const completionStatus: boolean[] = [
result.rows[0].lesson1 as boolean,
result.rows[0].lesson2 as boolean,
result.rows[0].lesson3 as boolean,
result.rows[0].lesson4 as boolean
];
return completionStatus;
}
export async function getAllCompletedLessons(
userId: string,
): Promise<boolean[]> {
const result = await db.execute(sql`
SELECT
EXISTS (SELECT user FROM ${lesson1Table} WHERE user = ${userId}) AS lesson1,
EXISTS (SELECT user FROM ${lesson2Table} WHERE user = ${userId}) AS lesson2,
EXISTS (SELECT user FROM ${lesson3Table} WHERE user = ${userId}) AS lesson3,
EXISTS (SELECT user FROM ${lesson4Table} WHERE user = ${userId}) AS lesson4
`);
const completionStatus: boolean[] = [
result.rows[0].lesson1 as boolean,
result.rows[0].lesson2 as boolean,
result.rows[0].lesson3 as boolean,
result.rows[0].lesson4 as boolean
];
return completionStatus;
}