Fetching data from database

[Kiran Bangde]

Hi everyone,

Iam stuck at a point ...I want to fetch a data from a database , where data should be insert manually , plz help me how to do that how to fire a queries in DB and how to use primary key and foreign key over here. 

Please help me ,Iam new to Django . 

Thanks in advance

[Ashutosh Mishra]

You have go through the django docs,

In django request.method.POST is used to inser data

And Model.objecs.all() this is the way how you fetch data,

You need to study docs

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAH3w0pg60HpYHzta5hjHTw7NaiBbuh7Q1uOfG%2BkZnRAGgQLOYA%40mail.gmail.com.

[David Nugent]

You question isn't very specific, however I'll try to add a couple of touch-points that may provide some direction.

Django manage.py can provide direct access to your models.

python manage.py shell

is your friend, for manually manipulating data, including the database via the Django ORM.

This link to the Django docs could provide a good starting point, particularly further down the page where models are queried using the Django shell.

Secondly are the import and export data commands available in manage.py, in particular the dumpdata and loaddata commands. I suspect this is what you are looking for.

[Kiran Bangde]

Thanks, I'll check them out. 

[kern zhou]

How to queries in DB: https://docs.djangoproject.com/en/3.1/topics/db/queries/#retrieving-all-objects

For the primary key:  https://docs.djangoproject.com/en/3.1/ref/models/fields/#primary-key

For the foreign key :   https://docs.djangoproject.com/en/3.1/ref/models/fields/#django.db.models.ForeignKey

You can get these informations from the official Django doc.

[Derek]

Have a look at:

https://www.guru99.com/python-mysql-example.html

and then:

https://www.mysqltutorial.org/python-mysql-insert/

https://www.mysqltutorial.org/python-mysql-update/

Not too hard for a beginner.