Download games2jolly games for Flashpoint

jollymania.py

import os.path
import sqlite3
import urllib.request

def main():
    db = sqlite3.connect(os.path.join('Data', 'flashpoint.sqlite'))
    cur = db.execute("SELECT launchCommand FROM game WHERE launchCommand LIKE '%games2jolly%'")
    urls = [s for (s,) in cur.fetchall()]
    for index, url in enumerate(urls):
        print('{}/{} {}'.format(index + 1, len(urls), url))
        urlpath = os.path.normpath(url.split('://')[1])
        filepath = os.path.join("Server", "htdocs", urlpath)
        try:
            with urllib.request.urlopen(url) as req:
                with open(filepath, 'wb') as f:
                    f.write(req.read())
        except:
            print('failed to get {}'.format(url))


if __name__ == '__main__':
    main()