Warning: This API is unstable and may change in the future. We will provide migration documentation and codemods, if needed, as this API stabilizes.

export async function eventManagementGetRecentTickets() {
    const sqlPool = await sql.connect(eventmgmt_config);
    const sqlRequest = new sql.Request(sqlPool);

    const sqlQuery = `SELECT TOP (300) * FROM [IAMEM].[dbo].[iamevents] WHERE [status] like '%Ticket%' Order by [eId] desc`;

    let queryResult = await sqlRequest.query(sqlQuery);
    await sqlPool.close();

    if (queryResult.recordset.length > 0) {
        return queryResult;
    }

    return null;
}


export default async function Page() {
    const tickets = await unstable_cache(eventManagementGetRecentTickets, [], { revalidate: 60, })()


    return (
        <div className="m-2 bg-paper rounded-md">
            <div className='p-2'>
                {tickets &&
                    <GenericTableV2 data={tickets} />
                }
            </div>
        </div>
    )
};

revalidate: The number of seconds after which the cache should be revalidated. Omit or pass false to cache indefinitely or until matching revalidateTag() or revalidatePath() methods are called.

React.cache(() => {
  /* cookie */
  return unstable_cache(
    () => {}
    [cookie]
  )();
});

// cached_functions.ts
const getData = async () => {
  const cookieList = cookies();
  return unstable_cache(
    () => function(),
    [cookieList.get("key")?.value]
  )();
}