Escaping special characters in filepaths using SQLAlchemy

I'm storing filenames and filepaths in MySQL. Retrieving them from the database using LIKE expressions requires that I escape all allowed filename chars that collide with MySQL special chars. I'm happy to simply use Python's string.replace() method, but was wondering if there was a more standard or built-in method of sanitizing filepaths with SQLAlchemy or dealing with filepaths in MySQL in general.

I need the solution to be OS-agnostic and established. It does not need to be implemented in SA开发者_如何学Python. I'll accept any procedure for encoding that works; failing that, I need a list of all chars that need to be escaped and a smart choice of an escape char.

SQLAlchemy do sanitize for you if you will use regular queries. Maybe the problem that you use like clause. Like require addition escape for such symbols: _%. Thus you will need replace methods if you want to quote like expression.

Why do you need to escape the file paths? As far as you are not manually writing select / insert queries, SQLAlchemy will take care of the escaping when it generates the query internally.

The file paths can be inserted as they are into the database.

As I know there isn’t what you are looking for in SQLAlchemy. Just go basestring.replace() method by yourself.

You don't need do anything SQLAlchemy will do it for you.