Expected duration: 3 - 4 weeks 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 attached - 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.