Load column from Database into list
How do you load a database column into a list with Django? I have a 'name' column of various names in my database and I want to be able to load all those names (ordered by id) into a list. So that I can iterate over that list and print the names, like this:
for name in name_list:
print name
I've googled this pretty 开发者_StackOverflow中文版thoroughly and I can't find anything. This should be so simple, its just the equivalent of SQL's "SELECT column FROM table"
class chat_messages(models.Model):
name = models.CharField(max_length=32)
Check out the docs for values_list()
. Django does a great job of creating the query specific to your request.
chat_messages.objects.all().values_list('name')
Will generate a query similar to:
SELECT `projectname_chat_messages`.`name` FROM `projectname_chat_messages`
精彩评论