sqlviz

from sqlviz.utils import *
from sqlviz.sql import *
from sqlviz.parser import *

Basic useage

conn = Conn(CREDS)
query = "select count(*) as records from pageviews"
sql = Sql(conn, query)
sql.run()

<style scoped> .dataframe tbody tr th:only-of-type { vertical-align: middle; }

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

</style>

	records
0	860385

Classes

---

Conn

 Conn (creds:dict)

A wrapper around a psycopg2 connection.

---

Sql

 Sql (conn:sqlviz.sql.Conn, query:str)

A query plus a db connection.