def test_payload(self):
# retrieve the next payload
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
hook_repository = HookRepository(connector)
hooks = hook_repository.list_active()
# retrieve the first hook, not the best method but for now it works
# expected to retrieve the hook to send an offer (nuon).
hook = hooks[0]
print hook
claim = Claim()
payload_ds = DatasourceBuilder.find(connector, hook['datasource'])
payload_c = ConnectorFactory.create_connector(payload_ds)
payload_repository = PayloadRepository(payload_c)
#payload = payload_repository.dequeue(claim, hook)
payload = payload_repository.next(hook)
print payload
print payload['proces_bestelling_id']
payload_repository.state(hook, payload, 'READY')
# options = json.loads(hook['options'])
#
# state = 'READY'
# #options = [{'status': '#state'}, {'proces_bestelling_id': '#payload.proces_bestelling_id'}]
# options = ExpressionParser.parse(options, locals())
# payload_repository.state(hook, payload, 'READY')
payload_c.close()
def run(self):
abort = self.get_abort()
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
logger = Logger(connector, self)
job_repository = JobRepository(connector)
job = job_repository.job()
job_name = job['job_name']
settings = self.get_settings()
threads = self.get_threads()
while self.is_running():
try:
watcher = self.get_watcher()
watcher.watch(connector, settings, threads, abort)
# check if we need to abort, can be called from the main thread or other thread
aborted = abort.is_aborted()
self.running(not aborted)
connector.close()
time.sleep(settings['watcher_idle_delay'])
except:
aborted = abort.is_aborted()
self.running(not aborted)
result = Traceback.build()
logger.fatal(job_name, result['message'], result['backtrace'])
connector.close()
time.sleep(settings['worker_exception_delay'])
def execute(self, connector, process_action):
job_name = process_action['job_name']
logger = Logger(connector, self)
chunk_repository = ChunkRepository(connector)
process_repository = ProcessRepository(connector)
process_property_repository = ProcessPropertyRepository(connector)
process_action_property_repository = ProcessActionPropertyRepository(connector)
# retrieve the chunk properties
process = process_repository.find_by_id(process_action['pcs_id'])
chunk_id = process_property_repository.get_property(process, 'chunk_id')
message = process_property_repository.get_property(process, 'message')
backtrace = process_property_repository.get_property(process, 'backtrace')
chunk = chunk_repository.find_by_id(chunk_id)
state = process_action_property_repository.get_property(process_action, 'state')
# retrieve the datasource of the payload
datasource = chunk['datasource']
payload_ds = DatasourceBuilder.find(connector, datasource)
payload_c = ConnectorFactory.create_connector(payload_ds)
payload_repository = PayloadRepository(payload_c)
payload = json.loads(chunk['payload'])
payload_repository.state(chunk, payload, state)
payload_c.close()
logger.info(job_name, 'job_name: ' + job_name + " state: " + chunk['state'])
def execute(self, connector, process_action):
logger = Logger(connector, self)
job_name = process_action['job_name']
process_repository = ProcessRepository(connector)
process_property_repository = ProcessPropertyRepository(connector)
process_action_property_repository = ProcessActionPropertyRepository(
connector)
# retrieve the file properties
process = process_repository.find_by_id(process_action['pcs_id'])
identifier = process_property_repository.get_property(
process, 'identifier')
datasource = process_action_property_repository.get_property(
process_action, 'datasource')
oracle_ds = DatasourceBuilder.find(connector, datasource)
oracle_c = ConnectorFactory.create_connector(oracle_ds)
scheduler = OracleScheduler(oracle_c)
if scheduler.is_running(identifier):
oracle_c.close()
return process_action
# the result should be
created_at = process['created_at']
run_result = scheduler.run_result(identifier, job_name, created_at)
oracle_c.close()
process_property_repository.set_property(process, 'message',
run_result['message'])
process_property_repository.set_property(process, 'state',
run_result['state'])
process_property_repository.set_property(process, 'backtrace',
run_result['backtrace'])
def test_call(self):
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
job_repository = JobRepository(connector)
job_name = job_repository.job()
process_respository = ProcessRepository(connector)
process = dict()
process['job_name'] = job_name['job_name']
process['pdn_id'] = None
process['state'] = None
process['e_pdn_id'] = None
process['name'] = None
process['queue'] = None
process_respository.insert(process)
event_respository = EventRepository(connector)
event = dict()
event['job_name'] = job_name['job_name']
event['state'] = None
event['repetition'] = 'DAYS'
event['intermission'] = '1'
event['pcs_id'] = process['id']
event_respository.insert(event)
process_property_repository = ProcessPropertyRepository(connector)
process_property_repository.set_property(process, 'event_id',
event['id'])
process_action_repository = ProcessActionRepository(connector)
process_action = dict()
process_action['job_name'] = job_name['job_name']
process_action['pcs_id'] = process['id']
process_action['dan_id'] = None
process_action['name'] = 'copy'
process_action['state'] = 'processed'
process_action_repository.insert(process_action)
process_action_property_repository = ProcessActionPropertyRepository(
connector)
process_action_property = dict()
process_action_property['name'] = 'file_id'
process_action_property['value'] = 1
process_action_property['pan_id'] = process_action['id']
process_action_property_repository.insert(process_action_property)
copy = Copy()
copy.execute(connector, process_action)
connector.close()
def run(self, stream):
job_name = ''
abort = self.get_abort()
stop = self.get_stop()
settings = self.get_settings()
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
logger = Logger(connector, self)
job_repository = JobRepository(connector)
job = job_repository.job()
job_name = job['job_name']
logger.trace(job_name, 'worker #' + str(self.get_id()) + " started.")
while self.is_running():
try:
url = stream['url']
username = stream['username']
password = stream['password']
auth = (username, password)
# when streaming works the code stops here.
# this is the reason why we use a Process instead of a Thread. A process can be terminated.
StreamScraper.listen(connector, job_name, stream, url, auth)
# check if we need to abort, can be called from the main thread or other thread
aborted = abort.is_aborted()
self.running(not aborted)
# check if we need to stop, will be set by the agent's WatchWorker thread
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
connector.close()
logger.trace(job_name, 'worker #' + str(self.get_id()) + " executed.")
except:
aborted = abort.is_aborted()
self.running(not aborted)
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
result = Traceback.build()
logger.fatal(job_name, result['message'], result['backtrace'])
connector.close()
time.sleep(settings['worker_exception_delay'])
def execute(self, connector, process_action):
logger = Logger(connector, self)
job_name = process_action['job_name']
file_repository = FileRepository(connector)
process_repository = ProcessRepository(connector)
process_property_repository = ProcessPropertyRepository(connector)
process_action_property_repository = ProcessActionPropertyRepository(
connector)
# retrieve the file properties
process = process_repository.find_by_id(process_action['pcs_id'])
payload = process_property_repository.get_property(process, 'payload')
if payload:
payload = json.loads(payload)
datasource = process_action_property_repository.get_property(
process_action, 'datasource')
method_name = process_action_property_repository.get_property(
process_action, 'method_name')
params = process_action_property_repository.get_property(
process_action, 'params')
test_result_params = process_action_property_repository.get_property(
process_action, 'test_result_params')
if params:
params = json.loads(params)
params = ExpressionParser.parse(params, locals())
oracle_ds = DatasourceBuilder.find(connector, datasource)
oracle_c = ConnectorFactory.create_connector(oracle_ds)
scheduler = OracleScheduler(oracle_c)
identifier = job_name + '_' + Strings.identifier(10)
message = dict()
message['method_name'] = method_name
message['identifier'] = identifier
message['params'] = params
if test_result_params:
message['test_result_params'] = json.loads(test_result_params)
scheduler.create_job(message)
logger.info(job_name, json.dumps(message))
process_property_repository.set_property(process, 'identifier',
identifier)
oracle_c.close()
def action(self, connector, message):
try:
process = json.loads(message['payload'])
process_repository = ProcessRepository(connector)
process['state'] = 'PROCESSING'
process['message'] = ''
process['backtrace'] = ''
process_repository.state(process)
process_definition_repository = ProcessDefinitionRepository(connector)
process_definition_action_repository = ProcessDefinitionActionRepository(connector)
process_definition = process_definition_repository.find_by_id(process['pdn_id'])
process_definition_action = process_definition_action_repository.find_first_by_process_definition(process_definition)
process_action_repository = ProcessActionRepository(connector)
process_action = dict()
process_action['job_name'] = process['job_name']
process_action['pcs_id'] = process['id']
process_action['dan_id'] = process_definition_action['id']
process_action['name'] = process_definition_action['name']
process_action['state'] = 'READY'
process_action = process_action_repository.insert(process_action)
process_action_property_repository = ProcessActionPropertyRepository(connector)
process_definition_action_property_repository = ProcessDefinitionActionPropertyRepository(connector)
process_definition_action_properties = process_definition_action_property_repository.list_by_process_definition_action(process_definition_action)
for process_definition_action_property in process_definition_action_properties:
process_action_property_repository.set_property(process_action, process_definition_action_property['name'], process_definition_action_property['value'])
payload = process_action
Message.enqueue(connector, process['queue'], payload, 'message', 'paprika.consumers.ProcessAction.ProcessAction')
except:
process = json.loads(message['payload'])
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
process_repository = ProcessRepository(paprika_ds)
result = Traceback.build()
result['id'] = process['id']
result['state'] = 'FAILED'
process_repository.state(result)
logger = Logger(connector, self)
logger.fatal(process['job_name'], result['message'], result['backtrace'])
def execute(self, connector, process_action):
logger = Logger(connector, self)
job_name = process_action['job_name']
process_repository = ProcessRepository(connector)
process_property_repository = ProcessPropertyRepository(connector)
process_action_property_repository = ProcessActionPropertyRepository(
connector)
# retrieve the file properties
process = process_repository.find_by_id(process_action['pcs_id'])
# retrieve the payload if present
payload = process_property_repository.get_property(process, 'payload')
if payload:
payload = json.loads(payload)
datasource = process_action_property_repository.get_property(
process_action, 'datasource')
method_name = process_action_property_repository.get_property(
process_action, 'method_name')
params = process_action_property_repository.get_property(
process_action, 'params')
if params:
params = json.loads(params)
params = ExpressionParser.parse(params, locals())
oracle_ds = DatasourceBuilder.find(connector, datasource)
oracle_c = ConnectorFactory.create_connector(oracle_ds)
oracle_call = OracleCall(oracle_c)
call = dict()
call['method_name'] = method_name
call['params'] = params
oracle_call.execute(call)
logger.info(job_name, json.dumps(call))
oracle_c.close()
process_property_repository.set_property(process, 'call',
json.dumps(call))
def execute(self, process_action):
job_name = process_action['job_name']
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
logger = Logger(self)
file_repository = FileRepository(paprika_ds)
process_repository = ProcessRepository(paprika_ds)
process_property_repository = ProcessPropertyRepository(paprika_ds)
process_action_property_repository = ProcessActionPropertyRepository(
paprika_ds)
# retrieve the file properties
process = process_repository.find_by_id(process_action['pcs_id'])
file_id = process_property_repository.get_property(process, 'file_id')
file = file_repository.find_by_id(file_id)
datasource = process_action_property_repository.get_property(
process_action, 'datasource')
drop_location = process_action_property_repository.get_property(
process_action, 'drop_location')
filename = drop_location + '/' + file['filename']
CsvFile.normalize(filename, filename + '.norm')
source_encoding = CsvFile.guess_encoding(filename + '.norm')
CsvFile.iconv(filename + '.norm', source_encoding, filename + '.utf8',
'utf8')
delimiter = CsvFile.guess_delimiter(filename + '.utf8')
skip_header = False
if not header:
header = CsvFile.read_header(filename + '.utf8', delimiter)
skip_header = True
ds = DatasourceBuilder.find(datasource)
connector = ConnectorFactory.create_connector(ds)
file_repository = FileRepository(ds)
file = dict()
file['pcs_id'] = 0
file['job_name'] = job_name
file['filename'] = filename
file['state'] = 'READY'
file['rule'] = ''
file['hashcode'] = ''
file['pickup_location'] = ''
file['path'] = ''
file['filesize'] = 0
file['pattern'] = ''
file = file_repository.insert(file)
statics = dict()
statics['job_name'] = job_name
statics['fle_id'] = file['id']
mapping = 'id.eeid;notification.action;job_name.job_name;fle_id.fle_id'
stager = Stager(ds)
stager.stage(filename + '.utf8', header, delimiter,
'tripolis_mailings', mapping, skip_header, statics)
stager.close()
logger.info(job_name,
'job_name: ' + job_name + 'file: ' + filename + " staged")
def run(self, queue):
abort = self.get_abort()
claim = self.get_claim()
stop = self.get_stop()
settings = self.get_settings()
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
logger = Logger(connector, self)
job_repository = JobRepository(connector)
job = job_repository.job()
job_name = job['job_name']
message = None
while self.is_running():
try:
message = None
# retrieve the next message
message_repository = MessageRepository(connector)
message = message_repository.dequeue(claim, queue)
if message:
consumer = ClassLoader.find(message['consumer'])
consumer.action(connector, message)
message_repository.state(queue, message, 'PROCESSED')
# check if we need to abort, can be called from the main thread or other thread
aborted = abort.is_aborted()
self.running(not aborted)
# check if we need to stop, will be set by the agent's WatchWorker thread
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
# no message to process
if not message:
connector.close()
time.sleep(settings['worker_idle_delay'])
logger.trace(job_name,
'worker #' + str(self.get_id()) + " executed.")
except:
aborted = abort.is_aborted()
self.running(not aborted)
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
result = Traceback.build()
if message:
try:
message_repository = MessageRepository(connector)
result['id'] = message['id']
message_repository.state(queue, result, 'FAILED')
except:
logger.fatal(job_name,
'Failed to persist message failure')
logger.fatal(job_name, result['message'], result['backtrace'])
connector.close()
time.sleep(settings['worker_exception_delay'])
def run(self, scheduled_event, test_mode=False):
abort = self.get_abort()
stop = self.get_stop()
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
logger = Logger(connector, self)
job_repository = JobRepository(connector)
job = job_repository.job()
job_name = job['job_name']
settings = self.get_settings()
while self.is_running():
try:
now = datetime.now()
scheduled_event_repository = ScheduledEventRepository(
connector)
scheduled_event = scheduled_event_repository.find_by_hashcode(
scheduled_event['hashcode'])
job_repository = JobRepository(connector)
event_repository = EventRepository(connector)
repetition = scheduled_event['repetition']
intermission = int(scheduled_event['intermission'])
expected = datetime.strptime(scheduled_event['expected'],
"%Y-%m-%d %H:%M:%S")
next_expected = None
if expected < now:
if repetition == 'HOURS':
next_expected = expected + timedelta(
hours=int(intermission))
while next_expected < now:
next_expected += timedelta(hours=int(intermission))
if repetition == 'DAYS':
next_expected = expected + timedelta(
days=int(intermission))
while next_expected < now:
next_expected += timedelta(days=int(intermission))
if repetition == 'MINUTES':
next_expected = expected + timedelta(
minutes=int(intermission))
while next_expected < now:
next_expected += timedelta(
minutes=int(intermission))
if next_expected:
message = dict()
message['id'] = scheduled_event['id']
message['expected'] = next_expected.__str__()
scheduled_event_repository.expected(message)
job = job_repository.job()
event_job_name = job['job_name']
process = ProcessService.create_process(
connector, scheduled_event['pdn_id'], event_job_name,
scheduled_event['e_pdn_id'])
event = dict()
event['state'] = 'READY'
event['repetition'] = repetition
event['intermission'] = intermission
event['expected'] = scheduled_event['expected']
event['job_name'] = event_job_name
event['pcs_id'] = process['id']
event = event_repository.insert(event)
process_property_repository = ProcessPropertyRepository(
connector)
process_property_repository.set_property(
process, 'event_id', event['id'])
ProcessService.execute_process(connector, process)
# check if we need to abort, can be called from the main thread or other thread
aborted = abort.is_aborted()
self.running(not aborted)
# check if we need to stop, will be set by the agent's WatchWorker thread
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
# check for test_mode, break the loop
if test_mode:
self.running(False)
connector.close()
time.sleep(settings['worker_idle_delay'])
logger.trace(job_name,
'worker #' + str(self.get_id()) + " executed.")
except:
aborted = abort.is_aborted()
self.running(not aborted)
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
result = Traceback.build()
logger.fatal(job_name, result['message'], result['backtrace'])
connector.close()
time.sleep(settings['worker_exception_delay'])
def execute(self, connector, process_action):
job_name = process_action['job_name']
logger = Logger(connector, self)
process_action_property_repository = ProcessActionPropertyRepository(
connector)
# retrieve the properties
uuid = process_action_property_repository.get_property(
process_action, 'uuid')
page_size = process_action_property_repository.get_property(
process_action, 'page_size')
datasource = process_action_property_repository.get_property(
process_action, 'datasource')
# create the scraper
scraper = Clang()
response = scraper.mailing_get_quickmails(uuid)
resource_id = response.msg
# get resource id
resource_status = 'BUSY'
while resource_status != "READY":
response = scraper.resource_get_by_id(uuid, resource_id)
resource_status = response.msg.status
time.sleep(1)
# get mailings
resource_size = response.msg.size
mailing_ids = []
for i in xrange(0, resource_size):
response = scraper.mailing_set_get_mailing_ids(
uuid, resource_id, i, 2)
mailing_ids.append(response.msg.integer[0])
scraper.resource_free(uuid, resource_id)
# get summaries
mail_summaries = []
for mailing_id in mailing_ids:
response = scraper.mailing_get_by_id(uuid, mailing_id)
campaign_name = response.msg.campaignName
content_name = response.msg.contentName
started_at = response.msg.startedAt
ended_at = response.msg.endedAt
description = response.msg.description
received = response.msg.received
unique_clicks = response.msg.uniqueClicks
unique_opens = response.msg.uniqueOpens
bounces = response.msg.bounces
message = dict()
message['mailing_id'] = mailing_id
message['campaign_name'] = Strings.encode(campaign_name, 'utf-8')
message['started_at'] = Strings.encode(started_at, 'utf-8')
message['ended_at'] = Strings.encode(ended_at, 'utf-8')
message['content_name'] = Strings.encode(content_name, 'utf-8')
message['description'] = Strings.encode(description, 'utf-8')
message['received'] = received
message['unique_clicks'] = unique_clicks
message['unique_opens'] = unique_opens
message['bounces'] = bounces
message['cor'] = MathHelper.divide(unique_opens, received) * 100.0
message['cto'] = MathHelper.divide(unique_clicks,
unique_opens) * 100.0
message['ctr'] = MathHelper.divide(unique_clicks, received) * 100.0
mail_summaries.append(message)
# delete all the mailings and insert the new ones.
mi_ds = DatasourceBuilder.find(datasource)
clang_mail_summary_repository = ClangMailSummaryRepository(mi_ds)
clang_mail_summary_repository.clean()
for summary in mail_summaries:
clang_mail_summary_repository.insert(summary)
logger.info(job_name, 'job_name: ' + job_name)
def run(self, location):
abort = self.get_abort()
stop = self.get_stop()
paprika_ds = DatasourceBuilder.build('paprika-ds.json')
connector = ConnectorFactory.create_connector(paprika_ds)
logger = Logger(connector, self)
job_repository = JobRepository(connector)
job = job_repository.job()
job_name = job['job_name']
settings = self.get_settings()
while self.is_running():
try:
properties = PropertyRepository(connector)
registry = FileRepository(connector)
rule_repository = RuleRepository(connector)
excluded_extensions = properties.get_property(
'scanner.excluded_extensions')
stable_check_delay = properties.get_property(
'scanner.stable_check_delay')
url = location['url']
patterns = location['patterns']
client = VfsFactory.create_client(url)
client.set_excluded_extensions(excluded_extensions)
client.set_stable_check_delay(int(stable_check_delay))
client.set_regular_expressions(patterns)
path = client.get_path()
recursive = int(location['recursive'])
depth = int(location['depth'])
client.connect()
files = client.list_stable(path,
recursive=recursive,
depth=depth)
for file in files:
registered_file = registry.get_by_hashcode(
file['hashcode'])
if not registered_file:
# find the rule
found_rule = None
rules = rule_repository.find_by_location(location)
for rule in rules:
if Matcher.match(ReMethod, rule['pattern'],
file['filename']):
found_rule = rule
if not found_rule:
found_rule = rule_repository.find_failsafe()
job = job_repository.job()
file_job_name = job['job_name']
logger.info(
file_job_name, "file: " + file['url'] + '/' +
file['filename'] + " rule: " + found_rule['rule'] +
" hascode:" + file['hashcode'])
process = ProcessService.create_process(
connector, found_rule['pdn_id'], file_job_name,
found_rule['e_pdn_id'])
message = dict()
message['job_name'] = file_job_name
message['filename'] = file['filename']
message['path'] = file['path']
message['pattern'] = found_rule['pattern']
message['rle_id'] = found_rule['id']
message['rule'] = found_rule['rule']
message['pickup_location'] = file['url']
message['filesize'] = file['size']
message['hashcode'] = file['hashcode']
message['pcs_id'] = process['id']
message['state'] = 'READY'
registered_file = registry.insert(message)
process_property_repository = ProcessPropertyRepository(
connector)
process_property_repository.set_property(
process, 'file_id', registered_file['id'])
process_property_repository.set_property(
process, 'pickup_location', file['url'])
process_property_repository.set_property(
process, 'path', file['path'])
process_property_repository.set_property(
process, 'payload',
json.dumps({
'filename': file['filename'],
'job_name': file_job_name
}))
ProcessService.execute_process(connector, process)
client.close()
# check if we need to abort, can be called from the main thread or other thread
aborted = abort.is_aborted()
self.running(not aborted)
# check if we need to stop, will be set by the agent's WatchWorker thread
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
connector.close()
time.sleep(settings['worker_idle_delay'])
logger.trace(job_name,
'worker #' + str(self.get_id()) + " executed.")
except:
aborted = abort.is_aborted()
self.running(not aborted)
if not aborted:
stopped = stop.is_stopped()
self.running(not stopped)
result = Traceback.build()
logger.fatal(job_name, result['message'], result['backtrace'])
connector.close()
time.sleep(settings['worker_exception_delay'])
def __init__(self, connector):
Repository.__init__(self, connector)
self.__logger = Logger(ConnectorFactory.create_connector(DatasourceBuilder.build('paprika-ds.json')), self)