demo_basic_jupyter.ipynb

demo_basic_jupyter.ipynb

generate_as_pdf.bash

jupyter nbconvert --to webpdf demo_basic_jupyter.ipynb --allow-chromium-download

generate_chart.py

import psycopg as pg
import os
import matplotlib.pyplot as plt
from matplotlib.backends.backend_pdf import PdfPages

# Fetch environment variables with defaults
host = os.getenv('QDB_CLIENT_HOST', '127.0.0.1')
port = os.getenv('QDB_CLIENT_PORT', '8812')
user = os.getenv('QDB_CLIENT_USER', 'admin')
password = os.getenv('QDB_CLIENT_PASSWORD', 'quest')

conn_str = f'user={user} password={password} host={host} port={port} dbname=qdb'
with pg.connect(conn_str, autocommit=True) as connection:
   with connection.cursor() as cur:
     cur.execute("""\
           SELECT
               rnd_str('EUR','USD', 'GBP', 'BRL','CLP','AUD','EGP','INR', 'KWD', 'JPY') as currency,
               avg(rnd_double()) as value
           FROM
               long_sequence(20,128349234,4327897);
           """)
     records = cur.fetchall()

plt.figure(figsize=(3, 3))
currency = [record[0] for record in records]
value = [record[1] for record in records]

plt.bar(currency, value)
plt.xlabel('currency')
plt.ylabel('value')
plt.title('currencies')
plt.xticks(rotation=45)
plt.plot()

pp = PdfPages('report.pdf')
pp.savefig()
pp.close()