Django

Django

• 生成Django工程

django-admin startproject mysite

• 开始服务

python manage.py runserver

• 创建应用

python manage.py startapp polls

• 生成建表语句

python manage.py makemigrations

• 生成数据库表

python manage.py migrate

• 数据库插入

p1 = Publisher(name='Apress', address='2855 Telegraph Avenue', city='Berkeley', state_province='CA', country='U.S.A.', website='http://www.apress.com/')
p1.save()

• 数据库检索

Publisher.object.all()
Publisher.objects.filter(name='Apress')
Publisher.objects.filter(country="U.S.A.", state_province="CA")
Publisher.objects.filter(name__contains="press")
Publisher.objects.filter(name__icontains="press")
Publisher.objects.filter(name__startswith="press")
Publisher.objects.filter(name__endswith="press")
Publisher.objects.get(name="Apress")

try:
   	p = Publisher.objects.get(name='Apress')
except Publisher.DoesNotExist:
   	print("Apress isn't in the database yet.")
else:
   	print("Apress is in the database.")
   	
   Publisher.objects.order_by("name")
   Publisher.objects.order_by('name')[0]
   Publisher.objects.order_by('name')[0:2]
   Publisher.objects.order_by("-name") #倒叙

• 数据库更新

Publisher.objects.filter(id=52).update(name='Apress Publishing')
Publisher.objects.all().update(country='USA')

• 数据库删除

Publisher.objects.filter(country='USA').delete()
Publisher.objects.all().delete()