import MySQLdb
import ConfigParser
class Mysql2Mysql(object):
def getConn(self,filename,dbname):
cf = ConfigParser.ConfigParser()
cf.read(filename)
db_host=cf.get(dbname,'db_host')
db_user=cf.get(dbname,'db_user')
db_pass=cf.get(dbname,'db_pass')
db_name= cf.get(dbname,'db_name')
db_port= cf.get(dbname,'db_port')
db_char=cf.get(dbname,'db_char')
try:
conn=MySQLdb.connect(host=db_host,port=int(db_port),user=db_user,passwd=db_pass,db=db_name)
return conn
except Exception as e:
print str(e)
return -1
def closeDB(self,conn):
try:
if conn:
conn.close()
import ConfigParser
class Mysql2Mysql(object):
def getConn(self,filename,dbname):
cf = ConfigParser.ConfigParser()
cf.read(filename)
db_host=cf.get(dbname,'db_host')
db_user=cf.get(dbname,'db_user')
db_pass=cf.get(dbname,'db_pass')
db_name= cf.get(dbname,'db_name')
db_port= cf.get(dbname,'db_port')
db_char=cf.get(dbname,'db_char')
try:
conn=MySQLdb.connect(host=db_host,port=int(db_port),user=db_user,passwd=db_pass,db=db_name)
return conn
except Exception as e:
print str(e)
return -1
def closeDB(self,conn):
try:
if conn:
conn.close()