我的技术生活-王炜™

#!/usr/local/python/bin/python
#encoding=utf-8
#description:backup the publish book resource
#author Aaron wang
import datetime,os
from sys import argv
import MySQLdb
def download():
        mydb=MySQLdb.connect(host=”192.168.1.1″,user=”root”,passwd=”root”,db=”online”,charset=”utf8″)
        cursor=mydb.cursor()
        cursor.execute(“select a.part_file,a.original_part_file from book_parts a,books b where a.id=b.id and b.status=’published’ “)
        n=cursor.fetchall() 

        for i in n:
                a=[]
                a.append(argv[1]+”/”+i[0])
                a.append(argv[1]+”/”+i[1])
                for row in a:
                        fname=os.popen(‘basename’+” “+row).readlines()
                        dname=os.popen(‘dirname’+” “+row).readlines()
                        os.popen(‘mkdir -p’+” “+argv[2]+”/”+dname[0])
                        os.popen(‘cp’+” “+row+” “+argv[2]+”/”+row)
                a=[]
                row=[]
                cursor.close()
def tar():
        today=datetime.date.today().strftime(‘%Y%m%d’)
        os.popen(‘cd’+” “+argv[2]+’ &&’+” “+’tar czf books’+today+’.tgz .’)
def usage():
        print “error:the parameter is empty!\nuasge:python ttools.py source destination\nexample:python ttools.py /ty/media /tmp”
if __name__==’__main__’:
        if len(argv) !=3:
                usage()
        else:
                download()
                tar()