Expected duration: 1 - 2 weeks Two independent Offline Win10 Dockerised Python process 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/# - 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 file utilising provided template - Export Job Info XML file - Update order status progress in MySQL eg: PROCESSING STEP 2 of X - Move Job files to execution 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 and 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 into execution folder - Move job output file (audio or video) to designated host / 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. If you have not read the brief before responding we will not interview you.
