# 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