How to quote a string value explicitly (Python DB API/Psycopg2)

by

Ok, so I was curious and went and looked at the source of psycopg2. Turns out I didn’t have to go further than the examples folder 🙂

And yes, this is psycopg2-specific. Basically, if you just want to quote a string you’d do this:

from psycopg2.extensions import adapt

print adapt("Hello World'; DROP DATABASE World;")

But what you probably want to do is to write and register your own adapter;

In the examples folder of psycopg2 you find the file ‘myfirstrecipe.py’ there is an example of how to cast and quote a specific type in a special way.

If you have objects for the stuff you want to do, you can just create an adapter that conforms to the ‘IPsycopgSQLQuote’ protocol (see pydocs for the myfirstrecipe.py-example…actually that’s the only reference I can find to that name) that quotes your object and then registering it like so:

from psycopg2.extensions import register_adapter

register_adapter(mytype, myadapter)

Also, the other examples are interesting; esp. ‘dialtone.py’ and ‘simple.py’.

More Related Contents:

  1. Pandas read_sql with parameters
  2. Passing table name as a parameter in psycopg2
  3. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  4. Getting the SQL from a Django QuerySet [duplicate]
  5. Django: Adding “NULLS LAST” to query
  6. LEFT JOIN Django ORM
  7. How to set up a PostgreSQL database in Django
  8. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  9. How to see the raw SQL queries Django is running?
  10. How to log all sql queries in Django?
  11. How to perform OR condition in django queryset?
  12. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  13. What is the best way to access stored procedures in Django’s ORM
  14. How to delete a record in Django models?
  15. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  16. Django MEDIA_URL and MEDIA_ROOT
  17. Multiple ModelAdmins/views for same model in Django admin
  18. how to iterate through dictionary in a dictionary in django template?
  19. Django Model Field Default Based Off Another Field in Same Model
  20. Django multi tenancy
  21. Django – How to make a variable available to all templates?
  22. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  23. Unexpected NoReverseMatch error when using include() in urls patterns
  24. Django override save for model only in some cases?
  25. How to execute “left outer join” in SqlAlchemy
  26. Django DoesNotExist
  27. Django – New fonts?
  28. Install mysqlclient for Django Python on Mac OS X Sierra
  29. Django admin: How to display the field marked as “editable=False” in the model?
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment