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()
