Convert data from db to json in python?

Question

Flask

Good
Is there a library to convert strings from the database to json format, otherwise I haven’t figured out how to collect it with handles yet, the output should be like this, the column name and the string value

Answer 1

select json_agg(tablename) from tablename;
Everything. Get json array.

Answer 2

https://marshmallow.readthedocs.io/en/latest/
https://flask-marshmallow.readthedocs.io/en/latest/

Answer 3

json.loads?

Answer 4

I think something like this:

connecror.exec("SELECT * FROM table")
json.dumps(connector.fetchall())

fetchall() - will return an iterable array of strings, where each string is an associative array - which is a ready structure for the dumps() function.
You only need to configure so that there is no duplication of names by their serial numbers - but this is already setting up the connector and connecting to the database.