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)