How to save multiple objects from a script in django shell

Question

Hello colleagues I would like to know if this list of objects can be saved from a script like the one I show, I want to execute it from the django shell

python3 manage.py shell < script.py

the following is my script

from orders_management.models import Products


objects = [
    'Products(name = "destornillador", section = "ferrreteria", price = 35)',
    'Products(name = "balon", section = "deportes", price = 25)',
    'Products(name = "raqueta", section = "deportes", price = 105)',
    'Products(name = "muneca", section = "juguetes", price = 15)',
    'Products(name = "tren electrico", section = "jugueteria", price = 135)',
]

for object in objects:
    my_product = object
    my_product.save()

the error it shows me

  File "<string>", line 15, in <module>
AttributeError: 'str' object has no attribute 'save'

user11718531 · Accepted Answer · 2021-05-02 20:33:27Z

1

That is because you have products wrapped in a string. Try it this way (without quotations around the products):

objects = [
    Products(name = "destornillador", section = "ferrreteria", price = 35),
    Products(name = "balon", section = "deportes", price = 25),
    Products(name = "raqueta", section = "deportes", price = 105),
    Products(name = "muneca", section = "juguetes", price = 15),
    Products(name = "tren electrico", section = "jugueteria", price = 135),
]

for object in objects:
    my_product = object
    my_product.save()

answered May 2, 2021 at 20:33

user11718531

Sign up to request clarification or add additional context in comments.

1 Comment

user11718531 Over a year ago

@AldoMatus If that is the case, could you accept my or Williem's answer?

willeM_ Van Onsem · Accepted Answer · 2021-05-02 20:34:00Z

0

You wrote 'Products()' between single quotes, so as a string, not as a Product object.

Furthermore you better use .bulk_create(…) [Django-doc] instead of saving each object manually, since that will do it in a single query:

from orders_management.models import Products

objects = [
    # no '…'
    Products(name = "destornillador", section = "ferrreteria", price = 35),
    Products(name = "balon", section = "deportes", price = 25),
    Products(name = "raqueta", section = "deportes", price = 105),
    Products(name = "muneca", section = "juguetes", price = 15),
    Products(name = "tren electrico", section = "jugueteria", price = 135),
]

Products.objects.bulk_create(objects)

Note: normally a Django model is given a singular name, so Product instead of ~~Products~~.

answered May 2, 2021 at 20:34

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

1 Comment

Aldo Matus Over a year ago

IT WORKED! THANKS A LOT FRIEND Willem Van Onsem

Collectives™ on Stack Overflow

How to save multiple objects from a script in django shell

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related