I have this code in my ORM
def insert(self, rows: dict):
field_names = rows.keys()
assert all(row.keys() == field_names for row in rows) # confirm that all rows have the same fields
fields_format = ", ".join(field_names)
values_placeholder_format = ", ".join([f'({", ".join(["%s"] * len(field_names))})'] * len(
rows))
query = f"INSERT INTO {self.model_class.table_name} ({fields_format}) " \
f"VALUES {values_placeholder_format}"
params = list()
for row in rows:
row_values = [row[field_name] for field_name in field_names]
params += row_values
self._execute_query(query, params)
And i have my dict,which i need to insert into my DB, but when i do this,i have an error 'str' object has no attribute 'keys'. This is my dict
{'AED': 3.67304, 'AFN': 88.494599, 'ALL': 116.95, 'AMD': 405.10373, 'ANG': 1.808175, 'AOA': 431.25095, 'ARS': 142.87505, 'AUD': 1.486241, 'AWG': 1.8, 'AZN': 1.7, 'BAM': 1.960624, 'BBD': 2}