Two Offline Win10 Python processes to operate in a docker container - Python experience required.
Docker experience required. MySQL experience required.
Win10 environment required. If you have not read the brief before responding we will not interview you.
Process 1 - Fetch Email Instruction - Run every 60 seconds:
- Login to EMAIL - Load next unread email in with SUBJECT = 'XXXXXX'
- Read new unread Email with XML body into memory with ORDERID/# + customised fields
- Update order status progress in remote MySQL eg: PROCESSING STEP 1 of X
- Lookup fields from body and query remote MySQL
- Create Concatenate job list with from mail body
- Create Job Script files utilising provided template with email provided parameters
- Validate job script files
- Update order status progress in MySQL eg: PROCESSING STEP 2 of X
- Move Job files to 'jobready' folder (If error - Send email to Error Handling email address with any created files attached) - Update order status progress in MySQL eg: PROCESSING STEP 2e of X
Process 2 - Run every 90 seconds:
- If Job Script and Job file list exists
- Move Job files into into execution folder
- Update order status progress in MySQL eg: PROCESSING STEP 3 of X
- Execute Job
- review output
- If successful
- Upload/Move file to archive location
- Update order status progress in MySQL eg: PROCESSING STEP 4 of X
- Move Job files into completed folder named ( Produced-MMM-YY)
- Ftp/Upload/Move job output file (video) to designated host or googledrive
- Update order status progress in MySQL eg: PROCESSING STEP 5 of X - Generate short link
- If error
-send email to Error Handling email address with any created files
- Update order status progress in MySQL eg: PROCESSING STEP 5e of X
So in summary I am looking to set up two periodic processes.
1) poll to read the next unread email, process the fields as input and create a command line script (like a batch file) then place the created script in a specific folder depending on the email fields and update a remote MySQL database.
and
2) poll a folder, execute a custom script created in step 1) , check the output is created, move the script to a done folder, ftp the mp4 output to a website, create a tinurl, update the MySQL,
Code must be documented
Must work on Windows 10 Docker 17.03
Payment on installation, configuration and testing of Python scripts in Docker container on Win10 machine.
About the recuiterMember since Aug 30, 2017 Adam S.
from Maryland, United States