How Choose Random User from database ?

88 views
Skip to first unread message

Mustafa Burhani

unread,
Apr 19, 2021, 8:44:36 PM4/19/21
to Django users
I want to Choose random user from databse is possible with django shell or need to create model ? for random function ?


Thanks !

Joel Tanko

unread,
Apr 19, 2021, 8:54:01 PM4/19/21
to django...@googlegroups.com
if you already have a table with some rows in it, writing a random function would work just fine.

# as an example
from random import randint
def select_random_user():
    all_users = User.objects.all()
    selected = list(all_users)[randint(0, all_users.count())]
    return selected

On Tue, 20 Apr 2021 at 01:45, Mustafa Burhani <mustafab...@gmail.com> wrote:
I want to Choose random user from databse is possible with django shell or need to create model ? for random function ?


Thanks !

--
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/055d5a55-ad28-4a97-b1ec-1d16369cc2a2n%40googlegroups.com.

Kelvin Sajere

unread,
Apr 19, 2021, 8:58:45 PM4/19/21
to django...@googlegroups.com
If you just want a random user, you could just use random.choice(). You can use it in shell, in a function or wherever you want.

Example:

import random
users = User.objects.all() #a list of all users
random_user = random.choice(users) #a random user

On Mon, Apr 19, 2021 at 20:45 Mustafa Burhani <mustafab...@gmail.com> wrote:
I want to Choose random user from databse is possible with django shell or need to create model ? for random function ?


Thanks !

--
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/055d5a55-ad28-4a97-b1ec-1d16369cc2a2n%40googlegroups.com.
--
KeLLs

mustafa burhani

unread,
Apr 19, 2021, 9:19:39 PM4/19/21
to django...@googlegroups.com

Thanks !

 

Sent from Mail for Windows 10

Scot Hacker

unread,
Apr 21, 2021, 2:00:40 AM4/21/21
to Django users

If the number of records you need to choose randomly between is not huge, this works fine:

`User.objects.order_by('?').first()`

You only need turn to use a special function or method if your query takes more than a microsecond to return, or you have a ton of traffic. i.e. use the ORM for random choices with caution.

./s

FIRDOUS BHAT

unread,
Apr 21, 2021, 2:44:16 AM4/21/21
to django...@googlegroups.com
Scot Hacker's answer is preferable

Reply all
Reply to author
Forward
0 new messages