def register_consumer(self, provider_loc = None):
"""Register consumer on source node first, then target node."""
if not provider_loc:
provider_loc = self.options.provider
if not provider_loc:
self.log.error('Please give provider location with --provider=')
sys.exit(1)
dst_db = self.get_database(self.target_db)
dst_curs = dst_db.cursor()
src_db = self.get_database(PDB, connstr = provider_loc)
src_curs = src_db.cursor()
# check target info
q = "select * from pgq_node.get_node_info(%s)"
res = self.exec_cmd(src_db, q, [ self.queue_name ])
pnode = res[0]['node_name']
if not pnode:
raise Exception('parent node not initialized?')
# source queue
BaseConsumer.register_consumer(self)
# fetch pos
q = "select last_tick from pgq.get_consumer_info(%s, %s)"
src_curs.execute(q, [self.queue_name, self.consumer_name])
last_tick = src_curs.fetchone()['last_tick']
if not last_tick:
raise Exception('registration failed?')
src_db.commit()
# target node
q = "select * from pgq_node.register_consumer(%s, %s, %s, %s)"
self.exec_cmd(dst_db, q, [self.queue_name, self.consumer_name, pnode, last_tick])
def register_consumer(self, provider_loc = None):
"""Register consumer on source node first, then target node."""
if not provider_loc:
provider_loc = self.options.provider
if not provider_loc:
self.log.error('Please give provider location with --provider=')
sys.exit(1)
dst_db = self.get_database(self.target_db)
dst_curs = dst_db.cursor()
src_db = self.get_database(PDB, connstr = provider_loc, profile = 'remote')
src_curs = src_db.cursor()
# check target info
q = "select * from pgq_node.get_node_info(%s)"
res = self.exec_cmd(src_db, q, [ self.queue_name ])
pnode = res[0]['node_name']
if not pnode:
raise Exception('parent node not initialized?')
# source queue
BaseConsumer.register_consumer(self)
# fetch pos
q = "select last_tick from pgq.get_consumer_info(%s, %s)"
src_curs.execute(q, [self.queue_name, self.consumer_name])
last_tick = src_curs.fetchone()['last_tick']
if not last_tick:
raise Exception('registration failed?')
src_db.commit()
# target node
q = "select * from pgq_node.register_consumer(%s, %s, %s, %s)"
self.exec_cmd(dst_db, q, [self.queue_name, self.consumer_name, pnode, last_tick])
def exception_hook(self, det, emsg):
try:
dst_db = self.get_database(self.target_db)
q = "select * from pgq_node.set_consumer_error(%s, %s, %s)"
self.exec_cmd(dst_db, q, [ self.queue_name, self.consumer_name, emsg ])
except:
self.log.warning("Failure to call pgq_node.set_consumer_error()")
self.reset()
BaseConsumer.exception_hook(self, det, emsg)
def exception_hook(self, det, emsg):
try:
dst_db = self.get_database(self.target_db)
q = "select * from pgq_node.set_consumer_error(%s, %s, %s)"
self.exec_cmd(dst_db, q, [ self.queue_name, self.consumer_name, emsg ])
except:
self.log.warning("Failure to call pgq_node.set_consumer_error()")
self.reset()
BaseConsumer.exception_hook(self, det, emsg)
def unregister_consumer(self):
dst_db = self.get_database(self.target_db)
state = self.get_consumer_state()
src_db = self.get_provider_db(state)
# unregister on provider
BaseConsumer.unregister_consumer(self)
# unregister on subscriber
q = "select * from pgq_node.unregister_consumer(%s, %s)"
self.exec_cmd(dst_db, q, [ self.queue_name, self.consumer_name ])
def unregister_consumer(self):
dst_db = self.get_database(self.target_db)
state = self.get_consumer_state()
src_db = self.get_provider_db(state)
# unregister on provider
BaseConsumer.unregister_consumer(self)
# unregister on subscriber
q = "select * from pgq_node.unregister_consumer(%s, %s)"
self.exec_cmd(dst_db, q, [ self.queue_name, self.consumer_name ])
def __init__(self, service_name, db_name, args):
"""Initialize new consumer.
@param service_name: service_name for DBScript
@param db_name: target database name for get_database()
@param args: cmdline args for DBScript
"""
BaseConsumer.__init__(self, service_name, PDB, args)
self.log.debug("__init__")
self.target_db = db_name
self.provider_connstr = None
def __init__(self, service_name, db_name, args):
"""Initialize new consumer.
@param service_name: service_name for DBScript
@param db_name: target database name for get_database()
@param args: cmdline args for DBScript
"""
BaseConsumer.__init__(self, service_name, PDB, args)
self.log.debug("__init__")
self.target_db = db_name
self.provider_connstr = None
def startup(self):
if self.options.rewind:
self.rewind()
sys.exit(0)
if self.options.reset:
self.dst_reset()
sys.exit(0)
return BaseConsumer.startup(self)
def init_optparse(self, parser = None):
p = BaseConsumer.init_optparse(self, parser)
p.add_option("--provider", help = "provider location for --register")
p.add_option("--rewind", action = "store_true",
help = "change queue position according to destination")
p.add_option("--reset", action = "store_true",
help = "reset queue pos on destination side")
return p
def startup(self):
if self.options.rewind:
self.rewind()
sys.exit(0)
if self.options.reset:
self.dst_reset()
sys.exit(0)
return BaseConsumer.startup(self)
def init_optparse(self, parser = None):
p = BaseConsumer.init_optparse(self, parser)
p.add_option("--provider", help = "provider location for --register")
p.add_option("--rewind", action = "store_true",
help = "change queue position according to destination")
p.add_option("--reset", action = "store_true",
help = "reset queue position on destination side")
return p
def work(self):
"""Refresh state before calling Consumer.work()."""
dst_db = self.get_database(self.target_db)
self._consumer_state = self.refresh_state(dst_db)
if self._consumer_state['node_type'] == 'root':
self.process_root_node(dst_db)
return
if not self.provider_connstr:
raise Exception('provider_connstr not set')
src_db = self.get_provider_db(self._consumer_state)
return BaseConsumer.work(self)
def work(self):
"""Refresh state before calling Consumer.work()."""
dst_db = self.get_database(self.target_db)
self._consumer_state = self.refresh_state(dst_db)
if self._consumer_state['node_type'] == 'root':
self.process_root_node(dst_db)
return
if not self.provider_connstr:
raise Exception('provider_connstr not set')
src_db = self.get_provider_db(self._consumer_state)
return BaseConsumer.work(self)
