[IMP] registry: check existence of tables with a single SQL query

1 files changed, 7 insertions, 0 deletions

diff --git a/odoo/tools/sql.py b/odoo/tools/sql.py
index 2772d99e3e7..6c783fe27e7 100644
--- a/odoo/tools/sql.py
+++ b/odoo/tools/sql.py
@@ -21,6 +21,13 @@ _CONFDELTYPES = {
     'SET DEFAULT': 'd',
 }
 
+def existing_tables(cr, tablenames):
+    """ Return the names of existing tables among ``tablenames``. """
+    query = """ SELECT table_name FROM information_schema.tables
+                WHERE table_name IN %s AND table_schema != 'information_schema' """
+    cr.execute(query, [tuple(tablenames)])
+    return [row[0] for row in cr.fetchall()]
+
 def table_exists(cr, tablename):
     """ Return whether the given table exists. """
     query = "SELECT 1 FROM information_schema.tables WHERE table_name=%s AND table_schema != 'information_schema'"