Python连接Mysql数据库

#!/usr/bin/python
#-*- coding: utf-8 -*-

import MySQLdb
import os
import time
import sys



'''
Created on 2016年9月1日

desc:检查传入的IP列表是否已经部署


@author: tingyu
'''

conn= MySQLdb.connect(
        host='132.121.130.18',
        port = 3306,
        user='root',
        passwd='hdp123',
        db ='test',
        )
cur = conn.cursor()




'''
根据IP列表文件路径，读取文件内的IP列表，判断该IP是否已经部署成功，如果已经部署成功则跳过
'''

logfile = os.getcwd() + os.sep + "deployIp.log"

def check(path):
    createLogFile(logfile)
    f = open(logfile, 'a')
    for line in open(path):
        if line is not None and line !='':
            line = line.strip('\n')
            line = line.strip(' ')
            print '当前处理的ip是: %s' % line
            sql = "select * from mondo_all where deploy_success='Y' and ip='"+line+"'"
            time.sleep(1)
            cunt = cur.execute(sql)
            if cunt ==0:
                f.write(line + '\n');
    f.close()
   

def createLogFile(logpath):
    print logpath
    try:   
        if os.path.isfile(logpath):
            os.remove(logpath)
        else:
            f = file(logpath,'w')
            f.close()
    except:
        print '创建日志文件出错.........'
                  
   

if __name__ == '__main__':
    iplist = 'G:\ips.txt'
    if len(sys.argv)==2:
        iplist = sys.argv[1]
        if os.path.isfile(iplist):
            check(iplist)
        else:
            print 'IP列表文件路径错误.......'
       
    else:
        print '参数不对,请重新输入命令'
        print 'uage:  python deployIp.py ip_file_path'