[django] check if db table exists

gistfile1.py

"""
Came up with this for satchmo's downloadable product migration, 0001_split.
"""
def db_table_exists(table, cursor=None):
    try:
        if not cursor:
            from django.db import connection
            cursor = connection.cursor()
        if not cursor:
            raise Exception
        table_names = connection.introspection.get_table_list(cursor)
    except:
        raise Exception("unable to determine if the table '%s' exists" % table)
    else:
        return table in table_names

FYI, In newer Django versions (at least 1.4) you can also do:

def db_table_exists(table_name):
    return table_name in connection.introspection.table_names()

Thanks for the tip! 😁

You're welcome. :-) Great to have such feedback!

Very helpful, thanks!

connection.introspection.table_names() is also available in django 1.3

👍

6 years later, this is is still helping people out! Thanks a lot

It's helpful~ thanks.

It helps thank you!!!!

Use of connection has been deprecated. This appears to be the most up to date version of this check:

from django.db import connections

def table_exists(table_name: str, connection_name: str) -> bool:
    return table_name in connections[connection_name].introspection.table_names()