Django之路--第三篇

1.ORM
1.1.创建类和字段

class UserInfo(models.Model):
    name=models.CharField(max_length=64)
    age=models.IntergerField()

python manage.py makemigrations
python manage.py migrate
#setting.py 中INSTALLED_APPS添加app

1.2.增删改查

增
models.UserInfo.object.create(name='root',age='22')

dic={'name':'root','age':22}
models.UserInfo.object.create(**dic)

obj=models.UserInfo(name='root',age='22')
obj.save
-----
删
models.UserInfo.object.filter(id=1).delete()
-----
改
models.UserInfo.object.filter(id__gt=1).update(name='root1')
-----
查
models.UserInfo.object.filter(id=1)
models.UserInfo.object.filter(id__gt=1)     #大于
models.UserInfo.object.filter(id__gte=1)   #大于等于
models.UserInfo.object.filter(id__lt=1)      #小于
models.UserInfo.object.filter(id__lte=1)    #小于等于

1.3外键关联

class UserType(models.Model):
    caption=models.CharField(max_length=32)

class UserInfo(models.Model):
    name=models.CharField(max_length=64)
    age=models.IntergerField()
    user_type=models.ForeignKey("UserType",to_field='id') #外键约束

转载于:https://blog.51cto.com/13803166/2160351