[client] database=xxx user=xx password=xx port=3306 host=xxx
python-db配置文件
标签：char port 配置文件 dict igp def pwd exce import
python-db配置文件
!/usr/bin/python27
# -*- encoding: utf-8 -*-
import sys
import ConfigParser
import MySQLdb
import MySQLdb.cursors
cf = ConfigParser.ConfigParser()
cf.read("/tmp/report/dbs.conf")
ouser = cf.get(‘client‘,‘user‘)
opwd = cf.get(‘client‘,‘password‘)
ohost = cf.get(‘client‘,‘host‘)
oport = cf.get(‘client‘,‘port‘)
odb = cf.get(‘client‘,‘database‘)
def mysqlLib(sql,host=ohost,port=oport,db=odb,user=ouser,pwd=opwd):
try:
con = MySQLdb.connect(host, user,pwd, db,charset="utf8");
cur = con.cursor()
cur.execute(sql)
data = cur.fetchall()
con.close()
return data
except Exception as e:
print e
def mysqlDictLib(sql,host=ohost,port=oport,db=odb,user=ouser,pwd=opwd):
try:
con = MySQLdb.connect(host, user,pwd, db,cursorclass = MySQLdb.cursors.DictCursor,charset="utf8");
cur = con.cursor()
cur.execute(sql)
data = cur.fetchall()
con.close()
return data
except Exception as e:
print e
if __name__ == ‘__main__‘:
sql = ‘select name from members where id in (select member_id from member_tags where tags_id=199 ) limit 5 ‘
# db = mysqlLib(sql)
db = mysqlDictLib(sql)
print db[0]["name"]