def __init__(self):
super().__init__()
self.db = edb.Database('arch2018')
self.fdm = edb.Database('fdm_new')
self.producer_id = 7079
return
def get_moviecode_id(self, moviecode):
"""
:param mc_in_cell: set
:return:
"""
r = self.bpm_conn(
'select `id`, `code` from `uni_moviecodes` where `code` = %s',
moviecode)
if r:
return r[0]['id']
else:
conn = edb.Database('w1_etl')
try:
moviecode_id = conn(
'select `id`, `code` from `obj_moviecodes` where `code` = %s',
moviecode)
if moviecode_id:
return moviecode_id[0]['id']
else:
return conn(
'insert into `obj_moviecodes` (`id`, `code`) value (null, %s)',
moviecode)
except Exception as e:
print(str(e))
finally:
conn.tvar.conn.close()
raise MoviecodeError
def __init__(self):
super().__init__()
self.bpm_conn = edb.Database('bpm')
self.pub_conn = edb.Database('pub')
self.bpm_movie_conn = edb.Database('bpm_movie')
self.fdm_conn = edb.Database('fdm')
# self.etl_conn = dbconn.Database('etl')
self.mds_conn = edb.Database('bestine')
self.mds_load_conn = edb.Database('bestine_w1')
# self.db = Database()
self.cells_base_file = "cells_pub_std_exterior"
self.cells = {}
self.group = None
self.slot_count = 0
self.pid2moviecode = {}
self.moviecode2mix_mode = {}
self.moviecodeMonth2pid = {}
# {'GF0010202':{'0123467a2018':set([('中数','租赁'),('院线','自购')])}
self.day_monitor_task_types = [
TASK_DAILY_LEASE_VS_LEASE, TASK_DAILY_MERGE_VS_ZZ
]
self.day_slots = collections.defaultdict(
lambda: dict.fromkeys(self.day_monitor_task_types))
# {(date, chain): {TaskType:TaskID, ...}}
self.month_monitor_task_types = [
TASK_MONTH_LEASE_VS_LEASE, TASK_MONTH_MON_VS_DAY,
TASK_MONTH_MERGE_VS_ZZ
]
self.month_slots = collections.defaultdict(
lambda: dict.fromkeys(self.month_monitor_task_types))
# {(month, chain): {TaskType:TaskID, ...}}
self.stopscreen_monitor_task_types = [
CHAIN_RELEASE_COMPARE_CHAIN_MONTH,
CHAIN_RELEASE_COMPARE_ZY_RELEASE, CHAIN_ZY_COMPARE_ZHUANZI
]
self.stopscreen_slots = collections.defaultdict(
lambda: dict.fromkeys(self.stopscreen_monitor_task_types))
# {(project, chain): {TaskType:TaskID, ...}}
self.slot_dir = {}
self.project_mix_mode = {}
# {(moviecode, chain): {TaskType:TaskID, ...}}
self.pid_id_map = {}
return
def __init__(self):
super().__init__()
self.bpm_conn = edb.Database('bpm')
self.pub_conn = edb.Database('pub')
self.bpm_movie_conn = edb.Database('bpm_movie')
self.fdm_conn = edb.Database('fdm')
# self.etl_conn = dbconn.Database('etl')
self.mds_conn = None
# self.db = Database()
self.cells_base_file = "cells_pub_std"
self.cells = {}
self.group = None
self.slot_count = 0
self.pid2moviecode = {}
self.moviecode2mix_mode = {}
self.moviecodeMonth2pid = {}
# {'GF0010202':{'0123467a2018':set([('中数','租赁'),('院线','自购')])}
self.day_monitor_task_types = [TASK_DAILY_LEASE_VS_LEASE]
self.day_slots = collections.defaultdict(
lambda: dict.fromkeys(self.day_monitor_task_types))
# {(date, chain): {TaskType:TaskID, ...}}
self.day_monitor = Monitor('DAY', 30)
self.month_monitor_task_types = [
TASK_MONTH_LEASE_VS_LEASE, TASK_MONTH_MON_VS_DAY
]
self.month_slots = collections.defaultdict(
lambda: dict.fromkeys(self.month_monitor_task_types))
# {(month, chain): {TaskType:TaskID, ...}}
self.month_monitor = Monitor('MTH', 40)
self.stopscreen_monitor_task_types = [
CHAIN_RELEASE_COMPARE_CHAIN_MONTH, CHAIN_RELEASE_COMPARE_ZY_RELEASE
]
self.stopscreen_slots = collections.defaultdict(
lambda: dict.fromkeys(self.stopscreen_monitor_task_types))
# {(project, chain): {TaskType:TaskID, ...}}
self.stopscreen_monitor = Monitor('STP', 100)
self.slot_dir = {}
self.project_mix_mode = {}
# {(moviecode, chain): {TaskType:TaskID, ...}}
self.project_monitor = Monitor('PRJ', 2 * 60)
self.pid_id_map = {}
# self.update_event = asyncio.Event()
self.cell_monitor = Monitor('CLL')
self.group_monitor = Monitor('GRP')
self.load_group_monitor = Monitor('LGP')
self.clean_group_monitor = Monitor('CGP', 60)
return
def __init__(self):
self.db = edb.Database('arch2018')