Handler to mark offers as expired.

[vikiival]

The task:

• You need to fetch offers whose expires lower or equal to current block number.
• Set their status as EXPIRED
• Save into DB

There are basically two options:

1. Do it on action of the NFT (LIST, ACCEPT_OFFER, SEND) - per particular NFT

2. Do it automatically every 100 blocks (// 5 blocks/min, so every 20 min) on all dataset

May @dzhelezov can drop a comment

[vikiival]

I was ahead of time ;D

[KngZhi]

👋

[vikiival]

This can be easily hacked with similar approach as I hacked metadata updater

• ⚡ updated metadata every 5 minutes #157

If you need some SQL magic happy to help

[vikiival]

Basically this handler should be called every 5 min

Sadly I do not handle expire time in dates as this is very variable thing

const OFFER_STATUS_ID = '2';
const OFFER_DELAY_MIN = 5;

export async function updateOfferStatus(block: bigint, store: Store): Promise<void> {
  
}

UPDATE offer SET status = 'EXPIRED' WHERE expiration <= $1
RETURNING id;