查询数据
数据的查询需要使用管理器对象进行
通过MyModel.objects管理器方法调用查询接口
1.all()方法 MyModel.objects.all()
查询MyModel实体中所有的数据,等同于select * from table
2.在模型类中定义 def __str__(self):方法可以定义默认的字符串
3.查询返回指定列 Mymodel.objects.values()
返回查询结果容器,容器内存字典,格式为: {'列1': 值1, '列2': 值2}
from bookstore.models import Book
books = Book.objects.values("title", "pub")
for book in books:
print("书名", book["title"], '出版社:', book['pub'])
print("book=", book)
4.查询返回指定列(元组表示) MyModel.objects.values_list()
from bookstore.models import Book
books = Book.objects.values_list("title", "pub")
for book in books:
print("书名", book[0], '出版社:', book[1])
print("book=", book) # ('Python', '清华⼤学出版社')..
5.排序查询 MyModel.objects.order_by('-列','列')
from bookstore.models import Book
books = Book.objects.order_by("price")
for book in books:
print("书名",book.title,'定价',book.price)
6.条件查询 MyModel.objects.filter(属性1=值1,属性2=值2)
当多个属性在一起时为"与"关系
from bookstore.models import Book
books = Book.objects.filter(pub="清华大学出版社")
from book in books:
prin