def _casino_logo():
"""
Copy casino logo images
"""
c.execute("""SELECT id, logo FROM old_site_casino c WHERE logo<>'' ORDER BY id ASC""")
for item in c.fetchall():
filename = copy_file("http://casino-rating.org/images/logos/%s.jpg" % item["logo"], "casino", "jpg")
c.execute("""UPDATE old_site_casino SET logo=%s WHERE id=%s""", (filename, item["id"]))
conn_new.commit()
def _slots_logo():
"""
Copy slots logo images
"""
c.execute("""SELECT id, screenshot FROM casino_game WHERE screenshot<>'' ORDER BY id ASC""")
for item in c.fetchall():
filename = copy_file("http://casino-rating.org/%s" % item["screenshot"], "slots",
get_file_extension(item["screenshot"]))
c.execute("""UPDATE casino_game SET screenshot=%s WHERE id=%s""", (filename, item["id"]))
conn_new.commit()
def _casino_screenshots():
"""
Copy casino screenshots
"""
c.execute("""SELECT id, casino_id, image FROM old_site_casinoscreenshot WHERE image<>'' ORDER BY id ASC""")
for item in c.fetchall():
filename = copy_file("http://casino-rating.org/images/logos/%s" % item["image"], "casino",
get_file_extension(item["image"]))
c.execute("""UPDATE old_site_casinoscreenshot SET image=%s WHERE id=%s""", (filename, item["id"]))
conn_new.commit()
def _casino_logo():
"""
Copy casino logo images
"""
c.execute(
"""SELECT c.id, old_id, image FROM casino_casino c
INNER JOIN casino_casinoinfo ci ON ci.casino_id=c.id WHERE image<>'' ORDER BY c.id ASC"""
)
for item in c.fetchall():
filename = copy_file("http://casino-rating.org/images/logos/%s.jpg" % item["image"], "casino", "jpg")
c.execute("""UPDATE casino_casinoinfo SET image=%s WHERE casino_id=%s AND lang_id=1""", (filename, item["id"]))
conn_new.commit()
