training.psql

\pset border 2
\pset linestyle unicode
\pset null 'Ø'

\x auto

\if :{?run_before}
\else
  \! clear
  \set run_before true
  \ir ./setup/setup.sql
\endif

\! clear
\echo '\033[1;35mStatistics: How PostgreSQL Counts w/o Counting (Sadeq Dousti)\033[0m'
\echo '   0 – Intro to query planner'
\echo '   1 – Gathering statistics'
\echo '   2 – Interlude: A utility function'
\echo '   3 – Histograms'
\echo '   4 – Dead row reaper: vacuum'
\echo '   5 – Stale stats: The wrong plan'
\echo '   6 – Multi-column stats'
\echo '   7 – Summary'
\echo '   q – quit'
\echo
\echo Type your choice and press <Enter>:
\! viu ./img/url_qr.png -w80 -x50

\prompt topic
\set topic '\'' :topic '\''
select
:topic::text = '0' as choice_is_0,
:topic::text = '1' as choice_is_1,
:topic::text = '2' as choice_is_2,
:topic::text = '3' as choice_is_3,
:topic::text = '4' as choice_is_4,
:topic::text = '5' as choice_is_5,
:topic::text = '6' as choice_is_6,
:topic::text = '7' as choice_is_7,
:topic::text = 'q' as choice_is_q\gset

\! clear

\if :choice_is_q
  \! clear
  \echo Bye :elephant  
\elif :choice_is_0
  \ir ./topics/0.sql
  \ir ./training.psql
\elif :choice_is_1
  \ir ./topics/1.sql
  \ir ./training.psql
\elif :choice_is_2
  \ir ./topics/2.sql
  \ir ./training.psql
\elif :choice_is_3
  \ir ./topics/3.sql
  \ir ./training.psql
\elif :choice_is_4
  \ir ./topics/4.sql
  \ir ./training.psql
\elif :choice_is_5
  \ir ./topics/5.sql
  \ir ./training.psql
\elif :choice_is_6
  \ir ./topics/6.sql
  \ir ./training.psql
\elif :choice_is_7
  \ir ./topics/7.sql
  \ir ./training.psql

\else
  \echo
  \echo '\033[1;31mError:\033[0m Unknown option! Try again.'
  \echo
  \ir ./training.psql
\endif