我有一个在我的数据库中生成数据的API路径,这个API路径只在我的Cron作业(job)集中在Vercel中调用.
然而,每次我构建项目时,数据库中都会显示新的数据.我相信这是因为NextJS的本质是预先执行一个终结点,以便它将在缓存中,但我如何防止在我的数据库中添加数据?
export const revalidate = 60 * 60 * 24 * 6; // every 6 days
export async function GET(request: Request) {
const url =
`${process.env.COINMARKETCAP_URL}/v1/cryptocurrency/listings/latest?limit=100` ??
"";
var options = {
headers: {
"X-CMC_PRO_API_KEY": process.env.COINMARKETCAP_API ?? "",
},
next: { revalidate: 60 * 60 * 24 * 6 },
};
const res = await fetch(url, options);
const data = await res.json();
const tokensList: Tokens[] =
data?.data?.map((token: any) => {
return {
name: token.name,
symbol: token.symbol,
priceAtDrawn: token.quote["USD"].price,
priceAtContest: 0,
category: "Top-100",
timeframe: getYearWeekString(),
};
}) ?? [];
const BTCBenchmark = tokensList
.filter((token) => token.symbol === "BTC")
.map((token) => ({ ...token, category: "BTC-benchmark" }));
if (tokensList?.length == 0) {
return NextResponse.json(
{ message: "Error on token list" },
{ status: 500 }
);
}
const selectedTokens = selectTokens(tokensList, 10);
return await addTokensDrawn([...selectedTokens, ...BTCBenchmark]);
}
async function addTokensDrawn(data: any) {
try {
await prisma.tokenDrawn.createMany({ data });
return NextResponse.json({ message: "Add Successfully" }, { status: 200 });
} catch (error) {
console.error("Request error", error);
return NextResponse.json({ message: "Error on add" }, { status: 500 });
}
}