How to serialize SqlAlchemy result to JSON?

by

You could just output your object as a dictionary:

class User:
   def as_dict(self):
       return {c.name: getattr(self, c.name) for c in self.__table__.columns}

And then you use User.as_dict() to serialize your object.

As explained in Convert sqlalchemy row object to python dict

More Related Contents:

  1. Updates to JSON field don’t persist to DB
  2. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  3. Convert Json File to data Frame
  4. How to parse data in JSON format?
  5. Python JSON serialize a Decimal object
  6. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  7. What’s the best way to parse a JSON response from the requests library?
  8. NumPy array is not JSON serializable
  9. How to execute raw SQL in Flask-SQLAlchemy app
  10. SQLAlchemy: print the actual query
  11. Query for list of attribute instead of tuples in SQLAlchemy
  12. Where’s my JSON data in my incoming Django request?
  13. How to give column name dynamically from string variable in sql alchemy filter?
  14. How to remove whitespaces and newlines from every value in a JSON file?
  15. Python call sql-server stored procedure with table valued parameter
  16. How can I verify Column data types in the SQLAlchemy ORM?
  17. Complex foreign key constraint in SQLAlchemy
  18. How can I loop over entries in JSON?
  19. How to upsert pandas DataFrame to Microsoft SQL Server table?
  20. How can I parse (read) and use JSON?
  21. SQLAlchemy: engine, connection and session difference
  22. JSON object must be str, bytes or bytearray, not dict
  23. How to append to a JSON file in Python?
  24. Relations on composite keys using sqlalchemy
  25. flake8 complains on boolean comparison “==” in filter clause
  26. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  27. Rendering JSON objects using a Django template after an Ajax call
  28. Single versus double quotes in json loads in Python
  29. SQLAlchemy classes across files
  30. flask sqlalchemy query with keyword as variable

Leave a Comment