python数据库特殊字符转义_用于MySQL的转义字符串Python

qq_笑_17

使用sqlalchemy的text函数删除特殊字符的解释：请注意text("your_insert_statement")以下功能的使用。它所做的是与sqlalchemy交流，传入字符串中的所有问号和百分号都应视为文字。import sqlalchemyfrom sqlalchemy import textfrom sqlalchemy.orm import sessionmakerfrom datetime import datetimeimport reengine = sqlalchemy.create_engine("mysql+mysqlconnector://%s:%s@%s/%s"     % ("your_username", "your_password", "your_hostname_mysql_server:3306",     "your_database"),     pool_size=3, pool_recycle=3600)conn = engine.connect()myfile = open('access2.log', 'r')lines = myfile.readlines()penguins = []for line in lines:   elements = re.split('\s+', line)   print "item: " +  elements[0]   linedate = datetime.fromtimestamp(float(elements[0]))   mydate = linedate.strftime("%Y-%m-%d %H:%M:%S.%f")   penguins.append(text(     "insert into your_table (foobar) values('%%%????')"))for penguin in penguins:    print penguin    conn.execute(penguin)conn.close()