예제 #1
0
def create_tables_from_sqlalchemy():
    """Create tables from SQLAlchemy definition"""
    try:
        import MySQLdb
    except ImportError:
        print 'ERRORL please install MySQL-python lib first...'
    else:
        from lifescore import models
        from sqlalchemy import create_engine
        engine = create_engine("mysql+mysqldb://lifescore:5mad_cows@localhost/" + 
                    "lifescore?charset=utf8&use_unicode=0")
        models.initialize_sql(engine)
예제 #2
0
def main(global_config, **settings):
    """ This function returns a Pyramid WSGI application.
    """
    engine = engine_from_config(settings, 'sqlalchemy.')
    initialize_sql(engine)
    set_cache_regions_from_settings(settings)
    session_factory = session_factory_from_settings(settings)
    config = Configurator(settings=settings)
    config.set_session_factory(session_factory)
    config.scan()
    config.add_static_view('static', 'lifescore:static')
    config.add_route('home', '/')
    config.add_route('dashboard', '/profile/{fb_id}')
    config.add_route('fetch_friends', '/fetch_friends')
    config.add_route('friends_rank_fetch', '/friends_rank_fetch')
    config.add_route('world_rank_fetch', '/world_rank_fetch')
    return config.make_wsgi_app()
예제 #3
0
def main(global_config, **settings):
    """ This function returns a Pyramid WSGI application.
    """
    engine = engine_from_config(settings, 'sqlalchemy.')
    initialize_sql(engine)
    set_cache_regions_from_settings(settings)
    session_factory = session_factory_from_settings(settings)
    config = Configurator(settings=settings)
    config.set_session_factory(session_factory)
    config.scan()
    config.add_static_view('static', 'lifescore:static')
    config.add_route('home', '/')
    config.add_route('dashboard', '/profile/{fb_id}')
    config.add_route('fetch_friends', '/fetch_friends')
    config.add_route('friends_rank_fetch', '/friends_rank_fetch')
    config.add_route('world_rank_fetch', '/world_rank_fetch')
    return config.make_wsgi_app()