Django: Insert row into database

Question

I'm new in Django. I've created a table by insert model into models.py.

Now, I want to insert a row into the database - table Dodavatel. I know, that I have to create an object with attributes as columns. But I don't know where should I put this code. In models.py?

This is my model:

class Dodavatel(models.Model):
    nazov = models.CharField(default='', max_length=255)
    dostupnost = models.IntegerField(default=0)

This is the code for inserting a row:

p = Dodavatel(nazov='Petr', dostupnost=1)
p.save()

Where should I put this code?

Create the database by running a "python manage.py syncdb" first. Then, you can add rows according to your model. Normally this is done in the View functions. — Freek Wiekmeijer
– Freek Wiekmeijer, Commented May 26, 2014 at 11:23

Radek Simko · Accepted Answer · 2014-05-26 12:02:52Z

48

If you only want to quick test your models you can start an interactive shell and execute your code there.

python manage.py shell

The above command starts a python interactive shell initialized with your Django project settings.

Then you can do something like:

from your_app_name.models import Dodavatel
p = Dodavatel(nazov='Petr', dostupnost=1)
p.save()

I do not recommend to use that code directly inside a view. Instead to create an item I would use a class based view like CreateView.

edited May 26, 2014 at 12:02

Radek Simko

16.2k18 gold badges74 silver badges110 bronze badges

answered May 26, 2014 at 11:35

Luca

1,1181 gold badge13 silver badges19 bronze badges

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

2 Comments

Milano Over a year ago

I write a script, which would inserting rows into the database. So this is in my script.py: views.add_Dodavatel("petr", 1) and this is in views.py: def add_Dodavatel(nazov,dostupnost): p = Dodavatel(nazov=nazov, dostupnost=dostupnost) p.save() But when I run the script.py I get error: File "C:\Python27\lib\site-packages\django\db\models\base.py", line 92, in new kwargs = {"app_label": model_module.__name__.split('.')[-2]} IndexError: list index out of range

Luca Over a year ago

You should not call a function from your views.py inside a script manually executed. Views should be called by django request-response cycle. If you want to create a script to insert bulk data in your db you should look at: docs.djangoproject.com/en/dev/howto/custom-management-commands

lava · Accepted Answer · 2022-02-07 09:06:00Z

2

For manual inserting data to table for testing purpose

Method1

Execute this command for creating Dodavatel in the database

 python manage.py makemigrations


 python manage.py migrate

Now you can see the table created in the database

Then type for open python project REPL:

python manage.py shell

add this code in the repl

from everych.cheese.models import Dodavatel

 dodavel = Dodavatel.objects.create(nazov="hi", dostupnost=3)

You can use python manage.py shell_plus instead of python manage.py shell.so you didn't want to add the line from everych. cheese. models import Dodavatel it automatically imported.

here everych my project name

cheese is the application name

change as your project and application name

After the above code is executed data will be inserted into the table output:-

Method2

Here just inserting data you must add a table using the above step.

python manage.py shell_plus

code

dat = Dodavatel(nazov="Petr", dostupnost=1)
dat.save()

Output:

edited Feb 7, 2022 at 9:06

answered Feb 7, 2022 at 8:46

lava

7,6262 gold badges44 silver badges35 bronze badges

1 Comment

lava Over a year ago

manage.py always in the root of the project .so the terminal must be in the root folder

Collectives™ on Stack Overflow

Django: Insert row into database

2 Answers 2

2 Comments

Method1

Method2

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Method1

Method2

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related