python Django 模型操作
1. 添加模型到数据库
class Book(models.Model):
name = models.CharField(max_length=20,null=False)
desc = models.CharField(max_length=100,name='description',db_column="description1") pub_date = models.DateTimeField(auto_now_add=True)
book = Book(name='三国演义',desc='三国英雄!') book.save()
2. objects:查找数据
objects 对象
3. all:查找所有数据
books = Book.objects.all()
4. filter:数据过滤
books = Book.objects.filter(name='三国演义')
> [<Book:三国演义>]
# 多个条件
books = Book.objects.filter(name='三国演义',desc='test')
5. get:获取单个对象
book = Book.objects.get(name='三国演义')
> <Book:三国演义>
6. order_by:数据排序
books = Book.objects.order_by("pub_date")
books = Book.objects.order_by("-pub_date")
7. save:修改数据
from datetime import datetime
book = Book.objects.get(name='三国演义') book.pub_date = datetime.now() book.save()
8. delete:删除数据
book = Book.objects.get(name='三国演义')
book.delete()