Select random field from database in Python

Question

So I am developing a Django app and what I want at the moment in to develop a script that selects a random field from a row with 3 words in a MySQL database that I have. I have searched for info but haven't managed how to do it.

My database:

What I want is the script to read the database and select a random word each time. I haven't worked so much with DBs in Python so I have no clue about how to do it. Help is much appreciated.

Gamopo · Accepted Answer · 2021-03-01 09:54:24Z

1

You can use random.choice like this:

import random

columns = ['word1', 'word2', 'word3']
chosen_column = random.choice(columns)

#now access DB using chosen_column for example:
Your_model.objects.raw('SELECT ' + chosen_column + ' FROM myapp_yourmodel')

edited Mar 1, 2021 at 9:54

answered Mar 1, 2021 at 9:45

Gamopo

1,5981 gold badge14 silver badges23 bronze badges

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

6 Comments

eneko valero Over a year ago

Okay thanks, when you mean access the DB using chosen_column what do you mean? Do I have to create a connexion with the MySQL database first?

Gamopo Over a year ago

If you're using Django, you probably can use the model so you don't have to specifically create a connection. I'll edit my answer with an example

Klaus D. Over a year ago

Wouldn't it be smarter to choice() after getting the data?

eneko valero Over a year ago

I imagine I'll have to do that in the view I'm rendering, don't I? @Gamopo

Gamopo Over a year ago

Sure! Or wherever you want to use it

|

Collectives™ on Stack Overflow

Select random field from database in Python

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related