def update_cg_StockOrderD(self, param, flag, my_time):
log_time = tLog.write_redis_log('cg_StockOrderD', '', 0)
print "Begin---{},Time:{},IN:{}".format("cg_StockOrderD",
datetime.now(), len(param))
objs, GoodsSKUIDs, StockOrderNID = self.getPyInfo(param, flag)
try:
if flag:
# insertSQL = "REPLACE INTO py_db.cg_stockorderd(GoodsSKUID,Amount,StockOrderNID,NID) VALUES (%s,%s,%s,%s)"
# public_obj = public(self.db_conn, self.sqlserver_conn)
# public_obj.commitmanyFun(objs, insertSQL)
# insertSQL = "REPLACE INTO py_db.cg_stockorderd(NID) VALUES ({})".format(Max_NID)
# cursor = self.db_conn.cursor()
# cursor.execute(insertSQL)
# cursor.execute('commit')
pass
if objs:
len_obj = len(objs)
else:
len_obj = 0
print "End---{},Time:{},OUT:{}".format("cg_StockOrderD",
datetime.now(), len_obj)
tLog.write_redis_log('cg_StockOrderD', log_time, len_obj)
if GoodsSKUIDs:
cg_StockInD_obj = cg_StockInD(self.db_conn,
self.sqlserver_conn)
cg_StockInD_objs, cg_StockInM_objs = cg_StockInD_obj.update_cg_StockInD(
GoodsSKUIDs, flag, my_time)
public_obj = public(self.db_conn, self.sqlserver_conn)
SKUList = public_obj.getSKU(GoodsSKUIDs)
return SKUList, objs, cg_StockInD_objs, cg_StockInM_objs, GoodsSKUIDs, StockOrderNID
except MySQLdb.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def update_P_TradeUn(self, NIDs):
print "开始更新{0}".format("P_TradeUn")
objs = self.getPyInfo(NIDs)
sql = "REPLACE INTO py_db.P_TradeUn(NID,SUFFIX,ORDERTIME,AMT,SALESTAX ) VALUES (%s,%s,%s,%s,%s)"
public_obj = public(self.db_conn, self.sqlserver_conn)
public_obj.commitmanyFun(objs, sql)
print "结束更新{0}".format("P_TradeUn")
def setHqLog(self, objs):
try:
insertSql = "REPLACE INTO py_db.B_GoodsLogs VALUES (%s,%s,%s,%s)"
public_obj = public(self.db_conn, self.sqlserver_conn)
public_obj.commitmanyFun(objs, insertSql)
except MySQLdb.Error, e:
#print "Mysql Error %d: %s" % (e.args[0], e.args[1])
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def setHqOP(self, SKUList):
SKUListTmp = []
# print SKUList
for SKU in SKUList:
SKU = SKU + ',3'
SKU = SKU.split(',')
SKUListTmp.append(SKU)
# for SKU in SKUList:
insertSql = "REPLACE INTO t_product_puyuan_op (sku,status) VALUES (%s,%s)"
public_obj = public(self.db_conn)
public_obj.commitmanyFun(SKUListTmp, insertSql)
def update_P_TradeDtUn(self, NIDs):
print "开始更新{0}".format("P_TradeDtUn")
objs = self.getPyInfo(NIDs)
sql = "REPLACE into py_db.P_TradeDtUn(NID,TradeNID,L_EBAYITEMTXNID,L_NAME,L_NUMBER,L_QTY,L_SHIPPINGAMT,L_HANDLINGAMT,L_CURRENCYCODE," \
"L_AMT,L_OPTIONSNAME,L_OPTIONSVALUE,L_TAXAMT,SKU,CostPrice,AliasCnName,AliasEnName,Weight,DeclaredValue," \
"OriginCountry,OriginCountryCode,BmpFileName,GoodsName,GoodsSKUID,StoreID,eBaySKU,L_ShipFee,L_TransFee," \
"L_ExpressFare,BuyerNote) VALUES (%s,%s,%s,%s,%s,%s," \
"%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
public_obj = public(self.db_conn, self.sqlserver_conn)
public_obj.commitmanyFun(objs, sql)
print "结束更新{0}".format("P_TradeDtUn")
def update_P_trade(self, TradeNIDs):
objs = self.getPyInfo(TradeNIDs)
print "开始更新{0}".format("P_trade")
if objs:
sql = "Replace INTO py_db.P_trade(NID,SUFFIX,ORDERTIME,AMT,SALESTAX) VALUES (%s,%s,%s,%s,%s)"
public_obj = public(self.db_conn, self.sqlserver_conn)
public_obj.commitmanyFun(objs, sql)
print "结束更新{0}".format("P_trade")
else:
print "{0}更新失败".format("P_trade")
def getPyLog(self):
objs = []
NID = self.getMaxNID()
if self.sqlserver_conn and NID:
sqlcursor = self.sqlserver_conn.cursor()
selectsql = "SELECT NID,GoodsCode,Operator,Logs from B_GoodsLogs(nolock) WHERE NID > %s "
try:
sqlcursor.execute(selectsql, NID)
public_obj = public()
objs = public_obj.fetchmanyFun(sqlcursor)
return objs
except pymssql.Error, e:
print "pymssql Error %d: %s" % (e.args[0], e.args[1])
def setHqOP(self, SKUList):
cursor = self.db_conn.cursor()
SKUListTmp = []
try:
if SKUList:
# print SKUList
for SKU in SKUList:
SKU = SKU + ',1'
SKU = SKU.split(',')
SKUListTmp.append(SKU)
# for SKU in SKUList:
insertSql = "REPLACE INTO t_product_puyuan_op (sku,status,Op_time) VALUES (%s,%s,'{0}')".format(
datetime.now())
public_obj = public(self.db_conn, self.sqlserver_conn)
public_obj.commitmanyFun(SKUListTmp, insertSql)
except MySQLdb.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def getPyLog(self):
objs = []
MaxNID = ''
NID = self.getMaxNID()
if self.sqlserver_conn and NID:
sqlcursor = self.sqlserver_conn.cursor()
selectsql = "SELECT NID,OrderNID from CG_StockLogs(nolock) WHERE NID > %s "
MaxNIDsql = "SELECT MAX(NID) from CG_StockLogs(nolock) WHERE NID > %s "
try:
sqlcursor.execute(selectsql, NID)
public_obj = public()
objs = public_obj.fetchmanyFun(sqlcursor)
sqlcursor.execute(MaxNIDsql, NID)
MaxNID = sqlcursor.fetchone()[0]
if not MaxNID:
MaxNID = NID
return objs, MaxNID
except MySQLdb.Error, e:
print "MySQLdb Error %d: %s" % (e.args[0], e.args[1])
def getPyLog(self):
print "获取普源日志开始时间：{0}".format(datetime.now())
objs = []
NID = self.getMaxNID()
if self.sqlserver_conn and NID:
sqlcursor = self.sqlserver_conn.cursor()
# selectsql = "SELECT NID,TradeNID,Operator,Logs from P_TradeLogs WHERE NID > %s "
selectsql = "SELECT NID,TradeNID from P_TradeLogs WHERE NID > %s"
while True:
try:
print "execute开始{0}".format(datetime.now())
sqlcursor.execute(selectsql, NID)
print "execute结束{0}".format(datetime.now())
public_obj = public()
objstmp = public_obj.fetchmanyFun(sqlcursor)
except pymssql.Error, e:
print "pymssql Error %d: %s" % (e.args[0], e.args[1])
else:
print "获取普源日志结束时间：{0}".format(datetime.now())
objs = objstmp
print len(objs)
break
return objs
def setHqLog(self, objs):
print "开始更新{0}".format("P_TradeLogs")
sql = "REPLACE INTO py_db.P_TradeLogs (NID,TradeNID) VALUES (%s,%s)"
public_obj = public(self.db_conn)
public_obj.commitmanyFun(objs, sql)
print "结束更新{0}".format("P_TradeLogs")
def __init__(self, db_conn, sqlserver_conn):
self.db_conn = db_conn
self.sqlserver_conn = sqlserver_conn
self.public_obj = public(self.db_conn, self.sqlserver_conn)
#!/usr/bin/env python
from cgi import *
# me
from dict import *
from public import *
POST = dict()
fs = FieldStorage()
for k in fs.keys():
v = fs[k].value
POST[k] = v
public(POST)
if __name__=="__main__":
pass
#!/usr/bin/env python
from dict import *
from get import *
from post import *
from public import *
REQUEST = dict()
REQUEST.update(GET)
REQUEST.update(POST)
public(REQUEST)
if __name__ == "__main__":
pass
#!/usr/bin/env python
from git.config import GitConfigParser # GitPython dist
from conf import *
from fullpath import *
from public import *
@public
class Gitconfig(Conf):
read_only = False
def __init__(self,path,read_only=False):
self.read_only = read_only
path = fullpath(path)
parser = GitConfigParser(path,read_only=self.read_only)
Conf.__init__(self,path=path,parser=parser)
def write(self):
self.parser.write()
gitconfig = Gitconfig("~/.gitconfig",True)
public(gitconfig)
if __name__=="__main__":
print(gitconfig)
print("section: %s" % gitconfig.sections)
print("gitconfig.init.templatedir: %s" % gitconfig.init.templatedir)
print("not_existing: %s" % gitconfig.not_existing)
#!/usr/bin/env python from dict import * from get import * from post import * from public import * REQUEST = dict() REQUEST.update(GET) REQUEST.update(POST) public(REQUEST) if __name__=="__main__": pass