gistfile1.txt

# Script to download most expected files in the database from production server.
# Run from within an container with db access like this:
# docker run -it --rm --name python_migrate --network faf_faf --network host -v /opt/faf/data/content:/content -v /opt/faf/scripts:/scripts python:latest bash
# and install mysql lib with apt-get update && apt-get install python-mysqldb

import MySQLdb
import urllib
import os

db = MySQLdb.connect("172.19.0.3","root","banana","faf_lobby")

cursor = db.cursor()

cursor.execute("select filename from map_version")

print("Maps")
while True:
    mapfile = cursor.fetchone()
    if mapfile == None:
        break

    destname = "/content/%s" % mapfile
    if not os.path.exists(destname):
      try:
        os.makedirs(os.path.dirname(destname))
      except:
        pass
      print("   downloading %s to %s" % (mapfile, destname))
      urllib.urlretrieve("http://content.faforever.com/%s" % mapfile, destname)

print("Mods")

cursor.execute("select filename from mod_version")

while True:
    modfile = cursor.fetchone()
    if modfile == None:
        break

    destname = "/content/%s" % modfile
    if not os.path.exists(destname):
      try:
        os.makedirs(os.path.dirname(destname))
      except:
        pass
      print("   downloading %s to %s" % (modfile, destname))
      urllib.urlretrieve("http://content.faforever.com/%s" % modfile, destname)

print("FAF")
cursor.execute("select name from updates_faf_files")

while True:
    updatefile = cursor.fetchone()
    if updatefile == None:
        break

    destname = "/content/faf/updaterNew/updates_faf_files/%s" % updatefile
    if not os.path.exists(destname):
      try:
        os.makedirs(os.path.dirname(destname))
      except:
        pass
      print("   downloading %s to %s" % (updatefile, destname))
      urllib.urlretrieve("http://content.faforever.com/faf/updaterNew/updates_faf_files/%s" % updatefile, destname)

db.close()