几天来,我一直在尝试用MySQL运行一些代码来填充我已经创建的数据库。最初运行时,我得到了错误1251:“客户端不支持服务器请求的身份验证协议;请考虑升级MySQL客户端”。在我找到的MySQL文档和堆栈溢出答案中,我被引导将默认的insecureAuth设置从默认的false更改为true。这是我目前使用的代码...
import datetime
import MySQLdb as mdb
from math import ceil
def obtain_btc():
now = datetime.datetime.utcnow()
symbols = ['BTC', 'Crypto', 'Bitcoin', 'No Sector', 'USD', now, now]
return symbols
def insert_btc_symbols(symbols, insecureAuth):
db_host = 'localhost'
db_user = 'natrob'
db_pass = '**********'
db_name = 'securities_master'
con = mdb.connect(host=db_host,user=db_user,passwd=db_pass,db=db_name,{insecureAuth:true})
column_str = "ticker, instrument, name, sector, currency, created_date, last_updated_date"
insert_str = (("%s, ")*7)[:2]
final_str = ("INSERT INTO symbols (%s) VALUES (%s)" % (column_str,insert_str))
print (final_str,len(symbols))
with con:
cur = con.cursor()
for i in range(0,int(ceil(len(symbols)/100.0))):
cur.executemany(final_str,symbols[i*100:(i+1)*100-1])
if __name__ == "__main__":
symbols = obtain_btc()
insert_btc_symbols(symbols)
我最近收到一个错误:"non-keyword arg after keyword arg“。我试图切换顺序,但没有成功,这让我相信我可能没有正确地更改默认设置。任何帮助或建议都是非常感谢的。谢谢。
https://stackoverflow.com/questions/50978144
复制相似问题