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