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