dump_nav_timing_data.py

#!/usr/bin/env python
# -*- coding: utf8 -*-
import sys
reload(sys)
sys.setdefaultencoding("utf-8")

import os

from sqlalchemy import create_engine, Column, String
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy.sql import exists, func


Base = automap_base()

class NavigationTiming(Base):
    __tablename__ = 'NavigationTiming_13317958_'
    uuid = Column(String, primary_key=True)

engine = create_engine('mysql://%(DB_USER)s:%(DB_PASS)s@m4-master/log?'
                       'charset=utf8' % os.environ)
Base.prepare(engine, reflect=True)

session = Session(engine)
measures = session.query(NavigationTiming).filter(
        NavigationTiming.timestamp >= 20151000000000,
        NavigationTiming.timestamp <  20151100000000
)

for measure in measures.yield_per(10):
    print measure
    sys.exit()