def load_environment(global_conf, app_conf):
"""Configure the Pylons environment via the ``pylons.config``
object
"""
# Pylons paths
root = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
paths = dict(root=root,
controllers=os.path.join(root, 'controllers'),
static_files=os.path.join(root, 'public'),
templates=[os.path.join(root, 'templates')])
# Initialize config with the basic options
config.init_app(global_conf, app_conf, package='thursdays', paths=paths)
config['routes.map'] = make_map()
config['pylons.app_globals'] = app_globals.Globals()
config['pylons.h'] = thursdays.lib.helpers
# Create the Mako TemplateLookup, with the default auto-escaping
config['pylons.app_globals'].mako_lookup = TemplateLookup(
directories=paths['templates'],
error_handler=handle_mako_error,
module_directory=os.path.join(app_conf['cache_dir'], 'templates'),
input_encoding='utf-8', default_filters=['escape'],
imports=['from webhelpers.html import escape'])
# Setup the SQLAlchemy database engine
engine = engine_from_config(config, 'sqlalchemy.')
init_model(engine)
import sqlalchemy as sa
import thursdays.model as model
import thursdays.model.meta as meta
from dateutil.parser import *
import urllib, re
DB_URL = "sqlite:///development.db"
engine = sa.create_engine(DB_URL)
model.init_model(engine)
opener = urllib.FancyURLopener({})
f = open('parsedoutput.txt', 'r')
line = f.readline()
while len(line) > 0:
assert line.find('######') >= 0
print line
date_str = f.readline()
date = parse(date_str)
url = f.readline()
print url
page = opener.open(url)
html = page.read()
name = re.search('<h1.*>(.*)</h1>', html).group(1)
addr = re.search('<span class="street-address">(.*?)</span>', html).group(1)
print "adding " + name + " at " + addr + " on " + str(date)