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 |
|
||
uri |
Y |
Y |
Y |
(See |
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