Function getEmptySubcategories

scripts/fill.ts:9–17

()

const fs = require("fs");

const getEmptySubcategories = async () => {
  const subcategoriesWithoutProducts = await db
    .select()
    .from(subcategories)
    .leftJoin(products, eq(products.subcategory_slug, subcategories.slug))
    .where(isNull(products.subcategory_slug));

  return subcategoriesWithoutProducts.map((s) => s.subcategories.slug);
};

function getRandomObjects(arr: any[], count: number) {
  const result = [];