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