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)
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()