ORM对数据库进行操作之增删改查
models.UserInfo.objects.create(
username=u,
sex=s,
email=e,
year=y,
)
''' create传值的方式二,用字典的形式
models.UserInfo.objects.create(
**{
'username':u,
'sex':s,
'email':e,
'year':y,
}
)
'''
models.UserInfo.objects.filter(id=2).delete()
models.UserInfo.objects.filter(id=1).update(username='jacklove')
models.UserInfo.objects.filter() 它包含了所有符合条件的对象
models.UserInfo.objects.all()
models.UserInfo.objects.get() 返回的是跟删选条件相匹配的对象,返回的结果有且只有一个,如果筛选
的符合条件的对象超过一个或者没有都会抛出错误
models.UserInfo.objects.exclude(id=2)
models.UserInfo.objects.filter(id=2).order_by('id')
models.UserInfo.objects.filter(id=2).reverse()
models.UserInfo.objects.filter(id=2).distinct()
models.UserInfo.objects.filter(id=3).count()
models.UserInfo.objects.filter(id=3).first()
models.UserInfo.objects.filter(id=3).last()
models.UserInfo.objects.filter(id=3).exists()
models.UserInfo.objects.filter(id__gt=1,id__lt=4)
models.UserInfo.objects.filtre(id__in=[1,3,5,7])
models.UserInfo.objects.filter(name__contains='小')
models.UserInfo.objects.filter(name__icontains='fsf')
models.UserInfo.objects.filtre(id__range=[1,7])
models.UserInfo.objects.filtre(birthday__year=2000)
models.UserInfo.objects.filter(name__startwith='fsf')
book_obj = models.Book.objects.all().first()
ret = book_obj.publisher
models.Book.object.filter(id=1).values('publisher__name')
publisher_obj = models.Publisher.objects.first()
ret = publisher_obj.book_set.all()
ret = models.Publisher.objects.filter(id=1).values_list('book_title')
models.Book.object.filter(title='Go').values('publisher__city')
from django.db.models import Avg,Min,Sum,Max
models.Book.object.all().aggregate(Avg('price'))
models.Book.object.values.('authors__name').annotate(Sum('price'))
from django.db.models import F
models.Book.objects.all().update(price=F('price')+20)
from django.db.models import Q
models.Book.objects.filter(Q(id=3)|Q(title='php')
models.Book.objects.filter(Q(price__gt=50)&(Q(id=3)|Q(title='php') ))
models.Book.objects.filter(Q(price__gt=50)&(Q(id=3)|Q(title='php') ), color='yellow')
models.Book.objects.filter(~Q(id=3))