DiggerX exercise

gistfile1.md

In this exercise we are going to run DiggerX, connect it to 4 different databases

• Oracle
• Postgres
• MSSQL
• MySQL And run queries against any of these databases

1. Create a new folder on your computer
2. Download and extract Digger into that folder
3. Create a config.yaml configuration file for DiggerX
4. Configure connections in DiggerX to the following databases - https://handbook.onebeat.cloud/doc/diggerx-testing-environment-xwtBpY93yJ, all except Sample Oracle Japanese
5. Configure the queries to run on each database from the files below
6. Run DiggerX using the above configuration file from Powershell/Terminal
7. Call http://localhost:3000/endpoints to make sure all your configuration is working

query_mssql.sql

select * from person

query_mysql.sql

select * from person limit 10

query_oracle.sql

select * from person FETCH NEXT 100 ROWS ONLY

query_postgres.sql

select *
from
person p,
person_region pr,
noc_region nr,
games g,
games_city gc,
games_competitor gc2,
city c
where
p.id = pr.person_id
and pr.region_id = nr.id
and g.id = gc.games_id
and gc.city_id = c.id
and gc2.person_id = p.id