diff options
| author | Jeremy Kersten <jke@odoo.com> | 2016-01-08 18:41:31 +0100 |
|---|---|---|
| committer | Jeremy Kersten <jke@odoo.com> | 2016-01-08 19:14:31 +0100 |
| commit | 774879a69cb304b53fa709b6166e5e6bb83d0205 (patch) | |
| tree | bf8c9ae3690c8e54bce372fe4501aed34ddcfd1e /openerp/tools/sql.py | |
| parent | aabe0cb8fe86673463be3da5510b38af34c32804 (diff) | |
[ADD] tools: add escape_psql function
By default, Odoo support _ and % in domain to search like in pgsql.
But if you want to search something starting by _ or containing %
the developper need to escape these character.
Diffstat (limited to 'openerp/tools/sql.py')
| -rw-r--r-- | openerp/tools/sql.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/openerp/tools/sql.py b/openerp/tools/sql.py index 9ce64906896..709edcf4538 100644 --- a/openerp/tools/sql.py +++ b/openerp/tools/sql.py @@ -4,3 +4,6 @@ def drop_view_if_exists(cr, viewname): cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,)) cr.commit() + +def escape_psql(to_escape): + return to_escape.replace('\\', r'\\').replace('%', '\%').replace('_', '\_') |