SQL Alchemy ORM returning a single column, how to avoid common post processing

by

One way to decrease the clutter in the source is to iterate like this:

results = [r for (r, ) in results]

Although this solution is one character longer than using the [] operator, I think it’s easier on the eyes.

For even less clutter, remove the parenthesis. This makes it harder when reading the code, to notice that you’re actually handling tuples, though:

results = [r for r, in results]

More Related Contents:

  1. Efficiently updating database using SQLAlchemy ORM
  2. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  3. SQLAlchemy ManyToMany secondary table with additional fields
  4. Bulk insert with SQLAlchemy ORM
  5. How can I verify Column data types in the SQLAlchemy ORM?
  6. SQLAlchemy: engine, connection and session difference
  7. sqlalchemy: create relations but without foreign key constraint in db?
  8. SQLAlchemy: how to filter date field?
  9. flask-sqlalchemy or sqlalchemy
  10. How to update sqlalchemy orm object by a python dict
  11. Is possible to mapping view with class using mapper in SqlAlchemy?
  12. SQLALchemy dynamic filter_by
  13. SQLAlchemy ordering by count on a many to many relationship
  14. SQLAlchemy: print the actual query
  15. SQLAlchemy create_all() does not create tables
  16. Python call sql-server stored procedure with table valued parameter
  17. Generate sql with subquery as a column in select statement using SQLAlchemy
  18. Complex foreign key constraint in SQLAlchemy
  19. What is choice_set in this Django app tutorial?
  20. Connection problems with SQLAlchemy and multiple processes
  21. How to upsert pandas DataFrame to Microsoft SQL Server table?
  22. How do i cast char to integer while querying in django ORM?
  23. Relations on composite keys using sqlalchemy
  24. flake8 complains on boolean comparison “==” in filter clause
  25. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  26. How to set connection timeout in SQLAlchemy
  27. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  28. SQLAlchemy classes across files
  29. How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?
  30. flask sqlalchemy query with keyword as variable

Leave a Comment