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)