import psycopg2
import pandas as pd


def getRemoteConn():
    # set username and password
    username = 'your@emailaddress.com'
    password = 'supersecretpassword'
    # set up database, typically account.game, the demo game should work for every user
    database = 'demo-account.demo-game'
    # connect and give back the connection
    conn = psycopg2.connect(
            "dbname='{db}' user='{user}' host='data.deltadna.net' password='{passw}'".format(user=username,
                                                                                             passw=password,
                                                                                             db=database))
    return conn


if __name__ == '__main__':
    try:
        # run the query using the returned connection
        data_frame = pd.read_sql_query(
            'select userId, sessionId, eventName, eventTimestamp, eventDate from events_dev limit 500',
            con=getRemoteConn())
        # do something with the dataframe created by pandas
        print data_frame.describe()
    except psycopg2.OperationalError as e:
        # catch database exception and print its message
        print e.message