[db-dump] don't create tarball on failed dump, properly remove temporary directory
"""
:organization: Logilab
:copyright: 2001-2009 LOGILAB S.A. (Paris, FRANCE), license is LGPL v2.
:contact: http://www.logilab.fr/ -- mailto:contact@logilab.fr
:license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses
"""
if confirm('remove deprecated database constraints?'):
execute = session.system_sql
session.set_pool()
dbhelper = session.pool.source('system').dbhelper
cu = session.pool['system']
for table in dbhelper.list_tables(cu):
if table.endswith('_relation'):
try:
execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey1' % (table, table))
execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey2' % (table, table))
except:
continue
checkpoint()
if 'inline_view' in schema:
# inline_view attribute should have been deleted for a while now....
drop_attribute('CWRelation', 'inline_view')