sys.setdefaultencoding('utf8') from sys import argv try: import xml.etree.cElementTree as ET except ImportError: import xml.etree.ElementTree as ET import urllib2 import mysql.connector #from mysql.connector import connection from gamelist import create_gamelist #from categorylist import * name_dict = create_gamelist() schema_name = 'boardgames' table_name = 'bggdata' """ try: environment = argv[1] Exception: print 'usage: python bggapi.py local|remote' """ try: gameid = argv[1] if gameid[0:2] != '99': print 'gameid should start with 99, example 991234' sys.exit(0) except:
import codecs import json try: import xml.etree.cElementTree as ET except ImportError: import xml.etree.ElementTree as ET #import urllib2 import mysql.connector #from mysql.connector import connection from gamelist import create_gamelist from categorylist import * nameCN_dict = create_gamelist() designer_dict = dict() designer_dict['Reiner Knizia'] = u'倪睿南' designer_dict['Chu-Lan Kao'] = u'高竹岚' designer_dict['Uwe Rosenberg'] = u'乌老师' designer_dict['Liu Xiao'] = u'刘啸' type_dict = create_typelist() category_dict = create_categorylist() mechanic_dict = create_mechaniclist() #print nameCN_dict schema_name = 'boardgames' table_name_src = 'bggdata' #table_name_dst = 'raw_text_table'
import os import sys from sys import argv import PIL from PIL import Image from exceptions import IOError img_home = os.getenv('IMG_HOME') slash = '/' from gamelist import create_gamelist nameCN_list = create_gamelist() game_list = nameCN_list try: gameid = argv[1] game_list = nameCN_list[gameid] from_postfix = 'JPG' to_postfix = 'jpg' except: from_postfix = 'JPG' to_postfix = 'jpg' print 'doing jpg progressive for all pics' #print "usage: python change_postfix.py gameid" #sys.exit(0) for gameid in game_list.keys(): #change name