想封装个类来作为读写数据库的类,然后就报错了
class mysql_tools():
def __init__(self, baseinfo):
print(baseinfo)
self.host = baseinfo.split('-')[2]
self.user = baseinfo.split('-')[0]
self.password = baseinfo.split('-')[1]
self.database = baseinfo.split('-')[3]
self.dbinfo = "mysql+pymysql://" + self.user + ":" + self.password + "@" + self.host + "/" + self.database + "?charset=utf8"
def get_sql_data(self, sql):
mydb = mysql.connector.connect(HOST=self.host, USER=self.user, PASSWORD=self.password, DATABASE=self.database)
cursor = mydb.cursor()
print(sql)
cursor.execute(sql)
result = cursor.fetchall()
return result
if __name__ == '__main__':
tl = mysql_tools(baseinfo="marker-123456-localhost-markdata")
print(tl.dbinfo)
re = tl.get_sql_data("select * from stock_all_oneday_data")
print(re)
Traceback (most recent call last):
File "C:/Users/connect_mysql.py", line 50, in
re = tl.get_sql_data("select * from stock_all_oneday_data")
File "C:/Users/connect_mysql.py", line 39, in get_sql_data
mydb = mysql.connector.connect(HOST=self.host,USER=self.user,PASSWORD=self.password,DATABASE=self.database)
File "D:\anaconda3\lib\site-packages\mysql\connector\__init__.py", line 264, in connect
return CMySQLConnection(*args, **kwargs)
File "D:\anaconda3\lib\site-packages\mysql\connector\connection_cext.py", line 80, in __init__
self.connect(**kwargs)
File "D:\anaconda3\lib\site-packages\mysql\connector\abstracts.py", line 963, in connect
self.config(**kwargs)
File "D:\anaconda3\lib\site-packages\mysql\connector\abstracts.py", line 502, in config
raise AttributeError("Unsupported argument '{0}'".format(key))
AttributeError: Unsupported argument 'HOST'
没想明白