sqldsn
======

:synopsis: Prints Data Source Name connection string on stdout



Supported Databases
-------------------

Currently the following databases are supported:

* PostgreSQL (psycopg2 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