Outreachy: Treeherder Environment SetUp for Backend Issue

[Carla-Moz]

Outreachy Final: Set up environment for fullstack tasks

Project requirements

• Docker & docker-compose
• Dbeaver (an SQL database admin tool - optional)

Clone this treeherder repo from GitHub.

Follow the documentation:

Treeherder docs for server and fullstack development

The following provides a basic set up walk-through. Please use the docs for more detailed information.

Running treeherder and perfcompare:

Run: docker-compose up --build
Run: Import query for data (See sample database setup)
Then, change this line: https://github.com/mozilla/perfcompare/blob/main/src/logic/treeherder.ts#L9
To: 0.0.0.0:5000
Rerun:docker-compose up

Database setup

Connection for postgresql:
Serverhost: localhost Port: 5432 Database: treeherder User=postgres Password: mozilla1234

Link to Julien’s SQL: https://drive.google.com/file/d/12Yx1llWDFEtq957Ck8sLFBkZp10sKJyt/view?usp=drive_link

Command to load Julien’s SQL:
step 1: gunzip treeherder.sql.gz

You'll need to install psql for that:

• MacOS: brew install libpq
• Linux Debian or Ubuntu: apt install postgresql-client
• Linux Fedora: dnf install postgresql-client

Loading using Dbeaver:
step 1: download the SQL script above
step 2: After you've downloaded Dbeaver and established a connection, go to SQL Editor in the menu bar
step 3: Go down to Import SQL script and click it
step 4: Open the downloaded SQL script

[FatumaA]

Hi,
The command here should be docker-compose up --build with two dashes 😊

Edit:
In case anyone is having trouble at this part:

Command to load Julien’s SQL:
step 1: gunzip -c treeherder.sql.gz or gunzip zcat treeherder.sql.gz
step2: psql -h localhost -U postgres -W < treeherder.sql

You should drag the decompressed sql file to the root of the Treeherder before running step two