How do I select literal values in an sqlalchemy query?

by

You’ll need to use a literal_column, which looks a bit like this:

sqlalchemy.orm.Query(Item, sqlalchemy.sql.expression.literal_column("0"))

Beware that the text argument is inserted into the query without any transformation; this may expose you to a SQL Injection vulnerability if you accept values for the text parameter from outside your application. If that’s something you need, you’ll want to use bindparam, which is about as easy to use; but you will have to invent a name:

sqlalchemy.orm.Query(Item, sqlalchemy.sql.expression.bindparam("zero", 0))

More Related Contents:

  1. How to convert SQLAlchemy row object to a Python dict?
  2. jsonify a SQLAlchemy result set in Flask [duplicate]
  3. Using OR in SQLAlchemy
  4. SQLAlchemy ORM conversion to pandas DataFrame
  5. SQLAlchemy: unexpected results when using `and` and `or`
  6. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  7. sqlalchemy: how to join several tables by one query?
  8. How to create an SQL View with SQLAlchemy?
  9. How to update SQLAlchemy row entry?
  10. Serve image stored in SQLAlchemy LargeBinary column
  11. SQLAlchemy: cascade delete
  12. How to create a new database using SQLAlchemy?
  13. When do I need to use sqlalchemy back_populates?
  14. SQLAlchemy ManyToMany secondary table with additional fields
  15. Can SQLAlchemy be used with Google Cloud SQL?
  16. Updates to JSON field don’t persist to DB
  17. ImportError: No module named MySQLdb
  18. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  19. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  20. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  21. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  22. creating a database outside the application context
  23. How to close a SQLAlchemy session?
  24. How to get number of affected rows in sqlalchemy?
  25. Using SQLAlchemy models in and out of Flask
  26. Is possible to mapping view with class using mapper in SqlAlchemy?
  27. SQLAlchemy column name with space
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. using sqlalchemy to load csv file into a database
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment