Writing a connection string when password contains special characters

by

Backslashes aren’t valid escape characters for URL component strings. You need to URL-encode the password portion of the connect string:

from urllib import quote_plus as urlquote
from sqlalchemy.engine import create_engine
engine = create_engine('postgres://user:%s@host/database' % urlquote('badpass'))

If you look at the implementation of the class used in SQLAlchemy to represent database connection URLs (in sqlalchemy/engine/url.py), you can see that they use the same method to escape passwords when converting the URL instances into strings, and that the parsing code uses the complementary urllib.unquote_plus function to extract the password from a connection string.

More Related Contents:

  1. Best way to convert string to bytes in Python 3?
  2. Reading a UTF8 CSV file with Python
  3. How to convert SQLAlchemy row object to a Python dict?
  4. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  5. SQLAlchemy IN clause
  6. A good way to get the charset/encoding of an HTTP response in Python
  7. Flask SQLAlchemy query, specify column names
  8. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  9. SQLAlchemy ORM conversion to pandas DataFrame
  10. How to disable SQLAlchemy caching?
  11. The smtplib.server.sendmail function in python raises UnicodeEncodeError: ‘ascii’ codec can’t encode character
  12. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  13. How to create an SQL View with SQLAlchemy?
  14. How to update SQLAlchemy row entry?
  15. SQLAlchemy: cascade delete
  16. sqlalchemy unique across multiple columns
  17. How to create a new database using SQLAlchemy?
  18. How to unquote a urlencoded unicode string in python?
  19. SQLAlchemy ManyToMany secondary table with additional fields
  20. Multi-threaded use of SQLAlchemy
  21. How to get column names from SQLAlchemy result (declarative syntax)
  22. How to discover table properties from SQLAlchemy mapped object
  23. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  24. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  25. creating a database outside the application context
  26. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  27. pandas to_sql all columns as nvarchar
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Can’t change system default SQLite binary
  30. add column to SQLAlchemy Table

Leave a Comment