manually querying a TraP database

tested with TraP 3.1.1

don't forget to install pandas and bokeh: pip install pandas



In [5]:

    
import logging
from tkp.db.model import Varmetric
import tkp.db
from pandas import DataFrame

logging.basicConfig(level=logging.INFO)

Database connection settings



In [6]:

    
engine = 'postgresql'
host = 'localhost'
port = 5432
user = 'gijs'
password = 'gijs'
database = 'gijs'
query_loglevel = logging.WARNING  # Set to INFO to see queries, otherwise WARNING

connect to the database



In [7]:

    
logging.getLogger('sqlalchemy.engine').setLevel(query_loglevel)
db = tkp.db.Database(engine=engine, host=host, port=port,
                     user=user, password=password, database=database)
db.connect()
session = db.Session()

Get runcat ID



In [13]:

    
dataset_id = 0
runcats = session.query(Varmetric).filter((Varmetric.eta_int > 0.1) & (Varmetric.v_int > 0.1)).all()
print runcats

[]