def _old_to_new(table='casino_casino'): """ Get dictionary with equal of old ID to new ID for casino records """ old_to_new = {} c_new.execute("SELECT id, old_id FROM %s ORDER BY id ASC" % table) for item in c_new.fetchall(): old_to_new[item[1]] = item[0] return old_to_new
def _casino_params(): """ Parting casino parameters and paymentsystems relates """ param_list = [297, 147, 111, 74, 210, 77, 116, 127] param_keys = {297 : "param_mobile", 147 : "param_browser", 111 : "param_audited", 74 : "param_integrity", 210 : "param_license", 77 : "param_jackpot", 116 : "param_tournaments", 127 : "param_nodepositbonus", 192 : "param_download"} #Get list of payment params ids payment_list = {} c_new.execute("SELECT id, param_ids FROM common_paymentsystem ORDER BY id ASC") for item in c_new.fetchall(): if item[1][0] is None: #input param_list.append(item[1][1]) payment_list[item[1][1]] = {"id" : item[0], "type" : 2} elif item[1][1] is None: #output param_list.append(item[1][0]) payment_list[item[1][0]] = {"id" : item[0], "type" : 1} else: param_list += item[1] payment_list[item[1][0]] = {"id" : item[0], "type" : 1} payment_list[item[1][1]] = {"id" : item[0], "type" : 2} # c_old.execute("""SELECT site_id AS old_id, site_name AS name, site_description AS info__description, # logo AS info__image, "path" AS info__purl_main, parameter_id AS p_id, parameter_value AS p_val # FROM view_rating ORDER BY id ASC""") c_old.execute("""SELECT casino_id AS old_id, parameter_id AS p_id, value AS p_val FROM managers_rating ORDER BY id ASC""") casino_list = {} old_to_new = _old_to_new() for item in c_old.fetchall(): if not old_to_new.has_key(item["old_id"]): continue oid = item["old_id"] pid = item["p_id"] if casino_list.has_key(oid): if pid not in param_list: continue else: ''' c_old.execute("""SELECT casino_domain AS domain, article AS info__text FROM managers_sites WHERE id=%s""" % oid) casino = c_old.fetchone() casino_list[oid] = {"info" : {"text" : casino["info__text"], "image" : item["info__image"], "purl_main" : item["info__purl_main"], "description" : item["info__description"]}, "main" : {"name" : item["name"], "domain" : casino["domain"]}, "payments" : {}} ''' casino_list[oid] = {"params" : {}, "payments" : {}} if param_keys.has_key(pid): #Set casino param value casino_list[oid]["params"][param_keys[pid]] = item["p_val"] if payment_list.has_key(pid) and int(item["p_val"]) == 1: #Set relates between casino and paymentsystem payid = payment_list[pid]["id"] value = 3 if casino_list[oid]["payments"].has_key(payid) else payment_list[pid]["type"] casino_list[oid]["payments"][payid] = value for old_id in casino_list.keys(): item = casino_list[old_id] c = item["params"] # i = item["info"] #update casino record new_id = old_to_new[old_id] c_new.execute("""UPDATE casino_casino SET param_mobile=%s, param_browser=%s, param_audited=%s, param_integrity=%s, param_license=%s, param_jackpot=%s, param_tournaments=%s, param_nodepositbonus=%s WHERE id=%s""", (c.get("param_mobile", -1), c.get("param_browser", -1), c.get("param_audited", -1), c.get("param_integrity", -1), c.get("param_license", -1), c.get("param_jackpot", -1), c.get("param_tournaments", -1), c.get("param_nodepositbonus", -1), new_id)) # new_id = c_new.fetchone()[0] ''' #insert casino info record c_new.execute("""INSERT INTO casino_casinoinfo(casino_id, lang_id, name, image, description, text, purl_main, purl_download, purl_bonus) VALUES(%s, 1, %s, %s, %s, %s, %s, '', '')""", (new_id, c["name"], i["image"], i["description"], i["text"], i["purl_main"])) conn_new.commit() ''' for payment_id in item["payments"]: #Add payment relates c_new.execute("""INSERT INTO casino_casinotopaymentsystem(casino_id, paymentsystem_id, type) VALUES(%s, %s, %s)""", (new_id, payment_id, item["payments"][payment_id])) conn_new.commit()