Ejemplo n.º 1
0
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)
Ejemplo n.º 2
0
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)