@socialgouv/matomo-postgres
v2.0.1
Published
Extract visitor events from Matomo API and push to Postgres
Downloads
11,915
Readme
@socialgouv/matomo-postgres
Extract matomo data from Live.getLastVisitsDetails API and push events and visits informations to Postgres.
Usage
Run the following job with correct environment variables.
npx @socialgouv/matomo-postgresEnvironment variables Deployment
| name | value |
| ----------------- | -------------------------------------------------------- |
| MATOMO_KEY* | matomo api token |
| MATOMO_SITE* | matomo site id |
| MATOMO_URL* | matomo url |
| PGDATABASE* | Postgres connection string |
| DESTINATION_TABLE | matomo |
| STARTDATE | default to today() |
| RESULTPERPAGE | matomo pagination (defaults to 500) |
| INITIAL_OFFSET | How many days to fetch on initialisation (defaults to 3) |
Dev
docker-compose up
export MATOMO_URL=
export MATOMO_SITE=
export MATOMO_KEY=
export DESTINATION_TABLE= # optional
export STARTDATE= # optional
export OFFSET= # optional
export PGDATABASE=postgres://postgres:[email protected]:5455/postgres
yarn startUse yarn test -u to update the snapshots
Database migrations
yarn migrate is run on each yarn start with Kysely migrations at ./src/migrations