for game in games: sk = game.get("__search_key__") code = game.get("code") name = game.get("name") print name expr = "@MAX(simpleslot/game['code','" + code + "'].sthpw/task.bid_end_date)" try: bed = server.eval(expr) bed = parser.parse(bed) if bed.month >= 1 and bed.month <= 3: quarter = 'Q1' elif bed.month >= 4 and bed.month <= 6: quarter = 'Q2' elif bed.month >= 7 and bed.month <= 9: quarter = 'Q3' elif bed.month >= 10 and bed.month <= 12: quarter = 'Q4' quarter_data = {'brief_quarter': quarter} year_data = {'brief_year': bed.year} server.update(sk, quarter_data) print year_data except: print "probably no tasks"
import tacticenv from tactic_client_lib import TacticServerStub server = TacticServerStub(protocol="xmlrpc") #server.set_project("sample3d") server.set_ticket("60128265ebea63620de1f5b0ffc502eb") search_type = "prod/shot" server.start(title='cow') sobject = server.insert(search_type, {'description': 'wow'}) server.update(search_key, {'description': 'another update'}) server.finish() sobject = server.insert(search_type, {'description': 'wow2'}) sobject = server.insert(search_type, {'description': 'wow3'})
if game_type[0] == "casino" or game_type[0] == "video_conf": #if game_name == "cf_king_of_hidden_weapons": for casino_process in casino_processes: expr = "@MIN(simpleslot/game['name','" + game_name + "'].simpleslot/3d.sthpw/task['process','" + casino_process + "'].bid_start_date)" temp_min = server.eval(expr) expr = "@MAX(simpleslot/game['name','" + game_name + "'].simpleslot/3d.sthpw/task['process','" + casino_process + "'].bid_end_date)" temp_max = server.eval(expr) if temp_min != None or temp_max != None: data["threed_" + casino_process + "_min"] = temp_min data["threed_" + casino_process + "_max"] = temp_max insert = 1 for game_in_combine in task_combine: #match combine list names to master list, if match, only update. code = game_in_combine.get("game_code") sk = game_in_combine.get("__search_key__") if code == game_code: inlist.append(data) server.update(sk, data) insert = 0 break if insert == 1: #if game not in combine list, insert server.insert(task_combine_sk, data) inlist.append(data) #return inlist
pipeline_code = task.get("pipeline_code") context = task.get("context") status = task.get("status") bsd = task.get("bid_start_date") bed = task.get("bid_end_date") assigned = task.get("assigned") data = { 'search_code': search_code, 'process': process, 'status': status, 'assigned': assigned, 'bid_start_date': bsd, 'bid_end_date': bed, 'search_type': search_type, 'pipeline_code': pipeline_code, 'context': context } new_task = server.insert("sthpw/task", data) new_task_code = new_task.get("code") expr = "@SOBJECT(sthpw/snapshot['search_code','" + code + "'])" snapshots = server.eval(expr) for snapshot in snapshots: print snapshot.get("context") snapshot_sk = snapshot.get("__search_key__") snapshot_data = {'search_code': new_task_code} server.update(snapshot_sk, snapshot_data)
import tacticenv from tactic_client_lib import TacticServerStub server = TacticServerStub(protocol="xmlrpc") #server.set_project("sample3d") server.set_ticket("60128265ebea63620de1f5b0ffc502eb") search_type = "prod/shot" server.start(title='cow') sobject = server.insert(search_type, { 'description': 'wow'} ) server.update(search_key, { 'description': 'another update'} ) server.finish() sobject = server.insert(search_type, { 'description': 'wow2'} ) sobject = server.insert(search_type, { 'description': 'wow3'} )