首先我非常确定各个参数是没错的
然后我试过给各个参数加上名称 例如 host=self.host 也是不行
CODE:
def __init__(self, host=None, username=None, password=None, database=None, config_file=None, dbms="mysql"):
"""
Class constractor
:param host:
:param username:
:param password:
:param database:
"""
self._host = host
self._username = username
self._password = password
self._database = database
self._run_transaction = None
if config_file:
self.get_mysql_credentials(config_file, dbms)
def get_mysql_credentials(self, configfile, dbms):
"""
Retrieve credentials from configuration file
:param configfile: path to
:param dbms: default is mysql
:return: VOID
"""
try:
if configfile:
cOnfig= configparser.ConfigParser()
config.read(configfile)
self._host = config[dbms]['host']
self._username = config[dbms]['username']
self._password = config[dbms]['password']
self._database = config[dbms]['database']
self._run_transaction = config[dbms]['transactions']
except:
print("Error: couldn't read config file")
def connect(self, database=None):
"""
Connect to a existing database
:param database: name
:return: the connection handler
"""
try:
if database: # if is not Null
self._database = database
cOnnection= pymysql.connect(self._host, self._username, self._password, self._database)
return connection
except pymysql.InternalError as error:
print(error.args[1])
config_file:::
[mysql]
host = localhost
username = root
password = passwordForCSC675
database = PharmacyManagementSystemDB
transactiOns= 1
然后我试过给各个参数加上名称 例如 host=self.host 也是不行
CODE:
def __init__(self, host=None, username=None, password=None, database=None, config_file=None, dbms="mysql"):
"""
Class constractor
:param host:
:param username:
:param password:
:param database:
"""
self._host = host
self._username = username
self._password = password
self._database = database
self._run_transaction = None
if config_file:
self.get_mysql_credentials(config_file, dbms)
def get_mysql_credentials(self, configfile, dbms):
"""
Retrieve credentials from configuration file
:param configfile: path to
:param dbms: default is mysql
:return: VOID
"""
try:
if configfile:
cOnfig= configparser.ConfigParser()
config.read(configfile)
self._host = config[dbms]['host']
self._username = config[dbms]['username']
self._password = config[dbms]['password']
self._database = config[dbms]['database']
self._run_transaction = config[dbms]['transactions']
except:
print("Error: couldn't read config file")
def connect(self, database=None):
"""
Connect to a existing database
:param database: name
:return: the connection handler
"""
try:
if database: # if is not Null
self._database = database
cOnnection= pymysql.connect(self._host, self._username, self._password, self._database)
return connection
except pymysql.InternalError as error:
print(error.args[1])
config_file:::
[mysql]
host = localhost
username = root
password = passwordForCSC675
database = PharmacyManagementSystemDB
transactiOns= 1
