Reebby/terraswap-graph

Terraswap Indexer + GraphQL

Terraswap Graph

Modules

• Indexer

  • Get tx logs from mantle (https://hive.terra.dev/graphql) and store terraswap relative data into the database
  • Collect hourly/daily reserve, volume and transaction count of each pairs
  • Collect recent 24 hours swap data to serve recent volume
  • Collect minutely exchage rate of each pairs
  • Collect tx_history

Prerequisites

1. Node.js >= 14.15.x
2. PostgreSQL == 13.x

Setup

1. Clone

   $ git clone https://github.com/teiwei2003/terraswap-graph.git

2. Install packages

   $ npm install

3. Setup the database

   • Install postgreSQL
   • create a database

     postgres => CREATE DATABASE terraswap-graph OWNER alice
     

4. set ormconfig.js

   const { DefaultNamingStrategy } = require('typeorm')
   const { values, snakeCase } = require('lodash')
   const entities = require('orm/entities')
   
   class CamelToSnakeNamingStrategy extends DefaultNamingStrategy {
     tableName(targetName, userSpecifiedName) {
       return userSpecifiedName ? userSpecifiedName : snakeCase(targetName)
     }
     columnName(propertyName, customName, embeddedPrefixes) {
       return snakeCase(embeddedPrefixes.concat(customName ? customName : propertyName).join('_'))
     }
     columnNameCustomized(customName) {
       return customName
     }
     relationName(propertyName) {
       return snakeCase(propertyName)
     }
   }
   
   const connectionOptions = {
     host: 'localhost',
     port: 5432,
     username: 'alice',
     password: 'password',
     database: 'terraswap-graph',
   }
   
   module.exports = [
     {
       name: 'default',
       type: 'postgres',
       synchronize: false,
       migrationsRun: true,
       logging: false,
       logger: 'file',
       migrations: ['src/orm/migrations/*.ts'],
       ...connectionOptions,
     },
     {
       name: 'migration',
       type: 'postgres',
       synchronize: false,
       migrationsRun: true,
       logging: true,
       logger: 'file',
       supportBigNumbers: true,
       bigNumberStrings: true,
       entities: values(entities),
       migrations: ['src/orm/migrations/*.ts'],
       namingStrategy: new CamelToSnakeNamingStrategy(),
       ...connectionOptions,
     },
   ]

5. Set .envrc

   about .envrc - https://direnv.net/

   .envrc (sample)

   TZ='UTC'
   
   export TERRA_LCD='https://lcd.terra.dev'
   export TERRA_CHAIN_ID='columbus-5'
   export TERRA_MANTLE='https://hive.terra.dev/graphql'
   
   export START_BLOCK_HEIGHT=549000
   

Run Modules

• Collector

  $ npm run collect

• GraphQL

  $ npm start