List Files | Just Commands | Repo | Logs

← back | Copy

export const getStuff = `
SELECT books.*
FROM books
JOIN menus
  ON json_extract(menus.books, '$[0]') = books.id;
`;

export async function getBookMenus(bookId: string, db: any) {
  const query = `
select * from menus where json_extract(books, '$[0]') = '${bookId}'
`;
  return (await db.query(query)).values;
}

export async function getMenuOffers(menuId: string, db: any) {
  const query = `
SELECT *
FROM offers
WHERE EXISTS (
    SELECT 1
    FROM json_each(menus)
    WHERE json_each.value = '${menuId}'
);
`;
  return (await db.query(query)).values;
}