CODEWITHSUNDEEP
djangodjango-modelsdjango-orm
user469652
user469652

Reputation: 51221

Django database query: How to get object by id?

Django automatically creates an id field as primary key.

Now I need to get the object by this id.

object = Class.objects.filter()

How to write this filter?

Upvotes: 176

Views: 264424

Answers (6)

Ebert Rodrigues
Ebert Rodrigues

Reputation: 21

In case you don't have some id, e.g., mysite.com/something/9182301, you can use get_object_or_404 importing by from django.shortcuts import get_object_or_404.

Use example:

def myFunc(request, my_pk):
    my_var = get_object_or_404(CLASS_NAME, pk=my_pk)

Upvotes: 1

Alvaro Rodriguez Scelza
Alvaro Rodriguez Scelza

Reputation: 4164

You can also use get_object_or_404 django shortcut. It raises a 404 error if object is not found.

Upvotes: 10

Pratik Randad
Pratik Randad

Reputation: 51

You can use:

objects_all=Class.objects.filter(filter_condition="")

This will return a query set even if it gets one object. If you need exactly one object use:

obj=Class.objects.get(conditon="")

Upvotes: 4

Anthony
Anthony

Reputation: 979

You can also do:

obj = ClassModel.get_by_id(object_id)

This works, but there may I'm not sure if it's supported in Django 2.

Upvotes: 3

iridescent
iridescent

Reputation: 3513

If you want to get an object, using get() is more straightforward:

obj = Class.objects.get(pk=this_object_id)

Upvotes: 309

Lucio Paiva
Lucio Paiva

Reputation: 20756

I got here for the same problem, but for a different reason:

Class.objects.get(id=1)

This code was raising an ImportError exception. What was confusing me was that the code below executed fine and returned a result set as expected:

Class.objects.all()

Tail of the traceback for the get() method:

File "django/db/models/loading.py", line 197, in get_models
    self._populate()
File "django/db/models/loading.py", line 72, in _populate
    self.load_app(app_name, True)
File "django/db/models/loading.py", line 94, in load_app
    app_module = import_module(app_name)
File "django/utils/importlib.py", line 35, in import_module
    __import__(name)
ImportError: No module named myapp

Reading the code inside Django's loading.py, I came to the conclusion that my settings.py had a bad path to my app which contains my Class model definition. All I had to do was correct the path to the app and the get() method executed fine.

Here is my settings.py with the corrected path:

INSTALLED_APPS = (
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.sites',
    # ...
    'mywebproject.myapp',

)

All the confusion was caused because I am using Django's ORM as a standalone, so the namespace had to reflect that.

Upvotes: 28

Related Questions