Skip to content

Bitgreen emissions calculation #503

Bitgreen emissions calculation

Bitgreen emissions calculation #503

name: Bitgreen emissions calculation
#Run job every 6 hours
on:
schedule:
- cron: '0 0,6,12,18 * * *'
jobs:
update-network-db:
runs-on: ubuntu-latest
services:
postgres:
image: postgres
env:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: ${{ secrets.POSTGRES_PASSWORD }}
#DATABASE_URL: ${{ secrets.DATABASE_URL }} #To-do change from localhost
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
ports:
# Maps TCP port 5432 on service container to the host
- 5432:5432
steps:
# Downloads a copy of the code in your repository before running CI tests
- name: Check out repository code
uses: actions/checkout@v3
# Performs a clean installation of all dependencies in the `package.json` file
# For more information, see https://docs.npmjs.com/cli/ci.html
- name: Install dependencies
run: npm ci
- name: Connect to PostgreSQL
# Runs a script that creates a PostgreSQL table, populates
# the table with data, and then retrieves the data
run: node --experimental-json-modules scripts/createNetworkData.mjs
# Environment variables used by the `client.js` script to create
# a new PostgreSQL table.
env:
# The hostname used to communicate with the PostgreSQL service container
POSTGRES_HOST: localhost
# The default PostgreSQL port
POSTGRES_PORT: 5432
DATABASE_URL: ${{ secrets.DATABASE_URL }}