sqldsn

:synopsis: Prints Data Source Name connection string on stdout

Supported Databases

Currently the following databases are supported:

• PostgreSQL (psycopg2, psycopg3, or postgis)
• Sqlite3
• MySQL

Patches to support other databases are welcome! :-)

Supported Styles

Currently the following databases are supported:

+----------+------------+-------+---------+---------------------------+ | Style | PostgreSQL | MySQL | Sqlite3 | Description | +==========+============+=======+=========+===========================+ | args | | Y | | command-line arguments | +----------+------------+-------+---------+---------------------------+ | filename | | | Y | filename | +----------+------------+-------+---------+---------------------------+ | keyvalue | Y | Y | | key-value pairs (legacy) | +----------+------------+-------+---------+---------------------------+ | kwargs | Y | | | Python keyword arguments | +----------+------------+-------+---------+---------------------------+ | pgpass | Y | | | .pgpass format | +----------+------------+-------+---------+---------------------------+ | uri | Y | Y | Y | (See dj-database-url) | +----------+------------+-------+---------+---------------------------+

Exit Codes

Exit status is 0 unless invalid options were given.

Example Usage

::

Prints the DSN for the default database

$ ./manage.py sqldsn

::

Prints the DSN for all databases

$ ./manage.py sqldsn --all

::

Print the DSN for database named 'slave'

$ ./manage.py sqldsn --database=slave

::

Print all DSN styles available for the default database

$ ./manage.py sqldsn --style=all

::

Print the URI for the default database

$ ./manage.py sqldsn -q --style=uri

::

Create .pgpass file for default database by using the quiet option

$ ./manage.py sqldsn -q --style=pgpass > .pgpass