330 """ Drop and store table constraints and indexes """ |
330 """ Drop and store table constraints and indexes """ |
331 indexes, constraints = self._dbh.application_indexes_constraints(tablename) |
331 indexes, constraints = self._dbh.application_indexes_constraints(tablename) |
332 for name, query in constraints.items(): |
332 for name, query in constraints.items(): |
333 sql = 'INSERT INTO cwmassive_constraints VALUES (%(e)s, %(c)s, %(t)s)' |
333 sql = 'INSERT INTO cwmassive_constraints VALUES (%(e)s, %(c)s, %(t)s)' |
334 self.sql(sql, {'e': tablename, 'c': query, 't': 'constraint'}) |
334 self.sql(sql, {'e': tablename, 'c': query, 't': 'constraint'}) |
335 sql = 'ALTER TABLE %s DROP CONSTRAINT %s CASCADE' % (tablename, name) |
335 sql = 'ALTER TABLE %s DROP CONSTRAINT %s' % (tablename, name) |
336 self.sql(sql) |
336 self.sql(sql) |
337 for name, query in indexes.items(): |
337 for name, query in indexes.items(): |
338 sql = 'INSERT INTO cwmassive_constraints VALUES (%(e)s, %(c)s, %(t)s)' |
338 sql = 'INSERT INTO cwmassive_constraints VALUES (%(e)s, %(c)s, %(t)s)' |
339 self.sql(sql, {'e': tablename, 'c': query, 't': 'index'}) |
339 self.sql(sql, {'e': tablename, 'c': query, 't': 'index'}) |
340 sql = 'DROP INDEX %s' % name |
340 sql = 'DROP INDEX %s' % name |