python mysql 转义_用于MySQL的转义字符串Python

使用sqlalchemy的text函数删除特殊字符的解释：

请注意text("your_insert_statement")以下功能的使用。它所做的是与sqlalchemy交流，传入字符串中的所有问号和百分号都应视为文字。

import sqlalchemy

from sqlalchemy import text

from sqlalchemy.orm import sessionmaker

from datetime import datetime

import re

engine = 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()