background

Recently I met a need , Need to export a lot of data , But I didn't write the data export program . The most important thing is that the program given by the manufacturer can only support seven days at most （ Must choose to spit lees ）, It takes about ten minutes to write locally . I made a rough calculation , The average day is 1 Thousands of data , Let me guide the data for three years , If manual operation is used, the construction period is estimated to be 10 Days or so , So I decided to use python Tool class in pywinauto To achieve .

（1） Ideas

I need the program to automatically send pc End exe File system fill in start time 、 End time 、 Then automatically click Start exporting Button to start the export , then 10 Minutes later Starting time = End time +1, End time = End time +6, Then set the maximum time , When the maximum time is less than the end time , This task is over .

(2) Environment building

（1）python3.6
 Copy code 

(3) Code implementation

"""
 Classification of window controls ：
   status bar ：StatusBar             Static content ：Static
   Button ：Button                 Check box ：CheckBOX
   Radio buttons ：RadioButton          Group box ：GroupBOX
   Combo box ：ComboxBox            Dialog box ( window )：Dialog
   Edit bar ：Edit                 Head content ：Header
   List box ：ListBox              List display control ：ListView
   Pop up menu ：PopupMenu          Tab controls ：TabControl
   The toolbar ：Toolbar              The tool tip ：ToolTips
   Tree view ：Tree View         Menu： menu 
  Menultem： A menu item             Pane： Panes 
"""

from pywinauto import Application
import time
import datetime
import configparser

# os.system("pause")
#sys.setdefaultencoding('utf-8')
#  start-up  navicat
# app = Application("uia").start(r"F:\exportData\RealBaseToPostgre.exe")
cf = configparser.ConfigParser()
cf.read("config.ini",encoding='utf-8-sig')
secs = cf.sections()  #  Get all of the section( There can be multiple configurations in a configuration file , Such as database related configuration , Mailbox related configuration ,secs = cf.sections()  #  Get all of the section( There can be multiple configurations in a configuration file , Such as database related configuration , Mailbox related configuration ,
                     # Every section from [] The parcel , namely [section]), And return... As a list 
path=cf.get("info","path")
sleepTime = cf.get("info", "sleep")
initime = cf.get("info", "initime")
app = Application("uia").start(r""+path)
print(' wait for :',initime,' Second program initialization complete ')
startDate=cf.get("info","startDate")
endDate=cf.get("info","endDate")
id=cf.get("info","id")
maxDate = cf.get('info','maxDate')
maxDate = (datetime.datetime.strptime(str(maxDate), "%Y-%m-%d") + datetime.timedelta(days=0)).strftime("%Y-%m-%d")
print(maxDate)
count = 0
#print('1:',startDate,endDate)
while (True):
   if (endDate >= maxDate):
       endDate = maxDate
       print(' The end date has exceeded the maximum date , Now set the value of the end date to the maximum date ！')
   print('The count is:', count)
   count = count + 1
   #  Select the window through the window title 
   dlg = app["TN8000 Old and new data conversion program "]
   edit = dlg['Edit']
   edit2 = dlg['Edit1']
   edit1 = dlg['Edit2']
   edit3 = dlg['Edit3']
   # edit.type_keys('edit')
   # send_keys(Keys.SPACE)
   edit1.type_keys(startDate+"{SPACE}00:00:00")
   edit2.type_keys(endDate+"{SPACE}23:59:59")
   edit3.type_keys(id)
   button1 = dlg[" Start exporting "]
   button1.click()

   print(' The Export button has been clicked , Now wait :', sleepTime, ' second ！')
   time.sleep(int(sleepTime))# Sleep x Second 

   ## Starting time +1
   mStartDate = (datetime.datetime.strptime(str(endDate), "%Y-%m-%d") + datetime.timedelta(days=1)).strftime(
       "%Y-%m-%d")
   ## End time 7 God 
   mEndate = (datetime.datetime.strptime(str(endDate), "%Y-%m-%d") + datetime.timedelta(days=1)).strftime("%Y-%m-%d")

   startDate=mStartDate
   # endDate=startDate
   endDate=mEndate
   #print('2:', startDate, endDate)
   if(startDate>maxDate):
       print(' The start date has exceeded the maximum date , End of preparation ......')
       break

   # datetime.datetime.strptime(str(startDate), "%Y-%m-%d") + datetime.timedelta(days=1).strftime("%Y-%m-%d")
   # endDate=datetime.datetime.strptime(str(startDate), "%Y-%m-%d")+datetime.timedelta(days=1).strftime("%Y-%m-%d")
   # print (endDate)
print("Good bye!")



# # button_close = dlg[' close ']
# dlg = app["TN8000 Old and new data conversion program "]
# #  Print all controls in the window 
# dlg.print_control_identifiers()
# # print(dlg.print_control_identifiers())
 Copy code 

Train of thought explanation

1. adopt Application start-up xx.exe file , And then through exe The file selects the interface control of the window through the window title , You can get... First dlg.print_control_identifiers() All controls , After finding the corresponding control name, you can operate on the control .

(4)config.ini To configure

[info]
path=F:\exportData\xx.exe
startDate=2018-01-01
endDate=2018-01-06
#maxDate=2021-05-01
maxDate=2021-05-01
id=1
max=4
sleep=120
# Program initialization time seconds 
initime = 10
configPath=config.ini
 Copy code 

（5） effect

（5） Compile and package as .exe file

explain : I met a little pit here , In the end, I choose cx-freeze To package as exe file , The specific operation is as follows ：

（1） install cx-freeze plug-in unit

（2） pack

cmd Go to the project directory .\venv\Scripts.., Copy path first , Like my path ：F:\PythonWorkSpace\untitled3\venv\Scripts\cxfreeze.exe

stay Terminal Open the input ：

F:\PythonWorkSpace\untitled3\venv\Scripts\cxfreeze.exe winauto.py --target-dir dist
 Copy code 

among target-dir dist Means to store the packaged files in the current directory dist Next , The effect is as follows :

end: Finally, we double-click exe File ready to run .