Django 之 ORM 單表查詢方法使用

一、在Django項目上運行python文件查詢數據庫

import os

if __name__ == '__main__':
    #加載Django項目的配置信息
    os.environ.setdefault("DJANGO_SETTINGS_MODULE","testinclude.settings")
    #導入Django,并啟動Django項目
    import django
    django.setup()

    from ormtest import models

    #查詢所有作者
    all_author = models.Author.objects.all()
    print(all_author)

    #get查詢某個人，當值不存在時會報錯
    person = models.Author.objects.get(id=7)
    print(person)

    print("filter".center(60,"*"))
    #filter返回數據為一個列表，當值不存在時，不會報錯，返回一個空的列表
    person = models.Author.objects.filter(id=7)
    print(person)
    print(person[0])

    #exclude 返回id不等于1的所有值，排隊法
    print("exclude".center(60,"*"))
    person = models.Author.objects.exclude(id=1)
    print(person)

    print("values返回值".center(60,"*"))
    person = models.Author.objects.values()
    print(person)

    print("orderby按照指定的字段排序")
    person = models.Author.objects.all().order_by("id")
    print(person)

    print("count統計匹配的數量".center(60,"*"))
    count = models.Author.objects.all().count()
    print(count)

    print("first返回第一行數據".center(60,"*"))
    person = models.Author.objects.all().first()
    print(person)

    print("last返回最后一行數據".center(60, "*"))
    person = models.Author.objects.all().last()
    print(person)

    print("查詢id大于4，小于6的值".center(50,"*"))
    person = models.Author.objects.filter(id__gt=5,id__lt=7)
    print(person)

    print("in查詢包括列表中的數或not_in".center(50,"*"))
    person = models.Author.objects.filter(id__in=[3,5,7])
    print(person)

    print("contains包含某些值".center(50,"*"))
    person = models.Author.objects.filter(name__contains="周")
    print(person)

    print("range相當于sql語句中的between and 5<7".center(50,"*"))
    person = models.Author.objects.filter(id__range=[5,7])
    print(person)

程序執行結果：

<QuerySet [<Author: author_name:小白>, <Author: author_name:小周>, <Author: author_name:小紅>, <Author: author_name:小綠>, <Author: author_name:小光>]>
author_name:小光
***************************filter***************************
<QuerySet [<Author: author_name:小光>]>
author_name:小光
**************************exclude***************************
<QuerySet [<Author: author_name:小白>, <Author: author_name:小周>, <Author: author_name:小紅>, <Author: author_name:小綠>, <Author: author_name:小光>]>
*************************values返回值**************************
<QuerySet [{'id': 3, 'name': '小白'}, {'id': 4, 'name': '小周'}, {'id': 5, 'name': '小紅'}, {'id': 6, 'name': '小綠'}, {'id': 7, 'name': '小光'}]>
orderby按照指定的字段排序
<QuerySet [<Author: author_name:小白>, <Author: author_name:小周>, <Author: author_name:小紅>, <Author: author_name:小綠>, <Author: author_name:小光>]>
************************count統計匹配的數量************************
5
************************first返回第一行數據************************
author_name:小白
************************last返回最后一行數據************************
author_name:小光
******************查詢id大于4，小于6的值*******************
<QuerySet [<Author: author_name:小綠>]>
****************in查詢包括列表中的數或not_in****************
<QuerySet [<Author: author_name:小白>, <Author: author_name:小紅>, <Author: author_name:小光>]>
******************contains包含某些值*******************
<QuerySet [<Author: author_name:小周>]>
**********range相當于sql語句中的between and 5<7**********
<QuerySet [<Author: author_name:小紅>, <Author: author_name:小綠>, <Author: author_name:小光>]>

models.py文件代碼

from django.db import models

# Create your models here.

class Publisher(models.Model):
    id = models.AutoField(primary_key=True)
    name = models.CharField(max_length=64,null=False,unique=True)

    def __str__(self):
        return "publisher_name:{}".format(self.name)

class Book(models.Model):
    id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=128,null=False)
    publisher = models.ForeignKey(to=Publisher)

    def __str__(self):
        return "book_title:{}".format(self.title)

class Author(models.Model):
    id = models.AutoField(primary_key=True)
    name = models.CharField(max_length=16,null=False)
    book = models.ManyToManyField(to="Book")

    def __str__(self):
        return "author_name:{}".format(self.name)