Skip to content

Instantly share code, notes, and snippets.

@joshdvir

joshdvir/query_mssql.sql

Last active May 16, 2023 05:06
Show Gist options
  • Save joshdvir/8b5ccd80d7ed17b8ae68aca54ebc7ef2 to your computer and use it in GitHub Desktop.
Save joshdvir/8b5ccd80d7ed17b8ae68aca54ebc7ef2 to your computer and use it in GitHub Desktop.
Download ZIP
DiggerX exercise
Raw
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
Raw
query_mssql.sql
select * from person
Raw
query_mysql.sql
select * from person limit 10
Raw
query_oracle.sql
select * from person FETCH NEXT 100 ROWS ONLY
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment