Created on Wed Aug 5 00:00:15 2020 @author: sysadmin """ import dtcfg as cfg import pandas as pd import os, base64 def myDecode(encStr): return base64.b64decode(encStr).decode() if __name__ == '__main__': t0 = cfg.timeStart() localSQL= cfg.MSSQL(cfg.host, cfg.user, cfg.pwd, cfg.lcdb) localSQL.Connect() if not localSQL.isConnect: print(localSQL.host + ' not connect') else: #load sql file sqlword="SELECT * FROM pyFileDT" fdata= pd.read_sql(sqlword, con=localSQL.conn) listFile= os.listdir() for inde in fdata.index: fileName= fdata.loc[inde, 'file_name'] +'.py' sqlmtime= fdata.loc[inde, 'mtime'] if fileName== 'loadPyFile.py': continue if not fileName in listFile or int(os.stat(fileName).st_mtime)< sqlmtime: ftxt= myDecode(fdata.loc[inde, 'file_content'])
Created on Mon Aug 3 09:06:12 2020 @author: Administrator """ import pandas as pd import random import time as ti import dtcfg as cfg from WindPy import w w.start() if __name__ == '__main__': t0 = cfg.timeStart() localSQL= cfg.MSSQL(cfg.host, cfg.user, cfg.pwd, cfg.lcdb) localSQL.Connect() recordSQL= cfg.MSSQL(cfg.host, cfg.user, cfg.pwd, cfg.rcddb) recordSQL.Connect() if not localSQL.isConnect: print(localSQL.host + ' not connect') elif not recordSQL.isConnect: print(recordSQL.host + ' not connect') else: listDate= localSQL.getDate('TFDT') srData=pd.DataFrame() for tdate in listDate: if tdate< cfg.startDate: continue #tdate= listDate[0] print('dealing date: %d, time elapsed: %.2f min'% (tdate, (ti.time() - t0)/60))