Execute bulk insert with sqlalchemy and mysql

Question

I am creating dynamically a bulk insert query. In my application I use sqlAlchemy and I would like to execute that insert.

The problem lies when I am creating the query. I want to insert data that contain special characters that should be escaped.

Using MysqlDb module there is a function MySQLdb.escape_string that escapes the special characters but unfortunately does not work for Unicode characters.

What are my options?

I want to notice that it is not easy to create the query as

q = INSERT INTO table (a, b) VALUES (:a1, :b1), (:a2, :b2) 
q_dict = {(a1, b1), (a2, b2)}

so I can execute Session.execute(q, q_dict) .

Is there a python function that accepts a string and escapes all characters that need escapting for Mysql?

Imagine that I want to create write a file to disk and then execute it through mysql console.

Giorgos Komnino · Accepted Answer · 2012-09-12 09:21:17Z

1

Here is the solution :

First get a DBAPi connection

 connection = engine. raw_connection()

And then you can escape the string v using:

 connection.escape(v)

answered Sep 12, 2012 at 9:21

Giorgos Komnino

4431 gold badge9 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute bulk insert with sqlalchemy and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related