def load_all(commit_interval=10000, scripts_only=False):
session = db.make_sqlalchemy_session()
if not scripts_only:
load_subject_matter(session, commit_interval=commit_interval)
load_communication_registrant(session, commit_interval=commit_interval)
load_communication_dpoh(session, commit_interval=commit_interval)
load_client(session, commit_interval=commit_interval)
run_sql_scripts()
import logbook
from docopt import docopt
from flask import Flask, Response
from flask.ext.cors import CORS
from src.db import db
from json import dumps
from sqlalchemy import asc
from collections import defaultdict
from src.data.clean import clean_name
APP = Flask(__name__)
CORS(APP)
SESSION = db.make_sqlalchemy_session()
BASE_PATH = "/api/v1/{0}"
PORT = 5001
def publicservant_itinerary(lastname=None, firstname=None, limit=100):
"""Get the itinerary of lobbyist meetings for a given public servant."""
lastname = clean_name(lastname) if lastname else ""
firstname = clean_name(firstname) if firstname else ""
query = SESSION.query(db.DPOHCommDetailsView)
query = query.filter(db.DPOHCommDetailsView.dpoh_last_name == lastname)
query = query.filter(db.DPOHCommDetailsView.dpoh_first_name == firstname)
query.order_by(db.DPOHCommDetailsView.com_date)
query.limit(limit)
