Exemple #1
0
def main():

    config = appconfig('config:/home/rojkov/work/pacemaker/pacemaker/development.ini')

    # Initialize DB
    engine = sa.engine_from_config(config, "sqlalchemy.")
    model.init_model(engine)

    for p in model.Session.query(model.Request).filter_by(state=model.Request.ST_NEW):
        print p.id
Exemple #2
0
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="pacemaker", paths=paths)

    config["routes.map"] = make_map(config)
    config["pylons.app_globals"] = app_globals.Globals(config)
    config["pylons.h"] = pacemaker.lib.helpers

    # Setup cache object as early as possible
    import pylons

    pylons.cache._push_object(config["pylons.app_globals"].cache)

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

    # CONFIGURATION OPTIONS HERE (note: all config options will override
    # any Pylons config options)

    # don't raise AttributeError for template context
    config["pylons.strict_tmpl_context"] = False

    return config
#!/usr/bin/python

from amqplib import client_0_8 as amqp
import sqlalchemy as sa
from paste.deploy import appconfig
from sqlalchemy.orm.exc import NoResultFound
import time

from pacemaker.model import init_model, Session
from pacemaker.model import Request

config = appconfig('config:/home/rojkov/work/pacemaker/pacemaker/development.ini')

# Initialize DB
engine = sa.engine_from_config(config, "sqlalchemy.")
init_model(engine)

conn = amqp.Connection(host="localhost:5672", userid="guest",
                       password="******", virual_host="/", insist=False)
chan = conn.channel()

# consumer's code
chan.queue_declare(queue="newrequests", durable=True,
                   exclusive=False, auto_delete=False)
chan.exchange_declare(exchange="sorting_room", type="topic", durable=True,
                      auto_delete=False)

chan.queue_bind(queue="newrequests", exchange="sorting_room",
                routing_key="requestprocessors.#")

def recv_callback(msg):