Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
An alternative approach to drop all tables in django project
# Alternative approach.
import os
import MySQLdb
print 'drop remaining tables...'
for name, db in settings.DATABASES.iteritems():
conn = MySQLdb.connect( db['HOST'], db['USER'], db['PASSWORD'], db['NAME'] )
c = conn.cursor()
c.execute('SET FOREIGN_KEY_CHECKS=0');
c.execute('SHOW TABLES')
for table in c.fetchall():
print '\t', table[0]
c.execute('DROP TABLE %s' % table[0])
c.execute('SET FOREIGN_KEY_CHECKS=1');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment