Python...LOVE IT!

the_Grinch

For the first time at work they are looking to automate basically everything we do. Our current project involves a lot of pieces, but once completed the insight we'll gain will be game changing (as noted by our consultant, if successful we will have done something no one else does). For my part, I needed to write a program (or script) that connects to a secure ftp, downloads a zip file, unzips said file, and confirms that the file containing the sha1 of the report was created within 3 minutes of the report being generated. Ultimately, if it fails, I will move the failed file to a folder and we'll generate an alert off of it. Below is my code:

#!/usr/bin/python
#This program will connect to the denoted ftp, download the required zip files
#unzip the files and then confirm that the checksum was performed within 3 minutes
#of the file being created
#Created by
#
#This program will connect to the ftp and download the required files
#Required ftp module, zip module, os module
import pysftp
import os

#This connects to the ftp with the username and password provided
srv = pysftp.Connection(host="host",username="",password="")

#Have to change to the correct directory
srv.chdir("public")

#File we need to download
srv.get("test.zip")

#Closes the ftp connection
srv.close()

print "File downloaded successfully"

#This will unzip the file after downloading
os.system("unzip test.zip")

print "Files extracted"


#This program will look for a difference in the creation time of the files

#This gets the time in seconds of the original files creation time
org = os.stat('file1').st_mtime

#This gets the time in seconds of the checksum file
csfile = os.stat('file2').st_mtime

#This gets the difference and alerts if it is over 180 seconds
tdiff = csfile - org

print tdiff

#Test to see if time is 3 minutes or less
if tdiff <= 180:
print "Time difference in file is equal to or less then 3 minutes"
else:
print "Time difference in file is greater then 3 minutes"

A little more background. The files need to be zipped because if they were downloaded directly from the FTP the times would change. By being zipped they maintain their creation times. Mtime is used because it only changes when the data within the file has been modified. Also, mtime shows the creation date in the form of seconds so that I can actually do the math.

Thexzeno

on the same boat here as well, i started learning python during my 1 year unemployment hiatus and never thought id use it during my job. Well i recently got my first it job at a help desk and lo and behold i managed to create a script that cuts of 30 secs from call time by automating the process pinging the 2nd lvl team through mscommunicator or lync2010.

I honestly suggest everyone take the time to learn python as its easy to read,very easy to learn and has a robust community with API'S for basically every application. if you do enough research i dont believe theres nothing you couldnt automate.


Also, looking at your code you should add a variable for user input that specifies the zipfile to be downloaded


for example:


Print "Please input name of the zipfile blahblahblah"
Zip_file = input() #it'll be raw_input if using python 2.7 i use 3 though

#File we need to download
srv.get(Zip_file)


not sure if youve already thought of that or what your requirements for the script are exactly though