Search code examples
pythondjangodjango-settings

how can I check database connection to mysql in django


how can I do it?

I thought, I can read something from database, but it looks too much, is there something like?:

settings.DATABASES['default'].check_connection()

Solution

  • All you need to do is start a application and if its not connected it will fail. Other way you can try is on shell try following -

    from django.db import connections
    from django.db.utils import OperationalError
    db_conn = connections['default']
    try:
        c = db_conn.cursor()
    except OperationalError:
        connected = False
    else:
        connected = True