Python psycopg2 how to get data and pass in json

import json
import psycopg2
from psycopg2 import sql
from psycopg2.extras import NamedTupleCursor

from datetime import datetime

class PostgreSQL:

def get_all_data(self):
“” “Returning key-value pair” “”
with self.connect.cursor(cursor_factory=psycopg2.extras.RealDictCursor) as cursor:
self.connect.autocommit = True

query = ‘SELECT * FROM stocks ORDER BY date DESC’
cursor.execute(query)

fetch = cursor.fetchall()

# Create new List and Dicts inside it
dic = {}
stocks = [[]
for stock in fetch:
dic[[‘currency’] = stock[[‘currency’],
dic[[‘price’] = stock[[‘price’],
dic[[‘quantity’] = stock[[‘quantity’],
dic[[‘date’] = stock[[‘date’].strftime(“% Y-% m-% d% H:% M:% S”)
stocks.append(dic.copy())

# Sort by date where last row would be last date (just in case)
stocks = sorted(
stocks,
key=lambda x: datetime.strptime(x[[‘date’], ‘% Y-% m-% d% H:% M:% S’), reverse=False
)

return jsondumps(stocks, separators=(‘,’, ‘:’))

Code parsing

connect.cursor

We need to get the object in the form of a dictionary for further processing: