Pinot queries rendered in Streamlit

app.py

import streamlit as st
from pinotdb import connect
import pandas as pd

st.title("GitHub Events")

broker_port = 8000
conn = connect(host='localhost', port=broker_port, path='/query/sql', scheme='http')

query = f"""
select organization, repo, sum(numLinesAdded)
from pullRequestMergedEvents
where createdTimeMillis > cast((now() - %(subtract_time)d*1000*60) as long)
group by organization, repo
order by sum(numLinesAdded) DESC
limit 10
"""
subtract_time = 24*60

curs = conn.cursor()
curs.execute(query, {"subtract_time": subtract_time})

st.header("Most active repositories")
st.table(pd.DataFrame(curs, columns=[item[0] for item in curs.description]))