开发者

Load column from Database into list

开发者 https://www.devze.com 2023-03-19 05:19 出处:网络
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

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`
0

精彩评论

暂无评论...
验证码 换一张
取 消