0

tried this but return list of all columns and data in tuple format i need data in key value pairs

records = cursor.fetchall()
field_names = [i[0] for i in cursor.description]
print(field_names)
for value in records:
    print(value)

output:

['client', 'engine', 'entity_name', 'attr_name', 'attr_type', 'attr_sql', 'attr_description', 'data_column', 'format_json', 'sort_json']
('bashas', 'benchmark', 'summary', 'day_part', 'D', 'summary.day_part', 'Day Part', 'day_part', None, None)
Barmar
  • 669,327
  • 51
  • 454
  • 560
Mayur Gupta
  • 41
  • 1
  • 6

0 Answers0