def load_environment(global_conf, app_conf): """Configure the Pylons environment via the ``pylons.config`` object """ config = PylonsConfig() # 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='tedx', paths=paths) config['routes.map'] = make_map(config) config['pylons.app_globals'] = app_globals.Globals(config) config['pylons.h'] = tedx.lib.helpers # Setup cache object as early as possible import pylons pylons.cache._push_object(config['pylons.app_globals'].cache) def my_preprocessor(text): text = re.sub(r'<(/?)mako:', r"<\1%", text) ## return text # 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'], preprocessor=my_preprocessor) config['pylons.strict_tmpl_context'] = False # Setup the SQLAlchemy database engine engine = engine_from_config(config, 'sqlalchemy.') init_model(engine) # CONFIGURATION OPTIONS HERE (note: all config options will override # any Pylons config options) #MIMETypes for video #MIMETypes.init() #MIMETypes.add_alias('mp4', 'video/mpeg') #MIMETypes.add_alias('flv', 'video/x-flv') return config
#! /usr/bin/env python # -*- coding: utf-8 -*- import sqlalchemy as sa from sqlalchemy.ext.serializer import loads, dumps import os from tedx import model from tedx.model import meta, user, place, comment, file, tag, scoring, notification, category engine = sa.create_engine("mysql://*****:*****@localhost:3306/tedx?charset=utf8") model.init_model(engine) # ... define mappers # pickle the query results = meta.Session.query(user.User).all() results.extend(meta.Session.query(user.Follower).all()) results.extend(meta.Session.query(tag.Tag).all()) results.extend(meta.Session.query(tag.User_tag).all()) results.extend(meta.Session.query(place.Place).all()) results.extend(meta.Session.query(tag.Place_tag).all()) results.extend(meta.Session.query(comment.Comment).all()) results.extend(meta.Session.query(file.File).all()) results.extend(meta.Session.query(notification.Notification).all()) results.extend(meta.Session.query(scoring.Place_scoring).all()) results.extend(meta.Session.query(scoring.Comment_scoring).all()) results.extend(meta.Session.query(tag.Comment_tag).all()) results.extend(meta.Session.query(category.Category).all()) results.extend(meta.Session.query(category.User_category).all()) results.extend(meta.Session.query(category.Place_category).all())