python使用配置表连接mysql进行数据查询、删除、修改

#cfg.py

#!usr/bin/env python

# -*-coding:utf-8-*-

import os

import sys

reload(sys)

sys.setdefaultencoding('utf-8')

db_host = 'ip'

db_port = 3360

db_user = 'X1'

db_passwd = 'X2'

db_name = 'X3'

****************************************************************************

*****************************************************************************

#调用cfg

import  cfg

def clear_today_data(createdata):

      conn = MySQLdb.connect(

                 host = cfg.db_host,

                 port = cfg.db_port,

                 user = cfg.db_user,

                 passwd = cfg.db_passwd,

                 db = cfg.db_name,

                 charset='utf-8'

                     )

        cur = conn.cursor()

       delete_sql = "delete from %s.table_name where pdate <=%s" %(cfg.db_name, createdata)

       cur.execute(delete_sql)

       conn.commit()

      cur.close()

     conn.close()