#!/usr/bin/python
|
# -*- coding: GBK -*-
|
#-------------------------------------------------------------------------------
|
#
|
##@package Code.gamecfg_export
|
#
|
# @todo:ÓÎÏ·¿Í»§¶Ë·þÎñ¶ËÅäÖÃÎļþµ¼³ö
|
# @author hxp
|
# @date 2017-07-19
|
# @version 1.0
|
#
|
# ÏêϸÃèÊö: ¸ù¾Ý²ß»®ÅäÖõÄĸ±í¸ñµ¼³ö¿Í»§¶Ë·þÎñ¶Ë³ÌÐòʹÓõÄÅäÖÃÎļþ
|
#
|
#-------------------------------------------------------------------------------
|
#"""Version = 2017-07-19 12:00"""
|
#-------------------------------------------------------------------------------
|
|
import ctypes
|
import ConfigParser
|
import xlrd
|
import sys
|
import os
|
|
####################################################################################################
|
|
STD_INPUT_HANDLE = -10
|
STD_OUTPUT_HANDLE = -11
|
STD_ERROR_HANDLE = -12
|
|
# ×ÖÌåÑÕÉ«¶¨Òå ,¹Ø¼üÔÚÓÚÑÕÉ«±àÂ룬ÓÉ2λʮÁù½øÖÆ×é³É£¬·Ö±ðÈ¡0~f£¬Ç°Ò»Î»Ö¸µÄÊDZ³¾°É«£¬ºóһλָµÄÊÇ×ÖÌåÉ«
|
#ÓÉÓڸú¯ÊýµÄÏÞÖÆ£¬Ó¦¸ÃÊÇÖ»ÓÐÕâ16ÖÖ£¬¿ÉÒÔÇ°¾°É«Óë±³¾°É«×éºÏ¡£Ò²¿ÉÒÔ¼¸ÖÖÑÕɫͨ¹ý»òÔËËã×éºÏ£¬×éºÏºó»¹ÊÇÔÚÕâ16ÖÖÑÕÉ«ÖÐ
|
|
# Windows CMDÃüÁîÐÐ ×ÖÌåÑÕÉ«¶¨Òå text colors
|
FOREGROUND_BLACK = 0x00 # black.
|
FOREGROUND_DARKBLUE = 0x01 # dark blue.
|
FOREGROUND_DARKGREEN = 0x02 # dark green.
|
FOREGROUND_DARKSKYBLUE = 0x03 # dark skyblue.
|
FOREGROUND_DARKRED = 0x04 # dark red.
|
FOREGROUND_DARKPINK = 0x05 # dark pink.
|
FOREGROUND_DARKYELLOW = 0x06 # dark yellow.
|
FOREGROUND_DARKWHITE = 0x07 # dark white.
|
FOREGROUND_DARKGRAY = 0x08 # dark gray.
|
FOREGROUND_BLUE = 0x09 # blue.
|
FOREGROUND_GREEN = 0x0a # green.
|
FOREGROUND_SKYBLUE = 0x0b # skyblue.
|
FOREGROUND_RED = 0x0c # red.
|
FOREGROUND_PINK = 0x0d # pink.
|
FOREGROUND_YELLOW = 0x0e # yellow.
|
FOREGROUND_WHITE = 0x0f # white.
|
|
# Windows CMDÃüÁîÐÐ ±³¾°ÑÕÉ«¶¨Òå background colors
|
BACKGROUND_BLUE = 0x10 # dark blue.
|
BACKGROUND_GREEN = 0x20 # dark green.
|
BACKGROUND_DARKSKYBLUE = 0x30 # dark skyblue.
|
BACKGROUND_DARKRED = 0x40 # dark red.
|
BACKGROUND_DARKPINK = 0x50 # dark pink.
|
BACKGROUND_DARKYELLOW = 0x60 # dark yellow.
|
BACKGROUND_DARKWHITE = 0x70 # dark white.
|
BACKGROUND_DARKGRAY = 0x80 # dark gray.
|
BACKGROUND_BLUE = 0x90 # blue.
|
BACKGROUND_GREEN = 0xa0 # green.
|
BACKGROUND_SKYBLUE = 0xb0 # skyblue.
|
BACKGROUND_RED = 0xc0 # red.
|
BACKGROUND_PINK = 0xd0 # pink.
|
BACKGROUND_YELLOW = 0xe0 # yellow.
|
BACKGROUND_WHITE = 0xf0 # white.
|
|
# get handle
|
std_out_handle = ctypes.windll.kernel32.GetStdHandle(STD_OUTPUT_HANDLE)
|
|
def set_cmd_text_color(color, handle=std_out_handle):
|
Bool = ctypes.windll.kernel32.SetConsoleTextAttribute(handle, color)
|
return Bool
|
|
#reset white
|
def resetColor():
|
set_cmd_text_color(FOREGROUND_RED | FOREGROUND_GREEN | FOREGROUND_BLUE)
|
return
|
|
#°µºìÉ«
|
#dark red
|
def printDarkRed(mess):
|
set_cmd_text_color(FOREGROUND_DARKRED)
|
sys.stdout.write(mess)
|
resetColor()
|
return
|
|
#ºìÉ«
|
#red
|
def printRed(mess, newLine=True):
|
set_cmd_text_color(FOREGROUND_RED)
|
sys.stdout.write(mess)
|
if newLine:
|
sys.stdout.write("\n")
|
resetColor()
|
return
|
|
####################################################################################################
|
|
cfg = ConfigParser.ConfigParser()
|
if os.path.exists("config2.ini"):
|
cfg.read("config2.ini")
|
else:
|
cfg.read("config.ini")
|
ClientRootPath = cfg.get("config", "ClientRootPath")
|
ServerRootPath = cfg.get("config", "ServerRootPath")
|
|
print "ClientRootPath: %s" % ClientRootPath
|
print "ServerRootPath: %s" % ServerRootPath
|
|
ClientRootPathList = [ClientRootPath]
|
for i in xrange(1, 6):
|
if not cfg.has_option("config", "ClientRootPath%s" % i):
|
break
|
ClientRootPathEx = cfg.get("config", "ClientRootPath%s" % i)
|
ClientRootPathList.append(ClientRootPathEx)
|
|
ServerRootPathList = [ServerRootPath]
|
for i in xrange(1, 6):
|
if not cfg.has_option("config", "ServerRootPath%s" % i):
|
break
|
serverRootPathEx = cfg.get("config", "ServerRootPath%s" % i)
|
ServerRootPathList.append(serverRootPathEx)
|
if len(ServerRootPathList) > 1:
|
print "ServerRootPathList: %s" % ServerRootPathList
|
|
ExportSign = ["C", "G", "S", "M", ""]
|
def GetExportSign(value):
|
exportSign = ""
|
upperSign = value.upper().replace(" ", "")
|
for s in upperSign:
|
if s not in ExportSign or s in exportSign:
|
return None
|
exportSign += s
|
return upperSign
|
|
Encoding = "gbk"
|
EncodingSpec = eval(cfg.get("config", "EncodingSpec"))
|
|
def DoExportCfgFile(fileName, exportInfo):
|
encoding = Encoding
|
for e, f in EncodingSpec.items():
|
if fileName in f:
|
encoding = e
|
break
|
sys.setdefaultencoding(encoding)
|
print "----------------------------"
|
filePath = exportInfo[0]
|
clientPath = exportInfo[1]
|
clientFileName = exportInfo[2]
|
serverPath = exportInfo[3]
|
serverFileName = exportInfo[4]
|
pkInfo = exportInfo[5]
|
|
exportContent = __GetFileExportContent(filePath, pkInfo)
|
if not exportContent:
|
return
|
gServerCfg, mServerCfg, serverCfg, clientCfg = exportContent
|
|
if not gServerCfg and not mServerCfg and not serverCfg and not clientCfg:
|
printRed("ÅäÖÃÎļþÎÞЧ£¡%s" % (filePath))
|
return
|
|
print "¿ªÊ¼µ¼±í: %s" % filePath
|
# unicodeÖеġ®\xa0¡¯×Ö·ûÔÚת»»³Égbk±àÂëʱ»á³öÏÖÎÊÌ⣬gbkÎÞ·¨×ª»»'\xa0'×Ö·û
|
# ËùÒÔ£¬ÔÚת»»µÄʱºò±ØÐè½øÐÐһЩǰÖö¯×÷ string.replace(u'\xa0', u' ')
|
if gServerCfg:
|
for ServerRootPath in ServerRootPathList:
|
gServerCfgName = ServerRootPath + "\CoreServerGroup\GameServer\PySysDB" + "\%s.txt" % serverFileName
|
fp = open(gServerCfgName, "w")
|
for c in gServerCfg:
|
fp.write("%s\n" % (c.replace(u'\xa0', u' ')))
|
fp.close()
|
print "µ¼³öGameServer: %s" % gServerCfgName
|
|
if mServerCfg:
|
for ServerRootPath in ServerRootPathList:
|
mServerCfgName = ServerRootPath + "\db\PyMongoDataServer\PySysDB" + "\%s.txt" % serverFileName
|
fp = open(mServerCfgName, "w")
|
for c in mServerCfg:
|
fp.write("%s\n" % (c.replace(u'\xa0', u' ')))
|
fp.close()
|
print "µ¼³öMapServer: %s" % mServerCfgName
|
|
if serverCfg:
|
for ServerRootPath in ServerRootPathList:
|
serverCfgName = ServerRootPath + serverPath + "\%s.txt" % serverFileName
|
fp = open(serverCfgName, "w")
|
for c in serverCfg:
|
fp.write("%s\n" % (c.replace(u'\xa0', u' ')))
|
fp.close()
|
print "µ¼³ö·þÎñ¶Ë: %s" % serverCfgName
|
|
if clientCfg:
|
for ClientRootPath in ClientRootPathList:
|
sys.setdefaultencoding("utf8") # Ç°¶ËĬÈϱàÂë
|
clientCfgName = ClientRootPath + clientPath + "\%s.txt" % clientFileName
|
fp = open(clientCfgName, "w")
|
for c in clientCfg:
|
fp.write("%s\n" % (c.replace(u'\xa0', u' ')))
|
fp.close()
|
print "µ¼³ö¿Í»§¶Ë: %s" % clientCfgName
|
|
return True
|
|
def __GetFileExportContent(filePath, pkInfo):
|
gServerCfg = []
|
mServerCfg = []
|
serverCfg = []
|
clientCfg = []
|
gServerCfgColList = [] # gameServer·þÎñ¶ËÅäÖÃËùÐèÒªµÄÁÐË÷ÒýÁбí
|
mServerCfgColList = [] # mapServer·þÎñ¶ËÅäÖÃËùÐèÒªµÄÁÐË÷ÒýÁбí - ¶îÍâµÄ
|
serverCfgColList = [] # ·þÎñ¶ËÅäÖÃËùÐèÒªµÄÁÐË÷ÒýÁбí
|
clientCfgColList = [] # ¿Í»§¶ËÅäÖÃËùÐèÒªµÄÁÐË÷ÒýÁбí
|
gServerCfgRowList = [] # gameServer·þÎñ¶ËÅäÖÃËùÐèÒªµÄÐÐË÷ÒýÁбí
|
mServerCfgRowList = [] # mapServer·þÎñ¶ËÅäÖÃËùÐèÒªµÄÐÐË÷ÒýÁбí - ¶îÍâµÄ
|
serverCfgRowList = [] # ·þÎñ¶ËÅäÖÃËùÐèÒªµÄÐÐË÷ÒýÁбí
|
clientCfgRowList = [] # ¿Í»§¶ËÅäÖÃËùÐèÒªµÄÐÐË÷ÒýÁбí
|
|
data = xlrd.open_workbook(filePath)
|
table = data.sheet_by_index(0) # ĬÈÏÖ»½âÎöµÚÒ»ÕŹ¤×÷±í
|
nrows = table.nrows # ÐÐÊý
|
ncols = table.ncols # ÁÐÊý
|
if not nrows or not ncols:
|
printRed("ÅäÖÃÎļþÎÞÊý¾Ý£¡%s" % (filePath))
|
return
|
|
# ÕÒ³öÐèÒªµ¼³öµÄÁÐ, SCÅäÖÃÐèÒª×ö¾«È·Æ¥Åä
|
firstRowValuesList = table.row_values(0) # µÚÒ»ÐÐ
|
for col, value in enumerate(firstRowValuesList):
|
if not (isinstance(value, unicode) or isinstance(value, str)):
|
continue
|
upperValue = GetExportSign(value)
|
if upperValue == None:
|
continue
|
if "G" in upperValue:
|
gServerCfgColList.append(col)
|
if "M" in upperValue:
|
mServerCfgColList.append(col)
|
if "S" in upperValue:
|
serverCfgColList.append(col)
|
if "C" in upperValue:
|
clientCfgColList.append(col)
|
|
# ÕÒ³öÐèÒªµ¼³öµÄÐÐ, SCÅäÖÃÐèÒª×ö¾«È·Æ¥Åä
|
firstColValuesList = table.col_values(0) # µÚÒ»ÁÐ
|
for row, value in enumerate(firstColValuesList):
|
if not (isinstance(value, unicode) or isinstance(value, str)):
|
continue
|
upperValue = GetExportSign(value)
|
if upperValue == None:
|
continue
|
if "G" in upperValue:
|
gServerCfgRowList.append(row)
|
if "M" in upperValue:
|
mServerCfgRowList.append(row)
|
if "S" in upperValue:
|
serverCfgRowList.append(row)
|
if "C" in upperValue:
|
clientCfgRowList.append(row)
|
|
# ×î¶àÖ»µ¼Ò»Áеģ¬ÕâÖÖ±íµÚÒ»ÁÐΪµ¼³öÐÐÅäÖÃ
|
if ncols > 1 and (not gServerCfgColList or gServerCfgColList == [0]) and (not mServerCfgColList or mServerCfgColList == [0]) \
|
and (not serverCfgColList or serverCfgColList == [0]) and (not clientCfgColList or clientCfgColList == [0]):
|
gServerCfgColList = []
|
mServerCfgColList = []
|
serverCfgColList = []
|
clientCfgColList = []
|
|
# ×î¶àÖ»µ¼Ò»Ðеģ¬ÕâÖÖ±íµÚÒ»ÐÐΪµ¼³öÁÐÅäÖÃ
|
if (not gServerCfgRowList or gServerCfgRowList == [0]) and (not mServerCfgRowList or mServerCfgRowList == [0]) \
|
and (not serverCfgRowList or serverCfgRowList == [0]) and (not clientCfgRowList or clientCfgRowList == [0]):
|
gServerCfgRowList = []
|
mServerCfgRowList = []
|
serverCfgRowList = []
|
clientCfgRowList = []
|
|
# 1-µÚÒ»ÐÐΪµ¼³öSCÅäÖã»2-µÚÒ»ÁÐΪµ¼³öSCÅäÖã»3-µÚÒ»ÐÐÁоùΪµ¼³öSCÅäÖÃ
|
if (gServerCfgColList or mServerCfgColList or serverCfgColList or clientCfgColList) \
|
and (gServerCfgRowList or mServerCfgRowList or serverCfgRowList or clientCfgRowList):
|
exportType = 3 # ÐÐÁе¼³ö£¬Ê×ÐÐÊ×ÁÐΪµ¼³öÅäÖÃ
|
elif gServerCfgColList or mServerCfgColList or serverCfgColList or clientCfgColList:
|
exportType = 1 # °´Áе¼³ö£¬Ê×ÐÐΪµ¼³öÅäÖÃ
|
elif gServerCfgRowList or mServerCfgRowList or serverCfgRowList or clientCfgRowList:
|
exportType = 2 # °´Ðе¼³ö£¬Ê×ÁÐΪµ¼³öÅäÖÃ
|
# µ±½öÊ×ÁÐΪSCÅäÖÃʱ£¬µ¼³öµÄÁÐΪ³ýÁËÊ×ÁÐÍâµÄÈ«²¿
|
gServerCfgColList = range(1, ncols)
|
mServerCfgColList = range(1, ncols)
|
serverCfgColList = range(1, ncols)
|
clientCfgColList = range(1, ncols)
|
else:
|
printRed('Îļþµ¼³ö¿Í»§¶Ë·þÎñ¶ËSCÅäÖôíÎ󣡽ö¿ÉÒÔÉ趨%sÖеÄÒ»ÖÖ»ò¶àÖÖ×éºÏ£¡' % ExportSign)
|
return
|
|
isFirstRowSC = exportType in [1, 3] # Ê×ÐÐÊÇ·ñSCµ¼³öÅäÖÃ
|
|
cfgKeyList = [] # ËùÓÐÅäÖÃÊý¾ÝµÄÖ÷¼ükeyÁбí, ÓÃÓÚÅжÏÊÇ·ñÖظ´key
|
pkFormat = ""
|
pkColList = [] # Ö÷¼ü×éºÏ×Ö¶ÎÁÐË÷Òý
|
pkList = pkInfo.split("|")
|
for i, pk in enumerate(pkList):
|
pkList[i] = pk.upper()
|
# ×Ö¶ÎÃûÐÐ
|
fieldRow = 2 if isFirstRowSC else 1
|
fieldRowValuesList = table.row_values(fieldRow) # ×Ö¶ÎÃûÐÐ
|
for col, value in enumerate(fieldRowValuesList):
|
if value.upper() in pkList:
|
pkColList.append(col)
|
pkFormat += "%s=%%s, " % value
|
|
# µ±ÐÐΪSCÅäÖÃʱ, ·þÎñ¶ËÌØÊâÐбàºÅ1,3Ðв»µ¼£» ÁÐΪSCÅäÖÃʱ£¬ÓÉÁÐÖ±½ÓÅäÉÏÈ¥, ÕâÀï¾Í²»ÔÙ×ö´¦Àí
|
serverIgnoreRow = [1, 3] if isFirstRowSC else [] # gameServerͨÓÃ
|
|
gServerFormat = "%s" + "\t%s"*(len(gServerCfgColList) - 1)
|
mServerFormat = "%s" + "\t%s"*(len(mServerCfgColList) - 1)
|
serverFormat = "%s" + "\t%s"*(len(serverCfgColList) - 1)
|
clientFormat = "%s" + "\t%s"*(len(clientCfgColList) - 1)
|
|
for row in xrange(nrows):
|
# Ê×ÐÐΪSCÅäÖÃʱ²»µ¼
|
if row == 0 and isFirstRowSC:
|
continue
|
|
rowValuesList = table.row_values(row)
|
# ¸¡µãÐÍתΪint
|
for i, v in enumerate(rowValuesList):
|
if type(v) != float:
|
continue
|
#ÓÅÏÈʹÓÃת×Ö·û´®ºóÔÙÈ¡Õû£¬·ÀÖ¹ÒòΪ¾«¶Èµ¼ÖµÄСÊýÎÊÌâ
|
strV = str(v)
|
if strV.endswith(".0"):
|
strV = strV[:-2]
|
rowValuesList[i] = int(strV)
|
continue
|
intV = int(v)
|
if intV == v:
|
rowValuesList[i] = intV
|
|
isAdd = False
|
if (exportType == 1 or row in gServerCfgRowList) and row not in serverIgnoreRow and gServerCfgColList:
|
isAdd = True
|
gServerCfg.append(gServerFormat % tuple([rowValuesList[i] for i in gServerCfgColList]))
|
|
if (exportType == 1 or row in mServerCfgRowList) and row not in serverIgnoreRow and mServerCfgColList:
|
isAdd = True
|
mServerCfg.append(mServerFormat % tuple([rowValuesList[i] for i in mServerCfgColList]))
|
|
if (exportType == 1 or row in serverCfgRowList) and row not in serverIgnoreRow and serverCfgColList:
|
isAdd = True
|
serverCfg.append(serverFormat % tuple([rowValuesList[i] for i in serverCfgColList]))
|
|
if (exportType == 1 or row in clientCfgRowList) and clientCfgColList:
|
isAdd = True
|
# Ìæ»»µ¼³öµ½¿Í»§¶ËÓõĹ«Ê½ÔËËã·û
|
for col, cfgStr in enumerate(rowValuesList):
|
cfgFormula = __RepalceClientCfgFormula(cfgStr)
|
if cfgFormula is None:
|
printRed("Ìæ»»¹«Ê½Ê§°Ü£¡µÚ%sÐУ¬µÚ%sÁС£" % (row + 1, col + 1))
|
return
|
rowValuesList[col] = cfgFormula
|
if row == 3:
|
# ˵Ã÷ÐУ¬Ìæ»»»»Ðзû£¬·Àֹǰ¶Ë¼ÓÔرí¸ñ±¨´í
|
clientCfg.append(clientFormat % tuple([rowValuesList[i].replace("\r", "").replace("\n", "") for i in clientCfgColList]))
|
else:
|
clientCfg.append(clientFormat % tuple([rowValuesList[i] for i in clientCfgColList]))
|
|
if isAdd and pkColList:
|
cfgKey = pkFormat % tuple([rowValuesList[pkCol] for pkCol in pkColList])
|
if cfgKey in cfgKeyList:
|
printRed("%s KeyÖظ´£º%s, µÚ%sÐС£" % (filePath, cfgKey, row + 1))
|
return
|
cfgKeyList.append(cfgKey)
|
|
return gServerCfg, mServerCfg, serverCfg, clientCfg
|
|
def __RepalceClientCfgFormula(formula):
|
# Ìæ»»µ¼³öµ½¿Í»§¶ËÓõĹ«Ê½, Ö»×öÔËËã·ûÌæ»»¼´¿É
|
if type(formula) not in [str, unicode]:
|
return formula
|
if "(" not in formula and ")" not in formula:
|
return formula
|
if u"£¨" in formula or u"£©" in formula:
|
printRed("¹«Ê½ÖÐÇëʹÓÃÓ¢ÎÄÀ¨ºÅ: %s" % formula)
|
return
|
#print "³õʼ: len=%s, %s" % (len(formula), formula)
|
formula = formula.replace(" ", "")
|
formula = formula.replace("random.random()", "(0;1)")
|
start = 0
|
doCnt = 0
|
while doCnt < 1000:
|
doCnt += 1
|
#print " %s, %s" % (start, formula)
|
right = formula.find(")", start)
|
if right == -1:
|
if "min(" in formula or "max(" in formula or "math.ceil(" in formula or "int(" in formula \
|
or "math.sqrt(" in formula or "pow(" in formula or "random.randint(" in formula:
|
start = 0 # ´ÓÍ·¿ªÊ¼
|
continue
|
else:
|
#print "ûÓпÉÌæ»»µÄÔËËã·ûÁË"
|
break
|
|
f = None
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "min(", 2, "{<[%s!%s]>}")
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "max(", 2, "{<[%s@%s]>}")
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "random.randint(", 2, "{<[%s~%s]>}") # ÐèÔÚint֮ǰ´¦Àí
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "int(", 1, "{<[%s#]>}")
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "math.ceil(", 1, "{<[%s$]>}")
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "math.sqrt(", 1, "{<[%s&]>}")
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "pow(", 2, "{<[%s^%s]>}")
|
|
# ¶¼ÕÒ²»µ½Æ¥ÅäµÄº¯ÊýÇé¿öÏ£¬¾ÍÊÇ´¿´âµÄ()À¨ÆðÀ´¼ÓÇ¿ÔËËãÓÅÏȼ¶µÄ£¬ÏÈÌ滻Ϊ{<[]>}£¬Ö®ºóÔÙͳһ»»»ØÈ¥
|
if f == None:
|
f = __DoReplacePyFunc(formula, right, "(", 1, "{<[%s]>}")
|
|
if f != None:
|
formula = f
|
start = right + 1
|
if doCnt >= 1000:
|
printRed("Ìæ»»¹«Ê½Ö´ÐдÎÊýÒì³£: %s" % formula)
|
return
|
|
formula = formula.replace("{<[", "(")
|
formula = formula.replace("]>}", ")")
|
#print "Ìæ»»½á¹û: %s" % formula
|
return formula
|
|
def __DoReplacePyFunc(formula, right, funcStr, funcParamCnt, replaceStr):
|
## Ìæ»»pyÔËË㺯ÊýΪ¿Í»§¶Ë¿ÉÓøñʽ
|
left = formula.rfind(funcStr, 0, right) # ´ÓºóÍùÇ°ÕÒ³öµÚÒ»¸öÆ¥ÅäµÄº¯Êý
|
if left == -1:
|
return
|
pyFuncStr = formula[left:right + 1]
|
paramStr = pyFuncStr[len(funcStr):-1]
|
if "(" in paramStr or ")" in paramStr:
|
#print " º¯Êý²ÎÊýÄÚÈÝÀïÓжàÓàÀ¨ºÅ²»´¦Àí: %s, %s" % (pyFuncStr, paramStr)
|
return
|
|
# ûÓвÎÊýµÄpyº¯ÊýÔÚ¿ªÊ¼Ö±½Ó¾«×¼Ìæ»»£¬Èç random.random()
|
if funcParamCnt == 2:
|
commaIndex = paramStr.find(",") # ¶ººÅË÷Òý
|
return formula.replace(pyFuncStr, replaceStr % (paramStr[:commaIndex], paramStr[commaIndex + 1:]))
|
elif funcParamCnt == 1:
|
return formula.replace(pyFuncStr, replaceStr % paramStr)
|
|
return
|
|
def Main():
|
print 'Number of arguments:', len(sys.argv), 'arguments.'
|
# ÔªËØ0Ϊ×ÔÉíÄ£¿éÃû£¬²»´¦Àí£¬´ÓÔªËØ1¿ªÊ¼´¦Àí
|
reload(sys)
|
sys.setdefaultencoding(Encoding)
|
|
exportDict = {}
|
for filePath in sys.argv[1:]:
|
|
fileBaseName = os.path.basename(filePath) # ÎļþÃû£¬º¬À©Õ¹Ãû
|
fileExtension = os.path.splitext(filePath)[-1] # À©Õ¹Ãû
|
fileName = fileBaseName.replace(fileExtension, "") # ²»º¬À©Õ¹Ãû
|
|
# Ö»´¦ÀíexcelÎļþ
|
if "xls" not in fileExtension:
|
printRed("²»´¦Àí¸ÃÎļþ,ÔÝʱֻµ¼excelÎļþ£¡%s" % filePath)
|
continue
|
exportDict[fileName] = filePath
|
|
clientFileNameList = []
|
serverFileNameList = []
|
exportInfoDict = {}
|
exportMapFile = open("TableExportMap.txt", 'r')
|
for line in exportMapFile.readlines():
|
#if not exportDict:
|
# break
|
exportMapInfo = line.split('\t')
|
fileName = exportMapInfo[0]
|
clientFileName = exportMapInfo[2]
|
serverFileName = exportMapInfo[4]
|
|
if clientFileName in clientFileNameList:
|
printRed("µ¼³öÇ°¶ËÎļþÃûÖظ´£¡%s -> %s" % (fileName, clientFileName))
|
return
|
if clientFileName and clientFileName != "-":
|
clientFileNameList.append(clientFileName)
|
|
if serverFileName in serverFileNameList:
|
printRed("µ¼³ö·þÎñ¶ËÎļþÃûÖظ´£¡%s -> %s" % (fileName, serverFileName))
|
return
|
if serverFileName and serverFileName != "-":
|
serverFileNameList.append(serverFileName)
|
|
if fileName not in exportDict:
|
continue
|
filePath = exportDict.pop(fileName)
|
exportInfoDict[fileName] = [filePath] + exportMapInfo[1:]
|
exportMapFile.close()
|
|
if exportDict:
|
for filePath in exportDict.values():
|
printRed("ÇëÅäÖÃÅäÖÃ±íµ¼³ö·¾¶£¡%s" % filePath)
|
return
|
|
exportCount = 0
|
for fileName, exportInfo in exportInfoDict.items():
|
if not DoExportCfgFile(fileName, exportInfo):
|
printRed("µ¼±íʧ°Ü! %s" % fileName)
|
break
|
exportCount += 1
|
|
print "----------------------------"
|
print "³É¹¦µ¼±íÊý: %s" % exportCount
|
print "----------------------------"
|
return
|
|
if __name__ == "__main__":
|
Main()
|
|
