Skip to main content
Version: Old ArrowSquid docs

EvmBatchProcessor in action

An end-to-end idiomatic usage of EvmBatchProcessor can be inspected in the gravatar-template repository (link out of date) and also learned from more elaborate examples.

In order to illustrate the concepts covered thus far, here we highlight the key steps, put together a processor configuration and a data handling definition.

1. Model the target schema and generate entity classes

Create or edit schema.graphql to define the target entities and relations. Consult the schema reference.

Update the entity classes, start a fresh database and regenerate migrations:

sqd codegen
sqd down
sqd up
sqd migration:generate

2. Generate Typescript ABI modules

Use evm-typegen to generate the facade classes, for example like this:

npx squid-evm-typegen src/abi 0x2E645469f354BB4F5c8a05B3b30A929361cf77eC#Gravity --clean

3. Configuration

See Configuration section for more details.

const processor = new EvmBatchProcessor()
archive: lookupArchive('eth-mainnet'),
chain: ''
.setBlockRange({ from: 6175243 })
// fetch logs emitted by '0x2E645469f354BB4F5c8a05B3b30A929361cf77eC'
// matching either `NewGravatar` or `UpdatedGravatar`
address: ['0x2E645469f354BB4F5c8a05B3b30A929361cf77eC'],
topic0: [

4. Iterate over the batch items and group events

The following code snippet illustrates a typical data transformation in a batch. The strategy is to

  • Iterate over ctx.blocks and block.logs
  • Decode each log using a suitable facade class
  • Enrich and transform the data
  • Upsert arrays of entities in batches using

The method the looks as follows: TypeormDatabase(), async (ctx) => {
// storing the new/updated entities in
// an in-memory identity map
const gravatars: Map<string, Gravatar> = new Map()
// iterate over the data batch stored in ctx.blocks
for (const c of ctx.blocks) {
for (const log of c.logs) {
// decode the log data
const { id, owner, displayName, imageUrl } = extractData(log)
// transform and normalize to match the target entity (Gravatar)
gravatars.set(id.toHexString(), new Gravatar({
id: id.toHexString(),
owner: decodeHex(owner),
// Upsert the entities that were updated.
// Note that automatically updates
// the existing entities and creates new ones.
// It splits the data into suitable chunks to
// guarantee an adequate performance.

In the snippet above, we decode both NewGravatar and UpdatedGravatar with a single helper function that uses the generated events facade class:

function extractData(evmLog: any): { id: ethers.BigNumber, owner: string, displayName: string, imageUrl: string} {
if (evmLog.topics[0] === events.NewGravatar.topic) {
return events.NewGravatar.decode(evmLog)
if (evmLog.topics[0] === events.UpdatedGravatar.topic) {
return events.UpdatedGravatar.decode(evmLog)
throw new Error('Unsupported topic')

5. Run the processor and store the transformed data into the target database

Run the processor with

sqd process

The script will build the code automatically before running.

In a separate terminal window, run

sqd serve

Inspect the GraphQL API at http://localhost:4350/graphql.