Bitgreen emissions calculation #491

	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 }}

Provide feedback