import { executeQuery } from "~/lib/db";
import helper from "~/functions/helper";

import cache from "~/functions/cache";

async function getList() {
	const cachekey = "subGroupsList";
	// console.log('get subgroups list')

	let list = null;

	if (cache.has(cachekey)) {
		// console.log('  >> cached subgroups list')
		list = cache.get(cachekey);
	} else {
		// console.log('  >> fetch fresh subgroups list')
		const rows = await executeQuery({
			query: `
			select
				*
			from
				item_subgroups
			order by
				sortOrder,
				itemSubGroupName
		`,
		});

		list = helper.emptyOrRows(rows);

		cache.set(cachekey, list);
	}

	// const meta = { page };

	// console.log('  >> subgroups list length', list.length)

	return list;
	// return {
	// 	list,
	// 	meta,
	// }
}

export default {
	getList,
};