I would like to save each dictionary as a separate instance of a db model using sqlalchemy.
I tried
JavaScript
x
12
12
1
from models.ordermodels import OrderModel, OrderItemsModel
2
3
for dic in request.cartItems:
4
order_item_a = OrderItemsModel(
5
name=dic.name,
6
quantity=dic.quantity,
7
price=dic.price,
8
order_id=x,
9
)
10
11
db.add(order_item_a)
12
in output
JavaScript
1
13
13
1
"cartItems": [
2
{
3
"name": "string",
4
"quantity": 0,
5
"price": 0
6
},
7
{
8
"name": "string",
9
"quantity": 110,
10
"price": 0
11
}
12
]
13
It only saves the last item , I want to save all the item in database. I’m using Postgresql
Advertisement
Answer
I’m pretty sure that only the last item is saved because you only save the last item.
You probably wrote something like this:
JavaScript
1
12
12
1
from models.ordermodels import OrderModel, OrderItemsModel
2
3
for dic in request.cartItems:
4
order_item_a = OrderItemsModel(
5
name=dic.name,
6
quantity=dic.quantity,
7
price=dic.price,
8
order_id=x,
9
)
10
11
db.add(order_item_a)
12
when in fact you should have written this:
JavaScript
1
12
12
1
from models.ordermodels import OrderModel, OrderItemsModel
2
3
for dic in request.cartItems:
4
order_item_a = OrderItemsModel(
5
name=dic.name,
6
quantity=dic.quantity,
7
price=dic.price,
8
order_id=x,
9
)
10
11
db.add(order_item_a)
12